Bank reconciliation status
bank_reconciliation_statusWhere each bank account stands on reconciliation: GL balance vs the latest statement's closing (with the difference, or an honest "unknown" when no balance is stated); rowCounts by stored status (SUGGESTED = proposed, awaiting the owner; UNCATEGORIZED = never categorised, incl. hand-typed rows; CONFIRMED = categorised, not in the ledger; POSTED; IGNORED = set aside); the unreviewed backlog (SUGGESTED + UNCATEGORIZED not paired on Clear transactions) with pairedInBooks; reconcilingItems — each item's signed effect on the difference, summing to it exactly (NOT_EXPLAINED is the honest remainder, STATEMENTS_DONT_JOIN a missing or duplicated statement). A statement line PAIRED on Clear transactions is in the books: it and the entry it is paired with sit in no other item, and PAIRED_ON_CLEAR appears only when a pair is for a different amount (its effect is what the pair leaves; pairedOnClear gives the paired line count). Cash moved with no bank line is DRIFT_: DRIFT_EXPENSE, DRIFT_GATEWAY_PAYOUT, DRIFT_OPENING, DRIFT_MANUAL, DRIFT_CASH_SALE (cash sales booked to the account), DRIFT_CASH_BILL (bills paid in cash), DRIFT_LOAN (loan instalments), DRIFT_DOCUMENT (other records: payroll, assets, credit notes, adjustments…), and DRIFT_OTHER only for what cannot be attributed; notOnStatementNotInBooks — unposted lines on no statement (hand-typed, or a recorded receipt/payment not yet posted), which do not affect the difference; and per recent statement its balances, tie-out and counts (paired = lines paired on Clear transactions, never counted as suggested, confirmed or uncategorized; pairsLeaving = that statement's pairs for a different amount and what they leave). A CREDIT CARD's figures are a liability: negative = money OWED, never cash. Same figures as the in-app Bank Reconciliation page. READ-ONLY.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||