A weekly cash dashboard helps an owner see whether expected receipts and available funds can cover upcoming payments. It should show the cash position, the timing of collections and disbursements, and the decisions needed when the forecast falls below a chosen buffer. It improves visibility; it does not create cash or guarantee that a shortfall will be avoided.
Define the cash included in the dashboard
List the bank accounts and entities covered by the forecast. Reconcile the opening position to the books and current bank information, including holds, pending ACH payments, outstanding checks and transfers in transit. If an outstanding payment already reduces opening available cash, do not subtract it again as a future payment.
Show legally restricted funds separately from cash available for operations. Also identify management-designated reserves, such as income-tax savings. An internal designation does not automatically create a legal restriction or a tax liability, but the dashboard should show its intended use so management does not overlook it.
Choose a consistent presentation: either forecast all included bank accounts and show earmarked amounts beneath total cash, or show an operating-account forecast with separate reserve-account schedules. Internal transfers between accounts included in a consolidated forecast do not reduce total cash.
A weekly example with the reserve clearly separated
The following figures are hypothetical. The $42,000 opening operating balance excludes an $11,000 tax reserve held in a separate account. No reserve transfers or tax payments occur in this example week. The $37,200 outflow estimate contains all modeled operating-account payments, without duplicates.
| Dashboard item | Amount | Meaning |
|---|---|---|
| Opening operating cash | $42,000 | Starting cash within the operating forecast. |
| Expected customer collections | $18,500 | Receipts expected this week from identified invoices. |
| Expected operating-account outflows | ($37,200) | Payroll, supplier, rent and debt payments included in the schedule. |
| Net operating-account movement | ($18,700) | $18,500 minus $37,200. |
| Projected closing operating cash | $23,300 | $42,000 minus $18,700. |
| Separate tax reserve, unchanged | $11,000 | Excluded from both operating balances above. |
| Total closing cash across both accounts | $34,300 | $23,300 plus $11,000. |
If management chooses a $25,000 operating-cash minimum, the projected closing balance is $1,700 below that policy level. The business has not necessarily run out of cash, but the threshold calls for a decision. The reserve’s presence does not mean it is available without considering its purpose and the coming tax payment.
Forecast receipts once, when collection is expected
Use the receivables report to identify invoices and realistic collection dates. Do not add the entire receivable balance to the cash forecast and then add collections from those same invoices. A customer invoice is a claim for payment; it becomes cash when collected. Schedule each expected receipt once.
Track aging against contractual due dates. A $9,000 invoice that is more than 30 days past due may warrant follow-up, but an invoice issued 35 days ago on 60-day terms is not yet overdue. Confirm disputed amounts, promised payment dates, deductions and partial payments for customers whose receipts materially affect the forecast.
Sales pipeline and gross margin can explain future cash risks, but they are not current bank receipts. Model a new contract through the expected work, billing and collection dates. Avoid counting the same sale in both a pipeline estimate and the open-invoice schedule once it has been billed.
Put payment dates and financing on the same timeline
Build outflows from supplier due dates, payroll funding requirements, taxes, debt service, credit-card statements, equipment commitments and owner distributions. Payroll amounts can vary with hours, bonuses and staffing; use the actual expected run. Respect legal and contractual payment obligations when considering changes to discretionary spending.
Break loan payments into principal and interest for accounting support while ensuring the cash forecast includes the full payment once. Distinguish employee net pay, payroll-tax funding and provider fees so tax amounts embedded in a payroll withdrawal are not repeated in another tax line.
Show an undrawn credit facility as potential financing capacity. Include a loan draw as a cash receipt only in a scenario with a supportable amount and funding date, considering lender conditions, availability, fees and repayments. A borrowing limit is not a bank balance.
Check intraweek timing when funds are tight. A Friday customer receipt cannot fund payroll due Wednesday unless another available source covers the gap. A positive week-end balance can conceal that midweek shortage.
Use a rolling forecast and keep the old version
A weekly dashboard can summarize a longer rolling forecast. SCORE’s cash-flow management materials describe looking ahead, updating actual results and comparing them with forecasts. SCORE also provides a 13-week analysis resource. Adapt the categories to the business rather than treating a template as a guarantee of completeness.
Keep a dated copy before updating. Compare actual receipts, payments and closing cash with what was previously forecast. Explain differences as timing changes, amount changes or missing items. If a customer’s $8,000 payment moved into next week, shift that receipt; do not leave it in both weeks.
Use a supportable base case and a separate downside case. For example, delay a major receipt by two weeks and include a plausible urgent repair. Record the assumptions and compare the lowest projected cash balance with the operating threshold.
Interpret runway carefully
A simple runway estimate divides the cash available for the modeled activity by a positive average net cash burn over the same time unit. For example, $20,000 divided by a sustained $2,500 weekly net cash outflow suggests eight weeks, assuming that pattern continues and no additional funding arrives.
Define the cash included and the period used to estimate burn. If average net burn is zero or negative, the division does not give a useful finite runway. Even with positive burn, a lumpy tax payment or seasonal receipt can make the dated forecast more informative than an average.
Turn the review into assigned actions
As a suggested operating routine, have the owner and person maintaining the records review the dashboard weekly. Add an operations lead when work schedules affect billing or spending. Choose a meeting length that fits the complexity; there is no required 20-to-40-minute standard.
- Confirm opening availability and the latest collection and payment assumptions.
- Review the prior forecast against actual results.
- Identify the next low-cash date and the receipts or payments driving it.
- Choose supported actions, such as resolving a billing dispute or deferring an uncommitted purchase.
- Assign each action to a person with a due date, then update the forecast.
Bookkeeping accuracy, forecasting and tax planning support different parts of this process. An internal management-report review does not independently assure every forecast input or promise a future result. If you need assistance, contact CPA Firm South Florida to define the records, forecasting support and review frequency required.
See “A Practical Owner Dashboard: Financial KPIs Worth Reviewing Monthly” for more on Monthly Financial KPI Dashboard.
Frequently asked questions
Should I add outstanding receivables to expected collections?
No. Receivables are the amounts customers owe. The forecast includes the cash expected from those invoices in the relevant weeks, once. Adding both the receivable balance and those same collections double-counts the receipts.
Is an invoice more than 30 days old overdue?
Only if its payment deadline has passed. Compare its due date with the agreed terms. A 35-day-old invoice on 60-day terms is not yet overdue.
Can a weekly review prevent every cash shortfall?
No. It can improve visibility and assign timely actions, but customers can still pay late, costs can change and financing can fail to arrive. Keep a downside scenario and check critical payment dates.
{“@context”:”https://schema.org”,”@type”:”FAQPage”,”mainEntity”:[{“@type”:”Question”,”name”:”Should I add outstanding receivables to expected collections?”,”acceptedAnswer”:{“@type”:”Answer”,”text”:”No. Receivables are the amounts customers owe. The forecast includes the cash expected from those invoices in the relevant weeks, once. Adding both the receivable balance and those same collections double-counts the receipts.”}},{“@type”:”Question”,”name”:”Is an invoice more than 30 days old overdue?”,”acceptedAnswer”:{“@type”:”Answer”,”text”:”Only if its payment deadline has passed. Compare its due date with the agreed terms. A 35-day-old invoice on 60-day terms is not yet overdue.”}},{“@type”:”Question”,”name”:”Can a weekly review prevent every cash shortfall?”,”acceptedAnswer”:{“@type”:”Answer”,”text”:”No. It can improve visibility and assign timely actions, but customers can still pay late, costs can change and financing can fail to arrive. Keep a downside scenario and check critical payment dates.”}}]}