Import bank statement

Summary

How to import bank transactions from a file downloaded from your bank into Sage Accounting.

Description

Import transactions from your bank using our bank statement import feature.

When to use a bank statement import

When your bank doesn't have a bank feed
If your bank feed isn't working
If you have historical transactions not included in your bank feed

Important notes

You can't import foreign currency bank statements
You can't import transactions from before your Accounts Start Date
You can view a list of Supported file formats for bank statement imports

Resolution

Import your statement

▼ 1. Upload your file

From Banking, select the bank account you want to import transactions to.
From Actions select the drop-down arrow and Import statement.
Select your file type.
Browse to, or drag and drop the file you're uploading.
Select the date format used in your file so we can process it correctly.
Add a comment to help you identify the import later.
Select upload file.

▼ 2. Verify transactions

After the file upload, you need to tell us which transactions show:

Money coming into the account
Money coming out of the account

To help with this, we'll display one of your transactions on the screen. Confirm your transaction as either money in or money out of the account to continue.

▼ 3. Review transactions

Your transactions will appear as a list. If there are errors with the way we've categorised these, you can go back to the Verify screen.

Once you've reviewed the transactions select Import transactions. We'll take you back to the Banking screen while we complete the import.

Your imported transactions will show on your bank account tile.

For support processing your imported statement read our Processing bank feeds article.

TIP: Once you've uploaded your statement, you can also apply bank rules to transactions to automate the process, saving you time. Read What are bank rules to find out more.

Import bank statement

Summary

Description

When to use a bank statement import

Important notes

Resolution

Import your statement

Fixing errors

SUPPORT & TRAINING

PARTNERS

COMPANY

FAQs