Transitioning from sage 50 to quickbooks

Forum|Forum|7 days ago
July 2, 2026
2 replies
30 views

Hi all,

I’m not an accountant but I have been tasked with helping a small business transition from sage 50 to QB. My big issue is the company has 2 company files, one for US sales in USD and one for Canadian sales in CAD. It is a Canadian company so the majority of the accounting work is done in the Canadian file.

They want it to be multi-currency so that the inventory is combined and it removes the need for end of month conversions. I have progressed so far with importing the canadian chart of accounts, customers and suppliers. I have a Journal entry that was built off of the Canadian trial balance, i broke up the accounts payable and recievable into all the different vendor purchases and customer purchases.

I have a few concerns though, I see that on the trial balances it looks like the company has a US accounts recievable (i think this is brought over from the US file and is convered to CAD dollars) and they also have multiple accounts that hold USD but are convered to CAD on the balance sheet.

Im assuming i want to remove the US account recievable and find a credit to remove that amount from to balance the sheet, then add the customers details from the US file after the initial journal load in USD to the same accounts recievable (so the US and CAD recievables end up in the same bucket instead of split)
Is there an easy way of doing that? Do i have to do it through importing invoices (for the US Customer Purchases) instead of a Journal Entry where everything seems to need to be balanced.

Thanks,
Sean

QuickBooks Online - International

SIAB

Level 2

Where is your client’s company located? US, Canada, or another country?

J

JaneDave_I

QuickBooks Team

Instead of dealing with time-consuming manual entry and confusing bookkeeping adjustments, the easiest approach is to let an automated tool capture your main information first, then add the US dollar details later.

We’ll start by purging your current QuickBooks account. This gives us a fresh start and prevents any old or messy files from getting in the way of the transfer.

Once everything is cleared out, we will use a tool called Dataswitcher on your Canadian Sage file. It automatically copies over almost all of your history, like your past transactions, bookkeeping categories, and customer and vendor lists, way faster and with much better accuracy than doing it by hand.

Once we confirm that all your Canadian information has been safely transferred, we have to enable the Multicurrency feature in your QuickBooks account. After that, you can manually import your US customers with their assigned USD currency along with their unpaid invoices and balances. QuickBooks will take care of the rest, automatically tracking your US dollars while keeping them separate from your Canadian funds.

Feel free to reply to this post if you need a hand with anything else. We want to make sure you're completely taken care of.

Sign up

Login with SSO

Let's get you signed in

Login with SSO

Scanning file for viruses.

This file cannot be downloaded