Per-Account Daily Statement?

Per-account, per-day walk: opening balance + day's debits + credits + closing balance + drift. Pick one account and one business day via the controls; KPIs surface the 5-number summary and the detail table lists every Money record posted that day. Drift = stored closing − (opening + signed-net flow); on a healthy feed it's exactly zero, so non-zero drift here is the single visual cue the underlying ledger doesn't reconcile for that account-day. Mirrors AR's Daily Statement pattern. Account picker lists accounts with stored daily balances only (L2 control-account stubs that lack their own balance row are filtered out). Role dropdown — renderer divergence: App2 narrows the Account list to the picked Role; QuickSight does not (a QS endpoint bug — see quicksight-quirks.md). On QS the Account dropdown shows the full universe regardless.

Opening Balance

End-of-prior-day stored balance for the picked account.

Debits (signed)

Sum of amount_money over Debit-direction legs posted today, signed by v6 convention (Debit = negative). Closing = Opening + Credits + Debits (the signs already carry direction; do NOT subtract).

Credits (signed)

Sum of amount_money over Credit-direction legs posted today, signed by v6 convention (Credit = positive). See Debits subtitle for the formula.

Closing Stored

The day's stored closing balance from the feed.

Posting Drift

Closing stored − (opening + signed-net flow) for THIS account-day. Non-zero ⇒ today's postings don't reconcile with today's stored balance change. Distinct from the Drift sheet's leaf/parent drift (stored vs cumulative computed; whole-history rather than per-day) and from parent aggregation drift (parent stored vs Σ child stored). The ✓/✗ glyph next to the number is the accessible state signal — green ✓ when drift = $0 (healthy reconciliation), red ✗ otherwise.

Posted Money Records

Every leg posted on the picked account-day. Direction shows Debit / Credit; status filters out Failed legs in the summary KPIs but not here. Right-click any row → View Transactions to see every leg of that transfer.

Control accounts (1:1 singletons)

Parent / singleton internal accounts — account_parent_role IS NULL filters to roots of the control hierarchy (account_scope = 'internal' keeps external counterparties out). Type the account name back into the Account picker above to drill into one. Last Balance + Last Transaction columns surface staleness — same-day vs balance-but-no-recent-tx tells you whether the feed is flowing AND whether anything is actually posting against this control. On sasquatch_pr this is the 10 GL controls (CashDueFRB, ACHOrigSettlement, etc.).