Northline Coffee — Stripe Payout Reconciliation to Chase 1002 (2026-07)

Northline Coffee — Stripe Payout Reconciliation to Chase 1002 (2026-07) A data-flow diagram generated by Mosofin. 01 / Stripe (payments) 02 / Payout 03 / Chase 1002 (cash SoT) 04 / QuickBooks (books SoT) Charges · gross, July · 01 / Stripe (payments) · Stripe report · Stripe Charges gross, July Stripe report Refunds · less · 01 / Stripe (payments) · Stripe report Refunds less Stripe report Fees · less · 01 / Stripe (payments) · Stripe report Fees less Stripe report Payouts · net, initiated · 02 / Payout · amount: unknown Payouts net, initiated amount: unknown In transit · initiated 30–31 Jul · 02 / Payout · timing In transit initiated 30–31 Jul timing Deposits · Chase statement · 03 / Chase 1002 (cash SoT) · cash SoT Deposits Chase statement cash SoT Wholesale ACH · not Stripe · 03 / Chase 1002 (cash SoT) · explained Wholesale ACH not Stripe explained Deposits in QBO · bank feed · 04 / QuickBooks (books SoT) · books SoT Deposits in QBO bank feed books SoT Unexplained · must be zero · 04 / QuickBooks (books SoT) · gate Unexplained must be zero gate gross charges Stripe less refunds Stripe less fees Stripe landed in July matched not yet landed timing ACH deposits non-Stripe bank feed matched − payouts − ACH − transit gate Legend money contra / deduction timing difference account sync

How it ties

  • • Stripe payout report explains gross, refunds, fees per payout
  • • Chase deposits are the only cash fact
  • • QuickBooks deposits come from the bank feed, not from Stripe

Guardrails

  • • In-transit payouts are dated timing items, listed by payout ID
  • • Wholesale ACH is explained separately; it is not a Stripe break
  • • No amounts drawn: none were supplied for 2026-07 · connected ≠ tied out

Gate

  • • Unexplained residual must be zero before lock
  • • A residual is a break owned by the controller
  • • Do not mark green on a non-zero difference