Catch payout variances weekly, not at month-end

Email Carly each week and she'll match every Stripe payout to a Xero bank line, calculate variance, and post anything over $50 to #finance with a suggested JE — so a controller running weekly recon catches problems early instead of at month-end.

Stripe Xero Slack

What Carly does

1. 01 List the week's Stripe payouts with gross and net amounts
2. 02 Match each payout to a Xero bank transaction by reference + date
3. 03 Calculate variance per payout — flag anything over $50
4. 04 For flagged items, trace the transaction-level breakdown
5. 05 Post the weekly variance report to #finance with JEs suggested

Variances caught in days, not weeks

Weekly cadence surfaces the real problems (missed fee reversals, pricing bugs) before they compound. Month-end close ties out on the first pass.

Email this to Carly to kick it off.

Hey Carly,

Can you reconcile this week's Stripe payouts against Xero? List every payout with gross and net, match each one to a Xero bank transaction by reference and date, and calculate the variance.

Anything over $50, trace the transaction-level breakdown so we know where the gap came from. Post the weekly variance report to #finance with suggested JEs for the flagged items.

Thanks!

More recipes for finance & ops teams

Categorize Brex expenses into the GL

Apply GL codes to the week's Brex transactions and append to the Expense Ledger sheet.

Read →

Route a PO to the right approver

Policy + threshold check, route to designated approver, ping in Slack with a 2-line summary.

Read →

Draft the monthly close memo

NetSuite + Stripe into a Notion memo with revenue, OpEx variance, runway, and open items.

Read →