The Import Data Wizard allows you to import data into any PracticeMaster file, including new contacts.
To use the Import Data Wizard
Note: PracticeMaster requires a text file containing comma-separated values to import. If your spreadsheet is in another format, such as a XLS file, you can save the file as a CSV format using Microsoft Excel or a similar application.
General Ledger’s Import Bank Transactions feature uses financial files in multiple formats (.OFX, .QBO, or .QFX) to help clear your bank transactions. This allows you to match up journal entries that are already in the system against the ones in the file.
To import bank transactions
To match imported transactions to journal entries
When you start your reconciliation, all cleared entries will be selected, cutting down the amount of time that the reconciliation takes.
The Import Bank Transactions program allows you to import transaction information via a file that you download from your bank or credit card company. File formats supported include the .OFX, .QFX, and .QBO file formats.
During the import process, Trust compares the imported bank account transactions with existing checks, deposit slips, and EFT transactions. If matching transactions are found, they are shown on the Matched tab so they can easily be marked as having cleared the bank. Any imported transactions that cannot be matched are shown on the Unmatched tab, allowing you to easily match them with existing transactions or create new entries based on the imported information.
To import bank or credit card transactions
You have now reduced the time it takes to reconcile your bank and credit card accounts.
Note: This process is also available in Tabs3 General Ledger (GL).
Often, the most common source of unbilled costs are the everyday tasks done in your office. Photocopies, faxes, phone calls, and many other tasks can easily be overlooked when entering costs for a client. Simple cost recovery methods can reclaim these expenses as needed. Many manufacturers offer devices that collect information and create an export file, which can be used in Tabs3 Billing.
The Tabs3 Device Interface software takes the export files from most collection devices and converts them into costs that can be imported to Tabs3 Billing. Additionally, it allows you to customize import settings so any standard text file can be converted, even if it is not already configured in the conversion program. This means it is very likely that you can import your task information, regardless of the device’s manufacturer.
To see if the Tabs3 Device Interface will work for you, or to order a license of the Tabs3 Device Interface for your firm, contact your local consultant or call our Sales Department at (402) 419-2200. Information about the Tabs3 Device Interface can also be found in our Knowledge Base Article R10737, “Tabs3 Device Interface Product Information,” and in R11684, “Tabs3 Device Interface Instructions.”
Did you know that you can import data into all of the Tabs3 and PracticeMaster software? Knowledge Base Article R11506, “Resources for Importing Data into Tabs3 and PracticeMaster Software,” provides a list of resources with information regarding programs that can be used to import data in Tabs3 and PracticeMaster software including the following:
Tabs3 Billing – Importing costs from photocopiers, telephone systems, fax machines, and more.
PracticeMaster – Importing data from third-party programs, documents into document management, Platinum Exchange Connector, Outlook, and more.
General Ledger Software (GLS) – Integration with PenSoft Payroll and importing data into GLS using an ASCII data file.
Trust Accounting Software (TAS) – Importing data into TAS using an ASCII data file.
Accounts Payable Software (APS) – Importing data into APS using an ASCII data file.
Our Knowledge Base can be accessed 24 hours a day, 7 days a week, at support.Tabs3.com. You can also access our Knowledge Base while in the software by selecting Help | Internet Resources | Knowledge Base.