Solution Properties
Solution ID:
240110000824850
Last Modified Date:
Wed Jan 10 01:44:05 UTC 2024
Taxonomy Path:
Category//Transactions
Author:
[email protected]
How to import bank statements
Description

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.

Cause
Resolution

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:

Steps to duplicate
Related Solutions

Common errors in Bank Feeds