Import bank transactions with Bank Feeds

Summary

In Sage 50 Accounts v30.1 and above, you can manually import a bank statement when using Bank Feeds.

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

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.

Bespoke training is available

Get extra support with bespoke one-to-one sessions from a Sage expert, built around your needs.
Leave your details and we'll be in touch.