Skip to content
logo Knowledgebase

Sage 50 Accounts to Sage Business Cloud Accounting - Reasons why migration may fail

Created on  | Last modified on 

Summary

This article covers some common error messages that may appear when migrating data from Sage 50 Accounts to Sage Business Cloud Accounting.

Description

 NOTE:This is not an exhaustive list of errors, if you are experiencing any which are not included on this article, please reach out to your Practice Success Manager who can then book you in for an appointment with the AD Migration Team. The AD Migration Team can provide a free of charge service to migrate the data for you, they do not offer Technical Support or training on how to migrate from Sage 50 Accounts to Sage Business Cloud.  

Some transactions have VAT values stored for zero rated VAT codes. To migrate these transactions the VAT code needs to be changed to the standard rate VAT code. This may impact future VAT Return declarations. Do you wish to continue?  
 
This doesn't affect or prevent migration; this error means that a VAT amount has been added to T0 in Sage 50 Accounts. 
 
When the data migrates, the VAT returns may not match those in Sage 50 Accounts. We recommend you check the first VAT Return you generate in Sage Business Cloud Accounting to ensure its correct. 
 
It is not possible to migrate this company due to the following error: Your data contains transactions using reverse charging on domestic supplies. These are not currently supported in Sage Business Cloud Accounting.   
 
This isn't currently supported via the tool. 
 
As a workaround you can edit the tax code in the configuration settings of Sage 50 Accounts.  
  • Clear the Enable Import/Export Code and Include in VAT Return checkboxes.
  • Using the drop-down option for Reverse Charge, change CIS Reverse Charge to No. 

Transactions migrate as Zero Rated. 

  • If the affected transactions have already been VAT Reconciled this only affects the historical ones and we recommend you use Sage 50 Accounts for record purposes. 
  • If the affected transactions haven't been VAT Reconciled, then the next VAT Return in Sage Business Cloud Accounting needs to be amended to account for this. For any purchases you need to do an adjustment on the VAT Return on Box 1 and 4 to add the VAT Value. For any sales no adjustment is needed as the Net Value is picked up on Box 6 as normal. 
 
Unable to migrate your data as VAT has been applied to unreconciled transactions for the following non-EU customer accounts:  / Unable to migrate your data as VAT has been applied to unreconciled transactions for the following non-EU supplier accounts:  
 
This occurs if any customer or supplier records have a non-GB Country Code. 
  • We recommend you apply a filter in each screen in Sage 50 Accounts stating -  Where > Country Code > Does not Equal > GB. 
  • Change the Country Code of each of these customers and supplier record to GB. 
  • Make a note of the changes, once the data is in Sage Business Cloud Accounting you should change these back to how they were originally. 
 
 NOTE: Batch Changes only works if there aren't VAT Numbers on the record. If you do have VAT Numbers on your customer or supplier records, you will need to amend each one individually and remove any Non-GB VAT Numbers in the record before following the above steps.  
 
Your data contains some incomplete journal entries and cannot be migrated.   
 
This error is potentially caused by Link Removed Transactions. You should run the reports available in the software to establish this. 
 
A clear audit trail routine may remove the Link Removed transactions. 
 
It is not possible to migrate this company due to the following error: Unable to migrate your data as some transactions have been included on more than one VAT Return. The end date of the latest VAT return with this problem is xxx.   
 
This occurs if VAT Return has been deleted in Sage 50 Accounts and then ran again for the same date range. The message advises how many years can be migrated over. 
 
It is not possible to migrate this company due to the following error: Unable to migrate your data as domestic VAT has been applied to transactions for the following EU VAT registered supplier accounts:  
 
This occurs if any customer or supplier records have a non-GB Country Code. 
  • We recommend you apply a filter in each screen in Sage 50 Accounts stating -  Where > Country Code > Does not Equal > GB. 
  • Change the Country Code of each of these customers and supplier record to GB.
  • Make a note of the changes, once the data is in Sage Business Cloud Accounting you should change these back to how they were originally. 
 NOTE:Batch Changes only works if there aren't VAT Numbers on the record. If you do have VAT Numbers on your customer or supplier records, you will need to amend each one individually and remove any Non-GB VAT Numbers in the record before following the above steps.  
 
It is not possible to migrate this company due to the following error: Unable to migrate your data as some required allocation records have been removed from the following transaction numbers:   
 
The message advises how many years can be migrated over. 
 
This error is potentially caused by Link Removed Transactions. You should run the reports available in the software to establish this. 
 
A clear audit trail routine, may remove the Link Removed transactions. 
 
We have detected that you have switched VAT Schemes from Standard VAT to VAT Cash Accounting. We currently do not support this scenario for migration. 
 
This error message appears if the company VAT scheme is VAT Cash Accounting, and the CIS module is enabled. 
 
It's not possible to migrate data with this error via the Migration Tool as an alternative you can enter opening balances into Sage Business Cloud Accounting.