Create intermediate Works with: Any AI

Bank Statement Categorization Helper

Table output Has example

Sort transactions quickly and consistently.

The Open buttons send the prompt text as currently shown below to that site only when you click. Fill in the placeholders first.

[VERIFY] is an editorial flag, not a blank to fill. Wherever the prompt shows [VERIFY], check that item against a reliable source before you use it.

Categorize these transactions. Category list: [CATEGORY_LIST]. Transactions (date, description, amount): [TRANSACTIONS]. Notes on recurring vendors: [VENDOR_NOTES].

Return a table: Date | Description | Amount | Category | Confidence (high, medium, low) | Reason | Question if unsure. Never guess silently: for any transaction you cannot place with confidence, mark it "needs my input" and ask a specific question (what was this payment for?).

After the table, give: totals by category with arithmetic; a list of vendors that appear several times and a proposed rule for each (always category X); possible duplicates; transfers between my own accounts, which should not be counted as income or expense; and items that may need a receipt. Finish with a short list of the ten rules I can put into my bookkeeping software. Do not state tax treatment; add [VERIFY] for items that might be personal or capital.

For every transaction marked 'needs my input', phrase the question so I can answer in one word or number. Report how many transactions were categorized with high confidence as a percentage of the total, with the arithmetic.

Please present all results as estimates that rest only on the information I gave you. Please do not read this as accounting, tax, legal or investment advice. A qualified accountant or financial adviser in [JURISDICTION] should review this before you act on it.

Fill in before use

Optional: type your details and the prompt above updates. Nothing is saved or sent.

Replace each bracketed placeholder with your own details, then paste into Any AI or another assistant.

12 Mar | AMZN Mktp 48.20 | Office supplies | high | printer paper seen in vendor notes
13 Mar | TRANSFER TO SAVINGS 500.00 | Transfer between my accounts | high | not income or expense
14 Mar | CITY PARK 9.00 | needs my input | low | Was this a client visit or personal parking? Answer: business or personal.
15 Mar | ADOBE 54.99 | Software | high | recurring; rule: always Software
16 Mar | DELI 22.40 | needs my input | medium | Who attended, and for what purpose?
Totals so far: Office supplies 48.20; Software 54.99; Transfers 500.00 (excluded); needs input 31.40. Check: 48.20 + 54.99 + 31.40 = 134.59 of expenses.
High-confidence share: 3 of 5 = 60 percent.
Possible duplicate: none. Receipt needed: parking and deli. Add [VERIFY] if personal or capital.

• categorization