Import a bank statement

To help reconcile your bank accounts, you can import a statement from your online banking service. This saves time when matching transactions and ensures that your accounts are accurate. You can import statements in to your checking or savings accounts from an unlimited number of bank accounts.

Before importing a statement

To import your statements, download them from your online banking service as QIF or OFX files. When you download your file, we recommend saving it to your C drive, not your Desktop because this can affect the file type. You should also make a note of the your statement end balance, because you need to enter this when reconciling your statement items to your entries. If you need help downloading your file, please contact your online banking service provider.

The Import Transactions feature is disabled if the bank account is currently linked to a bank through Downloaded Transactions.

Import a bank statement

  1. Go to Banking.
  2. Click the applicable bank account.
  3. On the Connect to Bank menu, select Import Statement.
  4. Depending on your browser, click Browse or Choose File and browse to the location in which you saved the bank statement file.
  5. Select the file, and then click Open.
  6. Enter the following information:
  • Enter the statement end balance. Enter the ending balance from the bank statement.
  • Enter the statement reference. Enter a reference for this reconciliation, for example, the statement date.
  1. Click Upload. Your transactions are imported and each item appears on a different line.

See Working with incoming bank transactions for information on how to match, create, transfer, or discard incoming transactions.