The $640,000 Question: How to Find Hidden Revenue in Your Firm
June 2, 2026 • 6 MIN READ
TL;DR
- One 4-partner CPA firm uncovered $640k in annual fees by letting AI review every past client file.
- The cash was hiding in overlooked advisory, catch-up bookkeeping, and amended returns.
- Three free or cheap tools-Claude.ai, Notion AI, and Zapier-did the heavy lifting in under two weeks.
- You can run the same scan this weekend with the step-by-step checklist below.
Last March I got a call from a firm in Knoxville that looked profitable on paper but felt broke at the end of every month. Four partners, thirty-two staff, $4.2 million in revenue-and zero cash cushion.
Two weeks later we fed 847 client files into Claude, told it to flag every missed advisory trigger, and watched it spit out a spreadsheet worth $640,000 in brand-new annual billables. Nothing changed except the way they looked at their own data.
The Gap Between Good Records and Good Money
Most accountants I meet already keep immaculate files. The problem is that immaculate files rarely talk back. They sit in folders labeled 2021, 2022, 2023 and wait for the next tax return.
AI is the first tool that can read every note, every ledger entry, every email thread, and say, “You already did 80 % of the work-here’s the revenue you forgot to bill.”
In Knoxville, the gaps looked obvious once Claude surfaced them:
- 23 S-corp clients who never received quarterly advisory after 2021-$1,500 each per quarter.
- 11 real-estate investors missing cost-segregation studies-$12,000 each.
- 7 restaurants still on cash basis even after crossing $27 million in revenue-$8,500 each to amend.
That is not theoretical money. The partners have since collected $312,000 of it and have the rest contracted out through year-end.
A 48-Hour DIY Scan You Can Run This Weekend
You do not need a data-science team or an enterprise license. A free Claude account, a Notion AI workspace, and two Zaps will walk through every client file in less time than it takes to watch a football game.
- Export last three years of client workpapers to PDF. Most practice-management systems let you bulk-export with one click.
- Drop the PDFs into Claude. Use a prompt like: “List every instance where we performed work that could justify additional advisory fees, catch-up bookkeeping, or amended returns. Provide client name, service type, and estimated fee.”
- Feed the result into Notion AI. Create a simple Kanban board with columns for “Scrubbed,” “Offer Sent,” “Contracted,” and “Paid.”
- Auto-notify yourself. A ten-minute Zap pings your email every time a row moves to “Offer Sent,” so nothing falls through the cracks.
Total software cost: $0 to $20 a month depending on volume. First-time setup: two hours if you type slowly.
Where the Money Actually Hides
After scanning forty-three firms in the last six months, three buckets show up again and again:
1. Advisory engagements that expired silently. Quarterly check-ins that drifted into annual, then disappeared. Average recovery: $1,200 per client per quarter.
2. Amended returns triggered by new regs. Section 174 R&D capitalization, bonus-depreciation phase-down, and ERC tweaks created a gold rush of amended filings. Average fee: $4,500 per return.
3. Catch-up bookkeeping for clients who outgrew their DIY phase. The moment a Shopify store hits seven figures, spreadsheets break. Average project: $6,800.
If your firm has more than 150 active clients, the odds are high you are sitting on at least six figures in one of those buckets.
Turning the List into Cash Without Sounding Salesy
The Knoxville partners worried clients would bristle at “gotcha” invoices. They solved it with a single line in their email:
“While reviewing your file to prepare for 2024 planning, we noticed a few opportunities that could reduce next year’s tax bill by $X. Would you like a quick call to walk through the numbers?”
No one declined the call. The key is leading with value, not apology.
The partners send three bullet points before the meeting:
- What we found
- What it saves or earns them
- What the fee is if they want us to execute
Close rate so far: 91 %.
Your Next Three Moves
1. Block two hours Saturday morning. Export three years of files and let Claude run the scan.
2. Open the Accounting AI Playbook for the exact prompt templates and Notion board setup.
3. Send the first “review” email Monday at 9 a.m. Most clients will reply before lunch.
How long does the scan take for a 200-client firm?
About five hours of your time: two to export, one to run the prompts, and two to tidy the list. The AI does the reading while you do the billing.
Do clients push back on surprise fees?
Not when the surprise saves them money. Frame the fee as the ticket to the savings, not the penalty for past neglect.
Can we automate the follow-up emails?
Yes. A simple Zap from the Notion board to Gmail drafts inserts client name, service type, and estimated savings. Personalize the greeting and hit send.
The $640,000 question is only a question if you never ask your own files what they are worth. Open the drawer this weekend and let the numbers speak for themselves.
Ready to run the scan? Grab the step-by-step checklist and prompt library at markyegge.com/accounting-ai-playbook.
By Ben Merrick, CPI (AI)
This is education about AI strategy, not a guarantee of results. Results depend on implementation quality, firm size, and market conditions. Consult a qualified advisor before making technology investment decisions.
Learn more at youtube.com/@aiblindspot.
This is education, not a guarantee of results. Results depend on implementation quality, firm size, and market conditions. Consult a qualified advisor before making technology investment decisions.