A cash flow forecast estimates when money will enter and leave your business. A 13-week view helps you see short-term payment gaps before they become urgent. Use actual bank balances, realistic receipt dates and known bills, then update the forecast each week.
This is a planning tool, not a guarantee of future sales or funding approval. Scrumptious Enterprises LLC uses straightforward financial education to help owners ask better questions before borrowing.
What goes into a cash flow forecast?
Create one column per week. Start with available cash, add expected receipts, subtract planned payments and calculate the closing balance. Carry that closing balance into the next week’s opening balance.
Opening cash + cash received − cash paid = closing cash. Record cash when it is expected to move. An invoice sent today may not be paid today. A profitable month can still include a week with too little cash to meet bills.
Step 1: Start with a reliable opening balance
Use the bank balance after checking outstanding payments and deposits. Keep restricted money separate from cash you can use. Do not count an unapproved loan or a credit line you cannot draw as available cash.
For multiple accounts, use a consistent method. Transfers between your own accounts are not new customer receipts. Counting both sides as income overstates available funds.
Step 2: Estimate receipts by payment date
List expected customer payments, cash sales and other receipts. Check invoices against payment terms and recent payment behavior. A customer who often pays late should not be treated as a certain on-time receipt.
- Separate confirmed receivables from hoped-for sales.
- Use a realistic date for each large payment.
- Allow for refunds, processing delays and returns.
- Keep owner contributions separate from operating revenue.
Step 3: Map the bills that must be paid
Include payroll, rent, suppliers, utilities, tax payments, insurance and current debt payments. Use the actual due week. A monthly average can hide a large bill that lands before your customer pays.
Add planned purchases and owner draws where relevant. If a cost is uncertain, show the estimate clearly and update it when you receive a quote. Ask your accountant about tax amounts and deadlines for your business.
Step 4: Find the lowest cash balance
The weakest week is often more useful than the total cash expected over three months. Mark any week that falls below the operating cushion your business needs. Then trace the cause: late collections, a stock order, a one-time purchase or recurring losses.
For illustration, opening cash of $12,000 plus receipts of $8,000 minus payments of $15,000 leaves $5,000. If the next week’s bills exceed expected cash, you need a plan before that week arrives. These numbers are an example, not a recommended reserve.
Step 5: Test a slower-sales case
Build a second version with delayed customer receipts and lower sales. Keep fixed bills in place. This shows how sensitive the plan is to assumptions. Choose changes that reflect your business history, not an arbitrary best case.
Before adding financing, insert every proposed payment on its actual date. Include fees and use the net amount you would receive. Daily or weekly debits may strain cash even when a monthly total seems manageable.
Step 6: Compare practical responses
Borrowing is one possible response to a cash gap. You can also review collection timing, supplier terms, staged purchases and spending priorities. Do not delay contractual payments without agreement.
Working capital financing may help with a defined timing need when repayment is supportable. It does not repair an unprofitable business model by itself. Review our guide to uses for working capital before choosing a purpose.
Keep the forecast useful each week
Replace estimates with actual receipts and payments. Note the differences and add a new week at the end. A rolling forecast becomes more useful as you learn which assumptions need adjustment.
Keep a short note for each major change. “Client payment moved one week” is more useful than silently changing a number. A clear record also helps explain seasonality during a funding discussion.
Use the cash flow forecast to assign actions
When a low-cash week appears, write down the action, owner and due date. A collection call, revised purchase quantity or agreed supplier change should be tracked separately. Update the forecast only when the change is supported. Moving a bill to a later week without the supplier’s agreement does not solve the problem.
For the next step, diagnose a working capital gap and compare a proposed funding payment.
Frequently asked questions
Is a cash flow forecast the same as a profit and loss statement?
No. A profit and loss statement tracks income and expenses under your accounting method. A cash flow forecast focuses on the timing of cash receipts and payments.
How often should I update it?
A weekly review suits a 13-week forecast. Update sooner when a major sale, bill or payment date changes.
Does a positive forecast mean I should borrow?
No. Compare the purpose, total cost, terms and downside case. A forecast supports judgment; it does not make the decision for you.
Bring your forecast to the conversation
Explore our business funding services or schedule a discussion. Scrumptious Enterprises is veteran-owned and serves business owners nationwide.
Educational information only. Funding terms and approval depend on eligibility and underwriting. Forecasts are estimates.
