Bank Reconciliation Outstanding Items Bridge Tool

Bridge separate statement/book cash with actual transit/checks, unrecorded credits/debits and signed corrections; preserves unexplained difference rather than adding a plug. Equal totals do not establish item clearance or record completeness.

Description

Bank reconciliation adjusts statement and book balances on their respective sides.

Bank reconciliation adjusts statement and book balances on their respective sides. A residual discrepancy must remain explicit instead of adding a plug.^[1]

The returned values include Adjusted bank cash minor, Adjusted book cash minor, Signed unreconciled bank minus book minor, Reconciled within caller tolerance. The How section below explains the calculation, input rules and interpretation.

When to use Bank Reconciliation Outstanding Items Bridge Tool

Use Bank Reconciliation Outstanding Items Bridge Tool when you need to evaluate the supplied records under the calculation and evidence rules below. No item clearance, complete evidence or forced balancing account is supplied.

Gather the source balances and explicit accounting policy. Monetary inputs use integer minor units in one currency; for a currency with 100 minor units per major unit, 12345 represents 123.45. One basis point is 0.01 percentage points; 10000 basis points is 100%. Dates and posting signs follow the individual rules below.

How to use Bank Reconciliation Outstanding Items Bridge Tool and understand its results

Gather the source balances and explicit accounting policy. Monetary inputs use integer minor units in one currency; for a currency with 100 minor units per major unit, 12345 represents 123.45. One basis point is 0.01 percentage points; 10000 basis points is 100%. Dates and posting signs follow the individual rules below.
Enter bankStatementBalanceMinor, depositsInTransitMinor, outstandingChecksMinor, bookCashBalanceMinor, unrecordedBankCreditsMinor, unrecordedBankDebitsMinor, signedBookErrorCorrectionsMinor, signedBankErrorCorrectionsMinor, callerToleranceMinor using the field table and calculation rules, then run the tool.
Read adjustedBankCashMinor, adjustedBookCashMinor, signedUnreconciledBankMinusBookMinor, reconciledWithinCallerTolerance. The explanation below defines the units, signs, ordering and any flags or placeholder values.
If the tool reports an input issue, correct the values and run it again. Apply the stated assumptions when interpreting a successfully returned result.

Input field	Meaning	Value type; see rules below	Requirement
bankStatementBalanceMinor	Bank statement balance minor	number	Required
depositsInTransitMinor	Deposits in transit minor	list of number	Required
outstandingChecksMinor	Outstanding checks minor	list of number	Required
bookCashBalanceMinor	Book cash balance minor	number	Required
unrecordedBankCreditsMinor	Unrecorded bank credits minor	list of number	Required
unrecordedBankDebitsMinor	Unrecorded bank debits minor	list of number	Required
signedBookErrorCorrectionsMinor	Signed book error corrections minor	list of number	Required
signedBankErrorCorrectionsMinor	Signed bank error corrections minor	list of number	Required
callerToleranceMinor	Caller tolerance minor	number	Required

Enter signed safe-integer statement/book balances and correction lists, nonnegative safe-integer transit/check/credit/debit lists and tolerance. Lists may be empty and need not align. Return checked adjusted balances, signed bank-minus-book residual and inclusive absolute-tolerance flag.

bank=statement+transit−checks+bankCorrections; book=ledger+credits−debits+bookCorrections

Units, indexing, boundary conditions and exceptional cases are defined in the calculation rules above.

Output field	Meaning	Value type
adjustedBankCashMinor	Adjusted bank cash minor	number
adjustedBookCashMinor	Adjusted book cash minor	number
signedUnreconciledBankMinusBookMinor	Signed unreconciled bank minus book minor	number
reconciledWithinCallerTolerance	Reconciled within caller tolerance	boolean

json

{
  "input": {
    "bankStatementBalanceMinor": 1000,
    "depositsInTransitMinor": [
      200
    ],
    "outstandingChecksMinor": [
      100
    ],
    "bookCashBalanceMinor": 1000,
    "unrecordedBankCreditsMinor": [
      50
    ],
    "unrecordedBankDebitsMinor": [
      20
    ],
    "signedBookErrorCorrectionsMinor": [
      70
    ],
    "signedBankErrorCorrectionsMinor": [
      0
    ],
    "callerToleranceMinor": 0
  },
  "output": {
    "adjustedBankCashMinor": 1100,
    "adjustedBookCashMinor": 1100,
    "signedUnreconciledBankMinusBookMinor": 0,
    "reconciledWithinCallerTolerance": true
  }
}

Limitations and assumptions

No item clearance, complete evidence or forced balancing account is supplied.

Numeric inputs, where present, must be finite. Follow the calculation-specific rules for overflow, underflow and exceptional cases. Numeric lists are limited to 10,000 entries and string lists to 128 entries of at most 128 characters. Follow any smaller limits above. Missing fields without a declared default, extra fields, wrong value types and violations of the calculation rules are input errors. A successfully returned false flag is an evaluated outcome; its meaning is explained above.

Alternative or Complementary methods

Use Sales Tax Collected vs Remitted Reconciliation Tool: Sales-tax payable reconciles opening liability with collections, remittances and customer refunds. A debit balance or unexplained discrepancy should retain its sign. For a complementary task, use Trial Balance Debits Credits Checker: A trial balance groups debit-positive signed account balances into debit and credit totals. Matching totals does not establish ledger completeness.

References

Bank Reconciliation Outstanding Items Bridge Tool — tool.io

Similar or alternative tools

Sales Tax Collected vs Remitted Reconciliation Tool
Sales-tax payable reconciles opening liability with collections, remittances and customer refunds. A debit balance or unexplained discrepancy should retain its sign.
Trial Balance Debits Credits Checker
A trial balance groups debit-positive signed account balances into debit and credit totals. Matching totals does not establish ledger completeness.