Case study · Stripe payout reconciliation
The checks before anything leaves
Every week goes through these checks before I can export it. If I override one, the reason gets written into the run log next to the numbers it let through.
From a real run · amounts removed
Weekly payout console
WEEK ENDING SEP 20, 2026
SNAPSHOT + FINGERPRINT SAVED
1 to review
Nothing here blocks the export. It still gets a look.
Checks
- Warn
No unattributable network costCost Stripe sends with no client posts to the platform line
- Pass
Journal entries balanceDebits equal credits in every entry
- Pass
Cost reconciles to sourceJournal lines add back to the Snowflake cost total
- Pass
Entity allocation tiesPlatform cost splits across entities with nothing created or lost
- Pass
Retention matches the rec sheetEach client's retention equals the reconciliation figure
- Pass
Retention invoices suppliedThe week's retention invoices are in
- Pass
No cost on a provisional accountA placeholder account is not a mapping
- Pass
Entity validatedChecked against journal entries already posted
- Pass
No open findingsNothing recorded as looking off this week
- Pass
Source population accounted forEvery category in the itemized view is declared and its cost captured
- Pass
Source view is completeEvery category in Stripe's ledger is declared, so a new fee type gets caught
- Pass
Cost/revenue ratio is plausibleA big move means cost and revenue disagree about the week
- Pass
Every account has a NetSuite nameNo client cost posts without a name
- Pass
Nothing already accruedChecked by Stripe's own row ID against earlier runs
- Pass
Cost composition is stableNew, vanished or shifted cost types get flagged
228,255
new Stripe rows, none accrued before
2
journal entries, one per payout window
6
files per run, snapshot included