All plays › Legal, accounting and finance

Legal, accounting and financeClaude

Cleaning a 40-page vendor PDF by hand replaced: a usable spreadsheet in two minutes

Picked and checked by Olga Pearson, host of The Practical AI Show · Published

What was the result?

self-reported

Fractional CFO Bobby Mays says a vendor's 40-page PDF became a clean spreadsheet his bookkeeper could use in two minutes. He says similar manual cleanups used to take 20 to 30 minutes each and estimates roughly $400 saved the previous month. The $400 calculation and cash-versus-time basis are not supplied.

Bobby Mays, founder of Fulcrum and a fractional CFO for small businesses, uses Claude to turn messy vendor invoices, spreadsheets and unstructured PDFs into usable data. His concrete example is a 40-page vendor PDF with inconsistently formatted line items: two minutes later he had a clean spreadsheet for his bookkeeper. This is document cleanup, not automated bookkeeping, tax filing or a claim that Claude made accounting decisions.

Who did this?

Bobby Mays (@Bobbymays)Fulcrum; fractional CFO services for small businessesBobby Mays (@Bobbymays) on X · Apr 2, 2026

How do I try it?

  1. Editorial adaptation: choose one vendor PDF your bookkeeper currently rekeys, and preserve an untouched copy.
  2. Define the exact spreadsheet columns and required number/date formats before extraction.
  3. Ask Claude to extract line items with source page references and flags for ambiguous text, rather than guessing.
  4. Reconcile row totals, taxes and invoice totals against the original; check duplicates, credits and a sample of descriptions.
  5. Give the checked spreadsheet to your bookkeeper for import or review. Measure cleanup time; do not let the model post entries or pay invoices.
Copy-paste prompt
Editorial adaptation, not Bobby Mays's exact prompt. Extract this vendor PDF into a spreadsheet with columns [invoice number, date, description, quantity, unit price, net, tax, total, currency, source page]. Preserve every row and sign. Flag unreadable or ambiguous fields as CHECK; never invent values. Add a reconciliation sheet comparing extracted totals to printed totals and list suspected duplicates separately. Do not merge or drop rows silently. Do not post to my books, upload to accounting software or pay anything. I will review before use.

Make it run every week

A play works once. Turn it into a routine in three small steps:

  1. Run it once and check the result yourself.
  2. Give your AI a schedule. Tell it when to run this play (every week, or every month) and to message you with what it found before you act.
  3. Keep a log. One line per run: what was checked, anything flagged, what you did.

See how owners turn plays into systems →

What should I watch out for?

Two minutes and $400 are self-reported, not independently timed/audited; 20 to 30 minutes describes similar manual cleanups, not necessarily the identical PDF. Do not annualize the $400 or call it a cash refund. Check scan quality, decimal separators, currencies and missing pages. Build it with Page: a vendor-document intake checklist to reduce future rekeying.

Did it work for you?

PageMotor keeps this site free.