Please note, these steps are for the latest v.25 version of Sage 50. If you have any intra-account transfers on the statements to import, please see here for handling these transactions before importing.
First Download your extracted bank statement data from AutoEntry in the Sage 50 format.
Sage 50 requires the account number from Sage, the nominal account and tax code entered before uploading to Sage. These details cannot be added by AutoEntry and so must be added before importing.
Open the CSV file that you downloaded from AutoEntry:
- Enter the correct bank account code for the account you're looking to import to in the Account Reference field (column B). This is the Sage 50 nominal code, not the actual bank account number. AutoEntry defaults to 1200 in the csv.
- Enter the appropriate Nominal Account Codes (the code number) in column C for Nominal Account. Note that for any transaction that is a transfer to a second bank account in the same Sage 50 company, then instead of adding this second bank account's code here (e.g. 1210), enter a suspense account code (e.g. 9998) - this balance will then be "contra'd off" when the equal-and-opposite entry is posted into the second bank account.
- Enter the appropriate Tax Codes (T1/T2 etc) in column for Tax Code (column I).
- Save the file as a regular CSV.
In Sage 50:
- Click 'File' and select 'Import'. The data import pop-up opens, there are 5 steps to complete the import. If a backup is required it can be done here too.
- Click 'Next'
- Select the first option - 'Audit Trail Transactions' and click Next
- Leave the selection on 'CSV' and browse your PC for the saved file of transactions. Ensure to check the box that the first row contains headings and click next.
- All the fields are pre-mapped for Sage 50 so simply click next.
- On the final screen simply click Import.
Sage can take a minute or two to import the file depending on file size, your computers' processing speed etc. An 'Import Results' window will show the successful import once the process is complete. If there are any errors, these would need to be corrected in the csv file and then imported again.