How to know if your QuickBooks numbers are actually right

A QuickBooks file that reconciles is not the same as a QuickBooks file that is correct. Reconciliation inside QuickBooks confirms that the transactions you entered add up to the ending balance you typed in. It does not confirm that those transactions match what actually happened in your bank, your card processor, or your marketplace payouts. The software can only report what it was told.

So the honest question is not “did it reconcile,” it is “does it agree with an independent record of the same money.” That is a different test, and it is the one that catches the errors that matter.

Why a clean reconciliation can still hide a wrong number

Most bookkeeping mistakes are not math errors. They are duplicated deposits, a payout booked as one lump sum instead of its fees and sales, an opening balance that was never explained, or a transaction edited inside a period you thought was closed. Each of these can leave the ending balance looking perfectly reconciled while the underlying detail is wrong.

The only way to find them is to compare the ledger to a second source that was produced independently: the bank statement, the processor settlement, the raw payout file. If the two disagree, the difference is real and it is measurable.

Measure the leftover in dollars, not a health score

When you compare two sources, resist the urge to collapse the result into a percentage or a grade. A “92% healthy” badge tells you nothing you can act on. What you want is the leftover: the exact number of dollars that one source has and the other cannot explain. That figure points you straight at the transaction that is missing, doubled, or miscategorized.

This is the core of Money Truth in FlowLedger. It reports leftover dollars from one second source, computed from stored events. When only QuickBooks is connected, it stays blank on purpose, because there is nothing yet to compare against. A blank field is the honest answer; an invented match would not be.

Read confidence from evidence, not a guess

When two records do line up, how sure are you that they are the same transaction and not a coincidence of the same amount on the same day? That certainty should come from evidence you can name: the date, the amount, a shared reference or memo, and the counterparty. The more of those that agree, the higher the confidence, and you should be able to open any pair and see exactly which pieces of evidence supported it.

That is deliberately different from leftover dollars. Leftover is how much money is unexplained. Confidence is how sure you are about an identity between two rows. Keeping them separate is what stops a weak match from being dressed up as a strong one. The reconciliation workspace pairs every movement, persists the match status between sessions, and draws confidence from that evidence rather than a model guess.

Check the structure of the file itself

Comparing to a second source catches money that does not line up. A separate pass should look at the ledger on its own for structural problems: duplicate entries, stale open items, an unexplained opening equity, and changes made inside a protected period. In FlowLedger these surface as individual book-integrity findings, each a stored record you can open and inspect. It is an internal integrity score, not a credit rating, and every component is something you can trace.

A practical sequence

To actually prove a period rather than assume it: connect QuickBooks, then bring in one real independent source for the same window, a bank feed or an imported statement. Look at the leftover in dollars and work it down to zero, opening each pair to confirm the evidence behind it. Then review the structural findings on the file and resolve the ones that are real. When the leftover is explained and the findings are cleared, you are not hoping the books are right, you can show why they are.

Nothing in this process posts back to QuickBooks or changes your accounting. It is a layer of proof on top of it. If the evidence is not there yet, the honest move is to say so and leave the field empty rather than fill the gap with a number that looks finished.

You can run this against your own file for free. Create an organization, connect QuickBooks and one real source, and see the leftover in dollars for yourself.