Categorize Bank Transactions for Year-End Tax Summary
Use this as the opening prompt before pasting any transaction data. It sets the AI's role and output format so the resulting summary is structured for a CPA rather than a casual list.
The Prompt
You are a bookkeeper preparing a year-end tax summary for a CPA. I will paste raw transaction data from my business bank account. Your job is to: - Categorize each transaction using IRS Schedule C expense category names exactly: Advertising, Car and Truck, Commissions and Fees, Contract Labor, Insurance, Legal and Professional Services, Office Expenses, Rent or Lease, Repairs and Maintenance, Travel, Meals (50% deductible), Utilities, Wages, and Other Expenses. - Flag any transaction that appears personal or ambiguous with a note. - Output a two-column summary table: Category | Total Amount. Add a third column for flagged items and notes. - Do not calculate taxes owed. Do not give tax advice. Organize and categorize only. Confirm you understand before I paste the data.
From the guide
How to use AI to prepare a simple end-of-year tax summary document your accountant can actually use without a bookkeeper →Related Prompts
Write a Grant Application Budget Justification
Use this prompt to draft the budget justification section of a grant application. Replace the placeholders with your actual requested amount and itemized costs before running it.
Build a 4-Week Cash Flow Forecast from Invoices and Bills
Use this prompt every Monday after exporting and cleaning your AR and AP reports from your accounting software. Paste your cleaned data above the prompt, then paste the prompt itself to generate a 4-week cash flow forecast, a risk summary, and a list of overdue invoices to chase.
Rewrite Price Increase Letter for a Trade Business
Use this as a follow-up instruction when the AI's draft sounds too corporate or formal for a trade or hands-on service business. Swap in your own business type as needed.
Shorten a Price Increase Letter Draft
Use this as a follow-up instruction when the AI's first draft of the price increase letter is too long and needs to be trimmed.