Use an agent to organize year-end books in QuickBooks
Glenn Hopper let Claude Cowork sort and rebuild a messy QuickBooks Online file, then used Claude for Excel to help classify card activity.
- What they did
- Glenn Hopper handed Claude Cowork control of a signed-in QuickBooks Online session after finding the available MCP route unusable outside a sandbox. Claude checked the account list, added revenue, COGS, and expense categories, and then reworked bad postings. He then supplied card CSVs plus context such as travel dates and known subscriptions, and Claude for Excel created an expense-account field while Hopper reviewed the steps as they happened.
- How it went
- The QuickBooks cleanup finished in less than an hour and ended with a usable cash-basis P&L. Both tools nailed the categorization on the first attempt. Claude also prepared quarterly journal entries, and the full project was done in one afternoon.
- Tips
- The card-expense portion needed careful prompt tuning; Hopper had to include travel dates, training costs, and business subscriptions before the personal charges sorted correctly. For bookkeeping tasks, plan to supervise the changes instead of letting the agent run unattended.
Try it yourself with Claude Cowork
Open [QuickBooks Online URL] and assist me with the [year] books. Scan for uncategorized or wrongly placed transactions, identify any account types I should add, and suggest how each entry should be handled under [my chart of accounts/rules]. Before you create new accounts, alter any entry, remove anything, or send anything onward, stop and present the proposed changes for my approval. After I approve, make the updates and give me a concise report of what changed and what still needs my review.
Fill in the [brackets]. Agents can make mistakes, so review anything before it is sent, paid or deleted.
Get 3 agent uses like this every morning
With the day's top AI news. Free, and one click to unsubscribe.
Related agent uses
Use Claude to review a rental damage dispute
A traveler used Claude to help push back on a Sixt damage bill, but its timestamp theory was based on the wrong photos.
Use Claude to reconcile overdue Dutch tax records
A user had Claude sort two years of Dutch tax paperwork, match supporting records, and draft accountant-ready summaries.
Use bank exports to build budgets and compare reports
They fed bank transactions into AI for spending analysis, budget building, and investment research without giving the system direct account control.
Use Claude to file tenant complaints from public records
Claude checked NYC building records, prepared 14 housing complaints, and submitted them for one tenant.
Turn bank statements into a spending dashboard
They use Claude to combine monthly statements, map spending, and review portfolio allocation in one place.
Find and claim misplaced payments with a treasury skill
Cornell’s finance and AI teams built a Claude treasury skill that matched unknown funds to the right claims.