Back to library
Claude#businessWorkflowSaves ~15min

Match Stripe payouts to bank deposits

Reconcile a week of Stripe payouts to the deposits in your bank feed — accounts for fees, refunds and chargebacks, flags anything that doesn't match.

rach_maeve29 May 2026
0.0(0)

Fill in the Template

0 / 6 filled

Your Built Prompt

Updates live as you type
My Stripe dashboard shows payouts that don't match what hit my bank because of fees, refunds and chargebacks. Help me reconcile a week's worth.

Bank account name (in Xero/MYOB): {{bank_account}}
Stripe currency: {{currency}}
Reconciliation period: {{period}}

Stripe payouts (date, amount, payout ID):
{{stripe_payouts}}

Bank deposits matching that period (date, amount, description):
{{bank_deposits}}

Stripe fees + refunds within the period (date, amount, type):
{{stripe_adjustments}}

For each Stripe payout:
1. Match it to a bank deposit (by date proximity ±2 days and amount).
2. If amounts don't match, explain the gap (which fees / refunds account for the difference).
3. Flag any payout with no matching deposit or any deposit with no matching payout.

Output as a table: Stripe Payout ID | Stripe Amount | Bank Deposit Date | Bank Amount | Gap | Explanation.

At the bottom give me:
- Total reconciled gross sales.
- Total Stripe fees (for separate Xero entry).
- Any unreconciled items to chase.

Australian conventions. Treat Stripe fees as a separate expense line, not a deduction from sales.
Run in

Fill in the required fields above to copy or run this prompt.

Tags

Community Feedback

0 comments
Be the first to leave feedback on this prompt.

Related Prompts

More in Business