Why Accounts Receivable Is Wrong After a QuickBooks Move

When accounts receivable does not match after a QuickBooks Desktop to Online migration, the cause is almost always specific invoices that did not come across, or came across with a different open balance. The A/R Ageing Detail report from both systems is the only report that names them. The trial balance can tell you the control account is out by $8,420 and nothing more.

Why can the trial balance not answer this?

Because A/R on a trial balance is one number — the sum of every open invoice you have.

A single line reading Accounts Receivable 8,420.15 is the total of perhaps four hundred invoices. When it disagrees by $2,300, that could be one missing invoice, three partially-paid ones, or four hundred tiny rounding differences. The number alone cannot distinguish those cases, and no amount of staring at it will.

What should I compare instead?

The A/R Ageing Detail from both systems, matched invoice number by invoice number.

Report	What it gives you
Trial Balance	A/R disagrees by 2,300.00
A/R Ageing Summary	Acme Corp disagrees by 2,300.00
A/R Ageing Detail	Invoice 1041 for Acme Corp, dated 12 Nov, is missing

Each step down that table cuts the search by roughly an order of magnitude. Detail is worth the extra export every time, because an invoice number is something you can go and look at.

What are the usual causes?

What you find	What it usually means
Invoice missing entirely	It did not migrate — often outside the transaction date range that came across
Open balance lower in Online	A payment or credit was applied differently
Open balance higher in Online	A payment did not migrate, or was unapplied
Customer missing entirely	The customer record did not come across, taking their invoices with it
Extra invoice in Online	Created during migration, or a duplicate

Missing invoices and unapplied payments are the two that account for most of the money.

Does a matching total mean I am safe?

No, and this is the trap. Two errors of the same size in opposite directions cancel out perfectly in the control account.

If invoice 1041 for $2,300 failed to migrate and an unrelated payment of $2,300 also failed to migrate, A/R agrees to the penny and two records are wrong. Only a line-by-line comparison catches that, which is precisely why the summary total is not sufficient evidence.

What about credit balances?

A negative open balance on a customer is normal — it means they have a credit or an overpayment on file. What matters is whether the sign survived the migration.

Real exports routinely show customers sitting at figures like -4,283.76. Check that credits are still credits on the Online side, because a flipped sign moves money by twice the amount and is easy to miss when you are scanning for missing rows.

Quick reference

Question	Answer
Which report names the invoice?	A/R Ageing Detail, both systems
Is a matching A/R total proof?	No — offsetting errors cancel out
What matches across systems?	The invoice number, within a customer
Most common single cause?	Invoices outside the migrated date range
Second most common?	Payments applied differently

Upload both ageing reports to the free check and it does the invoice-by-invoice match for you, naming each one that is missing or has moved.