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
Simulate a Tough Banker Interview With AI Feedback
Use this prompt after reviewing your Q&A prep sheet to simulate a real banker interview. Answer each question as you would in the actual meeting, and the AI will give you specific feedback on what landed well and what sounded weak or vague.
Rewrite a Loan Brief in Plain Business Language
Use this prompt after reviewing the AI-drafted loan brief if the language feels overly formal or generic. It produces a version that sounds more like you, which is important since you'll be handing it to a loan officer with your name on it.
Model Alternative Loan Structures for a Weak DSCR
Use this follow-up prompt if your initial DSCR calculation comes back between 1.0 and 1.25. It helps you model alternative loan structures and prepares you to address a weak coverage ratio before the lender raises it.
Prepare a Full Bank Loan Application Brief
Use this prompt at the start of your bank loan meeting prep session. Paste in your raw financial data — 12 months of revenue, monthly expenses, existing debt payments, loan amount requested, intended use of funds, and business assets — to get a DSCR calculation, a 5 Cs evaluation, a one-page loan brief, and a Q&A prep sheet in one response.