Business Value
Cuts monthly reconciliation from a frustrating evening down to minutes while catching the hidden transactions that quietly leak cash: duplicate vendor billings and undocumented, round-dollar transfers out of the business. The second category matters more than most owners realize. Unsupported round-dollar transfers are the exact patterns tax examiners and lenders flag as unapproved personal distributions. By automatically flagging potential double-payments and generating a proactive documentation checklist for round-dollar transactions, this prompt gives you duplicate charge alerts, a clean audit trail, and an import-ready ledger format that lets you confidently reconcile your books in a fraction of the time.
Verified Prompt
Act as an accounting clerk helping me reconcile my Grasshopper statement against my internal ledger.
- Flag any transactions with the exact same amount that occurred within [Insert Number, e.g., 5] days of each other — these are potential duplicate charges or double-billing. List each flagged pair with dates and amounts.
- Separately, flag round-number transfers (e.g., exact amounts like $500.00 or $1,000.00 with no cents) that don't have an obvious matching invoice or bill description in the data. For each one, note what supporting document I should go find (invoice, receipt, contractor agreement) to confirm it wasn't a personal distribution.
- Reformat the transaction list into columns ready for import into [Insert Software Name, e.g., QuickBooks]: Date, Description, Category, Amount, Debit/Credit.
Present the duplicate flags and round-transfer flags as two separate tables, followed by the reformatted import-ready data. Add one line noting that flagged items are patterns worth reviewing, not confirmed errors, and each should be verified against actual records before any correction is made.
OUTPUT: Produce exactly these three sections, in this order, with these exact headings:
- Potential Duplicates | Description | Amount | Date 1 | Date 2 | Days Apart | |---|---|---|---|---| | Acme Software (EXAMPLE) | -$99.00 | 2026-04-02 | 2026-04-04 | 2 | If none: write exactly "NO DUPLICATES FOUND" and nothing else in this section.
- Round-Dollar Transfers — Documentation Checklist | Date | Description | Amount | Document Needed | |---|---|---|---| If none: write exactly "NO ROUND-DOLLAR TRANSFERS FOUND".
- Import Table Every transaction, in date order, no omissions: | Date | Description | Amount | Category | |---|---|---|---| Category column: leave blank in every row. Dates everywhere in this output: YYYY-MM-DD. Amounts: negative sign for debits, two decimals.
RULES: 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.
Why it’s structured this way
This prompt is engineered to apply rigid, parameter-driven rules against your ledger, preventing the AI from making interpretive guesses so that every flagged duplicate is based on mathematical certainty rather than assumption.
- Parameter-Driven Detection: You set the matching criteria, within a window of days you choose. Explicit dials mean the same file produces the same findings every time, and you can tighten or loosen the check deliberately rather than hoping the model calibrates the way you’d want.
- Anti-Overreach Guardrail: The prompt is expressly forbidden from stretching its criteria to produce a finding, and must return the exact phrase “NO DUPLICATES FOUND” on a clean month. A tool that always finds something trains you to ignore it; a clean result has to be a real, trustworthy outcome.
- Constructive, Non-Accusatory Framing: Flagged transfers are paired with the specific receipt or invoice to locate, never characterized as improper. The output is a documentation task list, which is what’s actually useful and what keeps the exercise focused on preparation rather than suspicion.
- Import-Ready Output: Reformats the full transaction list with fixed columns and a blank category field, eliminating the re-keying step between your bank statement and your accounting software.
- Data Grounding & Stability: Connects directly to live account data via our MCP-based AI Connector, pulling transaction history securely to run direct comparisons and eliminate the need to manually export and format CSVs.
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.