Results.
Four projects, written up in full. Clients are described anonymously. I don't name them or share identifying details without permission.
$1M+ profit overstatement corrected.
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.
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.
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.
Eight-year backlog. 14,000 transactions. Chronic balance sheet problems resolved.
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.
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.
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.
35+ years of account history reconciled. 40,000+ transactions categorized.
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.
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.
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.
House-flipping business: from Excel to QuickBooks Online
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.
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.
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.
Have a similar problem?
Describe your situation and I'll tell you whether it's something I can help with.