Table of Contents
A cash flow forecast helps a small business owner see whether enough money will be available to pay bills in the weeks ahead. Build one by starting with available cash, estimating when payments will arrive and leave, and checking the projected balance each week before committing to new spending.
The point isn’t to predict every dollar perfectly. It’s to spot the week when a payroll run, supplier payment, or delayed customer payment could leave you short, while there’s still time to act.
Cash Flow Forecast Basics for Owners
Use a weekly forecast if you need to manage near-term bills. A 13-week view is a practical starting point: it covers roughly three months while keeping individual payment dates visible. If cash is especially tight, check the next two weeks by day as well.
Cash flow is different from profit. An invoice can count as revenue in your accounting records before the customer pays it, depending on your accounting method. The forecast asks a different question: when will the money actually be available to spend?
Start with the bank balance you can use for business payments. Exclude money held for a specific purpose if you won’t use it for ordinary bills, such as funds you’ve set aside for taxes. If those funds remain in the same bank account, record the balance you can actually use and avoid subtracting the same reserve again later.
Then collect three sources: unpaid customer invoices, bills and payroll dates, and recent bank transactions. The monthly bookkeeping checklist can help keep those records current. The forecast is forward-looking, though, so add expected payments that haven’t appeared in the books yet.
Build the Forecast One Week at a Time
A spreadsheet is enough for a first version. Give each week a column and put the opening balance, expected receipts, expected payments, and closing balance in separate rows. The closing balance for one week becomes the opening balance for the next.
Use these steps to fill it in:
- Enter available cash. Use the balance at the start of the first forecast week, adjusted for transactions that have cleared in your records but aren’t reflected in the balance you’re using.
- Place expected receipts. List customer payments in the weeks you expect to receive them, based on payment history and any confirmed dates.
- Place expected payments. Include payroll, taxes, rent, loan payments, supplier bills, subscriptions, and owner draws in their expected payment weeks.
- Calculate each closing balance. Add that week’s receipts to its opening balance, then subtract its payments. Carry the result into the following week.
- Mark the low point. Compare each closing balance with the cash cushion you want to protect, not just with zero.
Use the date cash is expected to reach or leave your account, not simply the invoice date. A customer’s promise to pay Friday may not mean funds are available Friday. Check your bank’s processing times and put the receipt in the later week if that’s when you expect to use it.
Don’t count a payment twice. If a customer payment is already in your starting balance, leave it out of forecast receipts. Likewise, if your starting balance already reflects a bill payment, don’t subtract that payment again.
Estimate Cash Flow Without False Precision
Some numbers will be known; others are estimates. Keep that distinction visible. A signed invoice with a confirmed payment date deserves a different label from a proposal the customer hasn’t accepted. Record the reason for each uncertain receipt in a note next to it.
For recurring sales, look at recent deposits and consider any known changes, such as a seasonal closure or a customer ending a contract. Avoid placing a full month’s expected sales in the first week just because that makes the balance look healthy. Spread receipts across the weeks when customers usually pay.
For expenses, include the full cash amount that will leave your account. Payroll, for example, can involve wages and related tax payments on different dates. Enter each expected outflow when due rather than using a single rough payroll figure if the timing differs.
Also include irregular costs that are easy to miss: annual renewals, insurance installments, equipment repairs, and tax payments. Check prior bank statements and your payment calendar for clues. For tax amounts and due dates, consult the relevant tax authority or your accountant rather than relying on a generic estimate.
Set a minimum cash cushion based on your obligations and tolerance for risk. A business with a large payroll due at once needs to consider that payment, even if its weekly average expense is low. A positive projected balance isn’t enough if it leaves no room for a late receipt or an unexpected bill.
Worked Example: A Late Customer Payment
Assumptions: A design studio begins a week with $5,000 in available cash. It expects a $4,000 customer payment that week and has $6,000 in payroll, rent, and other payments due. Its owner wants to keep at least $2,000 available.
Base calculation: $5,000 opening cash + $4,000 receipts − $6,000 payments = $3,000 closing cash. The projected balance stays $1,000 above the owner’s cushion.
Changed variable: The customer says $2,000 of the payment will arrive the following week instead. This week’s calculation becomes $5,000 + $2,000 − $6,000 = $1,000. The studio is still above zero, but it is $1,000 below its chosen cushion.
The owner can now review the actual due dates and ask whether a supplier will agree to move a payment. The delayed $2,000 belongs in the following week’s receipts, not in both weeks. The owner should also check that week’s bills before assuming the late payment resolves the problem.
This example is illustrative, not a prediction. Its value is the timing: the same customer payment produces a different near-term risk when only part of it arrives late.
Respond Early to a Projected Shortfall
When a week falls below your cushion, first confirm the entries. Check the opening balance, payment dates, and any receipt that depends on a customer’s promise. Then calculate how much cash you need and for how long. A one-week gap calls for a different response from a recurring deficit.
Start with actions you control. Pause a discretionary purchase or delay an owner draw if doing so is appropriate for your situation. Contact customers with overdue invoices and ask for a specific payment date. For a bill you cannot comfortably cover, speak with the supplier before it is due and get any revised arrangement in writing.
Don’t assume you can postpone payroll, taxes, loan payments, or contractual obligations without consequences. Check the applicable rules and agreements, and speak with your accountant or an attorney when needed. If you consider borrowing, compare the total cost, repayment dates, and effect on later forecast weeks before accepting an offer.
A forecast can also reveal that the issue isn’t timing. If balances keep falling even when customers pay on schedule, review pricing and expenses rather than repeatedly moving bills. A break-even analysis can help assess the sales needed to cover costs, though it won’t replace a cash forecast.
Keep the Cash Flow Forecast Useful
Update the forecast at least weekly. Replace estimates for the week just ended with actual receipts and payments, enter the current available balance, and add a new week at the far end. That keeps the view moving forward instead of leaving you with an outdated plan.
Pay particular attention to assumptions that were wrong. If one customer repeatedly pays two weeks after the due date, use that pattern for future estimates until the customer’s behavior changes. If supplier bills vary, compare your estimates with recent payments and investigate the difference.
Keep a second, more cautious view when a large receipt is uncertain. Move that payment to a later week or leave it out temporarily, then see whether essential bills remain covered. This isn’t a claim that the customer won’t pay; it shows how much room you have if payment is delayed.
Share the forecast with whoever approves spending or manages invoices, while limiting access to people who need the financial details. Agree on one owner for updates so separate versions don’t lead to conflicting decisions. A lender or accountant may ask for a longer forecast, but the weekly version remains useful for day-to-day payment decisions.
Frequently Asked Questions
Include only money available for business payments in the opening balance. Exclude funds reserved for specific purposes if you cannot use them for ordinary bills, and avoid subtracting a reserve twice.
Move the uncertain receipt to a later week or leave it out temporarily, then check whether essential bills remain covered. Note the reason for the uncertainty.
Check whether balances keep falling even when customers pay on schedule. If they do, review pricing and expenses rather than repeatedly moving bill dates.
Use the customer’s actual payment pattern to estimate future receipt dates until their behavior changes, rather than relying only on invoice due dates.
A lender may ask for a longer forecast, but the weekly version can still support day-to-day payment decisions. Keep the assumptions and timing clear when extending the view.
Bottom Line
A weekly cash flow forecast is worth building if your small business has uneven receipts, fixed bills, or little room for a late payment. It won’t tell you exactly what will happen, and it shouldn’t replace accounting records or professional advice. If your cash position is comfortable and predictable, a simpler monthly view may be enough. Today, list your available cash and the payments you expect over the next two weeks, then identify the lowest projected balance.
This article is for general information only and is not financial, tax, or legal advice; consult a qualified professional about your situation.
