Importing statements

If you have an online banking facility, you can use the Get Statement feature to import bank statement 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. Namely, your software 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 have the option of matching 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

note : Download 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 download this file. You can download OFX, QFX, QIF, and OFC files.

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 Get Statement. The Open window appears.

4	Locate and select the downloaded statement file.

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 check number, date, and amount as the criteria for matching withdrawals and deposits.

■	If there are unmatched transactions, the Unmatched Statement Transactions window appears. Go to step 7.

■	If 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.

7	Choose what you want to do with the transactions.

■

If you want to match a transaction, select the transaction and click 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 and click 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 will be marked as cleared.

8	Repeat step 7 for each unmatched transaction.

caution : Match or add all transactions

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 cleared transactions appears.

Related topics

■	Reconciling your bank accounts

■	Importing data