How to Build a Cash-Flow Forecast Before Taking Business Funding

A strong sales month does not always mean cash will be available when a payment is due. Customers may pay later, inventory may need to be bought first, and payroll still has a date on the calendar. A cash-flow forecast puts those moving parts in one place before you take on a new funding commitment.

Start with timing, not just profit

A forecast estimates the money your business expects to receive and pay over a future period. It is different from a cash-flow statement, which records what already happened.

The distinction matters when you sell on credit. An invoice may count toward sales before the customer pays it. In your cash forecast, place that collection in the period when you expect the money to be available, not simply when you make the sale.

Choose a useful planning window

For a starting point, try weekly columns for the next eight weeks. Extend the forecast if your collection cycle, seasonal purchases or planned spending runs longer. Eight weeks is a planning suggestion, not a funding requirement.

Use recent bank activity, unpaid invoices, supplier bills and your payroll calendar to build the first version. Write down the assumptions behind uncertain figures. A signed order, an expected repeat sale and a hoped-for new customer should not all be treated as equally certain.

Build the forecast one period at a time

Start with your opening business cash balance. Check it against your records and account for pending transactions so you do not count money twice. Then list the receipts and payments expected in each week.

• Cash in: customer collections, cash sales and other receipts you have a reasonable basis to expect.
• Cash out: payroll, rent, suppliers, taxes, insurance, existing funding payments, planned equipment purchases and owner withdrawals.
• Closing cash: opening cash plus receipts, minus payments. Carry that closing balance into the next period as its opening balance.

Keep separate rows for major costs rather than putting everything under miscellaneous. Mark one-time spending and uncertain receipts so you can change them without rebuilding the whole forecast.

Add a funding scenario separately

Keep a baseline forecast without the proposed funding. In a second version, add the amount the business would actually receive after any deductions, the purchase or expense it would pay for, and every payment or fee due during the forecast.

Use the actual written terms of the offer. Do not assume a monthly payment if the proposed schedule is more frequent. If several payments fall within one week, include them all. Extend the forecast far enough to understand the commitment, rather than stopping at the week the money arrives.

Check the lowest cash balance, not only the final one. Even a positive weekly closing balance can hide a midweek shortage if payroll leaves before a customer pays. Use daily detail around tight dates.

Test what happens if receipts arrive late

Consider this fictional example, not a Fundr offer: a business starts a week with $8,000, expects $12,000 in customer receipts and has $15,000 in planned payments. Its forecast closes at $5,000. A hypothetical additional funding payment of $1,000 would reduce that to $4,000, before any other changes.

If $5,000 of those receipts moves to the following week, the same version closes at negative $1,000. The monthly sales total might eventually be unchanged, but the payment date still creates a gap.

Repeat that test with a realistic slower-sales period or unexpected expense. Decide what cash cushion your business needs with your accountant. There is no single balance that is right for every business, and a positive forecast is not proof that funding is affordable.

Update it before you commit

Compare the forecast with actual collections and spending each week. Replace estimates with facts, move delayed receipts and add newly known costs. If a shortfall appears, review the amount, timing and purpose of the planned spending before accepting new obligations.

A forecast is a decision aid, not a guarantee of future cash or funding approval. Use it alongside a review of the full terms, total cost and risks of any offer.

Ready to discuss a funding need? Contact Fundr with your planned use of funds and the timing of your cash-flow gap.

This article is general educational information, not financial, accounting or legal advice.

Sources

• FDIC / SBA: Money Smart for Small Business, Managing Cash Flow - projections, receipts, spending and closing balances.
• SBA: 5 Classic Fails in Budgets and Forecasts - cash versus profit and comparing plans with actual results.
• British Business Bank: How to create a cash flow forecast in 4 steps - collection timing, planning horizon and regular updates. General method only, not UK lending or legal guidance.