Business Value
Compresses the worst part of tax season. Instead of spending hours hand-sorting a year of transactions or paying your CPA an hourly rate to do it for you, this prompt does the heavy lifting. You get a fully categorized ledger aligned with official IRS Schedule C lines, plus a focused, honest list of items that genuinely need a receipt or explanation. By automating the raw data categorization and filtering out internal transfers, this prompt ensures you hand your tax professional a clean, audit-ready file where the only work left is the strategic review that actually requires your specific business knowledge.
Why it’s structured this way
This prompt is engineered with strict categorization guardrails and explicit fail-safes to prevent the AI from guessing on unclear transactions, ensuring you never hand your tax professional a confidently incorrect ledger.
- Fixed Category Vocabulary: The Schedule C category names are specified exactly and no others are permitted. Left open, the same expense drifts between “Software,” “Office Expense,” and “Other” across runs, which makes year-over-year comparison and preparer handoff meaningless.
- Explicit Refusal to Guess: Unlabeled ATM withdrawals, numbered checks with no payee, and truncated merchant descriptions are routed to a “Requires Receipt/Clarification” list rather than assigned a plausible category. Inventing a payee is the one failure mode that could genuinely mislead your tax preparer, so the prompt is built to stop instead.
- Separation of Transfers From Expenses: Movements between your own accounts are flagged as excluded, not categorized. Counting an internal transfer as a business expense would overstate your deductions.
- Reconciling Summary: Categorized totals, review items, and excluded transfers must sum to your total outflows. If a transaction were dropped or double-counted, the arithmetic won’t balance and you’ll see it immediately.
- Data Grounding & Stability: Connects directly to live account data via our MCP-based AI Connector, allowing the AI to securely extract and categorize up to a full year of transaction history without the risk of manual data entry errors.
Verified Prompt
You are acting as my bookkeeper preparing a draft expense categorization for my tax preparer to review.
Pull all transactions from my [ACCOUNT NAME] account for [START DATE] to [END DATE].
- Assign every outgoing transaction to one draft IRS Schedule C expense category from this list: Advertising, Car & Truck, Commissions & Fees, Contract Labor, Cost of Goods Sold, Insurance, Interest, Legal & Professional Services, Office Expense, Rent or Lease, Repairs & Maintenance, Supplies, Taxes & Licenses, Travel, Meals, Utilities, Wages, Other. Use the vendor name and transaction type as your evidence, and state the evidence for any assignment that isn't obvious.
- Put any transaction you cannot confidently categorize into a separate "Requires Receipt/Clarification" list instead of guessing — especially ATM withdrawals, transfers between my own accounts, numbered checks with no payee, person-to-person payments, and generic or truncated merchant descriptions. Never invent a payee or purpose. Note that transfers between my own accounts are not business expenses at all and must not appear in any expense category.
- Give me two outputs: (a) a summary table of totals by category, and (b) the full transaction list as a clean table (Date | Description | Amount | Draft Category | Flag) that I can copy for my tax preparer.
OUTPUT: Generate a PDF summarizing the content. Produce exactly these three sections, in this order, with these exact headings:
- Category Summary One row per category used, then exactly these four reconciliation rows at the bottom, in this order: | Category | Total | |---|---| | Rent or Lease (EXAMPLE) | $26,400.00 | | — Total Categorized (OK) | ... | | — Total REVIEW | ... | | — Total EXCLUDED (transfers) | ... | | — Grand Total Outflows | ... | Grand Total Outflows must equal the sum of the three lines above it, and must equal the sum of all outgoing transactions in the file.
- Requires Receipt/Clarification Every REVIEW and EXCLUDED transaction: | Date | Description | Amount | Flag | Why | |---|---|---|---|---| | 2025-02-14 (EXAMPLE) | ATM Withdrawal | -$300.00 | REVIEW | No payee or purpose in description |
- Full Transaction Table Every outgoing transaction, in date order: | Date | Description | Amount | Draft Category | Flag | |---|---|---|---|---| | 2025-01-01 (EXAMPLE) | Acme Properties | -$2,200.00 | Rent or Lease | OK |
- Flag columns may contain only: OK, REVIEW, or EXCLUDED. Dates: YYYY-MM-DD.
RULES: This is a draft categorization for my tax professional to review — do not present any assignment as a final tax determination, and do not advise me on deductibility. If a transaction could plausibly fit two categories, pick one, mark it with an asterisk, and list the alternative. If any portion of the prompt is incomplete, please flag it immediately and prompt me back to ensure all portions of the prompt are filled out.
DATA SOURCE: If you're connected to my Grasshopper account(s) via the MCP connector, pull my transaction history directly.
Unlock the Full Power of This Prompt
To get the most accurate and actionable results, this prompt is designed to run on your real-time banking data. By activating the Grasshopper AI Connector, you establish a secure link between your bank account and your AI workspace, eliminating manual data entry and messy spreadsheets while ensuring your analysis is always grounded in the reality of your accounts.
Set Up In Online BankingThe content provided on this page is intended for educational and informational purposes only. It is not intended to be, and should not be construed as, financial, investment, tax, or legal advice. We strongly recommend consulting with a qualified financial advisor, tax professional, or legal counsel regarding your specific circumstances before making any financial or tax-related decisions.