General Ledger Q&A: Import Bank Transactions

January 2019    Tags: , ,

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

  1. From the File menu, point to Open and select Bank Account Manager.
  2. Select the GLS Account for which you want to import bank transactions and then click the Import Bank Transactions button.
  3. Select the file you received from your financial institution and click OK.
  4. Once the import has completed, click the Confirm Transactions button.
    1. Review any transactions on the Unmatched tab, matching them as needed.
    2. 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).

No votes yet.
Please wait...
Share or Print this Article


Comments are closed.