How to Import Bank Statements into Sage Accounting

Quick Answer {#quick-answer}

To import bank statements into Sage Accounting: convert your PDF or bank CSV to a Sage-compatible CSV using QuickBankConvert, then in Sage go to Banking → [Your Account] → Import Statement and upload the file. Sage requires Date (DD/MM/YYYY in the UK, or MM/DD/YYYY in North America), Description, and Amount columns. For Sage 50, OFX import offers a smoother workflow for US banks.

Sage Versions and Import Options {#sage-versions}

"Sage" covers a family of products with different import capabilities. Before preparing your file, confirm which version you are using:

This guide focuses on Sage Accounting (cloud) and Sage 50 (desktop) since these are the most common versions used by small businesses.

Preparing Your Bank Statement File {#prepare-file}

For Sage Accounting (Cloud)

Sage Accounting's CSV importer requires these columns in this order:

No header row is required in some versions of Sage Accounting—check whether your version prompts you for one during the column mapping step.

For Sage 50 (Desktop)

Sage 50's CSV import template includes these columns:

Callout: The fastest way to get a properly formatted file is to run your bank statement PDF through QuickBankConvert. It produces a clean CSV with normalized dates and amounts in the correct sign convention—ready to upload to Sage without manual column adjustments.

Fixing Common Pre-Import Issues

Importing a CSV into Sage Accounting {#csv-import-steps}

Step 1 – Prepare the CSV

Convert your bank statement to a Sage-compatible CSV using QuickBankConvert. Download the output file.

Step 2 – Open Your Bank Account in Sage

In Sage Accounting, navigate to:

Banking (left sidebar) → Select the relevant bank account

Step 3 – Access the Import Function

Inside the bank account view, look for:

Import Statement or Upload Statement button (usually in the top-right area or under a "More" menu)

Step 4 – Upload the File

Click Choose File or drag and drop your CSV. Sage will display a preview.

Step 5 – Map Columns

Sage will attempt to auto-detect columns. Verify each mapping:

• Date → Date
• Description → Description
• Amount → Amount (or Debit/Credit if using separate columns)

Set the correct date format from the dropdown if Sage does not detect it.

Step 6 – Review and Import

Review the transaction preview for obvious errors (wrong signs, garbled descriptions). Click Import or Confirm to proceed.

Step 7 – Match or Add Transactions

Sage will show each imported transaction alongside any existing entries or bank rules. Choose to:

• Match — link to an existing invoice or transaction already in Sage
• Create — add as a new transaction and categorize it
• Exclude — skip the transaction (use for internal transfers)

Importing OFX Files into Sage 50 {#ofx-import}

For Sage 50 desktop users in the US, OFX import is often more reliable than CSV because it includes additional metadata like transaction IDs that help prevent duplicates.

Getting an OFX File

Many US banks allow OFX download directly from the transaction history page. Look for a Download or Export button and choose OFX or Microsoft Money format.

If your bank only offers PDF or CSV, QuickBankConvert can convert those to a clean CSV which you can then import via the CSV method above.

Sage 50 OFX Import Steps

1. In Sage 50, go to Banking → Import Transactions
2. Select your bank account from the dropdown
3. Browse to your OFX file and click Open
4. Sage 50 will display a preview with debit/credit amounts pre-populated
5. Review the list and click Import

Troubleshooting Sage Import Errors {#troubleshooting}

Reconciling After Import in Sage {#after-import}

Once transactions are imported, reconciliation confirms your Sage balance matches your bank statement.

Sage Accounting Reconciliation

Go to Banking → [Account] → Reconcile. Sage shows your imported transactions alongside the statement balance you enter. Check off each transaction that appears on your official bank statement and click Complete Reconciliation when the difference reaches zero.

Tips for a clean reconciliation:

• Import one month at a time rather than multiple months in a single file—this makes it easier to reconcile month by month
• Note the closing balance from your bank statement before you begin; you will need to enter it in the reconciliation screen
• If the difference is not zero, look for: a transaction imported twice, a missing transaction, or an amount typed incorrectly

Callout: A common cause of stubborn reconciliation differences is the opening bank balance set in Sage when the account was first created. If this was entered incorrectly, every subsequent reconciliation will be off by the same amount. Check the opening balance in Settings → Chart of Accounts → [Bank Account] and correct it if needed.

For the cleanest import workflow, start with QuickBankConvert to normalize your bank data, then follow the steps above to get a Sage-ready file every time.