How to Build a Daily Cash Position

A daily cash position is a consolidated view of the cash you actually have available today — across every bank account, currency and entity, as of this morning. You build it from the opening balances on today's bank statements plus the day's known movements. It answers the treasurer's very first question — how much cash do we have, where is it, and what will it do today? — and it's the anchor for every funding, investing and borrowing decision that follows. Get the position wrong and everything downstream, including the forecast, is built on sand.

What a daily cash position is

The position is a point-in-time snapshot of actual cash, not a projection. It tells you, per account and rolled up to the group: what's the balance, what's already committed to move today, and what's therefore available to use. It's distinct from the cash flow forecast, which is about the future — the position is the solid ground the forecast stands on.

What goes into it

Two ingredients:

• Opening balances — the closing balance from yesterday's bank statement for every account, which is this morning's starting point.
• Today's known movements — everything you already know will hit today: expected large receipts, scheduled outgoing payments, maturing deposits, loan drawdowns or repayments, and intercompany transfers.

Opening balance plus known movements gives you the expected closing and, more usefully, the available cash right now.

Prior-day vs intraday

Most positions start from prior-day statements (yesterday's closing balances, delivered overnight as MT940 or camt.053). That's enough to start the day. But cash moves during the day, and a prior-day-only view goes stale by mid-morning. Intraday statements (camt.052) update the picture through the day as credits and debits actually land — essential if you're managing tight balances, sweeping, or funding same-day payments.

Actuals vs expected

A good position separates two things clearly:

• Actuals — balances and transactions confirmed by the bank statement. Facts.
• Expected — movements you know are coming but the bank hasn't confirmed yet. Assumptions.

Keeping them visibly distinct is what lets a treasurer trust the number. Blending an unconfirmed €5m receipt into the "actual" balance is how a position lies to you — and how a same-day investment gets made against cash that didn't arrive.

How to build one

The mechanics, in order:

1. Collect today's statements from every bank account — this is the step that makes or breaks it.
2. Normalize balances into your reporting currency (at a consistent rate), keeping the original currency too.
3. Layer on the day's known movements, tagged as expected vs actual.
4. Consolidate by account → entity → currency → group.
5. Present the available position, with drill-down, before the day's decisions get made.

By currency, entity and bank

A single group number hides what treasurers need. The position should slice by currency (you can't net USD against a trapped local currency), by entity (legal and tax reality constrains what's usable), and by bank (concentration and counterparty limits). Cash that exists but is trapped or not truly available shouldn't be counted as usable — showing only the group total invites exactly that mistake.

What usually goes wrong

• Missing accounts. One bank's feed isn't set up, so an account is silently excluded and the position understates cash. Completeness is everything.
• Stale statements. Running the whole day on prior-day balances when intraday movement matters.
• The eternal spreadsheet. A manual workbook rebuilt by hand each morning — slow, fragile, and wrong the moment someone's on holiday. If you must build it in a workbook, the right formula patterns at least make it less brittle. (This is the pain Delivery Sheet-style clarity and a real feed exist to remove.)
• Blending expected into actual. Treating unconfirmed flows as confirmed cash.
• No cutoff discipline. No agreed "as of" time, so different people quote different positions.

Build the position from a complete, timely statement feed, keep actuals and expected honest, slice it by currency and entity, and you give treasury the one number every other decision depends on. The next step up is making that view complete across the entire group — that's global cash visibility.

Part of the Cash & Liquidity Management guide. See also cash positioning vs forecasting and global cash visibility. The newsletter sends one finance-systems pattern, product decision or build lesson every two weeks.