How do I verify my converted data in QuickBooks after switching from Sage 50?
Run a four-point comparison before going live: trial balance, A/R and A/P aging, inventory quantities, and bank balances against your Sage reports.
Verify by comparing the QuickBooks file against your Sage reports as of the conversion date, before you record anything new. Four checks catch nearly every conversion problem: the trial balance, A/R and A/P aging, inventory quantities and value, and bank and credit card balances. If those four tie to Sage at the cutover date, the file is safe to go live on.
Start with the trial balance
Run a trial balance in QuickBooks as of the conversion date and set it beside the same report from Sage. Every account balance should match to the cent. Equity accounts deserve extra attention: differences in retained earnings and year-end rollover are common and usually explainable. What you are hunting for is a difference nobody can explain, because that points to a transaction that did not convert or landed in the wrong account.
Check A/R and A/P aging
Open the A/R aging summary and A/P aging summary in QuickBooks and compare each bucket against Sage. Compare customer and vendor totals first, then drill into individual invoices only where a total is off. An invoice that converted with the wrong date will shift between aging buckets even though the grand total still looks right, so the bucket totals matter as much as the bottom line. Unapplied credits and prepayments are a frequent source of small differences; check those before assuming a transaction is missing.
Verify inventory quantities and value
If Sage tracked inventory, compare quantity on hand per item and the total inventory asset value. Check the total first, because small per-item differences compound into a large asset difference. What carries over, and how cleanly, depends on the file: if quantities or the asset value are off, our engineers can evaluate the converted file and tell you whether it is a mapping issue that can be corrected or data that needs to be converted again.
Reconcile bank and credit card balances
Compare each bank and credit card account balance in QuickBooks to Sage as of the cutover date. Then, after go-live, reconcile the first month against the actual statement; that is the final proof that opening balances and cleared items arrived intact.
Run Verify on the new file
Before go-live, run the built-in Verify utility on the converted company file to confirm the conversion left no structural damage. If Verify reports errors that Rebuild does not clear, it is a repair job rather than a re-entry job; see our page on files that fail Verify or Rebuild.
When a number will not tie
Do not enter new transactions in a file that does not tie out; every day of new activity makes the cleanup harder. Write down each difference with its amount and account. If the totals will not reconcile, contact us about the file and we will assess what happened; the evaluation is free, and cost and timing depend on what the file actually needs.
Your next step: pick your cutover date, print or export the four Sage reports as of that date, and block an hour to run the comparisons above. Go live only when every total ties.