QuickBooks Online · Forensic audit

A forensic audit
for QuickBooks Online.

Find duplicates, anomalies, and data integrity issues across your QBO file — before your accountant does. Get a health score with prioritized recommendations.

The problem

QBO data drifts.
Quietly.

Every QuickBooks Online file accumulates issues over time. Sync errors create duplicate invoices. Customer records get entered twice with slightly different names. Inventory counts drift negative because a return wasn't restocked. Sales receipts post twice when an integration retried after a network blip. None of this is loud — your reports still run, your reconciliations mostly work — but the data quality erodes month after month until someone has to sit down and untangle it.

That someone is usually your accountant, at year-end, billing by the hour. By then the errors have compounded across multiple periods, and the cleanup is painful and expensive. The earlier you catch them, the cheaper the fix.

What TheReconciliator does

A structured audit pass
across your whole file.

TheReconciliator connects to your QBO company through the standard Intuit OAuth flow and runs a full forensic audit across transactions, customers, vendors, items, and inventory. It surfaces duplicates, anomalies, and data integrity issues, scores the overall health of your QBO file, and gives you a prioritized list of what to fix — ordered by what will compound fastest if left alone.

It also includes two specialized tools that handle problems QBO can't solve natively: TransactionClarity reconstructs cash spending by class from Bill Payments, and MigrationClarity validates post-migration data for duplicates, orphans, and balance mismatches.

How it works

Connect, audit,
fix.

Connect your QBO company via Intuit OAuth — read-only access, no writes to your live books.
TheReconciliator scans transactions, customers, vendors, items, and inventory levels.
Duplicate detection runs across name normalization, transaction signatures, and date proximity.
Inventory validation surfaces negative quantities, missing SKUs, and quantity-on-hand discrepancies.
Findings are scored and prioritized into a single QBO health score with a fix list.

Who it's for

Anyone responsible
for the books.

TheReconciliator is built for bookkeepers, controllers, and small-business owners who want to know what's actually in their QBO file before tax season. It's also useful for accountants taking on a new client — running a single audit pass surfaces the cleanup scope before you commit to a fixed engagement fee.

If you've ever hit "send to accountant" and then waited for the inevitable email about duplicate invoices and negative inventory, this is what you run first.

What you get

Concrete deliverables.

Transaction analysis report — duplicates and anomalies across invoices and sales receipts.
Customer audit — duplicate records and merge opportunities.
Inventory validation — negative quantities, missing SKUs, stock discrepancies.
Overall QBO health score with prioritized recommendations.
Exportable reports for your accountant, bookkeeper, or controller review.
TransactionClarity and MigrationClarity included as part of the suite.
Companion to Sealed Ledger — audit first, then seal the cleaned state as a verifiable archive.
Pairs with SyncMyCart — run a Reconciliator audit before turning on a new e-commerce sync.

Common findings

What we typically
surface on a first run.

Duplicate sales receipts from a Shopify or WooCommerce sync. Most integration errors don't fail loudly — they retry, succeed, and quietly post the same order twice. Over a year, that's a meaningful revenue overstatement.

Customer records with two-or-three near-duplicates. "Acme Corp", "Acme Corp.", and "Acme Corporation" become three customers, splitting transaction history and breaking aged-receivable reports.

Negative inventory on items that should never go negative. A return posted before the original sale, or a sync that processed events out of order, leaves you with item counts that don't match physical reality.

Orphaned transactions and gaps in the chart of accounts. Especially common after a migration — see MigrationClarity for that pass specifically.

Pricing

Available on request — contact us.

Get started

Find out what's
actually in your books.

One connect, one audit pass, one prioritized fix list. The earlier you catch it, the cheaper the fix.

Visit thereconciliator.com Contact us

Related: TransactionClarity · MigrationClarity · Sealed Ledger · SyncMyCart