Study guide
2.5 Cash Balance Review, Bank Reconciliation & Transaction Verification
Certified Treasury Professional CTP
Track your progress as you read
Finished sections get a check mark.
1 Chapter 1: Introduction & Corporate Treasury Fundamentals
1.1 CTP Credential, Exam Format & Testing Strategy 1.2 The Role of Corporate Treasury, Organization & Governance 1.3 Financial Statement Analysis, Working Capital & Cash Conversion Cycle
2 Chapter 2: Cash Positioning & Cash Flow Forecasting
2.1 Daily Cash Positioning & Short-Term Liquidity Balancing 2.2 Short-Term Cash Flow Forecasting Methodologies (Direct vs Indirect) 2.3 Medium- and Long-Term Forecasting & Scenario Modeling 2.4 Forecast Variance Analysis, Distribution Tracking & Error Metrics 2.5 Cash Balance Review, Bank Reconciliation & Transaction Verification
3 Chapter 3: Short-Term Investing & Borrowing
3.1 Short-Term Money Market Instruments & Investment Policy Guidelines 3.2 Money Market Yield Calculations, Compounding & Valuation 3.3 Short-Term Borrowing Facilities: Commercial Paper, Credit Lines & Factoring 3.4 Borrowing Cost Calculations, Commitment Fees & Debt Covenants 3.5 Investment Portfolio Construction, Laddering & Duration Management
4 Chapter 4: Cash Concentration & Global Banking Structures
4.1 Cash Concentration Systems, ZBAs & Target Balancing 4.2 Notional Pooling, Physical Sweeping & Cross-Border Liquidity 4.3 Multi-Bank Architecture & Global Account Hierarchy Design 4.4 Intercompany Loans, In-House Banking & Multilateral Netting
5 Chapter 5: Payment Systems, Collections & Disbursements
5.1 Payment Clearing Rails: Fedwire, CHIPS, ACH & Real-Time Payments 5.2 Collections Optimization: Lockbox Systems, Remote Deposit & Merchant Processing 5.3 Disbursement Management: Controlled Disbursement, Positive Pay & Virtual Cards 5.4 Cross-Border Settlement, SWIFT Messaging & ISO 20022 XML Standards
6 Chapter 6: Trade Finance & Financial Supply Chain
6.1 Letters of Credit (Commercial vs Standby) & Bank Guarantees 6.2 Documentary Collections, Open Account & Incoterms 2020 Rules 6.3 Supply Chain Financing, Reverse Factoring & Dynamic Discounting
7 Chapter 7: Capital Structure, Cost of Capital & Valuation
7.1 Capital Structure Theory, Modigliani-Miller & Optimal Leverage 7.2 Weighted Average Cost of Capital (WACC), CAPM & Hurdle Rates 7.3 Long-Term Capital Budgeting: NPV, IRR, Payback & Profitability Index 7.4 Dividend Policies, Share Repurchases & Capital Allocation Strategy
8 Chapter 8: Long-Term Debt & Equity Financing
8.1 Long-Term Debt: Corporate Bonds, Debentures, Private Placements & Covenants 8.2 Syndicated Loan Facilities: Term Loans, Revolvers & Arranger Roles 8.3 Bond Valuation, Duration, Convexity, Yield Curves & Rating Agencies 8.4 Equity Financing, IPOs, Follow-On Offerings & M&A Treasury Due Diligence
9 Chapter 9: Treasury Relationship Management & Banking Administration
9.1 Financial Service Provider Selection, RFPs & Scorecards 9.2 Bank Account Analysis Statements, Earnings Credit Rates (ECR) & Pricing 9.3 Bank Account Administration, FBAR Compliance & Delegations of Authority 9.4 Treasury as Internal Trusted Advisor, Consultant & Project Finance Partner 9.5 Internal Stakeholder Partnership: Accounting, FP&A, Tax, Legal, Audit, IT & Investor Relations
10 Chapter 10: Enterprise Financial Risk Management & Controls
10.1 Treasury Policy Manuals, Internal Controls & Segregation of Duties 10.2 Counterparty Credit Risk Assessment, Scoring & Exposure Limits 10.3 Regulatory Frameworks: SOX 404, Dodd-Frank, Basel III & AML/KYC 10.4 Business Continuity Planning (BCP), Disaster Recovery & Treasury Resilience
11 Chapter 11: Market Risk & Derivatives Hedging
11.1 FX Risk Types: Transaction, Translation & Economic Exposure 11.2 FX Hedging: Spot, Forwards, Futures, Options & Non-Deliverable Forwards 11.3 Interest Rate Risk: Swaps, Caps, Floors, Collars & SOFR Transition 11.4 Commodity Price Hedging & Hedge Accounting (ASC 815 / IFRS 9)
12 Chapter 12: Fraud Prevention, Information Security & Compliance
12.1 Treasury Fraud Vectors: Check Fraud, Business Email Compromise & ACH Tampering 12.2 Defense-in-Depth: Positive Pay, Dual Approvals, Out-of-Band Callbacks & Tokens 12.3 Merchant Services Security, PCI DSS Standards & Identity Access Governance
13 Chapter 13: Treasury Management Systems & Emerging Technologies
13.1 Treasury Management Systems (TMS) Architecture & Core Modules 13.2 ERP Integration, Application Programming Interfaces (APIs) & H2H Connectivity 13.3 Bank Connectivity: SWIFT gpi, ISO 20022 XML Messaging & EBICS 13.4 Artificial Intelligence, Robotic Process Automation & Future Treasury Trends 13.5 Implementing Treasury Products & Services: Bank Onboarding, TMS Deployment & Cutover
2.5 Cash Balance Review, Bank Reconciliation & Transaction Verification
Key Takeaways Explain This Topic AI
Reconciliation uses the prior-day statement (camt.053, MT940 or BAI2) and the ledger balance; intraday reports such as camt.052 and MT942 are provisional positioning tools and are never a reconciliation source of record.
Deposits in transit and outstanding checks adjust the bank side of a reconciliation, while service charges, interest credits, NSF returns and company keying errors adjust the book side — only book-side items generate journal entries.
A three-way reconciliation ties the bank statement, the treasury system and the general ledger, which isolates whether a break was a payment failure, an interface break, or an accounting error.
Unauthorized corporate ACH debits generally must be returned by the opening of business on the second banking day after settlement under the Nacha Rules, so a company that reconciles monthly structurally forfeits recoveries a daily reconciler captures.
A well-tuned reconciliation engine auto-matches 95% or more of transaction volume; a match rate below roughly 80% usually signals reference-data or BAI transaction-code mapping problems rather than genuine breaks.
Last updated: August 2026
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:
Report Type Legacy SWIFT ISO 20022 BAI What It Delivers
Prior-day statement MT940 camt.053 BAI2 Final, posted, end-of-day balances and every transaction for the closed business day. This is the reconciliation source of record.
Intraday report MT942 camt.052 BAI2 (intraday) Transactions posted so far today. Used for positioning , not for reconciliation — it is provisional.
Debit/credit advice MT900 / MT910 camt.054 — Single-item notification of a specific debit or credit.
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.
Reconciling Item Adjusts Direction Why
Deposits in transit Bank + The company recorded it; the bank has not posted it yet.
Outstanding checks Bank − The company recorded the disbursement; the check has not cleared.
Bank errors (mispost, wrong amount) Bank ± The bank must correct its own record.
Bank service charges / analysis fees Book − The company learns of them only from the statement.
Interest or earnings credit earned Book + Bank-originated credit not yet on the books.
NSF / returned deposited items Book − A recorded receipt that reversed.
Company recording errors Book ± The company must correct its own record.
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:
- Input Amount
- General ledger (book) cash balance $2,450,000
- Bank statement closing ledger balance $2,812,500
- Deposits in transit $410,000
- Outstanding checks $735,000
- Account analysis service charges not yet booked $3,200
- Interest credited by the bank, not yet booked $9,700
- NSF customer check returned $18,000
- Keying error: a $52,000 incoming customer wire was posted to the ledger as $3,000 understated by $49,000
Step 1 — Adjust the bank side: Adjusted Bank = $ 2,812,500 + $ 410,000 − $ 735,000 = $ 2,487,500 \text{Adjusted Bank} = \$2{,}812{,}500 + \$410{,}000 - \$735{,}000 = \mathbf{\$2{,}487{,}500} Adjusted Bank = $2 , 812 , 500 + $410 , 000 − $735 , 000 = $2 , 487 , 500
Step 2 — Adjust the book side: Adjusted Book = $ 2,450,000 − $ 3,200 + $ 9,700 − $ 18,000 + $ 49,000 = $ 2,487,500 \text{Adjusted Book} = \$2{,}450{,}000 - \$3{,}200 + \$9{,}700 - \$18{,}000 + \$49{,}000 = \mathbf{\$2{,}487{,}500} Adjusted Book = $2 , 450 , 000 − $3 , 200 + $9 , 700 − $18 , 000 + $49 , 000 = $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:
Exact match — amount, value date, and bank reference all agree. Auto-cleared.
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.
One-to-many / many-to-one — a single bank credit against multiple open receivables, or a batch debit against many payment records.
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:
- Age of Break Required Action
- 0–2 business days Analyst investigation in the normal queue
- 3–10 business days Escalation to the treasury manager; written explanation required
- 11–30 business days Escalation to the Treasurer/Controller; assessed for write-off or claim
- > 30 business days Reported to the audit committee; presumptively a control failure
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
- Metric Definition Healthy Target
- Auto-match rate Transactions cleared without human touch ÷ total transactions ≥ 95%
- Time to reconcile Business days from statement receipt to signed reconciliation ≤ 1 day
- Aged break ratio Value of breaks > 10 days ÷ total account value < 0.1%
- Unapplied cash aging Value of receipts in suspense > 30 days Trending to zero