Welcome
Login

Conversion limitations Sage50 Canada

We are aiming to cover all the possible scenarios of your source accounting system when converting it to the new one, nevertheless because the systems subtly vary on how they are handling accounting, it is not always possible to convert everything and for all your accounting period. Hence it is important you take your time to understand the limitations of our service.

Learn more about conversion limitations for all systems.

Apart from the limitations listed in the article linked above, Sage50 Canada also has the following ones:

Cash refunds and cheque refunds will be posted as journals

Quickbooks Online does not support refunding a cash payment or cheque from a supplier. So these entities will be posted as regular journals with no link back to the customer or supplier.

Some reversed journals will be posted

Some reversed journals will be posted to the destination system, since clearing them can cause differences in your Quickbooks conversion. Dataswitcher only clears journals when they cancel each other out.

Some debtor or creditor transactions, might not be posted as you expect

Due to various reasons related Dataswitcher might need to use a dummy customer or supplier to align your AR and AP history. 

"AR/AP auto-matching only occurs when the outstanding balance of the customer 
or supplier is 0.00"

Dataswitcher will try to auto-allocate all customers and suppliers that have a zero amount outstanding on conversion date with a special algorithm. If you have posted directly to your AR or AP system accounts you need to correct this post migration. Dataswitcher will try to make sure your historical AP an AR reports are similar for key dates (end of years and conversion date). In between these dates the reports might show discrepancies. When checking the AR and AP reports, please make sure that the data from Sage50 Canada is correct. There are situations where open invoices do not show up in the summary, but do show up in the detailed view in Sage50 Canada. Also make sure you are checking on either one of these dates:

1) Last transaction date in file

2) Migration date (the date when your data moved to QBO)

3) On any end of year

Alignment of AR/AP only happens on these moments.

"If you are using multiple accounts receivables and payables accounts these 
will be merged into one."

"As Quickbooks Online does not support having multiple of these accounts."

If you are transferring money between AR/AP accounts in transactions, these will be treated as journals. If you have purged data from your file, payments and invoices will posted as journals instead. You might have to allocate debits to credits for customers / suppliers that have an outstanding amount on migration date.

We will copy dates straight from the file

In Sage50 Canada, we will copy the dates straight from your file. If the journals in your file are dated in the future, the transactions will also be posted in the future to the destination system.

Foreign data will be converted in home-currency

All foreign currency data, is converted in home-currency. The historical exchange rate in Sage50 Canada will be used to do the conversion.

Historical migrations of accounts

Sage50 Canada allows you to transfer balances to new accounts on the close of year (transferring of opening balances). The history for these accounts will also be renumbered by Dataswitcher. Example: You have an old account 1250 which you have used in 2018, start of year 2019 you renumber this account to 1251, Dataswitcher will then also renumber the 2018 year for 1250 to 1251.

Financial start date

In Sage50 Canada it is possible to choose a start day other than one. Ie. 14-01-2020 instead of 01-01-2020. Quickbooks does not support this. Please keep this in mind when you are checking your trial balance since they can profit and loss accounts can be off. In that case your retained earnings will also be off.

Check your retained earnings

In Sage50 you can setup an opening balance for an account. In some cases (especially when the file is relatively new - or you have never run a close of year before) Dataswitcher can not reconstruct the account used for creating that opening balance (often it is retained earnings). That is why Dataswitcher will create the opening balance transaction, and will send the net result to the retained earnings account in the destination system. You need to check your retained earnings post-migration to see if this agrees. In some cases, DS might use the opening balance equity account. You might need to transfer from that account into retained earnings to get the amounts to agree.

Departments and classes

If you pick the classes and locations paid extra during the migration, the migration will be done as journal only. Next to that the departments and classes might not agree on retained earnings. Since you can purge data from Sage50 Canada for the old journals, the classes and departments for retained earnings might be off.

"Due to QBO API limitations, only departments are converted, not projects."

Forward journals (Next Year) will not be posted

If you have any next year journals, these will not be posted to Quickbooks Online. You have to add these manually.

Items and stock

Dataswitcher does not post a lot of fields for items and stock. Only code, stock code, location, name and description are posted. Current stock and purchase and sales price are also posted. Income and asset account are not posted to Quickbooks. We can however deliver you a set of files (the database tables from Sage50 Canada) which you can import manually in to Quickbooks Online.

Positions for COA numbers

Quickbooks does not support chart of account numbers that exceed the length of 7. If you have accounts in your chart of accounts which are 7 or longer, the migration will fail.

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.