A cash flow forecast estimates when money is expected to enter and leave your business. By laying out expected receipts and payments by date, you can see whether available cash may become tight before the bills are due. It is a planning tool, not a promise that the numbers will happen exactly as shown.
Start with the cash you can use now, add receipts when you reasonably expect to collect them, and subtract payments when you expect to make them. Then compare the projected ending balance with the cash your business needs for its upcoming commitments. If you are new to bookkeeping, the small business bookkeeping guide explains how this forecast fits into the larger recordkeeping routine.
What a cash flow forecast can—and cannot—tell you
A forecast places expected receipts and payments on a timeline, helping reveal whether money may arrive after payroll, supplier bills, rent, debt payments, or other commitments are due. A profitable business can still face a timing gap when customers pay after expenses fall due.
A forecast is different from both a profit and loss statement and a historical statement of cash flows. The profit and loss statement summarizes revenue and expenses for a period. A cash flow statement reports cash movements that already occurred. A forecast looks ahead and relies on assumptions about dates and amounts. If you need to interpret recorded results rather than estimate future balances, see how to read a profit and loss statement each month. In its business-plan guidance, the Small Business Administration asks businesses seeking funding to explain their projections and connect them to the funding request; it also calls for more detail in the first year.
The forecast cannot promise collections, determine tax treatment, or tell you which financing option is appropriate. Keep assumptions visible and update them as new information arrives.
Before you start: gather the records that explain timing
You do not need a complicated model to create a useful first forecast. Gather current bank balances, open invoices and payment terms, recent collection history, bills, payroll dates if applicable, loan schedules, planned purchases, and other known commitments. Mark uncertain estimates and assign someone to resolve missing information.
The IRS describes business records as a basis for monitoring the business, preparing statements, and supporting the amounts reported on tax returns. Those same records can help you build a forecast, but make sure you distinguish a forecast assumption from a transaction that has already happened.
How to build a cash flow forecast step by step
1. Choose a useful time horizon and period size
Choose a time window that matches the decision. A business reviewing payroll next week may need a closer view than one planning seasonal purchases months ahead. Use weekly or monthly periods, or combine close intervals for immediate commitments with broader periods farther out.
There is no single period size that suits every business. For a formal plan or funding request, follow the requested format; the SBA recommends quarterly or monthly projections for the first year of a traditional plan. For routine management, choose detail that reveals timing and can be maintained. If you are organizing lender documents as well, see what financial records to prepare before applying for a business loan.
2. Enter the starting cash available
Begin with cash the business can access at the start of the period. If the forecast covers multiple accounts, define which operating cash is included and use that scope consistently. Do not count a transfer between included accounts as both a new receipt and a payment.
Do not include an undrawn credit line, hoped-for loan, or planned owner contribution as available cash without a specific, supportable basis. Identify financing and owner funding separately from customer receipts. Check whether restricted or earmarked funds can cover ordinary commitments.
3. Estimate receipts by the date cash may arrive
List expected receipts by the date cash is likely to reach the account. For an invoice, estimate collection timing rather than using its issue date. Payment terms are a starting point; collection history, disputes, approval steps, seasonality, and a customer’s stated payment date can change the estimate.
Separate receipts by source—customer payments, point-of-sale deposits, refunds, financing, owner funding, or asset sales—so you can see which assumptions drive the forecast. These are not all operating sales, and transfers between included accounts should not inflate receipts.
If a large part of the expected cash depends on invoices that have not been paid, review their status and follow-up plan. The companion guide How to Organize Accounts Receivable and Follow Up on Overdue Invoices covers that tracking process.
4. Estimate payments by when they are expected to leave
List payments by due date or expected withdrawal date. Include recurring costs such as payroll, rent, insurance, software, and debt, plus supplier bills, inventory or materials, taxes, planned equipment, and irregular costs due within the forecast window. Other obligations depend on the business and its location.
Use bills, contracts, payroll calendars, statements, and approved purchase plans as evidence. Show uncertain dates or amounts as assumptions. Keep tax obligations and money collected on behalf of others visible, and confirm applicable requirements with the relevant authority or a qualified professional.
Do not subtract a bill twice. For example, if a supplier payment is already included in a scheduled payment list, do not also subtract the same amount as a broad “materials” estimate for that period.
5. Calculate the projected ending cash
For each period, use the same relationship:
Projected ending cash = starting available cash + expected cash receipts − expected cash payments
The ending cash for one period becomes the starting cash for the next. This roll-forward makes timing visible: an expected customer payment in a later period cannot cover a payment due earlier unless the business has other available cash or a separate funding source.
In a spreadsheet, track the period, beginning cash, expected receipts and payments, ending cash, and assumptions. After each period, add actual results to compare them with the forecast.
6. Write down assumptions and test a plausible downside
For each material estimate, record its basis: a customer’s usual payment pattern, the current payroll schedule, or a signed equipment quote. Distinguish uncertain assumptions from confirmed commitments.
Create a base case from the most reasonable information available, then test a downside case: a late customer payment, lower sales, or a cost above plan. An upside case may help if stronger sales would change staffing or inventory decisions. These scenarios are not predictions; they show how assumptions affect cash and timing.
7. Compare the forecast with actual activity and update it
At a cadence the business can maintain, compare forecast receipts and payments with actual activity. Identify changed assumptions, timing shifts, and unexpected items, then update the remaining periods.
Record the date and reason for material changes. Comparing estimates with actual timing helps improve future forecasts.
A simple example of how timing changes the picture
Imagine a service business whose payroll and rent are due before a client normally pays an invoice. The invoice supports expected revenue, but it does not put cash in the bank on its issue date. A forecast places the collection and payments on their likely dates, showing whether the balance may dip before the customer pays.
The forecast is not a substitute for the profit and loss statement; the two answer different questions about future cash and recorded results.
What to do when the forecast shows a tight period
A low projected balance is a signal to investigate, not proof that the business is failing. Check whether collection dates are realistic, bills are counted once, and irregular costs are included. Then determine whether the gap reflects timing, demand, an unexpected cost, or a longer-term mismatch.
Depending on the circumstances, next steps may include following up on overdue invoices, reviewing a planned purchase, or discussing financing with a qualified adviser. Check contractual and financial consequences before acting. If the gap recurs, review pricing, costs, sales assumptions, and the operating model.
Final checks before relying on the forecast
Confirm that actuals and estimates are distinguishable, transfers between included accounts are not double-counted, and irregular commitments are included. Revisit assumptions whenever payment dates or business conditions change.
Frequently asked questions
How often should I update a cash flow forecast?
Choose a cadence the business can maintain and revisit it when a material payment, cost, or operating assumption changes.
Do I need accounting software to make a forecast?
Not always. A spreadsheet may work for a simple forecast if it is kept current and easy to review; complex operations may need a more structured system or outside help.

