reconciliations

source

Bank-to-book reconciliation per account / period.

Definition

One reconciliation per (bank_account, period) — UNIQUE on the source. `difference_amount` is statement vs GL ending balance.

11 of 11

Column

Description

Tests · PII

reconciliation_id

Primary key — BIGSERIAL on the source.

2 tests

bank_account_id

FK to `bank_accounts.bank_account_id`. NOT NULL.

1 test

period_id

FK to `fiscal_periods.period_id` (not staged in this slice). NOT NULL.

1 test

statement_ending_balance

Bank statement ending balance. NUMERIC(14,2).

gl_ending_balance

GL cash-account ending balance. NUMERIC(14,2).

difference_amount

Statement minus GL. NUMERIC(14,2).

status

Lifecycle — `in_progress` / `balanced` / `closed`.

1 test

reconciled_by_employee_id

FK to the reconciling employee — actor reference. Nullable.

reconciled_at

When reconciliation completed. Nullable.

created_at

Row insert timestamp in the source DB.

updated_at

Row update timestamp in the source DB.