Help Centre

Banking > Importing statements
If you have an online banking facility, you can use the Get Statement feature to import electronic bank statements or credit card statement files.
This feature enables you to import transactions that you haven’t recorded in your company file (e.g. bank fees). It also enables you to use the imported transactions as part of your reconciliation process. That is, you can automatically match transactions on your statement with the transactions in your company file. Matched transactions will be marked as cleared for reconciliation, making it easy for you to reconcile your account at month-end.
If some transactions cannot be matched, you can match them manually with uncleared transactions, adding them or skipping them altogether. Unmatched transactions are usually bank interest, account fees and penalty charges applied by the bank.
To import your statement
Before you can import your bank or credit card statement, you need to download the statement file from your bank. Your bank’s website should provide instructions on how to do this. The following file formats are supported: OFX, QFX, QIF and OFC.
1
Go to the Banking command centre and click Bank Register. The Bank Register window appears.
2
In the Account field, type or select the account that corresponds to the bank or credit card statement.
3
Click Actions, then choose Get Statement. The Open window appears.
5
Click Open. The Get Statement window appears.
6
Click OK. The statement transactions are automatically matched with the transactions in your company file, using the cheque number and amount as the matching criteria. If:
there are any unmatched transactions, the Unmatched Statement Transactions window appears. Go to step 7.
all your transactions match, that’s it. These transactions will be marked as cleared in the Reconcile Accounts window. You can ignore the rest of this procedure.
If you want to match a transaction, select the transaction and click Actions and choose Match Transaction. The Match Transaction window appears, listing the uncleared transactions in your company file for the specified account. Select the transaction that you want to match with the statement transaction and click Match. The transaction will be marked as cleared.
If you want to add a transaction to your company file, select the transaction, click Actions and choose Add Transaction. The Spend Money window or the Receive Money window (depending upon the type of transaction you are adding) appears. Enter the details of the transaction and record it. The transaction is shown as cleared.
8
Repeat step 7 for each uncleared transaction you want to add or match.
We recommend you finish adding or matching every transaction in the unmatched transaction list before you click Done. If you re-open the statement file, the original list of unmatched transactions reappears in the Unmatched Statement Transactions window.
9
When you have finished matching and adding transactions, click Done. A list of all the transactions that were cleared appears.

Click to show more information

Top of page