structure_idrequired | string | The reconciliation block. |
namerequired | string | The block's name. |
scoperequired | string | ledger: the whole ledger against one source. account: one account against an independent balance.
|
methodrequired | string | Where the independent side comes from. source_ledger is the synced accounting system's own trial balance. schedule_register is what the account's schedules say it carries. statement is the ending balance of a statement recorded for the account. |
element_idoptional | string | The account reconciled; null for a ledger-scope block. |
required_for_closerequired | boolean | Whether the period's close waits on this reconciliation. |
materialityrequired | number | A difference up to this amount still counts as reconciled. |
statement_cycleoptional | string | statement blocks only: how often the account's statement is issued, monthly, quarterly or annual.
|
periodrequired | string | The period, as YYYY-MM. |
as_ofrequired | string (date) | The period's last day. |
statusrequired | string | not_started: not compared for this period. stale: the books have changed since it was compared, so run refresh-reconciliations. unreconciled: the sides differ by more than the materiality. reconciled: they agree within it. reviewed: reconciled and signed off.
|
unreconciled_differenceoptional | number | What is left unexplained at the last comparison; null when the period has not been compared. For a ledger-scope block, the sum of every account's absolute difference. For an account-scope block, the ledger balance minus the independent one. |
accounts_comparedoptional | integer | Ledger-scope only: accounts with a balance on either side. |
accounts_differentoptional | integer | Ledger-scope only: accounts that do not tie. |
ledger_balanceoptional | number | Account-scope only: the account's balance at the last comparison, debit-positive, as the period's close will leave it. |
independent_balanceoptional | number | Account-scope only: what the independent source said at the last comparison, debit-positive. |
balance_as_ofoptional | string (date) | Account-scope only: the date the two balances are stated at. The period's last day, unless the statement covering it ended earlier. |
componentsoptional | ReconciliationComponent[] | Account-scope only: what makes up the independent balance. One entry per schedule for schedule_register; the recorded statement for statement, then each outstanding line. ReconciliationComponent fields| Field | Type | Description |
|---|
namerequired | string | The schedule's name, the statement and its date, or the outstanding line's description. | amountrequired | number | What this part says the account holds, debit-positive. | kindoptional | string | schedule, statement, outstanding: a ledger line on a bank-fed account that did not come from the feed, dated on or before the statement, so the bank had not cleared it; or stale_outstanding: such a line dated before the statement's cycle, which the bank should have cleared by now. A stale line is listed but not counted toward the balance, so the difference it would explain stays unexplained until it clears, is voided or is re-dated.
| posting_dateoptional | string (date) | An outstanding line's posting date. | entry_idoptional | string | The journal entry an outstanding line belongs to. | structure_idoptional | string | The schedule, for a schedule_register part. | event_idoptional | string | The recorded balance, for a statement part; the event behind an outstanding line, when it has one. | document_idoptional | string | The statement document given as evidence, when one was. | noteoptional | string | Why a schedule carries nothing (disposed of, or ended early), or the note recorded with a statement balance. |
|
roll_forwardoptional | ReconciliationRollForward | statement on a bank-fed account whose statement ends before the period's last day: the statement carried to it by the feed's lines.
ReconciliationRollForward fields| Field | Type | Description |
|---|
statement_as_ofrequired | string (date) | The statement's ending date. | throughrequired | string (date) | The period's last day. | bank_linesrequired | integer | Booked feed lines dated after the statement, to the period end. | bank_activityrequired | number | Their net effect on the account, debit-positive. | bank_balancerequired | number | The statement balance carried to the period end by those lines: what the bank held then, debit-positive. | ledger_balancerequired | number | The ledger's balance at the period end, as the close will leave it, debit-positive. | outstandingrequired | number | Ledger lines not from the feed and dated on or before the period end, net: the ledger minus the carried bank balance. | feed_balanceoptional | number | A cross-check, never the figure reconciled: the bank feed's own balance from the first reading on or after the period end, less the booked feed lines between the period end and that reading. Null when the feed has no reading within ten days. | feed_balance_read_onoptional | string (date) | The day of the feed reading feed_balance starts from. |
|
sourceoptional | string | The system the independent side was read from. |
compared_atoptional | string (date-time) | When the two sides were last compared. |
fact_set_idoptional | string | The FactSet holding the period's comparison. |
compared_byoptional | string | The user whose action ran the last comparison. |
compared_viaoptional | string | operation when someone ran refresh-reconciliations; sync when a source sync refreshed it.
|
review_requiredrequired | boolean | Whether the close also waits for a sign-off. |
separate_reviewerrequired | boolean | Whether the reviewer must be someone other than the person who ran the comparison. |
reviewed_byoptional | string | The user who signed off the comparison as it stands. Null when nobody has, or when the balances changed after the sign-off. |
reviewed_atoptional | string (date-time) | When the standing sign-off was made. |
self_reviewedoptional | boolean | True when the reviewer is the person who ran the comparison they signed off. Null when there is no standing sign-off. |
differencesoptional | ReconciliationRow[] | Ledger-scope only: the accounts that did not tie at the last comparison, largest difference first. ReconciliationRow fields| Field | Type | Description |
|---|
element_idoptional | string | The chart account; null when the ledger has none for it. | account_codeoptional | string | The chart account's code. | account_namerequired | string | The account's name in the ledger, else in the source. | source_account_idoptional | string | The account's id in the source system, when it has one. | statementoptional | string | balance_sheet or income_statement. Balance-sheet accounts are compared cumulatively to the period end; income-statement accounts from the start of the fiscal year. Null when the ledger has no account.
| ledger_balancerequired | number | What the ledger holds. For source_ledger, landed entries only. For schedule_register, the balance as the period's close will leave it: landed entries, drafts awaiting the close, and schedule entries not yet drafted. | independent_balancerequired | number | What the independent source says. For a statement on a bank-fed account, the statement balance adjusted by its outstanding lines. | differencerequired | number | Ledger minus independent. | statusrequired | string | tied: both sides agree to the cent. different: both know the account and disagree. not_in_ledger: the source reports an account the ledger has none for. not_in_source: the ledger holds a balance on an account the source does not have.
| as_ofoptional | string (date) | The date both balances are stated at, when it is not the period's last day: a statement that ends mid-period is compared with the ledger at the statement's own date. | componentsoptional | ReconciliationComponent[] | Account-scope methods only: what makes up the independent balance. One entry per schedule for schedule_register; the recorded statement for statement, then each outstanding line. | roll_forwardoptional | ReconciliationRollForward | statement on a bank-fed account whose statement ends before the period's last day: the statement carried to it by the feed's lines.
|
|