Banking5 min read1 view

Balance Reporting

Balance reporting is the service banks provide that tells a company how much money sits in each of its accounts and what has moved through them, delivered automatically each morning and often updated during the day. It is the raw material of cash management: without it, treasury is guessing.

Modern versions push the data straight into a company's treasury or accounting system rather than onto a screen.

From the Money Master HQ dictionary, founded by Shihan Sheriff (FCMA, CGMA, CPA (Australia), MBA (General), MBA (Data Science & AI), UAECA, CAAB, CAIS; VP of Finance at Nomod, CFO at Esanjo Ventures). How these definitions are written.

Last updated 8 Oct 2026

On this page

This term

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 1

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 2

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 3

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

Available balance = ledger balance - uncollected deposits (float) - holds

Note

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

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.

Was this helpful?
Report an error
Disclaimer. The information provided in this finance dictionary is for educational and informational purposes only. It should not be construed as financial, investment, legal, or tax advice. Always consult with a qualified professional before making any financial decisions. Money Master HQ makes no representations or warranties about the accuracy, completeness, or suitability of this information. Use of this content is at your own risk.

Browse all terms