More in Bookkeeping, receipts & invoices.
Replace a bookkeeper with ChatGPT guidance, then Claude Code on QuickBooks
WorkedEvidence: Described by posterPosted Last checked
Alex Willen used ChatGPT to set up books for about 200 transactions, then gave Claude Code a QuickBooks API key to post entries.
How to use this
- Tap Copy prompt.
- Open the tool the case used (or a similar one) and paste the prompt; results may differ from the original.
- Paste it into the message box.
- Send it, then read the answer before acting on it.
New to this? What's a prompt?
A prompt is the message you send to the AI tool. Copy the one on this page, put your own details where it asks, and read the answer before you act on it.
Prompt
These are the person's own words, as shared in the source.
I need your help with bookkeeping. My new fund is incredibly simple financially, and I’m already tracking performance on a per-brand basis on Excel sheets, so my only bookkeeping need is to have something to give to my CPA come tax time. So far this year I only have ~200 transactions, and moving forward I expect 30-40/month. They are basically all: - Disbursements from my Amazon Seller accounts - Amazon ads payments - COGS and freight payments to suppliers - Insurance payment - Quickbooks payment - One brand has a Shopify account (otherwise they’re all pure FBA), so money in from Shopify and money out to pay Shopify subscription - Money in from investors for purchases and distributions out to investors - Money going out to escrow for purchases of new brands I keep talking to bookkeepers who want me to pay $500+/month and promise they’ll give me helpful financial insight yada yada yada which I don’t need or want from them. So I’m thinking I can just do this myself - it can’t be that hard, right? Since it’s just for taxes, seems like the easiest thing is to do cash accounting. Is that right? And then what else do I need to know + do here? I’ll bring you individual questions about how to handle particular transactions but for right now just give me the high level. I’m using QBO on a cheap subscription.
Try this in:
Sends the Original prompt shown above. ChatGPT and Grok open with it filled in, and ChatGPT may send it straight away. Gemini and Claude open empty, so we copy the prompt for you to paste. Every button also copies it.
Opens in a new tab. We don't see what you send.
These links are only a shortcut. We're not affiliated with OpenAI, Google, Anthropic or xAI, and your results may not match the source.
Optional stronger version
Our rewrite with extra checks. The poster didn't test it.
Before you start, ask me 1–3 short questions about the details below and wait for my answers. Once I've answered, confirm the plan in one line and run the whole task start to finish. Goal: Set up and keep simple small-business books that are good enough for my CPA at tax time. Questions to ask me first: - Cash or accrual, and what does your CPA need at year end? - Which transaction types make up most of your activity? - Which accounting software and plan are you on? Inputs (fill in or confirm): - Business type and entity: [DETAILS] - Transaction types: [SALES PAYOUTS / ADS / SUPPLIERS / INVESTORS / ESCROW] - Software: [QUICKBOOKS ONLINE / OTHER] - Year-to-date volume: [NUMBER] Rules: - Recommend the simplest method that is still correct for taxes, and explain the trade-offs. - Give exact steps for account setup and each transaction type. - Say when a menu location may differ in my software version. - Flag anything that needs my CPA's sign-off. Checkpoint: Show the chart of accounts and how each transaction type maps to it before I enter anything. If you get stuck: If a transaction doesn't fit, ask for the source document instead of guessing. Verify before you finish: Compare the P&L to platform revenue and my expected margin before sending it to the CPA. Output: A setup checklist, a transaction mapping table and a year-end CPA package list. Done when: My books reconcile and my CPA has what they need.
Customize the stronger version
Answer these questions and we'll put your answers into the stronger version. The original prompt above stays exactly as published.
Your prompt
Before you start, ask me 1–3 short questions about the details below and wait for my answers. Once I've answered, confirm the plan in one line and run the whole task start to finish. Goal: Set up and keep simple small-business books that are good enough for my CPA at tax time. Questions to ask me first: - Cash or accrual, and what does your CPA need at year end? - Which transaction types make up most of your activity? - Which accounting software and plan are you on? Inputs (fill in or confirm): - Business type and entity: [DETAILS] - Transaction types: [SALES PAYOUTS / ADS / SUPPLIERS / INVESTORS / ESCROW] - Software: [QUICKBOOKS ONLINE / OTHER] - Year-to-date volume: [NUMBER] Rules: - Recommend the simplest method that is still correct for taxes, and explain the trade-offs. - Give exact steps for account setup and each transaction type. - Say when a menu location may differ in my software version. - Flag anything that needs my CPA's sign-off. Checkpoint: Show the chart of accounts and how each transaction type maps to it before I enter anything. If you get stuck: If a transaction doesn't fit, ask for the source document instead of guessing. Verify before you finish: Compare the P&L to platform revenue and my expected margin before sending it to the CPA. Output: A setup checklist, a transaction mapping table and a year-end CPA package list. Done when: My books reconcile and my CPA has what they need.
Scroll to see the whole prompt. Your answers show in green.
4 blanks are still empty: Business type and entity; Transaction types; Software; Year-to-date volume. They'll stay in brackets in your prompt, so the chat tool may ask you about them.
What you type stays in this browser tab. We don't send it or save it, and it's gone when you leave the page.
AI tools
Outcome
Alex Willen runs small Amazon e-commerce brands. After a slow Upwork bookkeeper and pitches for $500-plus monthly services, Willen asked ChatGPT (GPT-5) to walk through books for a new entity with about 200 transactions so far. ChatGPT recommended cash accounting, walked through account setup and answered every transaction question; it only got QuickBooks Online menu locations wrong. Reviewing the old books, Willen found the bookkeeper had been manually splitting Amazon fees that the CPA didn't need. The resulting P&L lined up with Amazon revenue and expected margins. Because Willen was still doing all the clicking, Willen then gave Claude Code (Opus 4.5) a QuickBooks API key, which meant creating an app and filling out a security questionnaire, so it now posts entries directly. Willen still supplies context such as escrow releases for acquisitions.
Evidence: Described by posterThe person describes what happened in words, without screenshots or video.
Source
- Posted
- by Alex Willen
- Last checked
- Method:
- How we verify
https://theautomatedoperator.substack.com/p/can-ai-do-my-bookkeeping
Context: Original prompt quoted from the post. Willen calls the businesses very simple and checks the P&L before sending it to a CPA. The ChatGPT section was written around October 2025. Self-reported.
More in Bookkeeping, receipts & invoices
Replace a $400-a-month bookkeeper stack with Claude and Claude Code
Dee left a $400/month QuickBooks bookkeeper stack after Claude and Claude Code built a local ledger and P&L prompts.
WorkedClaude +1Evidence: Described by posterView CaseAutomate supplier invoice PDFs into ERP exports with Gemini and Apps Script
Asaf Lecht's Gemini Apps Script cut invoice batches to a 5-minute review, but Gemini invented dates until validation.
PartialGeminiEvidence: Described by posterView CaseBuild a free freelancer invoicing and expense tool with Claude Code
Joel Henry used Claude Code to build Kova, a free invoicing and expense tracker for contractors, after finding no lightweight tool.
WorkedClaude CodeEvidence: Described by posterView CaseAuto-file inbox invoices to Drive and Sheets with Gemini and Apps Script
Silvia Carasel used Gemini plus Apps Script to save Gmail invoices to Drive, log Sheets rows and email a report on the 20th.
WorkedGeminiEvidence: Described by posterView CaseRun a read-only Claude Code CFO agent over a local expense spreadsheet
Martino Vigiani's Claude Code CFO reads synced expense JSON for burn, runway and renewals, and is barred from writing the books.
WorkedClaude Code +1Evidence: Described by posterView CaseReplace QuickBooks with Beancount and a 20-minute Claude Code invoicer
John Sambrook left a $1,800/year QuickBooks plan after Claude Code built a Beancount invoicer in about twenty minutes.
WorkedClaude CodeEvidence: Described by posterView Case
Similar cases
Categorize a year's business bank transactions and draft accounts with Claude Cowork
Andrew Blumson taught Claude Cowork a bookkeeping system; the latest run filled over 100 rows and drafted year-end accounts.
WorkedClaude CoworkEvidence: Described by posterView CaseFill in a bookkeeper's mystery transactions from Amazon and Gmail with Claude Cowork
Claude Cowork matched Rachel Rofé's unidentified transactions to Amazon orders and Gmail receipts, getting about 90% done on its own.
WorkedClaude CoworkEvidence: Described by posterView CaseSort a year of mixed Amazon business purchases into QuickBooks categories with Claude, including the fiddly split transactions
Claude sorts Amazon business buys into QuickBooks Online at tax time, even splitting a mixed cart in 19 clicks.
WorkedClaudeEvidence: Described by posterView CaseDo year-end bookkeeping and Xero reconciliation with Claude Code
Claude Code categorized receipts and reconciled bank CSVs against Xero; the poster says it replaced $2–3K of accounting-firm work.
WorkedClaude Code +1Evidence: Screenshots or logsPoster says:~2–3K accounting-firm fee avoided
View CaseFile subcontractor invoices into 30 job folders automatically with ChatGPT
A builder used ChatGPT to make a script that reads emailed invoices and files them into 30 job folders, saving 5–6 hours a week.
WorkedChatGPTEvidence: Article or interviewView Case

