We moved!

Help articles have been migrated to the new Help and Support. You can find help for your products and accounts, discover FAQs, explore training, and contact us!

Importing transactions from a bank statement

If your financial institution allows you to download bank statements via the internet, you can quickly reconcile the firm impound bank accounts using the Bank Statement Import tab of the Actions > Reconcile Impound Bank Accounts screen. You can download statements for reconciliation in any of the following formats - OFX, QFX, QIF, and BAI2.

1. Download the bank statement file and save it to a location on your computer or network.
2. Choose Actions > Reconcile Impound Bank Accounts.
3. Select the account to reconcile, either by choosing it in the Reconciliation list or by selecting it in the Account section of the General Information tab.
4. Click the Bank Statement Import tab.
5. In the Statement file field, enter or browse to the path and file name of the statement you downloaded. The transactions in the import file are automatically matched to the transactions recorded in the application based on type, reference, and amount. If each transaction from the bank statement cannot be matched to a transaction recorded in the application, you will need to manually match transactions.
6. Continue with the reconciliation using the applicable tabs in the Actions > Reconcile Impound Bank Accounts screen.

Importing multiple statements

You can import multiple statements for each reconciliation. The following rules apply when importing multiple statements.

• If a statement has already been imported for the current reconciliation and you import another statement, the Unmatched bank account transactions grid and the Unmatched statement transactions grid are refreshed.
• New unmatched statement transactions are appended to the list of outstanding unmatched statement transactions from the other statement imports.
• You can import the same statement more than once during a reconciliation if necessary.

Manually matching transactions

When you import a bank statement for reconciliation in the Bank Statement Import tab of the Actions > Reconcile Impound Bank Accounts screen, the transactions in the import file are automatically matched to the transactions recorded in the application based on type, reference, and amount. If each transaction from the statement cannot be matched to a transaction recorded for this impound account in the application, the unmatched transactions are listed in the Unmatched bank account transactions grid (for transactions recorded in the application that could not be matched to a transaction in the bank statement) and the Unmatched statement transactions grid (for transactions from the bank statement that could not be matched to a transaction recorded in the application). The unmatched transactions are grouped by type - credit or debit.

Use the following procedure to manually match transactions.

1. Expand the list of credits and debits in the Unmatched bank account transactions grid and in the Unmatched statement transactions grid.
2. Scroll through the list of transactions in both grids until you find transactions that can be matched.
3. In the Unmatched statement transactions grid, mark the checkbox for the transaction to be matched.
4. In the Unmatched bank account transactions grid, mark the transaction(s) to match with the statement transaction.
5. Click the Match button. The transactions will be removed from the Bank Statement Import tab and marked as cleared in the Deposits & Additions tab or the Checks & Payments tab.
6. Repeat steps 2 through 5 until you cannot match any more transactions.

Making adjustments

You can save an unmatched statement transaction as an adjustment that is written back to the general ledger using the steps below.

1. In the Unmatched statement transactions grid, mark the checkbox in the Adjustment column for the transaction to save as an adjustment.

   Note: When you mark the Adjustment checkbox, this transaction is no longer available for matching. If you clear the Adjustment checkbox, the transaction will be available for matching again.

2. The GL Account column for that transaction changes to a drop-down list. Enter or select the appropriate GL account number to use for the adjustment transaction.

When you click the Post Adjustments, Finish Later, or Finalize button, the transaction will be moved to the applicable tab and marked as cleared. To view or delete the adjustment, choose Edit > Non-recurring Adjustments.

Was this article helpful?

Yes No

Submit