2.5 Cash Balance Review, Bank Reconciliation & Transaction Verification

2.5 Cash Balance Review, Bank Reconciliation & Transaction Verification

Executive Summary: Every forecast, every investment decision, and every fraud control in treasury rests on one assumption — that the cash balances on the screen are real. Task 1.G of the 2026–2028 CTP blueprint ("Review cash balances and reconcile transaction activity to ensure accuracy") carries 2–4 questions, and it is tested as a controls topic, not a bookkeeping topic. The exam wants to know whether you understand which side of a reconciliation an item belongs on, and why timely reconciliation is the detective control that caps fraud loss.

---

1. The Balance Reporting Inputs

Reconciliation begins with the data the bank sends. A CTP is expected to know which file answers which question:

[!WARNING] A classic exam distractor: reconciling to an intraday file. Intraday reports are unaudited snapshots that can be superseded, reversed, or re-sequenced before the day closes. Only the prior-day statement is a reconciliation source.

The Three Balance Types

Reconciliation also depends on reading the right balance:

• Ledger (book) balance — every posted item, regardless of availability. This is the figure that ties to the bank's records.
• Collected balance — ledger balance less deposits still in the availability float pipeline.
• Available balance — collected balance less holds. This is what you can actually spend today.

Reconciliation uses the ledger balance. Positioning uses the available balance. Confusing the two is the second most common error on this task statement.

---

2. The Three-Way Reconciliation Model

Mature treasury organizations do not perform a two-way bank-to-book tie. They perform a three-way reconciliation:

   BANK STATEMENT              TREASURY SYSTEM (TMS)              GENERAL LEDGER
   (camt.053 / BAI2)     <-->   Deal & payment records      <-->   Accounting entries
        |                              |                                 |
        +-------- Leg 1 ---------------+---------- Leg 2 ----------------+
                                       |
                              +-------- Leg 3 ---------+
                              (Bank statement to GL directly)

• Leg 1 (Bank ↔ TMS): Did every payment treasury released actually settle, at the amount and value date instructed? Catches failed, duplicated, or amended payments.
• Leg 2 (TMS ↔ GL): Did every settled transaction post to the correct GL account and cost center? Catches mapping and interface breaks.
• Leg 3 (Bank ↔ GL): The classic accounting bank reconciliation. Catches unrecorded bank-originated items and posting errors.

An organization that only runs Leg 3 will detect that cash is wrong but will not know whether the cause was a payment failure, an interface break, or an accounting error.

---

3. Which Side Does the Item Adjust?

This is the single most testable mechanic on Task 1.G. Every reconciling item adjusts either the bank balance or the book balance — never both.

The memory rule: if the company already knew about it but the bank hasn't caught up, adjust the bank; if the bank knew about it but the company hasn't caught up, adjust the book.

Worked Reconciliation

Scenario — Northlake Manufacturing, month-end reconciliation of its main concentration account:

Step 1 — Adjust the bank side: $\text{Adjusted Bank} = \$2{,}812{,}500 + \$410{,}000 - \$735{,}000 = \mathbf{\$2{,}487{,}500}$

Step 2 — Adjust the book side: $\text{Adjusted Book} = \$2{,}450{,}000 - \$3{,}200 + \$9{,}700 - \$18{,}000 + \$49{,}000 = \mathbf{\$2{,}487{,}500}$

Step 3 — Confirm the tie. Both sides reconcile to $2,487,500, which becomes the true cash position. Note that only the book-side adjustments generate journal entries; deposits in transit and outstanding checks require no entry because the company already recorded them.

---

4. Auto-Matching, Exceptions & Aging

Modern treasury workstations reconcile by rule, not by eye. Typical matching hierarchy:

1. Exact match — amount, value date, and bank reference all agree. Auto-cleared.
2. Tolerance match — amount agrees within a defined tolerance (e.g., ±$25 or ±0.5%) to absorb lifting fees and FX rounding. Auto-cleared with a log entry.
3. One-to-many / many-to-one — a single bank credit against multiple open receivables, or a batch debit against many payment records.
4. Unmatched → exception queue — routed to a human for investigation.

Benchmark: a well-tuned treasury reconciliation engine auto-matches 95%+ of transaction volume, leaving a manageable exception queue. A match rate below roughly 80% usually signals a reference-data problem — inconsistent remittance references or misconfigured BAI transaction-type codes — rather than genuine breaks.

Aging Discipline

Unreconciled items must be aged and escalated, not merely listed:

Suspense and unapplied cash accounts are a related trap. They are legitimate temporary parking for unidentified receipts, but a suspense account with a growing balance or aged items is an audit finding — and a favored hiding place for misappropriation.

---

5. Reconciliation as a Fraud Control — and Why Speed Is Money

Reconciliation is the detective control that backstops the preventive controls in Chapter 12. Its value is time-sensitive because the legal windows to recover funds are short:

• Unauthorized ACH debits on a corporate (non-consumer) account: under the Nacha Rules, the receiving company generally must notify its bank by the opening of business on the second banking day after settlement to return the entry.
• Forged or altered checks: UCC Articles 3 and 4 impose a duty on the customer to examine statements and report unauthorized items promptly; deposit agreements commonly compress this to a stated window, and failure to report can shift the loss to the company.

The operational conclusion the exam tests: daily reconciliation is not accounting hygiene, it is loss prevention. A company reconciling monthly cannot meet a next-business-day ACH return deadline, so it absorbs losses a daily reconciler would have returned at par.

Segregation of Duties

The reconciler must be independent of both payment initiation and payment approval. The person who releases wires must never be the person who confirms that wires settled correctly — that combination allows a fraudulent payment to be concealed by the same individual who created it.

Key Metrics