Stripe Fees and Revenue Reconciliation Audit
Check fees, refunds and net revenue against reports.
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 Stripe fees and net revenue for learning. Monthly data: gross volume, fees, refunds, disputes, payouts, and the figures recorded in the accounting system: [MONTHLY_DATA]. Fee schedule as I understand it: [FEE_SCHEDULE]. Start with what data you have and what is missing, and ask for the pricing page figures and any custom agreement terms rather than assuming them. Compute the effective fee rate each month as fees divided by gross volume and compare with the expected rate, highlighting months more than a tenth of a percentage point away; for each flagged month list possible causes in order of likelihood (currency conversion, refunds not returning fees, timing, additional services, mix of cards) and the report to check. Worked month (invented): gross volume 52,400.00; fees 1,630.60; effective rate 3.11 percent; refunds 1,200.00; disputes 150.00; net payout 49,419.40; bank deposits 49,419.40; difference 0.00. Reconcile net revenue to payouts and to the accounting entries in a table. Return a table, questions for Stripe support and the accountant, a monthly checklist and a summary for the accountant. Mark numbers as examples [VERIFY]. This is bookkeeping education, not accounting, tax or legal advice; rules differ by place, so note what a qualified accountant must confirm [VERIFY].
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.