Excel workbook previewDaily Cash Position Report Template
3 free downloads per account. Just your email and a 6-digit code.
About this template
A daily cash position report tells the finance team, before the morning payment run, how much cash sits in each bank account, what is expected in and out today and where the group will close. It is how treasury decides whether to sweep surplus into the concentration account, fund an account that is short, place money on deposit or hold back a payment. Lenders and new CFOs often ask to see it.
This workbook lists ten accounts of an invented group across three currencies with prior-day balances, same-day receipts and payments, a projected close and a minimum for each account. A rates sheet converts every balance to USD, restricted cash is kept apart, an expected items sheet tracks the large flows and a summary adds the undrawn revolver to show total liquidity. It follows general treasury practice.
Who it is for
The treasury analyst or controller who must tell the CFO every morning how much cash the group has and where it sits.
What is inside
- Position sheet with 10 worked accounts in USD, GBP and EUR and 16 blank formatted rows
- Projected closing balance, surplus or shortfall against each account's minimum, and a Red, Amber, Green or Restricted status
- USD equivalents from a rates table that you update each morning
- Restricted cash flag so restricted balances stay out of available liquidity
- Expected Items sheet with 10 worked large receipts and payments, status and a threshold flag
- Summary sheet with totals by currency and entity, available cash, undrawn revolver and total liquidity
- Action dropdown for each account: hold, sweep, fund, invest or escalate
- How to use sheet, freeze panes, filters and print fit
How to use it
Enter today's report date and exchange rates on the Summary and Rates sheets, then paste each account's prior-day closing balance into the Position sheet.
Files
- XLSXdaily-cash-position-report-template.xlsx18 KB
Opens in Microsoft Word or Excel, Google Docs or Sheets, and LibreOffice. Based on general finance practice, not on one published standard. A template to adapt, not legal, tax or accounting advice.
Questions about this template
What is the difference between a cash position and a cash forecast?
The cash position is today: what each bank account holds and what will settle before the cut-off. The forecast looks forward for weeks or months. Treasury teams use the daily position to move money today and roll its actuals into the 13-week forecast each week.
Why set a minimum balance for each account?
Some accounts need a floor to cover card settlements, direct debits or bank fees, and some must stay at zero. A per-account minimum lets the sheet show which accounts are short and which have surplus that can be swept or invested.
Should restricted cash be in the report?
Yes, but kept apart. Cash held as collateral, in escrow or for a specific purpose belongs on the report so balances reconcile to the bank, but it is not available to pay suppliers. The template flags it and leaves it out of available cash and total liquidity.




