+1 480 485 7373
Microsoft Teams
What changes when the books leave QuickBooks
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 a transaction 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, a report is filtered by class, location or customer after the fact. In Business Central, dimensions are stamped on every ledger entry at posting time, so the analysis you want next year has to be designed before the first opening entry is loaded.
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
QuickBooks habits that need a decision first
Undeposited Funds
QuickBooks parks receipts in Undeposited Funds until a deposit is recorded. Any balance still sitting there at cutover has to be cleared or explained, because Business Central applies payments through a cash receipt journal straight to a bank account. Every open item in that account is listed before the cutover date.
Edits to closed periods
QuickBooks lets users change prior-period transactions unless a closing date and password are set, and many files have neither. We compare the trial balance your accountant signed off with the one the file shows at export, since 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 businesses invent workarounds like a second vendor record with a suffix. Business Central keeps customers and vendors apart and can link them for netting, so those duplicates can be merged.
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, and the method you choose decides how opening quantities must be valued.
A cutover built around month-end
- 1
Pick a period end
Cutover lands on the last day of a month, ideally a quarter end, so the closing QuickBooks trial balance is a set of numbers your accountant already knows and has checked.
- 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, so your team can test posting before anything is final.
- 3
Freeze QuickBooks
On cutover day QuickBooks stops taking new invoices and bills. Anything dated after the cutover is entered in Business Central only, and the QuickBooks closing date is set so nobody slips an entry in.
- 4
Bring open items as documents
Each unpaid invoice and bill comes across individually with its original number, date and due date, so aging and collections carry on. The offset goes to a migration clearing account.
- 5
Post balances and prove them
Balance-sheet accounts are posted as one opening journal. The clearing account must net to zero, and receivables and payables aging must match the QuickBooks aging reports to the cent.
What stays in QuickBooks
- ✓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 migration questions
Can we bring all our QuickBooks transaction history?
Technically yes, but it is rarely worth it. Every historical invoice would need its customer, item, tax and dimension mapped exactly as current data is, and the old transactions were posted under rules that no longer apply. Most companies bring monthly net change by account for the prior year or two, which keeps comparative financial statements working, and keep QuickBooks available read-only for lookups. If an auditor or a lender needs detail, the archived file answers that.
Do QuickBooks Online and Desktop move the same way?
The destination is the same, but the extraction differs. QuickBooks Online data comes out through its list and report exports or its API, while Desktop offers list exports, report exports to Excel and IIF files. Desktop files also tend to carry older quirks, such as average cost inventory and years of unused list entries, so they need more clean-up before anything is loaded.
Will our outside accountant still be able to work with us?
Yes. Business Central has an External Accountant licence type, and almost every list and report exports to Excel. Your accountant will see a different screen, but the trial balance, aging and financial statements are recognizable. We suggest involving them in approving the cutover trial balance, since they will sign off on the year that straddles both systems.
What happens to our sales tax setup?
QuickBooks sales tax items and groups are rebuilt as tax jurisdictions, tax groups and tax areas, which is how US sales tax works in Business Central. Companies selling into many states often add a tax calculation service from AppSource instead of maintaining rates by hand. Either way, the setup is tested on sample invoices before cutover so customers are charged what they were charged before.
How is a QuickBooks migration priced?
We scope it in writing first: the number of companies, whether inventory is involved, how much history you want and which integrations exist. The scoping call sets the plan, and you see the written scope before any commitment is made.
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.