How to import bank statements

Import bank transactions into Sage Accounting from a supported statement file. Review and verify imported transactions before processing or reconciliation.

Import bank transactions from a file for Chequing, Credit Card, and Savings accounts.

Sage Accounting does not support file imports for Cash in Hand, Loan, Other, or foreign currency accounts.

If you have historical transactions or many transactions to record, import them from a bank statement file.

Import historical bank statements before you connect a bank feed.

Download your bank statement

1. Sign in to your online banking service.
2. Download your bank statement in one of the following formats:
   

   BAI2

   CAMT053

   OFX

   ASO

   QIF

   CSV

   XLS

   XLSX

Prepare and upload the file

1. Go to Banking.
2. Select the bank account you want to update.
3. Select the dropdown arrow beside Connect to bank.
4. Select Import statement.
5. Select Open file import guide.
6. Review the file requirements or download example files.
7. Format the file if required.
   
   NOTE:

   CSV, XLS, and XLSX files must contain the required column headers.

    
8. Select Select a file from your device.
9. Browse to the file and select Open.
10. Alternatively, drag and drop the file into the upload window
11. Select the date format used in the file.
12. Enter a comment to identify the import.
13. Select Upload file.

Verify and import transactions

1. Review the sample transaction in the verification window.
2. Confirm whether the transaction records money entering or leaving the account.
3. Sage Accounting applies your selection to the remaining transactions.
4. Review all transactions for accuracy.
5. Correct any errors.
6. Select Import transactions.

Understand the import window

Pending transactions	View transactions that Sage Accounting has not yet recorded in the bank activity for the selected account.
Selected account	Switch between bank accounts that use a direct bank feed or imported bank statements.
Bank feed refresh	Select Refresh to download transactions your bank processed since the last connection.
Bank feed connection	Update connection credentials or disconnect the bank feed from the selected bank account.

 

Review imported transactions

1. Return to Banking.
2. Review the imported transactions in the selected bank account.
3. Sage Accounting displays imported transactions alongside downloaded bank feed transactions.
4. Sage Accounting marks imported transactions with an Imported label.

Troubleshoot import issues

If the import does not complete successfully:

• Confirm that the file format is supported
• Verify that all dates use the same format
• Check that CSV, XLS, and XLSX files contain the required headers
• Review the file for missing transaction details
• Use the import guide to validate the file structure

Next steps

After you import transactions, you can:

• Process imported bank transactions
• Match transactions to existing records
• Bank account reconciliation and troubleshooting
• Connect a bank feed
• Create bank rules

Common errors in Bank Feeds