Import bank statement

Summary

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

Description

You can 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

Resolution

What you need to know

You're unable to import foreign currency bank statements into Sage Accounting. You can only import a bank statement in your local currency
The account start date can't be after the first transaction you wish to import
To check the types of files you can import, see Supported file formats for bank statement imports

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.

If you receive an error message when importing your bank statement, Read our Common import errors article.

Review imported bank transactions

The number of imported transactions from your statement shows on the Banking page. Select the number to view all transactions on the incoming bank transactions page. y

You must then match, create or transfer the transactions as needed.

Available options >

Match transactions to bank rules. Read What are bank rules
Match transactions to outstanding invoices, credit notes or receipts. Read Match bank transactions from bank feeds or an imported file
Create a new transaction
Transfer from or to a different account
Delete bank transactions you don’t want to import

Help with importing a statement

If the import failed, review the list of errors to see which entries failed and why. Correct the issues in your file and then try the import again. Read more about Error: 'File not imported' when importing a bank statement.

Tips for creating a CSV file >

To resolve import errors, copy and paste into a template, then apply example row formatting to all copied rows:

Download a CSV template that matches the information from your bank's CSV file.
In the file, leave the heading and the top example row, then delete the information from all other rows.
In your bank's CSV file:
Remove any columns that aren't in the template file.
Copy all the remaining rows and columns.
In the CSV template:
Right click under the top example row,
In the paste options, choose Paste as values.
Copy the formatting from the top example to all the pasted rows below.
Make sure you leave the amount columns with no values blank and don't contain zeros, 0.00.
Remove any special characters.

Once you've uploaded your statement

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.
Delete any duplicate transactions before importing them