Cash flow forecast for a new business: costs and timing

A cash flow forecast for a new business turns opening costs, sales assumptions and payment dates into an expected bank balance. Start with cash actually available, keep financing separate from sales and test what happens when customers pay later. Without trading history, the quality of the forecast depends on visible assumptions and the evidence behind them.

The general cash flow forecast explains the recurring receipts and payments structure. A launch needs an additional discipline: show which costs occur before trading, which receipts depend on unproven demand and which funding has actually been secured.

Start with commitments and evidence

Gather the bank balance, startup purchase list, supplier quotes, lease, planned payroll, signed orders and any approved funding documents. Put dates beside amounts. A supplier quote establishes a potential cost; the payment schedule establishes when that cost affects cash.

The SBA's startup-cost guidance separates one-time expenses from monthly expenses. That is a useful forecast layout because equipment, deposits and launch fees can consume cash before recurring operations begin.

Give each assumption a status such as committed, supported estimate or unconfirmed. Record the source and owner beside it. A signed customer order is stronger evidence than a sales target, but neither proves the cash collection date without payment terms.

For demand assumptions, build the separate sales forecast for a new business. Bring its units and prices into the cash plan, then apply collection timing. Do not turn the entire sales figure into a bank receipt automatically.

Build the launch schedule

Consider an illustrative US commercial cleaning company beginning operations in January. It has $30,000 available and expects an additional $40,000 owner contribution before startup purchases are paid. Treat that contribution as conditional until its bank receipt is confirmed.

The launch outlays are explicit:

The sales plan assumes jobs invoiced at $2,000 each: ten in January, fifteen in February and twenty in March. Those counts are planning inputs, not observed conversion rates. The collection assumption is half in the invoice month and half in the following month, with no opening customer receivables.

Operating payments cover the supplied payroll, occupancy, supplies and other recurring spending schedule. The example keeps them as one row; the working file should retain the underlying supplier and payroll lines so the total can be checked.

Closing cash = Opening cash + Customer receipts + Funding receipts − Startup outlays − Operating payments

February receipts are $15,000 from February invoices plus $10,000 from January. March receipts are $20,000 from March invoices plus $15,000 from February. Dollar amounts are exact; this example requires no rounding.

Put the formulas in the spreadsheet

Use columns A through H in the order shown above. Put the same-month collection share, 50%, in K1 and opening receivables due in January, zero, in K2. In Excel, January receipts in D2 are:

=C2*$K$1+$K$2

February receipts in D3 use the current month's sales plus the uncollected share of the preceding month's sales:

=C3*$K$1+C2*(1-$K$1)

Fill that formula down for later months. Closing cash in H2 and the next month's opening cash in B3 are:

=B2+D2+E2-F2-G2
=H2

When there are individual expected receipts, sum their scheduled dates instead of applying a blanket percentage. Microsoft's SUMIFS documentation explains adding amounts that meet multiple criteria. With receipt dates in J2:J100, amounts in K2:K100, period start in M2 and next period start in N2:

=SUMIFS($K$2:$K$100,$J$2:$J$100,">="&M2,$J$2:$J$100,"<"&N2)

Covirage is not affiliated with Microsoft.

Prove the balance, then stress collection timing

The period bridge must reconcile: $30,000 opening cash plus $40,000 funding plus $70,000 customer receipts, less $24,000 startup outlays and $69,000 operating payments, equals $47,000 closing cash. Never add the monthly opening or closing balances together; they are successive balances of the same cash.

The sales-to-cash check also works. Total invoices are $90,000 and receipts are $70,000, leaving $20,000 receivable at March end. That equals the uncollected half of March sales. There are no write-offs, taxes collected from customers or other receivable movements in this simplified example.

Now change only the collection split to 25% in the invoice month and 75% in the next month:

The lowest month-end balance becomes $30,500 in February. Monthly balances can still hide a payroll shortfall inside a month. Use the 13-week cash flow layout to schedule those near-term dates rather than assuming month-end cash is always available earlier.

Replace assumptions with actual results

Keep the approved launch forecast and add actual bank movements beside it. Suppose January customer receipts are $8,000 and operating payments are $21,000, while funding and startup outlays occur as planned. Actual closing cash is $33,000: $3,000 below the forecast's $36,000.

The difference has two causes: receipts are $2,000 below plan and operating payments are $1,000 above plan. Determine whether the receipt gap is delayed collection or missing sales before changing future months. A cash flow forecast chart can display the revised balances, but the explanation must still point back to the dated rows.

Where it goes wrong

• Unconfirmed funding enters opening cash. Keep it separately dated and expose the case where it arrives late.
• Sales become immediate receipts. Use expected payment dates or a documented collection split.
• Deposits disappear from the plan. Refundable amounts still reduce available cash when paid.
• Equipment is counted twice. Include its payment once; do not also subtract accounting depreciation as cash.
• Actuals overwrite the original plan. Preserve the comparison so forecast errors remain visible and assumptions can improve.

Check your launch plan in Covirage

Bring a sample of your own startup-cost schedule, forecast receipts and actual bank or ledger export to Covirage. Covirage maps the columns; its tools compute and check the supplied cash balances and comparisons, and the external AI model explains the results with every figure traced to its rows. Create a free Covirage account and use your first actual receipts to challenge the launch assumptions.

See forecast analysis for the supporting approach.