A bank balance tells you where you are today. A cash flow forecast spreadsheet helps you see where that balance may be headed. That distinction matters when payroll lands before a large customer payment, when a tax payment shares a week with rent, or when a new purchase looks affordable until the next few commitments are added to the same view.
You can build this in Excel, Google Sheets, or a similar tool. The software is less important than the habits behind it: begin with a reconciled balance, use realistic dates, separate known facts from assumptions, and update the file often enough for it to remain useful. The FDIC’s small-business cash-flow training makes the same point simply: estimates can be revised, and the value is in getting into the habit of thinking ahead.
Choose the time horizon before you build
Start with the question you want the spreadsheet to answer. If you are trying to make sure payroll, rent, supplier bills, and collection dates can coexist, use one column per week for the next eight to thirteen weeks. Weekly columns make timing visible. If you are planning a seasonal year, a staffing change, or a larger equipment decision, add a monthly view for the next six to twelve months.
There is no prize for making the file elaborate. A new business with a few recurring costs may need only a short weekly sheet. A company with several customer invoices, inventory purchases, or a larger payroll may need more detail. The right horizon is the one that gives you enough warning to make a sensible choice.
Set up the rows that matter

Create a label column at the left, then add one column for each week or month. Keep a notes column at the right for expected receipt dates, payment terms, or assumptions that need a follow-up. Arrange the rows in a sequence that mirrors the movement of cash through the business.
- Opening cash: Use the cleared bank balance you can support, not a stale bank-feed number and not the total of invoices you sent.
- Cash in: Add customer payments, cash sales, deposits, recurring receipts, financing proceeds, or other cash that is genuinely expected in that period.
- Cash out: List payroll, contractor payments, supplier bills, rent, utilities, software, insurance, loan payments, taxes, owner draws, and other commitments.
- Totals and closing cash: Keep these rows together at the bottom so the period’s net movement and remaining balance are easy to scan.
Be specific enough to spot the items that can change a decision. A single row called “expenses” is quick, but it hides why one week is tight. You do not need a separate row for every office supply. You do need distinct rows for payments such as payroll, taxes, rent, significant vendor commitments, and owner draws when they can materially affect the bank balance.
Keep the spreadsheet in a format another person could understand. Use one clear label for each row and avoid burying a key payment inside a vague category. If you revise a forecast because a vendor agreed to a new due date or a customer gave a payment commitment, write a short note beside the relevant amount. That small bit of context prevents the file from becoming a set of numbers no one can explain two weeks later.
Enter receipts by realistic payment date
Do not enter revenue when you invoice it unless the customer will actually pay in that same period. Instead, list the payment in the week or month you reasonably expect the cash to arrive. This is one of the most important differences between a cash forecast and a profit-and-loss view.
Use your open invoice list as a starting point. For each material invoice, ask: has the customer confirmed timing, what is their normal payment pattern, and is there a reason this payment could slip? An accounts receivable aging report can make this exercise much more honest. Older invoices and disputed balances may still be collectible, but they should not be treated as equally dependable cash.
For new sales, use a separate assumption row and label it clearly. A signed agreement with a deposit date belongs in the forecast. A promising conversation does not belong beside payroll as if it were settled. When a receipt is uncertain, create a base case that reflects the most likely timing and a cautious case that moves the amount later.
Put payments in the period they clear
Next, fill in cash out using the dates money will leave the account. The payment date, not the date you received a bill, is what belongs in this spreadsheet. Pull from the payroll calendar, vendor due dates, rent schedule, loan amortization, credit-card due date, insurance renewal, subscriptions, and tax calendar.
The IRS recordkeeping guidance for small businesses emphasizes keeping records that clearly show income and expenses and summarize business transactions. That recordkeeping work is what turns a forecast from a hopeful worksheet into a decision tool. When the underlying records are scattered or incomplete, use conservative dates and flag what still needs confirmation.
Do not overlook irregular payments. Annual software renewals, quarterly insurance, estimated tax payments, equipment repairs, owner distributions, and loan principal can all create a low point that an ordinary month does not reveal. Add them now, then keep a short future-commitments list so the same surprise does not return next quarter.
Use four linked formulas
The spreadsheet does not need complex formulas. Once the rows are in place, use a few consistent calculations across every period. Test them with small amounts before trusting a larger plan.
| Row | What it does | Example formula |
|---|---|---|
| Total cash in | Adds expected receipts for the period | =SUM(receipt rows) |
| Total cash out | Adds expected payments for the period | =SUM(payment rows) |
| Net cash movement | Shows what changes during the period | =Total cash in − Total cash out |
| Closing cash | Shows projected cash at the end of the period | =Opening cash + Net cash movement |
| Next opening cash | Carries the result forward | =Previous period closing cash |
Check the math in at least two ways. First, change one receipt date and make sure every later closing balance changes as expected. Then compare the first opening balance to the reconciled bank balance. Formula rows should not be hand-entered. If possible, use a fill color to distinguish input cells from calculation cells so no one accidentally overwrites the logic.
Keep a separate actual-versus-forecast row if the business is working through a tight period. It does not need to be complicated. After a week closes, record the cash that actually came in and went out beside the original estimate, then make a brief note about any meaningful difference. That comparison helps distinguish a one-time surprise from a pattern. If customer receipts are repeatedly later than forecast, the problem may be collection timing rather than an isolated shortfall. If supplier payments are consistently larger, the purchasing plan may need a closer look.
Add a minimum cash balance and one caution scenario
A positive closing balance is not automatically a comfortable one. Pick a practical cash floor for the business. It might cover a payroll cycle, a core vendor commitment, or the amount that allows the owner to sleep at night while ordinary uncertainty plays out. Put that floor on its own row and use conditional formatting to highlight periods that fall below it.
Then test one realistic disruption. Move a large customer payment forward by two weeks, add an unexpected repair, or increase a supplier payment. Do not use the result to panic. Use it to identify which assumptions need attention first. A low projected balance can create useful options while there is still time: a collection follow-up, a deposit request, a changed purchase date, a discussion with a vendor, or a financing conversation before a last-minute crunch.
For a fuller worked example, see our four-week cash flow forecast example. It shows how a business can remain busy and still need to pay close attention to the exact week a receipt arrives.
When the forecast shows a gap, avoid making a rushed decision from one number alone. Look at the transactions driving it. Is the gap caused by a payment that can be moved, an invoice that should be followed up, a cost that is discretionary, or an obligation that needs to be funded differently? The spreadsheet is there to prompt those conversations while choices are still available. It is not a replacement for professional tax, lending, or legal advice when a decision calls for it.
Make the spreadsheet part of the weekly rhythm

A forecast becomes stale quickly when it is treated as a one-time project. Set a recurring appointment each week, ideally after the bank activity and invoices have been reviewed. Replace last week’s estimates with actual deposits and payments. Move the customer payment date when you have new information. Add the next week or month to the end of the schedule.
As you review, focus on the lowest projected closing balance instead of just the total at the end of the quarter. That low point is often where the decision lives. Add brief notes beside large changes. Over time, you will see whether late receipts, rising supplier costs, tax timing, or recurring spending is creating the same pressure again and again.
Give the review a simple order: reconcile the opening cash, update expected customer payments, update known bills and payroll, scan the lowest future balance, and decide whether anyone needs a follow-up. A 20-minute review that happens every week is more useful than a detailed model opened only when cash is already tight. Make the file part of the same operating rhythm as sending invoices, reviewing receivables, and approving payments.
If your books are current, this routine can be quick. If opening cash is unclear, invoices are not current, or the forecast keeps needing major corrections, begin with the records. Integra’s small business bookkeeping support can help build a dependable monthly rhythm, while bookkeeping cleanup services can help organize older activity before you rely on it for decisions.
Keep the spreadsheet useful, not perfect
The spreadsheet will be wrong sometimes. Customers change plans, costs rise, and unexpected opportunities arrive. That is not a reason to abandon it. It is the reason to keep it current. A forecast should become more useful as actual results replace earlier estimates and as you learn which assumptions tend to be optimistic.
Start simple, use truthful dates, and review the next decision before it becomes urgent. If you want a blank weekly layout before building your own, the cash flow forecast template shows a clear format. The aim is not a beautiful spreadsheet. It is a clearer view of what the business can do next.
Cash flow forecast spreadsheet FAQs
What should be included in a cash flow forecast spreadsheet?
Start with the actual opening cash balance, then list expected customer receipts and every planned payment in the period when cash is likely to move. Include totals for cash in and cash out, net movement, and a closing balance that carries forward into the next period.
Should a cash flow forecast be weekly or monthly?
Use the shortest period that helps you make a decision. A weekly view is usually more useful when payroll, customer collections, inventory, or tax payments can make one week very different from the next. A monthly view can help with longer-term planning. Many owners use both.
Is a cash flow forecast the same as a profit and loss statement?
No. A profit and loss statement records revenue and expenses for an accounting period. A cash forecast focuses on when money is actually expected to enter or leave the bank account. An invoice can be revenue before it becomes usable cash.
How often should I update my spreadsheet?
Review it at least weekly. Replace estimates with actual deposits and payments, move expected receipt dates when a customer gives new information, add another period at the end, and look for the next low point in the projected balance.




