Import bank transactions through an upload process

All banks provide files with the account transactions in their online banking. You can usually download those files in the same area where you check your bank statements. If the bank provides more than one file format, you need to choose the OFX file format.

After you download the file with your account transactions, follow these steps to upload it in OnBalance.

  1. In the Transactions screen, click Manage > Bank Reconciliation.
  2. In the Bank Reconciliation screen, click Import New Data for the bank account from which you want to import the bank transactions.
  3. Click Upload a file from your Internet banking.
  4. Click the Search File button and locate the OFX file on your computer.
  5. OnBalance will read the file and check if there are now transactions to be imported.
    • If there are new transactions, OnBalance will import them and open the Match screen.
    • If there are no new transactions, OnBalance will display a message to let you know.

Note: If you upload a file to OnBalance that that you have already uploaded, OnBalance will be able to see all of the bank transactions in the file that have already been processed. This will allow you to avoid having duplicate transactions.

The availability of some or all of these features depends on your version of OnBalance.