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. This option is useful when:
- 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
Before you begin
Take note of these important points:
- 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
Import your statement
For your first time importing your bank statement, see the steps below:
- From Banking, locate the bank account you want to import transactions to.
- Select Actions and then Import statement.
- Browse to or drag and drop the file you're uploading, then select Review transactions.
- Select the date format used in your file so we can process it correctly, then choose Continue.
- You can now Review transactions to check any errors.
- Select Confirm import to finalise.
After importing a statement for the first time, Accounting retains the options you selected for your next import. You'll get the option to change your Import settings and Import without review to speed up the process.
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.