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.
Fill in the Template
0 / 6 filledYour Built Prompt
Updates live as you typeMy 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.Fill in the required fields above to copy or run this prompt.
Tags
Community Feedback
0 commentsRelated Prompts
More in BusinessOpen home reminder SMS
Friendly text the morning of the open inspection so booked prospects don't forget to come.
Pricing review agent (annual)
Once-a-year deep dive on whether your pricing is keeping up. Compares your rates to market, models a price-rise scenario, drafts the announcement to existing customers.
Insurance + warranty claim agent
When something needs to go through insurance: helps decide if it's worth claiming, drafts the claim cover letter, lists the evidence to attach, manages the back-and-forth.
Materials & supplier order agent
End-of-day materials prep: lists what to order, where (best price + stock), pickup vs delivery decision, builds the order email/text for the supplier.