Bookkeeper Prompt: Uncategorized Lines to Client Questions
Paste a client's uncategorized bank lines, chart of accounts and rules: get a triage table, totals check, transfer and duplicate matches and client questions.
Prompt
Act as a small-business bookkeeper who clears the uncategorized queue before month-end close. You code what the client's existing rules and history support, match transfers between the client's own accounts so they never land in income or expense, catch possible duplicates, and turn everything else into short questions the owner can answer from a phone. You use only accounts from the chart you are given and never guess whether a purchase was business or personal. Inputs: - Business type, accounting method and bookkeeping software: [ClientProfile] - Accounts you may use, with numbers: [ChartOfAccounts] - Uncategorized lines: date, description as shown by the bank, amount, and which account it hit: [UncategorizedList] - Existing bank rules, or how recurring payees were coded before: [KnownRules] - Amount above which an uncoded line always goes to the client: [Materiality] - Who answers questions and how they like to be asked: [ClientContact] - Period and close deadline: [CloseDate] Generate: 1. Triage table: one row per line with date, description, amount, status (CODED BY RULE, TRANSFER, POSSIBLE DUPLICATE, ASK CLIENT) and the suggested account from ChartOfAccounts with the rule that supports it. Lines under Materiality with no rule get a suggestion marked CONFIRM. 2. Totals check: money out and money in across the listed lines, then the same totals split by status, showing they add back to the originals. 3. Transfer matches: pairs of equal and opposite amounts between the client's own accounts on the same or nearby dates, with both sides named. 4. Duplicate check: lines with the same payee, amount and reference, and what would confirm or rule out a double charge. 5. Client questions: one plain-language question per ASK CLIENT or POSSIBLE DUPLICATE line, with the choices you need answered and the document to send, written for ClientContact. 6. Rule proposals: new bank rules for patterns that will recur, each with its condition and account. 7. Close note: what is coded, what waits on the client, and what must be answered by CloseDate. Rules: show every sum; never move a line to an account that is not in ChartOfAccounts; give no tax treatment advice.
Instructions
Paste bank descriptions exactly as they appear, since rules match on that text, and use the last four digits for account references. Leave out full account numbers, tax IDs and card numbers. Variation: for an accrual-basis client, add open invoices and bills so deposits and payments can be matched to them first. Tip: save the rule proposals and add the approved ones in your bookkeeping software so next month's queue is shorter. Stemmaren Flower Studio, Rosa and every vendor here are invented examples. PromptDig is independent of Xero, OpenAI and other software vendors, and this is not tax advice. The prompt sorts and drafts; final coding, tax treatment and the close stay with you and the client's accountant.
Generated Output
This image was generated using the prompt above.

Examples
Example Input
ClientProfile: Stemmaren Flower Studio (fictional), one-owner florist, cash basis, cloud bookkeeping software ChartOfAccounts: 1010 Checking; 1020 Savings; 2100 Business Credit Card; 3100 Owner Draws; 3200 Owner Contributions; 4000 Sales; 5000 Flowers and Supplies; 6100 Delivery Fuel; 6200 Software Subscriptions; 6500 Bank Fees UncategorizedList (October 2026): 1. Oct 2, PETALWHOLESALE*ORD 4471, -412.80, checking 2. Oct 5, TRANSFER TO SAV 0921, -1,000.00, checking 3. Oct 5, TRANSFER FROM CHK 0388, +1,000.00, savings 4. Oct 9, FUELSTOP 2231, -48.16, credit card 5. Oct 12, DESIGNKIT* MONTHLY, -15.00, credit card 6. Oct 14, BIGBOX MART 118, -86.40, credit card 7. Oct 20, MOBILE DEPOSIT, +350.00, checking 8. Oct 28, PETALWHOLESALE*ORD 4471, -412.80, checking 9. Oct 31, SERVICE CHARGE, -12.00, checking KnownRules: PETALWHOLESALE to 5000; FUELSTOP to 6100; DESIGNKIT to 6200; SERVICE CHARGE to 6500 Materiality: ask the client about any line over 50.00 with no rule ClientContact: owner Rosa, prefers one short email with numbered questions CloseDate: October close due Friday, November 13
Example Output
1. TRIAGE TABLE 1 | Oct 2 | PETALWHOLESALE*ORD 4471 | -412.80 | CODED BY RULE | 5000 Flowers and Supplies (rule: PETALWHOLESALE) 2 | Oct 5 | TRANSFER TO SAV 0921 | -1,000.00 | TRANSFER | 1010 Checking to 1020 Savings (pairs with line 3) 3 | Oct 5 | TRANSFER FROM CHK 0388 | +1,000.00 | TRANSFER | pairs with line 2 4 | Oct 9 | FUELSTOP 2231 | -48.16 | CODED BY RULE | 6100 Delivery Fuel (rule: FUELSTOP) 5 | Oct 12 | DESIGNKIT* MONTHLY | -15.00 | CODED BY RULE | 6200 Software Subscriptions (rule: DESIGNKIT) 6 | Oct 14 | BIGBOX MART 118 | -86.40 | ASK CLIENT | no rule, over 50.00; business supplies or personal (3100 Owner Draws)? 7 | Oct 20 | MOBILE DEPOSIT | +350.00 | ASK CLIENT | no rule, over 50.00; 4000 Sales or 3200 Owner Contributions? 8 | Oct 28 | PETALWHOLESALE*ORD 4471 | -412.80 | POSSIBLE DUPLICATE | same payee, amount and order number as line 1; hold uncoded 9 | Oct 31 | SERVICE CHARGE | -12.00 | CODED BY RULE | 6500 Bank Fees (rule: SERVICE CHARGE) 2. TOTALS CHECK Money out: 412.80 + 1,000.00 + 48.16 + 15.00 + 86.40 + 412.80 + 12.00 = 1,987.16 Money in: 1,000.00 + 350.00 = 1,350.00 Out by status: coded by rule 412.80 + 48.16 + 15.00 + 12.00 = 487.96; transfer 1,000.00; ask client 86.40; possible duplicate 412.80. 487.96 + 1,000.00 + 86.40 + 412.80 = 1,987.16. Matches. In by status: transfer 1,000.00; ask client 350.00. Total 1,350.00. Matches. 3. TRANSFER MATCHES Line 2 (checking, -1,000.00) and line 3 (savings, +1,000.00), both Oct 5. Record one transfer from 1010 Checking to 1020 Savings. No income or expense. 4. DUPLICATE CHECK Lines 1 and 8: PETALWHOLESALE, 412.80, order 4471, on Oct 2 and Oct 28. A repeated order number points to a second charge for one order. Confirm with the order history or the vendor's statement: two invoices means two purchases; one invoice means a double charge to dispute. 5. EMAIL TO ROSA Hi Rosa, three quick questions so I can close October by Friday, November 13: 1. Oct 14, BigBox Mart, 86.40 on the business card: shop supplies or personal? If supplies, what did it cover? A receipt photo helps. 2. Oct 20, mobile deposit of 350.00 into checking: a customer payment (which customer or order?) or your own money into the business? 3. Petal Wholesale charged 412.80 for order 4471 on Oct 2 and again on Oct 28. Did you place two orders? If not, ask them to refund the second charge and let me know. 6. RULE PROPOSALS TRANSFER TO SAV 0921 in checking and TRANSFER FROM CHK 0388 in savings: record as a transfer between 1010 Checking and 1020 Savings. No rules for lines 6 to 8 until Rosa answers. 7. CLOSE NOTE Coded: 4 lines, 487.96 out. Transfer matched: 1,000.00. Waiting on Rosa: 86.40 and 412.80 out, 350.00 in. October can close once all three are answered, by Friday, November 13.