Refund, Dispute and Payout Reconciliation Audit
Reconcile Stripe reports with the bank and bookkeeping records.
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.
Audit refunds, disputes and payouts. A summary of charges, refunds, dispute amounts and fees by month, and payouts received in the bank: [STRIPE_SUMMARY]. Bookkeeping entries for the same period: [BOOKKEEPING_ENTRIES]. How fees and disputes are recorded: [RECORDING_METHOD]. Reconcile gross sales minus refunds, dispute losses and fees to payouts for each month, showing the arithmetic and any difference. Identify timing differences (payout delays), fees recorded net rather than gross, disputes not recorded, refunds not matched to original sales, and currency differences. Make a table with Month, Gross, Refunds, Disputes, Fees, Net expected, Payouts, Difference, and Explanation. Propose a monthly reconciliation routine and a list of items to ask my bookkeeper. Use only my figures. Do not provide tax advice. Mark report names [VERIFY]. Add a worked month with invented figures: gross charges 18,400, refunds 620, dispute losses 150, fees 574, net expected 17,056, payouts received 16,500 plus 556 still pending, so the difference is explained by timing; show how to document the pending amount and check it next month.
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.