Bank Balance Reporting and Reconciliation

Why Bank Balance Reporting and Reconciliation Matters

Every decision a treasury professional makes about investing surplus cash, drawing on a credit line, or releasing a payment starts with one deceptively simple question: how much cash do we actually have right now? Bank balance reporting answers that question, and reconciliation confirms the answer is correct. Together they form the information backbone of corporate liquidity management.

For the AFP Certified Treasury Professional (CTP) exam, this topic sits inside the Corporate Liquidity Management domain and is tested heavily because it connects directly to cash positioning, cash forecasting, fraud control, bank relationship management, and accounting controls. If you misread a bank report, you may invest money you do not have (causing an overdraft) or leave idle balances uninvested (losing yield). If you fail to reconcile, fraud and errors go undetected and financial statements become unreliable. Examiners expect you to know the vocabulary, the mechanics, and the judgment calls.

What Bank Balance Reporting Is

Bank balance reporting is the process by which banks transmit account balance and transaction information to corporate customers so treasury can determine the daily cash position. Reports are delivered through bank portals, treasury management systems (TMS), ERP integrations, SWIFT, or host-to-host connections.

The Three Balances You Must Know

1. Ledger balance – The balance on the bank's books. It includes all deposits credited, including checks that have not yet cleared (uncollected funds). It is the starting point but is not the amount you can spend.

2. Collected balance – Ledger balance minus deposit float (items deposited but not yet collected from the paying bank). This represents funds the bank has actually received. Banks typically calculate earnings credit or interest on collected balances.

3. Available balance – The portion of the balance the company may actually withdraw, invest, or transfer today. It is the collected balance adjusted for holds, availability schedules, and any items the bank has not yet made available. In practice, the available balance is the number treasury uses to build the cash position.

Memory aid: Ledger is what the bank recorded, Collected is what the bank received, Available is what you can use.

Float Assignment

Deposit float is often shown as 0-day (immediate), 1-day, and 2-day (or more) availability. A check deposited today may have ledger credit today but become collected and available over the next one to two business days according to the bank's availability schedule. Exam questions frequently require you to compute collected or available balances from ledger balances and float detail.

Types of Balance Reports

Prior-day (previous-day) reports – Delivered early in the morning, they show the closing ledger and collected balances for the prior business day, detailed debits and credits (checks paid, ACH, wires, lockbox deposits, fees), and float breakdown. They form the opening position for today.

Intraday (current-day) reports – Updated periodically or in real time, they show today's activity as it posts: incoming wires, ACH credits and debits, controlled disbursement presentment totals, lockbox receipts, and returned items. They allow treasury to refine the position before the daily investment, borrowing, and funding deadlines.

Controlled disbursement notification – A special intraday report telling the company the total dollar amount of checks presented against the controlled disbursement account, usually by mid-morning, so the account can be funded exactly.

Reporting Formats and Standards

• BAI2 – The Bank Administration Institute format, dominant in the United States for prior-day and intraday reporting. Uses numeric type codes (for example, 010 series for opening ledger, 040 for opening available, summary and detail codes for transactions).
• SWIFT MT940 – End-of-day customer statement message; MT941 balance report; MT942 interim (intraday) transaction report. Widely used for international accounts.
• ISO 20022 XML – camt.052 (intraday account report), camt.053 (end-of-day statement), camt.054 (debit/credit notification). This is the global standard that is replacing MT messages and offers richer remittance data.
• Proprietary bank portals and APIs – Increasingly, banks offer real-time balance APIs that feed directly into a TMS.

The exam tests whether you can match the format to its use: BAI2 for U.S. prior-day/intraday, MT940/camt.053 for end-of-day, MT942/camt.052 for intraday.

Multibank Reporting and Aggregation

Large companies hold accounts at many banks. Rather than logging into each portal, treasury uses a multibank reporting service, a TMS, or SWIFT connectivity (SWIFT for Corporates / SCORE) to aggregate balances into a single consolidated view. Aggregation supports global cash visibility, which is a precondition for pooling, netting, and centralized investing.

How Balance Reporting Drives the Daily Cash Position

The daily cash position worksheet typically follows this logic:

Opening available balance (from prior-day report)
+ Expected receipts (lockbox, ACH credits, incoming wires confirmed intraday)
– Expected disbursements (controlled disbursement presentments, ACH debits, outgoing wires, payroll)
= Projected closing available balance

Treasury compares the projected closing balance to the target balance (the minimum the company wishes to hold at that bank, often set to cover service charges via earnings credit or to meet compensating balance requirements). If the projection exceeds the target, surplus is invested or used to pay down debt; if it falls short, funds are transferred in, borrowed, or investments liquidated. Accuracy of the balance report determines the quality of this decision.

What Bank Reconciliation Is

Bank reconciliation is the control process of comparing the company's general ledger cash account (book balance) with the bank's records (bank balance) and explaining every difference. The goal is to arrive at a single adjusted (true) cash balance that both sides agree to, and to identify errors, unrecorded items, and potential fraud.

Classic Reconciliation Mechanics

Adjustments to the bank balance (items the company knows about but the bank has not yet processed):
• Add deposits in transit
• Subtract outstanding checks
• Add or subtract bank errors

Adjustments to the book balance (items the bank processed but the company has not yet recorded):
• Subtract bank service charges and fees
• Add interest earned
• Subtract NSF (returned) checks
• Add or subtract electronic transactions not yet booked (ACH debits, wire fees, automatic loan payments)
• Add or subtract book errors (for example, a check recorded as 450 that was written for 540)

When both sides are properly adjusted, adjusted bank balance = adjusted book balance. Only the book-side adjustments require journal entries in the general ledger.

Bank-Provided Account Reconciliation Services

Banks offer automated Account Reconciliation Programs (ARP) that dramatically reduce manual effort:

• Full reconciliation – The company transmits a check issue file (check number, date, payee, amount). The bank matches paid items against the file and returns a reconciled report listing paid checks, outstanding checks, stop payments, and exceptions. This is the most comprehensive service and integrates naturally with positive pay.
• Partial reconciliation – The bank provides a file of paid checks only (number, amount, paid date); the company performs the match against its own issue records.
• Deposit reconciliation – For companies with many locations depositing to one concentration account, the bank assigns location codes (often encoded on deposit slips) and reports deposits by location, allowing verification that every store or branch deposited as expected.
• Positive pay / payee positive pay / reverse positive pay – Fraud controls closely tied to reconciliation. Positive pay matches presented checks to the issue file before payment; payee positive pay also verifies payee name; reverse positive pay sends the company the paid list and requires the company to approve or reject. ACH positive pay, ACH blocks, and ACH filters apply similar controls to electronic debits.

Reconciliation Frequency and Controls

Best practice is daily reconciliation of high-volume accounts and at minimum monthly reconciliation of all accounts, with timely investigation of unmatched items. Key internal controls include segregation of duties (the person reconciling should not initiate payments or have access to cash), supervisory review and sign-off, documented aging of reconciling items, and automated matching within a TMS or ERP to reduce human error. Unreconciled or long-outstanding items are red flags for fraud, kiting, or process failure.

Common Reconciling Issues in Treasury Operations

• Timing differences at month-end and across time zones for foreign accounts
• Unapplied cash from lockbox or ACH receipts lacking remittance detail
• Returned items (NSF checks, ACH returns) posting after the original credit
• Bank fees deducted from the account versus invoiced separately in the account analysis statement
• Foreign exchange differences on multicurrency accounts
• Duplicate or missing transactions caused by interface failures between bank files and the TMS

Link to the Account Analysis Statement

The monthly account analysis statement (standardized in the U.S. via the AFP Service Codes and reported in 822 or camt.086 formats) shows average ledger balances, average collected balances, reserve requirements, earnings credit rate, service volumes, and fees. Reconciling this statement against balance reports and the bank's fee schedule is a separate but related control that ensures the company is not overcharged and that balances are being credited correctly.

Exam Tips: Answering Questions on Bank Balance Reporting and Reconciliation

1. Master the balance hierarchy. If a question asks which balance to use for investment decisions or building the daily cash position, the answer is available balance. If it asks what the bank uses to compute earnings credit, the answer is usually collected balance. Ledger balance is almost never the correct basis for a spending decision.

2. Practice float calculations. Expect a question like: Ledger balance 1,000,000; deposits with 1-day float 200,000; 2-day float 50,000. Collected balance equals 750,000. Read carefully whether the question wants collected or available and whether any holds apply.

3. Know which side each reconciling item adjusts. Deposits in transit and outstanding checks always adjust the bank balance. Fees, interest, NSF checks, and unrecorded electronic items always adjust the book balance. A quick test: if the bank already knows about it, adjust the books; if only the company knows about it, adjust the bank.

4. Remember that only book-side adjustments require journal entries. A question asking which items need a general ledger entry is testing this distinction.

5. Match the report to its timing. Prior-day reports establish the opening position; intraday reports refine it; controlled disbursement notification tells you how much to fund. If a scenario describes a need to know wires received in the last hour, the answer involves intraday reporting, not prior-day.

6. Distinguish full, partial, and deposit reconciliation. Full means the company sends an issue file and the bank does the matching. Partial means the bank sends paid data and the company matches. Deposit reconciliation involves location codes and multiple depositing sites. If the question mentions an issue file transmitted to the bank, think full reconciliation or positive pay.

7. Associate formats correctly. BAI2 is U.S. balance reporting; MT940 and camt.053 are end-of-day statements; MT942 and camt.052 are intraday; camt.054 is a debit/credit advice; account analysis uses the 822 or camt.086. Do not confuse balance reporting formats with payment formats such as MT101 or pain.001.

8. When asked for the best control, favor automation plus segregation of duties. CTP answers that are best practice typically involve timely (daily) reconciliation, automated matching, positive pay, and independent review. Answers that rely on a single person doing everything or on monthly manual review are usually distractors.

9. Watch for fraud cues. Scenarios mentioning altered payees point to payee positive pay; unauthorized ACH debits point to ACH blocks or filters; stale outstanding items or unexplained adjustments point to a need for investigation and stronger reconciliation controls.

10. Read the question stem for the decision being made. Many questions wrap a reconciliation or reporting fact inside a cash positioning problem. Identify what number the treasurer actually needs (available balance, projected closing position, amount to fund), then work backward to which report and which balance supplies it.

11. Eliminate answers that confuse accounting with liquidity. The book balance in the general ledger is an accounting figure; it is not what you invest. Questions that pit book balance against available balance for a same-day investment decision are testing exactly this.

12. Manage your time on calculation questions. Set up a two-column reconciliation quickly, list items under the correct column, and check that adjusted totals agree. If they do not, you have most likely placed an item on the wrong side.

Summary

Bank balance reporting tells treasury how much cash exists and when it is usable; reconciliation proves those numbers are right and protects against error and fraud. For the CTP exam, be fluent in ledger, collected, and available balances; prior-day versus intraday reporting; BAI2, SWIFT MT, and ISO 20022 camt formats; the mechanics of adjusting bank and book balances; and the bank-provided reconciliation and positive pay services that make the process efficient and secure. Anchor every answer in the practical question of what the treasurer needs to know to make a sound, timely liquidity decision.