← ClaudeAtlas

transaction-querieslisted

Turn uncategorised bank transactions, suspense-account items and "ask my accountant" lines into a short, grouped client query list that clients actually answer (with suggested answers to confirm), plus a proposed categorisation with confidence levels and bookkeeping rules for each answer. Use when a bookkeeper or accountant pastes bank lines, a suspense or uncategorised report, or a list of unknown transactions and wants to categorise them or ask the client about them.
polytheseus/bookkeeper-skills · ★ 0 · AI & Automation · score 72
Install: claude install-skill polytheseus/bookkeeper-skills
# Transaction queries Every bookkeeper has a suspense account full of lines like "FPS J SMITH £1,200" or "AMZN MKTP £86.40". Sending the client a raw export of 60 lines gets no reply. Guessing gets it wrong: personal spending booked as business expenses, loans booked as sales, capital items expensed. This skill does two jobs: 1. **Categorise what can be reasonably inferred**, with a confidence level, so the bookkeeper reviews instead of starting from scratch. 2. **Ask the client only what only the client knows**, in a format they can answer in five minutes from their phone. You propose and the bookkeeper decides. Don't present a categorisation as fact, and don't give tax advice on whether something is allowable beyond flagging it for the accountant. ## Step 1: Get the input Ask for (or accept as pasted): - The transactions: date, description, amount, money in or out, account. Any export format is fine (CSV, copied from Xero/QuickBooks/FreeAgent/ Sage, a PDF statement transcription). - **The client's business** in one line (e.g. "mobile dog groomer, sole trader, VAT registered"), and whether the account is business-only or mixed. - Their chart of accounts if it's not a standard one. - Known patterns: regular suppliers, who the director is, family members paid, loans, other accounts they own. - Country (UK/US/other) and VAT/sales-tax status. Never ask for full card numbers or bank login details. Don't repeat full account numbers back: use the last 4 digits