Categorize Bank Statement Transactions for Monthly Bookkeeping
Use this prompt at the end of each month after downloading your bank statement as a CSV. Upload the CSV to ChatGPT or paste it into Claude along with this prompt to get a categorized expense summary table your accountant can actually use.
The Prompt
I am uploading a bank statement CSV for my [type of business — e.g., freelance graphic design studio / retail bakery / HVAC service company]. Please categorize every transaction as an expense, income, or transfer. For expenses, assign each one to the most appropriate category from this list: - Advertising - Car & Truck - Contract Labor - Insurance - Office Expenses - Rent / Lease - Repairs & Maintenance - Supplies - Travel - Meals (note: 50% deductible) - Utilities - Professional Services - Subscriptions / Software - Owner Draw / Transfer (do not count these as expenses) Flag any transaction you are not confident about with [REVIEW] and a one-sentence note explaining why. Output a markdown table with these columns: Category | Number of Transactions | Total Amount | Example Vendors Below the table, list all [REVIEW] items separately.
From the guide
Using AI to prepare a simple end-of-month bookkeeping summary from your bank statement so you know where your money went before your accountant does →Related Prompts
Chase a Long-Term Client for an Overdue Invoice
Add this line to the main invoice sequence prompt when the overdue client is a long-standing one and you want to maintain the relationship while still being direct about the outstanding payment.
Stop AI Writing Apologetic Invoice Chasing Emails
Add this line to the main invoice sequence prompt if the initial output contains hedging language like 'I hope this finds you well' or 'I just wanted to follow up.' Can also be added to any individual email rewrite request.
Rewrite Invoice Chasing Email to Sound Firmer
Use this follow-up prompt if the AI-generated Email 3 still sounds too apologetic or soft after the initial sequence generation. Paste it into the same chat session immediately after reviewing the output.
Write a Four-Email Overdue Invoice Chasing Sequence
Use this prompt once to generate a complete four-email overdue invoice chasing sequence. Fill in your business details before sending, then save the output as reusable templates for every future overdue invoice.