Case 01 Luxury retail

$1M+ profit overstatement corrected.

Situation

A luxury retailer's QuickBooks file showed a profit figure that didn't match what the business felt it was earning. Management suspected something was wrong but couldn't identify where the discrepancy came from. The books had accumulated errors over time, including a mix of mis-applied invoices, incorrectly classified revenue, and historical entries that had never been reviewed.

What I did

I audited the historical invoice register in QuickBooks going back through multiple years. This meant opening each affected invoice, tracing it to its corresponding payment, and checking that the income had been recognized correctly. Where revenue had been recorded in the wrong period, misclassified to the wrong account, or double-counted because of how payments were applied, I made the correction.

The bulk of the overstatement traced back to QuickBooks misclassifications: income items posted to accounts that inflated the net profit number without being offset by the correct cost entries. Fixing these required both correcting the account allocations and reconciling the affected periods.

Outcome

The profit overstatement of more than $1 million was identified and corrected. The client ended with a P&L and balance sheet that accurately reflected their actual financial position, ready for their accountant to review before filing.

$1M+

profit overstatement found and corrected


Industry
Luxury retail
Root cause
Miscategorized revenue; incorrect historical invoice postings
Work involved
Historical invoice audit; account reclassification; multi-year reconciliation

Case 02 Craft brewery

Eight-year backlog. 14,000 transactions. Chronic balance sheet problems resolved.

Situation

A craft brewery hadn't had their QuickBooks file properly cleaned in eight years. The balance sheet showed negative balances on accounts that should never go negative. Stale entries, such as payments recorded but never cleared and credit memos that had sat open for years, had accumulated and distorted every financial report. The owners couldn't rely on any figure the system produced.

What I did

Working chronologically from the earliest affected period, I reviewed all 14,000 transactions in the backlog. Each account was reconciled against its bank or statement history. Stale journal entries that had no corresponding real-world transaction were investigated. Where they were errors, I removed or reversed them, and where they reflected a real transaction that had been posted incorrectly, I found the correct period and account.

The negative balance sheet items were traced to a combination of uncleared payments, incorrectly applied vendor credits, and a handful of accounts that had been set up incorrectly from the start. Fixing them required correcting the underlying account structure as well as the individual transaction postings.

Outcome

All 14,000 transactions processed, all accounts reconciled, negative balance sheet items resolved, and stale entries cleared. The brewery had a clean QuickBooks file for the first time in eight years, with balance sheet accounts that reflected real balances and a P&L the owners could use to make decisions.

14,000

transactions processed across an 8-year backlog


Industry
Craft brewery
Root cause
8-year backlog; stale entries; negative balance sheet from uncorrected posting errors
Work involved
Full transaction review; account structure correction; multi-year reconciliation; stale entry clearance

Case 03 Multi-industry

35+ years of account history reconciled. 40,000+ transactions categorized.

Situation

Across a set of engagements spanning e-commerce, healthcare, and home services clients, the common thread was volume: large numbers of uncategorized or miscategorized transactions, long histories of bank and credit card accounts that had never been formally reconciled, and expense records with no project or job coding.

What I did

Each engagement ran on the same process: map every account, pull statement history, reconcile period by period. For transaction categorization, I worked through each uncategorized item, matched it to source documents where available, and assigned the correct account, class, and, where job costing was needed, project code.

For the expense allocation work, over 2,000 transactions required review and project-code assignment. This involved cross-referencing job schedules, vendor invoices, and existing categorizations to ensure each expense landed in the correct project bucket.

Outcome

35+ cumulative years of bank and credit card account history reconciled. More than 40,000 transactions categorized and coded. Each client received a clean QuickBooks file, reconciled account registers, and, where job costing was part of the scope, a working project P&L structure they could maintain going forward.

40,000+

transactions categorized & coded

35+ yr

of account history reconciled


Industries
E-commerce, healthcare, home services
Work involved
Transaction categorization; bank reconciliation; project-code allocation; job costing setup

Case 04 House flipping

House-flipping business: from Excel to QuickBooks Online

Situation

A house-flipping business was moving its books from Excel to QuickBooks Online. The first bookkeeper had created accounts in the chart of accounts for each property instead of using QuickBooks projects. The result was a cluttered chart of accounts and no reliable numbers per property.

What I did

I went through the books transaction by transaction, created a project for each property, and allocated about 2,000 transactions across 6 projects. While checking against the client's Excel files, I also found mistakes in those spreadsheets.

Outcome

Each property is now tracked as its own project with the right expenses allocated to it. The client reviewed the errors I found in his spreadsheets and confirmed them.

~2,000

transactions allocated across 6 projects


Industry
House flipping
Root cause
Property accounts in the chart of accounts instead of QuickBooks projects
Work involved
Transaction-by-transaction review; project setup; expense allocation; check against the client's Excel files

Have a similar problem?

Describe your situation and I'll tell you whether it's something I can help with.