← All use cases

Use case #12 · CPA

Turn client documents into tax workpapers with Claude: a solo CPA's workpapers from source documents, and a C-corp book-to-tax workbook mapped to Form 1120

Sam Leon, CPA (The Millennial CPA / TaxWeave), via The Accounting Podcast, and Sophia Peng CPAs, Inc. (LinkedIn) ·

The short version

What they did

Two firms have Claude build the workpapers a return is prepared from, then review what it produces.

Workpapers from a client’s source documents

Sam Leon feeds client source documents to Claude to produce tax workpapers, smart intake for scoping, and speed up review. The Accounting Podcast, 2026-07-25.

A C-corp book-to-tax workbook

Sophia Peng CPAs had Claude build a C corporation workpaper workbook: TB book-to-tax bridge, book-tax balance sheet and P&L with California, NOL schedule, fixed asset rollforward, all tabs mapped to Form 1120. Their LinkedIn post, 2026-03-16.

Result (as claimed)

Workpapers from documents: episode title “How Sam Leon Uses Claude Cowork to Prep Tax Returns 5x Faster”; show notes say “why review remains the bottleneck”

The C-corp workbook: “My favorite version of this workbook I’ve ever had.” “production-ready tax workpaper built for real compliance workflows.”

Prompt

Written for this library, one for each example.

From source documents:

I’m a CPA preparing individual tax workpapers for [tax year]. I’ll attach [source documents with names and SSNs removed], [last year’s document list] and [my workpaper layout and current-year return mapping, if available].

1. Build a spreadsheet with a row for each relevant form box or amount, showing document name, page, form type, payer, box, amount and proposed return line.
2. Compare the documents received with last year’s list and flag possible missing items for me to investigate.
3. List anything needing preparer judgment separately.

Keep labels plain and trace every amount to its source. Don’t guess unreadable amounts or treat a prior-year document as proof one is required this year. Ask about missing return mappings, and mark any proposed line I need to check against the current forms. Don’t prepare or file a return.

A C-corp workbook:

I’m a CPA building a reusable C corporation tax workpaper template for [tax year], including federal and California columns. I’ll provide [our layout], [reviewed calculation rules] and [current Form 1120 line mapping]. Use placeholders rather than client figures.

1. Build an Excel workbook with a trial balance tab showing unadjusted book, adjustments, adjusted book, permanent differences, temporary differences, tax basis and Form 1120 line.
2. Add book-to-tax balance sheet and profit-and-loss tabs, prior-year comparisons, a loss carryforward schedule and a fixed asset rollforward.
3. Link supporting tabs to the trial balance by formula wherever the figures relate. Label separate inputs clearly.

Give me a short plain-English guide to the tabs and formulas. Don’t invent rates, carryforward balances or return mappings. Flag missing rules for my review, and include checks that expose totals that don’t agree.

Do it yourself

These steps are my suggested way in, not any one person’s setup.

Level: Intermediate for a formula-linked workbook. A source-document workpaper in a chat is Beginner.

What you need

  • A chat assistant that reads PDFs and builds spreadsheets, such as Claude, on a business plan.
  • A prior-year client file you already prepared, with its source documents and final workpapers.
  • Your firm’s workpaper layout, if you have one.

Start simple

  1. Take last year’s source documents for one individual client. Redact names and SSNs.
  2. Paste the “From source documents” prompt with the files.
  3. Compare each row with your final workpaper: form, payer, box, amount, return line.
  4. Ask for the C-corp workbook with placeholders, and check that the tabs link by formula.
  5. Note every wrong return line and every missed document.

Take it further

  • Keep a project with your workpaper template and instructions so each client starts the same way.
  • Load a real trial balance into the workbook and tie the bridge to the prior return.
  • Use the time saved on review, which the source calls the bottleneck.

Check your work

  • Tie totals to the source documents, not to the AI’s summary.
  • Check return line references against the current year’s forms. This library’s test found an outdated line.
  • The preparer reviews every number before it reaches the return.

Testing

2026-10-18 (the source-documents example): All ten answer-key amounts and the three required flags appeared in 47.239 seconds. An outdated return line and unsupported conclusions prevent a clean accuracy pass; the 5x speed claim was not measured. The full run record includes the exact inputs, output, timing and scoring. The source claim remains unverified.

Before you rely on it

  • This is general information about how accountants use AI, not professional guidance for your engagements.
  • You stay responsible for the work under your professional standards, including review and sign-off. An AI tool’s output is a draft, not evidence.
  • Before you send client data to an AI tool, read the tool’s data and training terms, and get any client consent you need. For tax return information, that includes IRC section 7216.

Source checked. The link, author, date and quote were confirmed against the source. The result itself has not been reproduced. Prompt adapted for this library, inspired by the case. Business size: Solo; 1-10 employees. Results are quoted as the source claimed them and never improved. Spot an error or a broken link? Email charlie@cbarmorecpa.com.

More in Tax prep

New cases go out every Saturday in Inside AI.