Weekly Cash-Flow Report Template for SME Owners
A weekly cash-flow report should tell an SME owner how low cash will go, when it will happen, why the forecast changed, and which decision needs to be made next.
An SME owner does not need another finance pack.
They need four answers:
- How much usable cash do we have now?
- What is the lowest projected balance over the next 13 weeks?
- What changed since last week's forecast?
- Which action cannot wait?
The template below is designed around those questions.
It is not a replacement for the cash-flow statement, management accounts, or detailed forecast model. It is the one-page management layer that turns those records into a weekly operating conversation.
You can build it in a spreadsheet, accounting platform, reporting tool, or automated dashboard. The format matters less than using consistent definitions and assigning owners to every exception.
The one-page weekly cash-flow report
Copy this structure into your preferred reporting tool.
Report details
| Field | Value |
|---|---|
| Entity or group | [business_name] |
| Reporting date | [date] |
| Forecast horizon | 13 weeks ending [date] |
| Prepared by | [name] |
| Reviewed by | [name] |
| Data refreshed | [timestamp] |
| Report status | Draft / Reviewed |
Cash headline
| Measure | This week | Last week | Change |
|---|---|---|---|
| Available cash now | SGD [amount] |
SGD [amount] |
SGD [amount] |
| Forecast closing cash, week 4 | SGD [amount] |
SGD [amount] |
SGD [amount] |
| Forecast closing cash, week 13 | SGD [amount] |
SGD [amount] |
SGD [amount] |
| Lowest forecast balance | SGD [amount] |
SGD [amount] |
SGD [amount] |
| Date of lowest balance | [date] |
[date] |
[days] |
| Headroom above minimum | SGD [amount] |
SGD [amount] |
SGD [amount] |
Owner summary
Cash position:
[One sentence describing current liquidity and the lowest expected balance.]Main change:
[The largest reason the forecast moved since last week.]Main risk:
[The receipt, payment, or assumption most likely to create a shortfall.]Decision required:
[Specific decision, owner, and deadline.]
That summary should contain facts and named actions, not “cash flow remains challenging.”
The 13-week cash movement table
Use one column per week.
| SGD | W1 | W2 | W3 | W4 | W5 | W6 | W7 | W8 | W9 | W10 | W11 | W12 | W13 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Opening cash | |||||||||||||
| Cash in | |||||||||||||
| Customer receipts | |||||||||||||
| Other operating receipts | |||||||||||||
| Financing receipts | |||||||||||||
| Asset or one-off receipts | |||||||||||||
| Total cash in | |||||||||||||
| Cash out | |||||||||||||
| Suppliers | |||||||||||||
| Payroll and CPF | |||||||||||||
| GST and other tax | |||||||||||||
| Rent and occupancy | |||||||||||||
| Operating expenses | |||||||||||||
| Loan principal and interest | |||||||||||||
| Capital expenditure | |||||||||||||
| Owner or intercompany payments | |||||||||||||
| Total cash out | |||||||||||||
| Net cash movement | |||||||||||||
| Closing cash | |||||||||||||
| Minimum cash threshold | |||||||||||||
| Headroom / shortfall |
The table uses the direct method: expected cash receipts and payments are placed in the weeks when cash is likely to move.
Do not use profit as a substitute for cash. Revenue may remain unpaid, depreciation does not use current cash, and loan principal does not appear as an operating expense.
How to define available cash
Start with cash that can actually be used.
Include:
- Operating bank balances
- Payment-provider funds available for settlement
- Accessible cash accounts
- Undrawn facility only if shown separately and genuinely available
Identify separately:
- Restricted cash
- Client money
- Security deposits
- Fixed deposits not available on demand
- Accounts held for a specific purpose
- Unreconciled balances
- Transfers in progress
The headline should not combine SGD 300,000 of operating cash with SGD 200,000 of restricted money and call the business liquid.
Document the definition beneath the report:
Available cash includes
[accounts]and excludes[restricted balances]. Bank data was last refreshed at[time]; unreconciled difference is SGD[amount].
How to forecast customer receipts
Open invoices should not automatically land on their due dates.
Use this hierarchy:
- Confirmed payment date
- Reliable customer-specific payment pattern
- Contractual due date for current invoices
- Reviewed estimate for overdue invoices
- Exclude or heavily discount disputed and doubtful balances
For the largest receipts, show the detail:
| Customer | Invoice(s) | Amount | Forecast date | Basis | Confidence | Owner |
|---|---|---|---|---|---|---|
[name] |
[references] |
SGD [amount] |
[date] |
Promise / pattern / due date | High / medium / low | [name] |
“Overdue” is not a forecast date.
If a customer says payment will arrive Friday, record the commitment and source. If Friday passes, update the forecast and create an action rather than quietly moving the receipt one week right.
How to forecast payments
Start with approved bills and committed obligations.
Include:
- Supplier payments
- Payroll and CPF
- GST and other taxes
- Rent
- Loan payments
- Insurance
- Recurring subscriptions
- Approved capital expenditure
- Contracted professional fees
- Intercompany or owner payments
For each material payment, ask:
- Is the amount final?
- Is the date fixed?
- Is it approved?
- Can timing be changed?
- What happens if it is delayed?
Separate fixed obligations from discretionary cash out.
| Payment | Amount | Date | Fixed? | Approved? | Owner |
|---|---|---|---|---|---|
| Payroll | SGD [amount] |
[date] |
Yes | Yes | [name] |
| Equipment deposit | SGD [amount] |
[date] |
No | Pending | [name] |
This gives the owner choices when the downside case appears.
The forecast-change bridge
Every weekly report should explain why the forecast changed.
Week-13 closing cash bridge
| Movement since last report | Impact |
|---|---|
| Prior week-13 closing cash | SGD [amount] |
| Customer receipts moved earlier | + SGD [amount] |
| Customer receipts delayed | − SGD [amount] |
| New sales receipts added | + SGD [amount] |
| Supplier payments added | − SGD [amount] |
| Payroll or tax change | ± SGD [amount] |
| Capital expenditure change | ± SGD [amount] |
| Actual-versus-forecast variance | ± SGD [amount] |
| Other | ± SGD [amount] |
| Current week-13 closing cash | SGD [amount] |
This bridge separates business changes from forecast errors.
If the forecast fell by SGD 90,000, the owner should see whether one customer delayed payment, a purchase was approved, or last week's estimate was wrong.
Risks and exceptions
List only matters that could change a decision.
| Risk or exception | Cash impact | Timing | Likelihood | Owner | Next action | Due |
|---|---|---|---|---|---|---|
[description] |
SGD [amount] |
[week/date] |
High / medium / low | [name] |
[action] |
[date] |
Examples:
- Major customer payment not confirmed
- Invoice dispute unresolved
- GST estimate incomplete
- Payroll file not final
- Supplier bill missing approval
- Payment-provider settlement delayed
- Bank account unreconciled
- Credit facility renewal pending
- Capital purchase awaiting decision
Do not hide data-quality problems in a footnote. If bank data is stale, that is a report risk.
Assumptions register
Material assumptions need owners.
| Assumption | Value or treatment | Evidence | Confidence | Owner | Last reviewed |
|---|---|---|---|---|---|
| Customer A payment | SGD [amount] on [date] |
Email / call / pattern | High / medium / low | [name] |
[date] |
| Monthly sales receipts | SGD [amount] |
Confirmed orders / estimate | |||
| GST payment | SGD [amount] |
Draft computation | |||
| New hire start date | [date] |
Approved offer | |||
| Equipment purchase | Included / excluded | Approval status |
The owner should be able to challenge the assumption without reverse-engineering a formula.
Action log
End the report with decisions.
| Action | Owner | Due date | Cash impact | Status |
|---|---|---|---|---|
| Confirm Customer A payment date | [name] |
[date] |
SGD [amount] |
Open |
| Decide whether to defer equipment deposit | [name] |
[date] |
SGD [amount] |
Open |
| Finalise GST estimate | [name] |
[date] |
SGD [amount] |
Open |
| Investigate unreconciled bank difference | [name] |
[date] |
SGD [amount] |
Open |
Carry incomplete actions into the next report. Do not let the weekly meeting become a fresh discussion of the same unresolved item.
A 30-minute weekly cash meeting
Use a fixed agenda.
Minutes 0–5: confirm the starting point
- Available cash
- Reconciliation status
- Data freshness
- Lowest projected balance
Minutes 5–12: review forecast changes
- Largest movements from last week
- Actual-versus-forecast variance
- Changed customer receipts
- New commitments
Minutes 12–20: review risks
- Largest uncertain receipts
- Fixed payments
- Threshold breaches
- Data-quality exceptions
Minutes 20–27: make decisions
- Collection action
- Supplier timing
- Spending approval
- Funding or transfer
- Scenario update
Minutes 27–30: assign owners
- Action
- Owner
- Due date
- Expected cash impact
Do not spend the meeting correcting spreadsheet formulas. Data and exceptions should be reviewed before the meeting.
Traffic-light rules
Define colours using thresholds rather than mood.
Green
- Closing cash remains above the minimum threshold
- Critical data sources are current
- No material unexplained variance
Amber
- Headroom approaches the warning threshold
- Material receipts are medium confidence
- One critical source or assumption needs review
- Action can prevent a shortfall
Red
- Forecast falls below minimum cash
- Payroll, tax, or other critical obligation is at risk
- Opening cash is materially unreconciled
- Financing or owner decision is immediately required
Record the numerical thresholds in the report. “Amber because finance feels cautious” is not a rule.
Minimum viable spreadsheet structure
If building this in a spreadsheet, use separate tabs:
- Dashboard — owner-facing summary
- 13-week forecast — weekly cash movements
- Customer receipts — invoice-level expected dates
- Payments — bills and other obligations
- Assumptions — management inputs and scenarios
- Actions — owner and deadline
- Actual versus forecast — accuracy and variance
- Data checks — reconciliation and refresh status
Avoid hard-coding adjustments directly into the dashboard. Every number should trace to a source or named assumption.
What to automate
Automation can:
- Pull bank balances
- Import invoices and bills
- Carry forward recurring payments
- Apply customer payment assumptions
- Calculate weekly totals
- Compare current and prior forecasts
- Generate threshold alerts
- Produce the report
- Distribute it to approved recipients
- Track refresh failures
People should still review:
- Material customer payment dates
- Disputes
- Payroll and tax estimates
- New spending
- Financing assumptions
- Intercompany transfers
- Threshold breaches
Use the core rule: automate data movement and calculations, but keep material assumptions visible and owned. Our guide to choosing the first SME automation project explains how to decide whether the reporting workload is stable and valuable enough to automate.
Report controls
Before distribution, confirm:
- Opening cash agrees with reconciled records
- Restricted balances are excluded or identified
- Every material receipt and payment has an owner
- Forecast dates are current
- Formulas and totals balance
- Prior-week bridge reconciles
- Data refresh failures are visible
- Scenario and base case are not mixed
- Manual overrides are logged
- Report status and reviewer are shown
Restrict access appropriately. A cash forecast can contain payroll, financing, customer, supplier, and bank information.
Common template mistakes
Too much detail on page one
The owner needs decisions and exceptions. Keep transaction detail in supporting tabs.
Using invoice due dates without review
Overdue and disputed invoices need realistic expected dates.
Forgetting obligations outside accounts payable
Payroll, tax, loans, and approved purchases may not appear as ordinary bills.
Reporting closing cash without the low point
A business may finish the quarter comfortably while going negative for one week in the middle.
Updating numbers without explaining movement
The forecast bridge is what makes the report accountable.
Leaving actions unnamed
“Chase debtors” is not an action. “Mei to confirm Customer A's SGD 80,000 payment date by Tuesday” is.
What success looks like
A useful weekly report should reduce:
- Time spent compiling data
- Surprises
- Unreconciled balances
- Unowned assumptions
- Repeated discussion without action
Measure:
- Preparation time
- Forecast versus actual cash
- Receipt-date accuracy
- Payment-date accuracy
- Actions completed on time
- Threshold breaches identified early
- Manual adjustments
- Failed data refreshes
The report is working when management acts earlier, not when the dashboard becomes prettier.
The bottom line
A weekly cash-flow report should fit on one management page and answer:
- What cash is available?
- How low will it go?
- Why did the forecast change?
- What must we do now?
The supporting 13-week model, assumptions register, and action log provide the evidence beneath those answers.
Use the Calcudesk automation ROI calculator to estimate the time spent compiling recurring reports. If this template depends on several systems and manual updates, book a 30-minute discovery call and we will map how to automate the data while keeping judgment visible.