Skip to main content
All CollectionsSage 50 Accounts - IntegrationSage 50 UK&IInvoices & Bank Statements
Download and import bank statement data into Sage 50 Accounts UKI
Download and import bank statement data into Sage 50 Accounts UKI

How to download the bank statement from AutoEntry and import it into Sage 50 Accounts UKI.

Oliver Cook avatar
Written by Oliver Cook
Updated over a week ago

To transfer your bank statement data from AutoEntry into Sage 50 Accounts, you must do the following:

  1. Download the bank statement from AutoEntry.

  2. Edit the Excel template where required.

  3. Import the completed template into Sage 50 Accounts.

📎NOTE: This only works if you use Sage 50 Accounts v25 and above.


Before you start

Before you import your Bank Statement data from AutoEntry to Sage 50 Accounts you require the following details:

  • Your Sage account number

  • The nominal account entered

  • The tax code entered

This is because AutoEntry can't add these details so you must add them manually before importing.

📎NOTE: If you have any intra-account transfers on the statements to import, use our guide, AutoEntry Bank Statement Export with Account Transfers for Sage 50 Accounts UKI, for more information on how to handle these transactions before importing.


Step 1 - Download bank statement data from AutoEntry

  1. Follow the usual steps to download your extracted bank statement data from AutoEntry.

    When you need to select a file type, click Sage 50.

  2. Enter the relevant bank account code 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.

  3. Enter the appropriate nominal account code numbers in column C.

  4. Enter the appropriate Tax Codes (T1/T2 etc.) in the Tax Code column.

  5. Save the file as a regular CSV and close it.


Step 2 - Import into Sage 50 Accounts

  1. Go to Sage 50 Accounts and click File.

  2. Click Import, and the data import pop-up opens.

  3. Follow the on-screen instructions.

📎NOTE: All the fields will be already pre-mapped for Sage 50 Accounts.

📌TIP: For more details on how to import into Sage 50 Accounts, use the Sage 50 Accounts guide below.

As you already have an import file prepared, you can skip to the section on how to import the completed template.

Did this answer your question?