NOTE: To find out what data you can import and for help with preparing your import file, take a look at our guide to data 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.
   • If required, you can use the Load Map and Save Map options to import the default or previously saved mappings.
9. Once all of the required fields are mapped, click Next, check the summary information is correct, then click Import or Finish.

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 the Imported pane. Click Edit import to amend the original import file, click Close, then attempt to import again.