Real client stories. The mess that arrived, the plan, and where the file landed. Names, industries, and identifying details anonymized. Numbers and mechanics exactly as they happened.
Trust reconciliation, gross vs. net revenue treatment, and a full workflow redesign for a boutique vacation rental company.
A boutique vacation rental company managing properties across multiple platforms (Airbnb, VRBO, direct bookings) was operating with a trust account holding owner funds, guest funds, and its own earned commissions in one pool. Reservation revenue was recorded gross rather than net, inflating reported income to several times the actual size of the business. A large deferred revenue balance had been recognized as income on the prior year's tax return, and future reservations were still flowing into the same account with no reconciliation mechanism to separate what belonged to the company from what was held in trust.
Nearly a year of coding questions had gone unanswered because the workflow depended on owner input that never came. The chart of accounts carried structural misclassifications, with owner reimbursements posting as income, suspense accounts sitting in the wrong section of the balance sheet, and duplicate revenue accounts. Airbnb payouts, which land at check-in, were being treated the same as VRBO deposits, which land at booking. Nothing in the current setup could tell the owner whether the trust bank actually matched what she owed.
We built a monthly Trust Reconciliation template that ties the trust bank balance to the sum of every liability the business owes (owner distributions, prepaid stays, refundable deposits) with Airbnb correctly excluded. A reservation classification system was set up to read confirmation prefixes and route each booking to the right treatment. The reimbursables workflow was restructured to use a single-item pattern with project tagging, so owner recoveries pull through the monthly bill without touching the balance sheet. And we worked with the tax team to correct the prior-year deferred revenue treatment on the current-year return rather than amending backward.
The first test run of the Trust Reconciliation template came within $290 of the expected balance across a $554,000 holding account. Every confirmation code classified correctly, with none falling into Other or Unknown. Prior-year treatment was resolved in coordination with the tax team without requiring an amended return. The owner now has a monthly close package that actually ties, and a defensible workflow going forward.
The first test run came within $290 of the expected balance across a $554,000 holding account.
Multi-year cleanup and tax-ready reconstruction for a service business whose 2021 return had never been filed.
A service business came to us with a 2021 tax return that had never been filed and a set of books nobody could sign off on. The owner had attempted her own cleanup with AI assistance before handing it over, which had left a trail of plug journal entries moving unresolved balances around the balance sheet to zero out whichever account was being examined. Accounts Receivable showed a net negative $2 million balance. Undeposited Funds was carrying orphaned deposits from a prior invoicing system. Three vehicle purchases from 2020 (two Ford trucks and a Toyota) had never been booked as assets, with trade-in disposals and loan payoffs sitting in the wrong accounts.
The Accounts Receivable balance was almost entirely noise. $1.66 million of platform deposits and $375,000 of Automated Clearing House payments had been miscoded to Accounts Receivable under placeholder customers with names like "Other Customer", "QuickBooks Customer", and "Automated Clearing House Customer". Real customer receivables netted to about $33,000. Revenue for 2021 had been booked in two lumpy chunks (one covering January through June from the prior invoicing system, and a single $2.3 million year-end catch-up entry), with July through November showing zero revenue on the Profit and Loss statement despite deposits actively flowing in. That $2.3 million entry had been offset to a plug asset account rather than Accounts Receivable, which is why Accounts Receivable was underwater in the first place.
We reclassed the year-end revenue entry, moving $1.99 million from the plug asset account to Accounts Receivable under the correct placeholder, bringing Accounts Receivable from negative $2 million to positive $329,000. Undeposited Funds discrepancies were traced down to specific batches through forensic reconciliation (a $20,916 batch of pre-2021 invoice deposits with no matching Receive Payments, plus a $22,180 December plug batch), reducing Undeposited Funds from negative $29,980 to negative $9,065. Full journal entries were built for the three vehicle acquisitions including trade-in disposals and prior-year corrections. The depreciation schedule was matched to the last filed tax return. Reasonable salary compliance risks were flagged for the S corporation owner.
The 2021 books are moving toward close-ready. Every plug entry gets inventoried before the final CPA adjustment number goes over, so the tax return is built on real numbers instead of moved-around ones. What started as an unfileable year is turning into a foundation the client can build the next three years on top of.
AI is a tool. Whether it helps or hurts depends on who's holding it.
Not every engagement makes a headline case study, but each one has the same shape: a real problem, a specific fix, and a file that ties. A handful of recent ones, at a glance.
A United States holding company owns a Mexican condo financed by a U.S. dollar mortgage held by a Mexican lender. The lender's statements advance principal on the scheduled amortization even when the actual payment lands late, and the QuickBooks Online mortgage payable never tied to reality. We built a full 240-payment reconciliation workbook with an amortization schedule, a payment log, and a statement-by-statement cross-check. All 17 available statements now tie. Book principal reductions record when cash actually moves, reconciled by payment number rather than by date.
A commercial lines insurance agency running its trust account inside QuickBooks Online needed the trust and operating sides to behave like separate pools. The chart didn't distinguish agency fees (earned at binding) from commissions (earned on carrier remittance). We restructured to an off-books trust approach: the trust bank feed stays in QuickBooks Online to catch Trust-to-Ops transfers while everything else is handled through the Agency Management System. Agency fee treatment was confirmed against 197 endorsement rows (zero negative values, meaning non-refundable at binding). The agency now has a clean cash basis Profit and Loss statement and a defensible trust boundary.
A wellness practice held two retirement plans at Schwab, each with a custodial account and a sweep, plus an investment portfolio previously held at another custodian. None of it was reconciled in QuickBooks Online. We built the full 2025 journal entry set for the prior-custodian activity, then transitioned forward to Schwab reconciliation across all four sub-accounts on the same monthly cadence as operating cash. A large unresolved withdrawal was parked in Ask My Accountant pending advisor confirmation rather than plugged. Open items are visibly open rather than buried.
A brewery operating across four locations needed payroll costs broken out by site rather than lumped into a single line on the consolidated Profit and Loss statement. Without the split, the operator couldn't tell which location was profitable at the labor line, and cost-per-pint math ran on averages. We built location-split payroll expense and liability workbooks that allocate gross wages, employer taxes, and accrued liabilities to each location's cost center, then roll back up into consolidated reporting. The split is auditable rather than assumed.
An ATM operator running terminals across seven hospitality locations processes transactions through Payment Alliance International, reloads its own cash, and accrues surcharge income monthly. QuickBooks Online vault cash had a growing gap against physical cash in the machines. We built two Excel templates: a nine-tab reconciliation workbook that ties QuickBooks Online to the four essential Payment Alliance International reports with zero variance, and a single-tab monthly recon with worked examples for every month of 2025. Loads tie to the dollar, and year-end vault cash carries a documented Cash in Transit adjustment.
If your books have a shape we know, we would rather talk about it than write generic case studies. The discovery call is free, and it is the honest way to find out whether we are a fit.
Book a discovery callThe industries are different. The mechanics are different. But every one of these engagements ran on the same handful of ideas.
Books tie to bank statements, broker statements, Agency Management System data, Payment Alliance International reports. Not to whatever balance makes the difference go away.
A plug journal entry is a question nobody answered. Every plug we inherit gets inventoried and traced before the file is called clean.
When something needs a client answer or an advisor confirmation, it sits in Ask My Accountant with a note, not in a Profit and Loss statement account where it quietly disappears.
Every cleanup ends with a template or a process that keeps the fix in place. Otherwise the file drifts back to the state that got us called.
If you recognize your own file in any of these, the discovery call is the fastest way to find out what a rebuild would take.
Book a discovery call