Sage Accounting Migration Tool in Sage 50 Accounts

The Sage Business Cloud Migration Tool can be used to validate Sage 50 Accounts datasets to make sure they will import into Sage Accounting, once validated you can then create a file to import into Sage Accounting.

If you haven't already, take a look at our Prepare to migrate guide to make sure you have your accounts in order and don't have any potential barriers that could prevent the migration. Read more >

To use the migration tool you must be logged on as Manager or Administrator. Unfortunalty the migration tool only supports UK based companies, but we are working on it, if you are an Irish based company you can follow our other migration options.  

 CAUTION: Not using 27.2? You can upgrade to the latest version or download and install the migration tool.

1. Open Sage 50 Accounts and from the Company List, choose the company you wish to convert to Sage Accounting and click Open Company.
    TIP: You can see the status of your company data for migration in the 'Sage Accounting migration ready?' column. 
2. Click File, Maintenance then click Validate.
3. Once the Sage Business Cloud Migration Tool opens click Next, then, click Next.
4. To make sure your migration is successful please enter the following:
   

   Company details	Enter required company details.  CAUTION: Please make sure you enter your full postcode e.g. NE139AA
   Company Contents	This information shows you the contents of your data.
   Approach	Select the relevant approach: Transaction histories - includes all transaction from Account Start Date to the current date. Opening Balances - includes opening balances from current date. Account records only - includes customers, suppliers, chart of accounts and bank accounts but no transaction history. you also have the option to Ignore any inactive accounts.
   Dates	Enter Years to migrate, we recommend entering two and to check the Opening Balances Date.  NOTE: you can migrate more than two years however, the chances of the migration failing will increase.
   VAT Registration	If required, enter your VAT details, and check the Tax Return Frequency.  CAUTION: When entering your VAT Number please ensure it has no spaces e.g. 012345678
   Select Reference	Sage Accounting can only include one invoice reference, therefore you need to select which reference you want to migrate.

5. From the drop down list, choose the Chart of Accounts you want to migrate, then click Go.
    TIP: If you've converted companies before, and have saved settings you want to apply, to load the file, click Load previous settings.
   A confirmation window appears listing completed tasks and any items to review.
6. To check the mappings and assignment of codes click View all items.
   If required, you can edit the mappings and if you have errors or warnings, click the links to investigate further and allocate codes as required.
7. Click Next.
8. If required, you may need to resolve conflicts, you can do this manually, or click Auto-resolve conflicts, enter the relevant changes and click Apply.
9. Click Next then click Download Data File.
10. Enter a file name, browse to a known location, we recomend your desktop, click Save and OK.

You've successfully exported the Sage 50 Accounts dataset and you're now ready to import the file into Sage Accountant Partner Edition.

Next step > 

Need Help?

The AD Migration Team are restricted in terms of any technical support that they offer for ‘self-serve’ migrations as they are resourced on an appointment basis schedule for Sage Accountants who have requested the service being done by a specialist.

If you would like us to take a thorough look into your data we would recommend booking an appointment via your Practice Success Manager and we can complete the migration for you. If you are unsure who your Practice Success Manager is you can contact the team by emailing [email protected].

You can read more about the Free of Charge service we offer for migrations Here>.