If you perform a VAT reconciliation and upload data with unreconciled transactions, they don't appear on your VAT return in Sage 50 Accounts. In this situation you need to calculate the VAT return in TASBooks, print the detailed VAT report and add the balances to your first Sage VAT submission.
Unpaid and unallocated invoices that are recorded under a VAT Cash Account scheme will be transferred using appropriate VAT Coding. These transactions appear on your VAT return once the payment/receipt or allocation is complete in Sage 50 Accounts.
Outstanding invoice transactions that have VAT distributed into multiple VAT rates appear as separate transactions on Sage 50 Accounts with the appropriate VAT coding. For more information about this, check the adjusting figures on your VAT Return guide >
The migration process doesn't migrate your Government Gateway VAT credentials for submissions. You need to enter these in Sage 50 Accounts. Read more >
If you run a VAT Cash Accounting scheme you'll see a difference in the trial balance totals in Sage when compared to TASBooks. This is due to the way Sage 50 Accounts records purchase and sales VAT as separate nominal accounts. TASBooks records VAT into a single nominal account so when the values are migrated this single account is reversed into the two separate accounts, therefore potentially increasing both the Debit and Credit side of the sales and purchase VAT accounts.
Differences in your Trial Balance can also occur if you have values recorded in your opening balance and suspense accounts in TASBooks as these are consolidated into a single combined suspense account in Sage 50 Accounts.
If you use Multiple Departments in TASBooks the migration process consolidates all departments into a single nominal code balance, it does this by creating a new nominal code to combine the values. This is necessary because Sage departments are not directly linked to nominal codes like in TASBooks. You need to recreate your departments in Sage 50 Accounts.
A department consolidation report is attached to help you reconcile the new codes to the original source code used in TASBooks.
Some transactions may be found to have allocation issues in TASBooks, for example a payment/receipt allocation failure. To fix this, you need to unallocate the transactions on the relevant customer or supplier account so that the migration can take place successfully.
This doesn't affect the overall balance on the affected account, but it may require you to reallocate the transactions in Sage 50 Accounts so they don't show as outstanding amounts on your aged balance reports.
A migration adjustment may also be required to put the unbalanced value back into the purchase or sales control account to correct your trial balance. This will be carried out, if necessary, by the migration team and will show as a Migration Adjustment from the Combined Suspense Account to the affected control account.
As we're unable to migrate your existing chart of accounts structure on TASBooks we try to accurately map your codes to Sage 50 Accounts. Sometimes due to the complexity and customisation on TASBooks some codes may not map in a way that you would like. In this situation you may need to make some minor adjustments to the way they are presented and located on your management reports.
For more information, check the following guides:
All transactions are posted to the opening date that you request. This includes nominal, invoice/credit notes and unallocated payments and receipts. Unfortunately, it isn’t possible to transfer transactions using the date they were entered. If you need to see aged balances you can still access TASBooks to view this historical information pre-migration.
Please note, your returned Sage 50 Accounts back up file size will be smaller than your TASBooks back up file, due to the exclusion of historical data.
If you have unreconciled bank transactions migrated, the first time you do a reconciliation on Sage it may appear incorrect. To create unreconciled bank transactions on Sage the migration process needs to make an adjustment to the bank nominal account book balance so you'll see adjustment transactions on this screen the first time you do it.
Reconcile the transactions as normal against your bank statement and once you’re happy with the checks, select the adjustment transactions to include them in the saved reconciliation. This is only necessary on the first reconciliation in Sage 50 Accounts.
The migration transfers all product records. If you need to do data cleansing and remove any records you can use the Clear Stock option. This removes the opening balance cost price created by the migration to allow you to delete the product record.
To help you find the report, you're looking for in Sage 50 Accounts, we've set up a report finder guide.
While we make every effort to accurately transfer your data and carry out basic balancing checks we strongly recommend that you reconcile your Trial Balance and Customer/Supplier balances in Sage 50 Accounts.
For assistance with chart of accounts changes please contact Sage support.