Multi-Year Financial Reconciliation
How eight years of invoices, purchase orders, and journal entries were reconciled in Zoho Books after a failed migration, with inventory rebuilt from validated go-live balances and negative stock eliminated.
Client details generalized to protect confidentiality.
Businesses living with a bad migration, where the books technically function but nobody trusts the historical numbers or the stock figures.
The Challenge
A prior migration from QuickBooks had completed without failing outright, which was the problem. Invoices, purchase orders, and journal entries had come across with gaps and duplicates spanning eight years. Inventory carried negative quantities on items that had never gone out of stock, which meant valuation was wrong and nobody could explain by how much. The books produced numbers, and the numbers were not defensible.
The Solution
Reconciliation Against Source Records
Every transaction class is reconciled against the source system rather than spot-checked, so the size of the problem is established before anything is corrected.
- Transaction counts and totals by period
- Comparison against source exports
- Gap and duplicate identification
- Discrepancy register with disposition
Duplicate and Gap Correction
Duplicates are removed and missing records recreated with documentation of what changed and why.
- Duplicate identification by composite key
- Controlled removal with audit notes
- Missing transaction recreation
- Period totals re-verified after each pass
Inventory Rebuild From Validated Balances
Rather than correcting stock item by item, inventory is rebuilt forward from a validated go-live balance.
- Physical count establishing go-live balances
- Opening stock adjustments posted
- Transaction history replayed forward
- Negative quantities eliminated
Valuation and Close Verification
Valuation is verified after the rebuild, and prior periods are closed so the corrected history cannot drift again.
- Valuation recalculated post-rebuild
- Period locks applied
- Reconciliation report retained as evidence
- Ongoing variance monitoring
Apps in This Solution
Zoho Books
Zoho Inventory
Under the Hood Technical detail
- Sequence
- Reconciliation before correction, always. Correcting individual errors as they are found produces a moving target where period totals change while you are still measuring them, and the work never converges.
- Inventory Strategy
- Stock was rebuilt from a validated opening balance rather than corrected transaction by transaction. Eight years of movement containing errors cannot be corrected reliably in place, and the physical count provided a defensible anchor the historical data could not.
- Negative Stock Root Cause
- Negative quantities came from movements posted out of sequence during the original migration, not from data entry. Fixing the symptom item by item would have left the same condition to reappear on the next stock take.
- Evidence Retention
- The discrepancy register and reconciliation reports are retained rather than discarded once the books balance. The value of this work is largely that the numbers can be defended, and that requires showing the work.
- Notable Constraint
- Some historical gaps could not be resolved because source records no longer existed. Those are documented as known limitations with quantified impact rather than plugged with balancing entries that would obscure them.
The Results
- Eight years of transaction history was reconciled against source records.
- Inventory was rebuilt from a validated count, eliminating negative stock.
- Corrected periods are locked and the reconciliation evidence is retained.
Living With a Bad Migration?
We have reconciled and rebuilt books after failed migrations, including inventory and multi-year history. Tell us what does not tie out.