We use cookies on our website to provide you with the best experience. If you continue browsing, you are consenting to our use of these cookies, but if you would like to know more, including how you can change your settings, take a look at our Privacy Notice.

Sage 50 Accounts Import Wizard

To save time entering data into Sage 50 Accounts, you can create an import file that holds the information you want to enter. Once your data file is prepared and you've closed the file, you can quickly import the information into your software.

Find out what data you can import >

Import your data file

  1. On the menu bar click File then click Import.
  2. If required, click Backup to back up your data, then once complete, click Next.
  3. In the Data type window, select the type of data you want to import then click Next.
  4. In the Data source window, select the format of the data you're importing.

    The Excel worksheet (*.xls;*.xlsx) option is only enabled if you've a compatible version of Microsoft Excel installed.
  5. If the first row of your data contains headings, select the First row contains headings check box.
  6. Click Browse, locate and select the file to import, then click Open.
  7. If your import file contains multiple worksheets, choose the required worksheet from the drop-down list.

  8. Click Next. To link the imported data to the correct fields in Sage 50 Accounts, complete the Imported Field column as required, choosing the relevant field from the drop-down list. Compulsory fields are marked with an asterisk.
  9. If required, you can use the Load Map and Save Map options to import the default or previously saved mappings.

  10. Once all of the required fields are mapped, click Next, check the summary information is correct, then click Import or Finish.
  11. If the import is successful, a list of transactions imported appears in the Record Imported pane. Click Close.

    If the import is unsuccessful, a list of import errors appear in the Records not Imported pane. Click Edit import to amend the original import file, click Close, then attempt to import again.

Watch the video