Import bank transactions with Bank Feeds

Solution Properties

Solution ID:

240109094532807

Last Modified Date:

Tue Jun 30 09:52:45 UTC 2026

Taxonomy Path:

Case category//How do I...//import/export

Author:

Import bank transactions with Bank Feeds

Description

With bank feeds enabled, you can import your bank statement, saving time on manually processing your bank transactions.

Cause

Resolution

You can set up your bank account for importing without setting up a Bank feed.

Go to the Bank Feeds module.
Locate the account you want to set up for importing, and click the Get started link.
Click the Import statement button on the Work with bank transactions window:
Follow the import your bank transactions file section below to import the file.

To connect your bank account to an automated Bank feed later, click the three dots and select Connect to automatic feed.

If you already have a Bank feed set up, you can still import your transactions manually if you need to.

After opening the import wizard from your Bank feeds screen:

Select Continue on the Welcome to the Bank feeds import feature window.
In the Upload your file section, choose Select a file from your device.
Browse to the bank statement file, and click Open.

NOTE:

We support the following file types: .CSV, .BAI, .XML, .TXT, .OFX, .ASO, .QBO, .QFX, .QIF, .XLS.
For help with formatting, follow our import file format rules article, which includes templates.
Once you're ready to import your file, click Review transactions.
If prompted, select the correct date order that the dates are displayed in your file:

Click the relevant option, then click Continue.
On the Review transactions window, check that your transactions are correct:

TIP: Click Switch transaction types to change money in transactions to be negative. The software changes this over for you and reprocesses the imported file.
Once you're happy with the transactions, click Confirm import.

The transactions you've imported will now show in the To be matched tab, ready for you to match with your Sage transactions.

[BCB:366:UKI - training sales:ECB]

Steps to duplicate