What it means
A balance report separates several different numbers that people loosely call "the balance". The ledger or book balance is everything posted, the available balance strips out uncollected deposits and holds, and the collected balance counts only funds the bank has genuinely received.
Treasury decisions are made on the available figure, never on the ledger figure. Reports arrive in two rhythms.
Previous-day reporting lands early each morning and covers the closed position for the day before, while intraday reporting updates through the day as large receipts and payments settle. Any company running tight liquidity or same-day sweeps needs the intraday feed rather than the morning one alone.
Delivery happens through bank portals, standardised files such as BAI2 and MT940, or an API feeding the treasury system directly. Standard formats matter because a group with accounts at six banks in four countries cannot sensibly log into six portals every morning.
Pulling those feeds into one consolidated position is the core job of a treasury workstation. Good balance reporting supports concentration and sweeping, where balances above a target level move automatically into a central account or an overnight deposit.
It also underpins daily bank reconciliation, fraud detection through unexpected debits, and short-term cash forecasting that can be trusted. Poor reporting shows up as idle cash sitting in one account while another runs into overdraft interest.
In practice
Real-world examples.
Example
A retail group with 14 store accounts receives a consolidated previous-day report at 6am each morning, sweeps every store balance above $10,000 into a central account, and funds the payment run from one place instead of fourteen.
Example
A manufacturer relies on previous-day reporting only and misses a $600,000 customer receipt that landed at 11am. It draws on its overdraft that afternoon and pays a day of unnecessary interest that an intraday feed would have avoided entirely.
Example
A finance team spots a $48,000 debit in the morning report that matches no approved payment. Because the report arrived before the cut-off for recall, the bank stops the second transfer in the same fraudulent sequence.
Formula
Calculation
Available balance = ledger balance - uncollected deposits (float) - holds
A company's main operating account shows the following at the start of the day.
Ledger balance: $1,450,000
Cheques deposited but not yet cleared: $220,000
Holds placed by the bank on disputed items: $35,000
Available balance = $1,450,000 - $220,000 - $35,000 = $1,195,000
Treasury keeps a target operating buffer of $250,000 in the account and sweeps the rest into an overnight deposit.
Amount swept = $1,195,000 - $250,000 = $945,000
At an overnight rate of 4.5%, one night on that balance earns $945,000 x 0.045 / 365 = $116.51, and if a similar balance were sustained across a full year the interest would be $945,000 x 0.045 = $42,525. That annual figure is what justifies the cost of automated reporting and sweeping.Case study
Seen in the real world.
Cobalt Lane Retail is a fictional chain used here to illustrate what balance reporting changes. Before the project, each of its 14 store managers checked a bank portal manually and emailed a figure to head office, which meant the group position was known by lunchtime and was rarely accurate.
The company moved to an automated previous-day file from its bank feeding a simple treasury sheet, plus an intraday feed on the two accounts that handled large supplier payments. The group position was now available by 6.30am, and balances above each store's $10,000 buffer were swept nightly into a concentration account.
In this illustrative example the swept balance averaged around $945,000, which at 4.5% earned roughly $42,525 a year in overnight interest, and the group also stopped paying overdraft interest on two accounts that had been technically overdrawn while others sat idle. The reporting change cost a fraction of that in bank fees.
Watch out
Common mistakes.
- Treating the ledger balance as spendable cash. Uncollected deposits and holds mean the available balance is the only figure worth acting on.
- Relying on previous-day reporting when the business has large same-day flows. The position is already several hours out of date by the time anyone reads it.
- Assuming the bank portal is enough for a multi-bank group. Manually collecting figures from several portals introduces exactly the delays and errors that automated reporting removes.
Questions
People also ask.
What is the difference between balance reporting and bank reconciliation?
Balance reporting tells you what the bank says happened, while reconciliation compares that record with your own ledger and explains the differences.
What formats do banks use?
Common standards include BAI2 and MT940 for files, with a growing share of groups taking the same data through a bank API instead.
How often should a treasury team review balances?
Daily as a minimum for previous-day positions, and intraday wherever same-day receipts or payments can move the position materially.
From the founder's library
Take it further with the book.
Build your financial confidence beyond this definition. Shihan's full-length guide, Accounting Fundamentals, takes the same plain-English approach and turns it into a complete, practical playbook for non-finance managers, business owners and students - with chapter-end quiz answers and presentation slides included.
25% off with code MMHQ25, applied at checkout. Priced in USD - checkout may show the equivalent in your local currency.
View the book and save 25%Related