The Tool Desk
Outbyte PC Repair FREERepair Windows errors before they cause bigger problemsFix Now →Outbyte Driver Updater FREEScan for outdated or missing drivers - takes under a minuteDriver Scan →Build a period-by-period forecast from your current bank balance, expected customer receipts, and expected payments. Make demand and service-cost assumptions explicit, test a base case and a downside case, then track the lowest projected cash balance and when it occurs. Update the forecast with actual results so you can distinguish a timing gap from a lasting change in demand or costs.
What a cash flow forecast tells you
A cash flow forecast estimates when money will enter and leave the business, and the cash balance expected at the end of each period. An income statement, booked work, or invoice total does not by itself show when the money will be available to pay wages, suppliers, tax, or other bills. Record receipts and payments in the periods they are expected to reach or leave your account.
The right level of detail depends on the decisions you need to make. Monthly periods may work for routine planning; weekly or daily periods can be more useful when cash needs close monitoring. Choose a cadence that reflects your billing, payroll, tax, and supplier-payment schedules. New Zealand’s Business.govt.nz guidance describes preparing forecasts in a spreadsheet or accounting software, while Business Victoria provides a forecasting template.
Build the forecast from cash timing
1. Set the period and opening cash
Choose a forecast horizon and period length that fit the business’s cash cycle and the decisions ahead. Use the current bank balance as the opening cash figure, rather than an accounting profit figure or an estimate of unpaid invoices.
Free tools Windows power users keep installed
One-click scans. No signup required.
#1 Best Overall
- Daily Cash Flow Log Book 110 Pages Large Format：Daily Cash Flow Log Book with 110 pages in large 8.5 x 11 Inch format provides ample space for daily income expense tracking supporting long term financial record keeping
- Financial Record Keeping Notebook for Daily Accounting：Helps track cash in cash out balances and transactions making it ideal as a petty cash ledger book for small business store office and home accounting
- Structured Inner Page Accounting Fields：Daily Cash Flow Log Book pages include sheet number month year date from to starting balance date description cash in cash out balance total end date closing balance approved by and signature sections
- Petty Cash Large Ledger Book Spiral Bound：Petty Cash Large Ledger Book with spiral binding allows pages to lay flat for easy writing and efficient daily bookkeeping and cash management tasks
- Professional Cash Flow Ledger with Premium Paper：Daily Cash Flow Log Book uses 80 gsm double sided black and white printed pages with a laminated 300 gsm cover ensuring durability for long term financial tracking
2. Enter receipts and payments when they are expected
For each period, list expected customer receipts and cash payments. Base the timing on when funds are expected to arrive or leave—not just on an invoice date, a contract value, or when work is performed. Carry each period’s closing balance forward as the next period’s opening balance.
A simple layout is:
| Period | Opening cash | Expected receipts | Expected payments | Closing cash |
|---|---|---|---|---|
| Period 1 | Bank balance at forecast start | Cash expected in during the period | Cash expected out during the period | Opening cash + receipts − payments |
| Period 2 | Period 1 closing cash | Cash expected in during the period | Cash expected out during the period | Opening cash + receipts − payments |
3. Document demand and service-cost assumptions
Write down what drives the figures instead of hiding uncertainty inside one sales or expense estimate. For demand, note expected workload or client volume, contract or project start dates, seasonal patterns, and the evidence for each assumption. That evidence might include confirmed work, pipeline status, or other indicators relevant to your business; identify what is confirmed and what remains uncertain.
For delivery costs, list expected staffing, supplier, and other costs with their likely amounts and payment timing. Consider whether a change in workload would also change labor or supplier spending, and whether those costs occur before or after customer payment. Keep the assumptions traceable so that, when actual results differ, you can identify which estimate needs revision.
Test uncertainty with separate scenarios
Use a base case and a downside case. Add an upside case only if it helps answer a real capacity or spending decision. Each scenario should change a small, visible set of assumptions; it is a controlled alternative, not a claim that one outcome is certain. The Department for Education’s guidance for colleges recommends setting out a range of potential scenarios when the out-turn position is materially uncertain.
Rank #3
- 1.Daily Cash Flow Log Book 120 Pages Large Format：Daily Cash Flow Log Book with 120 pages in large 6 x 9 Inch format provides ample space for daily income expense tracking supporting long term financial record keeping
- 2.Financial Record Keeping Notebook for Daily Accounting：Helps track cash in cash out balances and transactions making it ideal as a petty cash ledger book for small business store office and home accounting
- 3.Structured Inner Page Accounting Fields：Daily Cash Flow Log Book pages include sheet number month year date from to starting balance date description cash in cash out balance total end date closing balance approved by and signature sections
- 4.Petty Cash Large Ledger Book Spiral Bound：Petty Cash Large Ledger Book with spiral binding allows pages to lay flat for easy writing and efficient daily bookkeeping and cash management tasks
- 5.Professional Cash Flow Ledger with Premium Paper：Daily Cash Flow Log Book uses 80 gsm double sided black and white printed pages with a laminated 300 gsm cover ensuring durability for long term financial tracking
Choose assumptions that could materially affect cash, such as:
- Lower client demand or a delayed project start.
- Higher labor or supplier costs, or costs arriving earlier than expected.
- Slower customer collections or receipts shifting into a later period.
- Changes to price, contract timing, or workload where relevant to the business.
Keep the scenarios comparable. For each one, show demand or workload, relevant price and project timing, labor and supplier cost levels and timing, customer collection timing, the lowest projected cash balance and its date, and the actions still available before that date. Change only the assumptions needed to represent each case; this makes the cause of a cash difference easier to see.
Find the cash low point and decide when to act
Review the lowest projected cash balance in each scenario and the period in which it occurs. A forecast can show that cash tightens before an otherwise profitable project pays, or that a cost increase matters most when receipts are delayed. The timing matters: it tells you how much lead time you have to assess options.
Use the forecast as an early-warning tool, not as a universal instruction to cut spending or borrow. Depending on your obligations and circumstances, possible options to assess may include following up an overdue or expected receivable, rescheduling discretionary spending, or revisiting planned commitments. Consider the consequences for customer relationships, service delivery, contractual duties, and local tax or payroll requirements before changing payment or spending plans.
Update the forecast and learn from differences
At each update, compare forecast cash movements with what actually happened. Identify whether a difference came from timing—such as a receipt arriving later—or from a lasting change, such as fewer bookings or a higher cost to deliver the work. Revise assumptions for the remaining periods accordingly; do not leave an outdated estimate in place simply because the original plan looked reasonable.
The Department for Education (England), in its Management accounts: good practice guide for colleges, says: “You should keep an up-to-date rolling cashflow forecast and report this in each month’s accounts.” That guidance is written for colleges in England, so its reporting instruction should not be treated as a rule for every service business. The rolling-forecast principle is useful more broadly: replace elapsed periods with actuals, carry the latest cash balance forward, and extend the forecast to cover the next relevant planning horizon.
Reviewing a series of forecast-versus-actual results is more informative than judging accuracy from a single snapshot. If a recurring miss comes from collection timing, adjust the receipt assumptions. If demand or service costs have changed, update the underlying drivers as well as the totals. Keep the forecast at a level of detail you can maintain reliably, and use the same period structure when comparing scenarios and actual results.
Where the guidance applies
The method is general, but the cited public guidance comes from different jurisdictions and settings: England’s college management-account guidance, New Zealand and Australian small-business resources, Queensland and Victoria guidance, and a U.S. federal contracting regulation. Acquisition.gov’s cash-flow forecast provision is specific to federal government contractors; it should not be read as a legal requirement for all businesses. Tax due dates, payroll rules, payment conventions, and available business support vary by location and business model, so confirm local obligations before acting on a forecast.
Recommended Free Tools
Quick Recap
- Department for Education (England): Management accounts: good practice guide for colleges
- Business.govt.nz: Cash flow forecasting
- Business Queensland: Budgets and forecasts
- Acquisition.gov: 232.072-3 Cash flow forecasts
- business.gov.au: Improve your cash flow
- Business Victoria: Cash flow forecasting
Product prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on Amazon at the time of purchase will apply.
