Distinguish money in transit from missing settlement

Purpose

Staff need a current view of expected money for the day they are reviewing.

How It Works

A bookkeeper chooses the relevant unit and day, then inspects the outstanding ledger. Rhythm combines dates, active holdings and resolutions into the displayed state. Candidate payouts help the bookkeeper investigate where expected money might have gone. Historical day selection can differ from today’s state without modifying the record. Missing permission or invalid selection stops the read.

Relationships

Effect recording supplies items, exception detection follows overdue states and readiness uses the same financial position.

Show evidence (sources, provenance, origins, pinned commits)

The Formal Contract

The narrative above explains; the sections below are authoritative — the rules, scenarios and tests this document binds.

Outcomes: Staff distinguish settled, traveling and missing money at their selected day.Requested-day calculations avoid stale aging labels.Compatible payout candidates help investigate missing arrival.
Surfaces: consoleapi
Intent sources: services-accounting:docs/milestones/plans/ACCT-M8-plan.md#D10 (§1: every money movement not yet in a deposit is visible, aged by the calendar)services-accounting:docs/milestones/plans/ACCT-M8-plan.md#D10 (§4: the architecture §6 invariants hold; INV-17; architecture §12.1 hybrid model)

Controls

22 controls apply, from the corpus control catalogue.

TC-IAM-001 TC-IAM-002 TC-IAM-004 TC-IAM-005 TC-IAM-006 TC-AZ-001 TC-AZ-002 TC-AZ-003 TC-AZ-004 TC-AZ-006 TC-TEN-001 TC-TEN-002 TC-TEN-003 TC-DAT-001 TC-DAT-002 TC-DAT-003 TC-LOG-004 TC-PI-001 TC-PI-002 TC-PI-005 TC-PRV-001 TC-PRV-002

Permissions

Key	Checked at	Scope
`accounting.settlement-items.read`	api	tenant
`accounting.application.access`	console	tenant

Business Rules

10 rules, 9 to be proved before approval. A rule's product intent is derived from its origin: 10 confirmed by a product decision, the rest inheriting this capability's confirmed.

Id	Rule	Kind	Enforced at	Provenance
`01`must prove Confirmed	Outstanding status is recalculated for the requested day using resolution, finalized claim, open claim, eligibility, hold and arrival timing in that order, then acceptance or investigation after grace. ✓ A long-overdue capture claimed by a finalized reconciliation reads settled.✗ A capture claimed by a draft never reads overdue. origin: services-accounting:docs/milestones/plans/ACCT-M8-plan.md#D10 (§4: the architecture §6 invariants hold; architecture §12.3) proved by `ATS-ACC-REC-006-01`, `ATS-ACC-REC-006-09`, `ATS-ACC-REC-006-10`, `ATS-ACC-REC-006-11`, `ATS-ACC-REC-007-09`, `TST-ACC-REC-088`	calculation	service, database	test services-accounting:modules/reconciliation/tests/unit/rules/outstanding-state.spec.js#is settled when its active claim is finalized, even long overdue; services-accounting:modules/reconciliation/tests/unit/rules/outstanding-state.spec.js#is resolved when the item has a resolution, even with a finalized claim; services-accounting:modules/reconciliation/tests/unit/rules/outstanding-state.spec.js#is in an open reconciliation when its active claim is open, even long overdue; services-accounting:modules/reconciliation/tests/unit/rules/outstanding-state.spec.js#is not yet eligible with no eligible date; services-accounting:modules/reconciliation/tests/unit/rules/outstanding-state.spec.js#is held with no expected settlement date, however late; services-accounting:modules/reconciliation/tests/unit/rules/outstanding-state.spec.js#is under investigation with an open exception; services-accounting:modules/reconciliation/tests/unit/rules/outstanding-state.spec.js#is accepted with an accepted exception
`02`must prove Confirmed	Unclaimed money stays in transit through its expected day, becomes late through its business-day grace and overdue afterward; a reserve without an expected release remains held. origin: services-accounting:docs/milestones/plans/ACCT-M8-plan.md#D10 (plan approved 2026-10-22 10:40 ET; §2 scope); §1: not yet eligible, in transit, late, overdue proved by `ATS-ACC-REC-005-12`, `ATS-ACC-REC-006-02`, `TST-ACC-REC-072`, `TST-ACC-REC-088`	calculation	service	test services-accounting:modules/reconciliation/tests/unit/rules/outstanding-state.spec.js#is overdue the day after the grace ends; services-accounting:modules/reconciliation/tests/unit/rules/outstanding-state.spec.js#is late the day after its expected date, over the weekend; services-accounting:modules/reconciliation/tests/unit/rules/outstanding-state.spec.js#is late on the last day of the grace; services-accounting:modules/reconciliation/tests/unit/rules/outstanding-state.spec.js#is still late on the Tuesday when the grace runs over Columbus Day; services-accounting:modules/reconciliation/tests/integration/services/persistence/settlement-items.queries.integration.spec.js#names the grace of the merchant account’s override and the payment a capture came from
`03`must prove Confirmed	Grace uses the merchant override, then processor default, then a two-business-day fallback. proved by `ATS-ACC-REC-005-12`, `ATS-ACC-REC-006-02`, `TST-ACC-REC-072`, `TST-ACC-REC-088`	calculation	service	test services-accounting:modules/reconciliation/tests/integration/services/persistence/settlement-items.queries.integration.spec.js#names the grace of the merchant account’s override and the payment a capture came from; services-accounting:modules/reconciliation/tests/unit/rules/outstanding-state.spec.js#is late the day after its expected date, over the weekend; services-accounting:modules/reconciliation/tests/unit/rules/outstanding-state.spec.js#is late on the last day of the grace; services-accounting:modules/reconciliation/tests/unit/rules/outstanding-state.spec.js#is overdue the day after the grace ends; services-accounting:modules/reconciliation/tests/unit/rules/outstanding-state.spec.js#is still late on the Tuesday when the grace runs over Columbus Day
`04`must prove Confirmed	Cursor-paged settlement lists order oldest first and include requested-day status, age since occurrence and holder, with filters for state, unit, merchant, processor, kind, source batch, occurrence range and customer search. origin: services-accounting:docs/milestones/plans/ACCT-M8-plan.md#D10 (plan approved 2026-10-22 10:40 ET; §2 scope) proved by `ATS-ACC-REC-006-03`, `TST-ACC-REC-024`, `TST-ACC-REC-072`	policy	api, service	test services-accounting:modules/reconciliation/tests/e2e/outstanding.e2e.spec.js#answers 200 with alpha’s items oldest first, each with its derived state at asOf; services-accounting:modules/reconciliation/tests/e2e/outstanding.e2e.spec.js#answers the calendar days each item has been outstanding since its local occurrence date; services-accounting:modules/reconciliation/tests/e2e/outstanding.e2e.spec.js#answers the claiming batch of a claimed item; services-accounting:modules/reconciliation/tests/e2e/outstanding.e2e.spec.js#filters by the states named, comma-separated; services-accounting:modules/reconciliation/tests/integration/services/persistence/settlement-items.queries.integration.spec.js#answers an operational batch’s items; services-accounting:modules/reconciliation/tests/integration/services/persistence/settlement-items.queries.integration.spec.js#answers the items whose customer label contains the search, whatever its case; services-accounting:modules/reconciliation/tests/e2e/outstanding.e2e.spec.js#refuses a state outside the vocabulary with 400; services-accounting:modules/reconciliation/tests/e2e/outstanding.e2e.spec.js#refuses a cursor it did not answer with 400; services-accounting:modules/reconciliation/tests/e2e/outstanding.e2e.spec.js#refuses an asOf that is not YYYY-MM-DD with 400
`05`must prove Confirmed	Unsupported states, malformed cursors and dates outside the accepted year-month-day shape are rejected. proved by `ATS-ACC-REC-006-03`, `TST-ACC-REC-024`, `TST-ACC-REC-072`	validation	api	observed services-accounting:modules/reconciliation/aws/api/outstanding.schemas.ts:listSettlementItemsQuerySchema
`06`must prove Confirmed	Settlement summaries group requested-day counts and signed totals by state, processor and currency, respecting unit, merchant and processor filters. origin: services-accounting:docs/milestones/plans/ACCT-M8-plan.md#D10 (plan approved 2026-10-22 10:40 ET; §2 scope); brief: what reached settlement, what is in transit, what is missing proved by `ATS-ACC-REC-006-04`, `TST-ACC-REC-024`, `TST-ACC-REC-072`	calculation	service	test services-accounting:modules/reconciliation/tests/e2e/outstanding.e2e.spec.js#answers 200 with alpha’s counts and totals by state, processor and currency; services-accounting:modules/reconciliation/tests/integration/services/persistence/settlement-items.queries.integration.spec.js#counts and totals the items by state, processor and currency at the date; services-accounting:modules/reconciliation/tests/integration/services/persistence/settlement-items.queries.integration.spec.js#summarizes a processor’s items alone
`07`must prove Confirmed	An item awaiting settlement can show up to five free live payouts of its merchant and currency from one business day before expected arrival, even before eligibility. proved by `ATS-ACC-REC-006-05`, `TST-ACC-REC-024`, `TST-ACC-REC-072`	calculation	service	test services-accounting:modules/reconciliation/tests/integration/services/persistence/settlement-items.queries.integration.spec.js#offers the free payout dated on its expected date, in the list; services-accounting:modules/reconciliation/tests/integration/services/persistence/settlement-items.queries.integration.spec.js#offers it in the detail too; services-accounting:modules/reconciliation/tests/e2e/outstanding.e2e.spec.js#answers 200 with the item, its state facts and the payout that may carry it
`08`must prove Confirmed	Database list status agrees with the pure status calculation at expected-day, weekend, holiday and grace boundaries. proved by `ATS-ACC-REC-006-06`, `TST-ACC-REC-072`	invariant	service, database	test services-accounting:modules/reconciliation/tests/integration/services/persistence/settlement-items.queries.integration.spec.js#answers the same literal state for every item on Monday 2026-10-12, Columbus Day, by the SQL and by the rule; services-accounting:modules/reconciliation/tests/integration/services/persistence/settlement-items.queries.integration.spec.js#answers the same literal state for every item on Friday 2026-10-09, the expected date, by the SQL and by the rule; services-accounting:modules/reconciliation/tests/integration/services/persistence/settlement-items.queries.integration.spec.js#answers the same literal state for every item on Thursday 2026-10-15, past the grace, by the SQL and by the rule
`09`must prove Confirmed	Settlement read permission controls access, and records in another workspace are absent. origin: services-accounting:docs/milestones/plans/ACCT-M8-plan.md#D5 proved by `ATS-ACC-REC-006-07`, `TST-ACC-REC-024`	permission	api	test services-accounting:modules/reconciliation/tests/e2e/outstanding.e2e.spec.js#refuses the list without accounting.settlement-items.read with 403; services-accounting:modules/reconciliation/tests/e2e/outstanding.e2e.spec.js#refuses the summary without accounting.settlement-items.read with 403; services-accounting:modules/reconciliation/tests/e2e/outstanding.e2e.spec.js#refuses tenant A’s item in tenant B with 404; services-accounting:modules/reconciliation/tests/e2e/outstanding.e2e.spec.js#lists none of tenant A’s items in tenant B
`10` Confirmed	Outstanding Payments presents the selected unit’s items outside finalized reconciliations with transit and overdue totals, and enables overdue-problem acceptance according to accept permission. origin: services-accounting:docs/milestones/plans/ACCT-M8-plan.md#D6 (architecture §3.4 U12)	policy	console	observed react-console:components/accounting/reconciliation/outstanding-screen.tsx:OutstandingScreen

Scenarios

Id	Given	When	Then	Provenance
`01`	The five-hundred-dollar post-cut-off gift spans the holiday and two-day grace.	Review Monday, Tuesday and Friday positions.	It progresses from not eligible to transit to overdue.	test services-accounting:modules/reconciliation/tests/e2e/reconciliation-scenario.e2e.spec.js#step 9: has the gift not yet eligible on 2026-10-12 (Columbus Day) and in transit on 2026-10-13
`02`	The explained items are held by a finalized reconciliation.	Inspect outstanding money.	Those items are settled and only the separate gift remains outstanding.	test services-accounting:modules/reconciliation/tests/e2e/reconciliation-scenario.e2e.spec.js#step 9: has every claimed item settled, the gift the only item outstanding

Edge Cases

Id	Given	When	Then	Provenance
`03`	An item is overdue today but had reached only its expected day earlier.	Read its earlier-day state.	The historical position is in transit.	test services-accounting:modules/reconciliation/tests/e2e/outstanding.e2e.spec.js#derives the state at the asOf given: the overdue item was in transit on its expected date

Planning

Implementation

Distinguish money in transit from missing settlement ​

Purpose ​

How It Works ​

Relationships ​