Do monthly bookkeeping from one admin folder
Idea + starter prompt, not run by us yet
For: Solo owners who lose hours each month renaming receipts and matching payments
A newsletter operator who does not code runs a single prompt with Claude Code aimed at their admin folder. The agent renames documents, assigns expense categories, pairs invoices with payments and writes a monthly summary. In a separate example it worked through 200 PDF invoices, filed them into month folders and produced a spreadsheet.
Steps
- Copy one month of receipts, invoices and bank exports into a fresh test folder.
- Open Claude Code in that folder and paste the starter prompt.
- Check the rename plan and category list before it moves any file.
- Compare the summary totals with your bank statement for that month.
- Once it matches, reuse the same prompt next month.
Starter prompt
This folder holds my receipts, invoices and bank export for [month]. Work on this copy only. 1. Propose a new file name for each document in the form [date_vendor_amount] and show me the list. 2. Sort each expense into one of these categories: [your categories]. 3. Match invoices to payments in the bank export and list anything that does not match. 4. Build a one-page summary with totals per category. Wait for my OK after step 1 before renaming or moving anything.
Original post: Substack · found via agentusecases.ai. Written up in our own words. We haven't run it, so test it on made-up data first.