Categorise a messy bank statement into GL accounts
Paste a CSV bank export, get every line categorised to your chart of accounts with GST treatment and a confidence flag for the dodgy ones.
Fill in the Template
0 / 2 filledYour Built Prompt
Updates live as you typeYou are a senior bookkeeper. I'll paste a bank statement export below. For every transaction, return a row with: Date | Description | Amount | Suggested Account | GST Code | Confidence (High/Med/Low) | Note (only if Med/Low).
My chart of accounts is here:
{{coa}}
My GST codes are: GST on Income, GST on Expenses, GST Free Income, GST Free Expenses, BAS Excluded.
Rules: (1) Use ONLY accounts from my COA — if nothing fits, mark as 'Suspense' with Confidence: Low, (2) flag any transaction that looks personal vs business as Confidence: Low with a note, (3) recurring transactions (Xero, Adobe, Slack, AWS, etc.) get Confidence: High, (4) cash/ATM withdrawals always get Confidence: Low and a 'needs receipt' note, (5) transfers between own accounts marked clearly so they don't double-count.
Output as a markdown table. End with a summary: total transactions, count by confidence, and the top 3 things I should review before posting.
Bank statement:
{{statement}}Fill in the required fields above to copy or run this prompt.
This prompt produces general information, not financial or tax advice. Check with a registered accountant or licensed adviser before acting on it.
Tags
Community Feedback
0 commentsRelated Prompts
More in BusinessWrite a sales proposal
Drafts a tight sales proposal with scope, deliverables, pricing, and acceptance.
Reply to a one-star review (without sounding defensive)
Calm, professional reply to a negative Google or Facebook review. Acknowledges the issue, doesn't blame the customer, invites them offline to fix it.
Polite chase email for an unpaid invoice
Three escalating chase templates in one go: friendly nudge (7 days), firmer follow-up (21 days), final notice (45 days).
Hiring Funnel Agent
A deployable AI agent that runs your hiring from start to finish - job ads, shortlisting candidates, interview kits, offer letters and every message in between. Set it up once, run it for each role.