Skip to content
agentusehub

Extract expenses from credit card statements into Excel

The author had Claude Code read a folder of credit card statements, learn his patterns, and put relevant expenses into an Excel sheet, saving hours; he plans to review subscriptions next.

Time saved
Not reported
Setup time
Not reported
Running cost
Not reported
Cost range
Not reported

Use case overview

The author had Claude Code read a folder of credit card statements, learn his patterns, and put relevant expenses into an Excel sheet, saving hours; he plans to review subscriptions next.

Reported experience

  1. What they did

    The author put all her personal credit card statements in one folder and ran Claude Code from inside it. She asked it to find likely business expenses to be reimbursed. It first talked through the early statements with her to learn her patterns and ask about anything unclear. At the end it wrote the relevant expenses to an Excel sheet in the same folder.

  2. How it went

    She says it saved her hours. She gives no accuracy figures or error rates. Reviewing and cancelling unneeded subscriptions is her planned next step.

  3. Worth knowing

    Claude Code needs a Claude Pro ($20/month) or Max ($100-200/month) subscription. The post also notes that employer data-protection rules may limit use with work data.

Example prompts

Try with Claude Code
Read all the credit card statements in [folder path] and work out which charges are [type of expense, e.g. business or reimbursable]. Put them into an Excel file with columns for date, merchant, amount, and category, and flag any charges you're unsure about instead of guessing. Finish with a short list of recurring subscriptions you found, but don't change or delete any of my original files.
Money, Bills & Benefits

Extract receipt data for freelancer bookkeeping

An app built with Claude Code extracts vendor, date, total, tax and line items from receipts, including foreign-currency ones at historical exchange rates, for freelancers and small businesses.

Claude Code