Home · Business tools · Match Stripe payouts to your bank and your books, and list what doesn't match
Match Stripe payouts to your bank and your books, and list what doesn't match
Stripe pays out one lump that covers dozens of charges, fees and refunds. Match payouts to bank lines and invoices, and get a short exceptions list.
The prompt · ChatGPT
Reconcile my Stripe payouts. If my data from this tool is available to you in this chat through a connected app, use it and tell me which records you used; if not, work only from the export or text I've pasted below. Stripe report: [attach the balance or payout reconciliation report CSV for the period] Bank statement: [attach the CSV for the same period] Paid invoices in my books: [attach the export, if you want invoice matching too] Accounting software: [e.g. Xero, QuickBooks, Sage] Ask me up to 3 short questions first if anything important is missing. Wait for my answers. Then: 1. A table: each payout, the bank line it matches, and the gross charges, fees, refunds and disputes inside it. 2. Invoices paid through Stripe, matched to charges. 3. An exceptions list: payouts with no bank line, bank lines with no payout, charges with no invoice. 4. The fee total for the period, for my bookkeeper to post. Read-only: don't create refunds or change anything in Stripe. This is help organising my own figures and wording, not financial, tax or legal advice; my accountant or bookkeeper checks anything that gets filed or posted. Only use what I've told you, leave blanks for anything I haven't given, and don't invent facts or figures. UK English. Stay in this ChatGPT chat. Do not turn on apps or connectors, and do not use memory from another chat.
What you get (sample answer)
Payout 12 Sep 4,820 → bank line 12 Sep 4,820. Inside: charges 5,100, fees 148, refunds 132. Payout 19 Sep 3,910 → bank line matched. Exceptions: charge ch_9f3 has no invoice in your books; bank line 22 Sep 40 (Stripe adjust) — check Dashboard. Fee total for period: 290 — give to bookkeeper.
Loading the outline…