Skip to content
logo Knowledgebase

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

Created on  | Last modified on 

Summary

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

Description

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 50cloud Accounts.

When the data migrates, the VAT returns may not match those in Sage 50cloud Accounts. We recommend you check the first VAT Return you generate in Sage Business Cloud Accounting to ensure it's 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 50cloud 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 50cloud 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 neededm 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 50cloud 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 so we advise to do individually and remove any Non-GB VAT Numbers in the record. 


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 50cloud 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 50cloud 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 so we advise to do individually and remove any Non-GB VAT Numbers in the record. 


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.