We have a few bank and credit card accounts that are very active, and it takes longer than we want to complete our monthly reconciliation. Is there a way that we can streamline this process to make it any quicker?
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, GLS compares the imported bank account transactions with existing journal entries and deposit slips. 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 journal entries based on the imported information.
To import bank or credit card transactions
- From the File menu, point to Open and select Bank Account Manager.
- Select the GLS Account for which you want to import bank transactions and then click the Import Bank Transactions button.
- Select the file you received from your financial institution and click OK.
- Once the import has completed, click the Confirm Transactions button.
- Review any transactions on the Unmatched tab, matching them as needed.
- Review the transactions on the Matched tab and click Confirm once complete.
You have now reduced the time it takes to reconcile your bank and credit card accounts.
Note: This process is also available in Trust Accounting Software (TAS).
We have a file that contains information for multiple invoices. Is it possible to import this type of file into APS so we don’t have to enter them one at a time?
You can use the Import Invoices function in APS to import data from an ASCII file into the APS Invoice file, provided the file is in the appropriate format and named A3IMPORT.DTA.
To import invoices, open the Import Invoices program (Maintenance | Invoice | Import Invoices) and click OK. The Import Invoices window will display the number of records that are imported, and invalid invoices will be sent to an error list.
For more information on the Import Invoices program, including the required format of the A3IMPORT.DTA file, refer to Knowledge Base Article R11505, “Importing Data into APS.”
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 other programs such as Tabs3.
The Tabs3 Device Interface takes the export files from most collection devices and converts them into costs that can be posted to Tabs3. 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.
We offer a wide range of collection device conversion interfaces. 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 reseller and 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.
