You commented “BOOKS”: here it is

Bookkeeping Categorization Prompt

Paste your transaction CSV and get every line categorized by expense type, ready to hand your accountant or drop into QuickBooks.

Free prompt pack · copy-paste ready · built by the BrainVaultAI team

Bookkeeping is the thing founders do at 11pm the night before their accountant asks for it. This prompt cuts that time by 80%. Feed it a CSV of raw bank or card transactions and it returns every line categorized with a category, confidence level, and a flag for anything ambiguous. Use it monthly or quarterly. Works best with a consistent chart of accounts, the prompt will ask for yours or use standard categories if you skip it. ### How to use

Export a CSV from your bank or card. Paste it plus your categories (or let Claude use defaults). Review flagged lines manually. Copy the output into your accounting tool.

Transaction Categorization Prompt
You are a bookkeeper. Categorize each transaction in the CSV below. For each row output:
- Date
- Description (cleaned up)
- Amount
- Category (from the list below or your best match)
- Confidence: High / Medium / Low
- Flag: YES if ambiguous or needs human review Categories to use:
Software & SaaS / Payroll & Contractors / Marketing & Ads / Travel & Meals / Office & Supplies / Professional Services / Bank Fees / Revenue / Transfers / Unknown If I give you a custom chart of accounts instead, use that. Rules:
- Mark anything over $1,000 from an unknown vendor as Flag: YES
- Split-code subscriptions (e.g., AWS) as Software & SaaS
- Treat Stripe payouts as Revenue Return as a markdown table. CSV:
[PASTE CSV HERE]
Monthly Close Checklist: Bookkeeping QA
Use this before handing anything to your accountant.

[ ] All transactions pulled from bank and credit card feeds for the month
[ ] Every transaction has a category and a memo (payee name is not enough)
[ ] Splits are applied to transactions covering multiple categories
[ ] Personal charges are flagged and moved to owner draw or reimbursement
[ ] Recurring subscriptions are mapped to correct expense accounts, not lumped into software
[ ] Any payment to a contractor over $600 YTD is noted for 1099 tracking
[ ] Opening and closing balances reconcile to bank statements
[ ] Uncategorized or review-flagged transactions are at zero
[ ] PDF or CSV export is attached and labeled with month and year
[ ] Notes doc lists any unusual items the accountant should know about

Paste this list into your task manager or the top of your bookkeeping doc each month. Do not close the month without every box checked.

Want the editable version?

We'll send the editable version of this asset, plus a short series of our highest-leverage AI plays for operators. No spam. Unsubscribe in one click.

Free. No spam. Unsubscribe in one click. By submitting you agree to receive emails from BrainVaultAI.

Go further

Want all 51 founder-grade prompts?

51 production-grade prompts (Operator, Climber, Independent)
Copy-paste ready, no theory
Lifetime updates
Today$47

One-time $47. Instant access. No subscription.

More free AI guides in the full library · follow @brainVaultAI