Migrating 20 Years of Desktop Books for a $40,000 Clean-Up

ABC Supply Company Moves Two Decades of Books to the Cloud

Client:

ABC Supply Company is a long-established parts and supply retailer serving both walk-in and commercial customers. The business carries tens of thousands of units of inventory across more than a thousand stocked items and runs a small, long-tenured team. Every invoice, bill and payroll run for twenty years lived in a single desktop accounting file, on a single office computer, that only one person could open at a time.

Challenges:

The desktop program did what it had always done, and that was the problem. No bank feeds, no remote access, no tax engine. GST was tracked across three manually maintained ledger accounts and filed from spreadsheets. Payroll ran with an outside provider and reached the books only as lump-sum transfers, so wage cost by department, vacation liability and remittances were invisible to the financials.

The deeper issues only appeared once migration work began. Supplier statements did not tie to the ledger. Vacation banks had drifted for years, including balances below zero and a salaried employee accruing vacation pay that should never have existed. A sales tax receivable sat stranded in a holding account no filing had ever touched, and the legacy records carried stock quantities below zero on items that had been oversold.

Other Considerations & Issues:

• The business could not stop. Sales, purchasing and payroll continued every day through the migration window, so the cutover had to happen around live trading.
• Prior years had to stay untouched. Retained earnings were independently verified and locked before any clean-up began, so corrections could never silently rewrite prior-year results.
• The first filing had to be right. The first sales tax return out of the new system would also be the company's first return ever prepared by a tax engine rather than by hand.

Solution:

Rather than a single risky copy-paste cutover, Path 2 Profit ran the migration in deliberate, verified phases:

• Master data first. Customers, all 605 vendor records and the full item catalogue moved before a single transaction did, with 47 clusters of duplicate vendor records flagged on the way through.
• A verified inventory baseline. Custom extraction tooling re-derived closing inventory from the legacy system's own reports, and every stocked item was retested until the cloud file tied to the legacy records, quantity for quantity.
• Payroll rebuilt run by run. Thirteen payroll runs were re-posted in the ledger from the payroll provider's source reports, complete with department splits and vacation accruals, and payroll now runs natively in the cloud system.
• Sales tax into the engine. The three-account manual GST structure was mapped into the native tax engine, stranded balances were resolved, and the first engine-prepared return was reconciled to the ledger before filing.

What the Migration Surfaced:

A migration done properly does not copy balances across, it re-derives them from source and proves them. That process surfaced, in weeks, problems that had been invisible for years: a $28,791 supplier credit missing from the payables ledger, caught by reconciling to the supplier's own statement, $6,178 of vacation liability that had accrued for a salaried employee who should never have accrued it, and a $5,752 payroll remittance overpayment sitting unnoticed with the tax authority.

Inventory got the deepest treatment. Every one of 1,260 stocked items was retested against the legacy records, and the rebuilt inventory subledger now ties to the legacy system within $214, with zero quantity mismatches.

Impact:

The owner now sees live books from anywhere. Bank and card activity lands daily through feeds, sales tax calculates itself on every transaction, payroll posts into the ledger with full department detail, and the bookkeeping team works in the file remotely, at the same time. Month end is no longer a reconstruction exercise, it is a review.

What the migration surfaced:

Finding	Where It Hid	Amount	Status
Missing supplier credit	One vendor's statement	$28,791	Surfaced
Vacation accrued in error	Payroll records	$6,178	Identified
Overpaid tax remittance	Government account	$5,752	Confirmed

Before and after:

Measure	Before	After	Change
Where the books live	One office computer	Secure cloud	Anywhere
Sales tax (GST)	Three manual accounts	Native tax engine	Automated
Payroll	Outside the books	Every run in the ledger	Integrated
Bank and card data	Keyed by hand	Daily feeds	Live

---

Conclusion:

Twenty years of history is exactly why businesses stay on aging desktop software, and exactly why the move is worth more than it looks. Every balance in the new file was proven against source on the way in, which is how the migration surfaced more than $40,000 in errors the old books would have carried forward indefinitely.

The clean-up keeps paying: supplier statements now tie to the penny, the payables ledger is kept current against supplier portals, and every sales tax filing comes straight off the engine. If your books still live on one computer in the back office, the path to the cloud is shorter than you think, and it usually pays for itself in what it finds.