+1 480 485 7373
Microsoft Teams
What changes when QuickBooks books move to Business Central
QuickBooks posts almost everything straight to the general ledger through the items and accounts chosen on each form. Business Central adds a layer in between. Posting groups on customers, vendors and items decide which G/L accounts an entry hits. That layer lets a controller change the account for a whole class of transactions in one place. It is also the first thing the migration has to design, because QuickBooks has nothing to copy it from.
Reporting shifts too. In QuickBooks, you filter a report by class, location or customer after the fact. In Business Central, dimensions land on every ledger entry at posting time. So you design next year's analysis before you load the first opening entry.
None of this means rebuilding the business from scratch. Customers, vendors, items, terms and the chart of accounts all have direct counterparts. The work is in the decisions around them.
QuickBooks lists and where they land in Business Central
QuickBooks habits to settle before Business Central
Undeposited Funds
QuickBooks parks receipts in Undeposited Funds until someone records a deposit. At cutover, you clear or explain any balance still there. Business Central applies payments through a cash receipt journal straight to a bank account. We list every open item in that account before the cutover date.
Edits to closed periods
QuickBooks lets users change prior-period entries unless someone sets a closing date and password. Many files have neither. So we compare the trial balance your accountant signed off with the one the file shows at export. A late edit to last year quietly changes the opening balance.
One names list
In QuickBooks Desktop a name can be a customer, a vendor or an employee, but not two at once. So firms invent workarounds, like a second vendor record with a suffix. Business Central keeps customers and vendors apart and can link them for netting. That lets us merge those duplicates during the QuickBooks to Business Central migration.
Average cost on Desktop
QuickBooks Desktop Pro and Premier value inventory at average cost, while QuickBooks Online uses FIFO. Business Central offers FIFO, LIFO, Average, Standard and Specific, set per item. The method you choose decides how you value opening quantities.
A QuickBooks to Business Central cutover at month-end
- 1
Pick a period end
Cutover lands on the last day of a month, ideally a quarter end. Then the closing QuickBooks trial balance is a set of numbers your accountant already knows.
- 2
Load master data into a sandbox
Chart of accounts, customers, vendors and items go into a Business Central sandbox through configuration packages and Excel. Your team then tests posting before anything is final.
- 3
Freeze QuickBooks
On cutover day QuickBooks stops taking new invoices and bills. Staff enter anything dated after cutover in Business Central only. We also set the QuickBooks closing date so nobody slips an entry in.
- 4
Bring open items as documents
Each unpaid invoice and bill comes across with its original number, date and due date. That way aging and collections carry on. The offset goes to a migration clearing account.
- 5
Post balances and prove them
We post balance-sheet accounts as one opening journal. The clearing account must net to zero. Receivables and payables aging must match the QuickBooks reports to the cent.
What stays in QuickBooks after the move to Business Central
- ✓Bank reconciliation history. Business Central starts from the last reconciled statement balance, with uncleared checks and deposits loaded as open items.
- ✓Memorized transactions and recurring templates, rebuilt as recurring journals or standard sales and purchase codes.
- ✓Payroll. There is no built-in US payroll in Business Central, so the payroll service stays and posts a journal entry each run.
- ✓Attachments, notes and the audit trail. Keep a read-only copy of the file, or an export, for your auditors.
- ✓Closed invoices and paid bills. Prior-year detail is usually summarized as monthly net change by account so comparative statements still work.
- ✓Custom report layouts and saved report settings, replaced by Business Central reports, Excel layouts or Power BI.
QuickBooks to Business Central migration questions
Can we bring all our QuickBooks transaction history?
Technically yes, but it is rarely worth it. Each old invoice would need its customer, item, tax and dimension mapped like current data. And the old entries followed rules that no longer apply. Most firms bring monthly net change by account for a year or two and keep QuickBooks read-only for lookups. The archived file answers any auditor or lender who needs detail.
Do QuickBooks Online and Desktop move the same way?
The target is the same; the export differs. QuickBooks Online data comes out through exports or its API. Desktop offers list exports, Excel report exports and IIF files. Desktop files also carry older quirks, such as average cost and years of unused list entries, so they need more clean-up.
Will our outside accountant still be able to work with us?
Yes. Business Central has an External Accountant license, and nearly every report exports to Excel. The screens are new, but the trial balance, aging and statements look familiar. Ask them to approve the cutover trial balance, since they sign off on the year that spans both systems.
What happens to our sales tax setup?
We rebuild QuickBooks sales tax items and groups as tax jurisdictions, groups and areas, the way US sales tax works in Business Central. Multistate sellers often add an AppSource tax service instead of keeping rates by hand. Either way, we test the setup on sample invoices so customers pay the same tax as before.
How is a QuickBooks migration priced?
We scope it in writing first: how many companies, whether inventory is in play, how much history you want and which integrations exist. The scoping call sets the plan, and you see the written scope before you commit.
Talk to us about your project.
Tell us what you run today and what has to change. A senior consultant replies with a written next step.