You do not need a complex model. You need one owner, a consistent cutoff, and a short weekly meeting that replaces estimates with actuals and turns the first projected shortfall into an action.
Why 13 Weeks Works For Near-Term Decisions
An annual budget explains the broad plan. A monthly forecast shows the expected shape of the year. A 13-week forecast answers a narrower question: Will available cash cover the obligations that arrive on specific dates? That makes it useful for collection priorities, vendor timing, hiring, owner draws, inventory purchases, and financing conversations. The FDIC/SBA cash-flow curriculum treats projection as a core part of managing the movement of money, not as an exercise reserved for large finance teams.
Set Up The Columns And Starting Cash
Create one column for each of the next 13 weeks. Start with cash that is actually available for operations. Exclude tax set-asides, restricted funds, customer deposits that cannot be used yet, and reserves protected by policy. Choose a minimum cash threshold that triggers action before the account approaches zero. Date the first column consistently, decide whether weeks end on Friday or Sunday, and document which bank accounts are included so the starting point does not change silently.
Use A Basic Row Structure
● Beginning cash, followed by expected customer receipts and other inflows.
● Total cash available, followed by payroll, taxes, debt, rent, vendors, inventory, and other outflows.
● Ending cash, which becomes the next week's beginning balance, plus a separate minimum-cash line.
Even when the forecast begins in a worksheet, free accounting software can provide cleaner starting balances and transaction history than rebuilding them from bank statements each week. The forecast should extend the books, not compete with them.
Forecast Inflows By Date And Probability
List open invoices by the week cash is realistically expected, not automatically by the due date. Consider the customer's approval process, normal payment pattern, disputed items, and deposit timing. Add recurring receipts, signed deposits, refunds, and other expected cash. Keep uncertain pipeline separate from committed work. In the base case, include only receipts supported by a clear event or a consistent pattern; flag everything else for a scenario. Add a short note beside large receipts showing the invoice, contact, approval step, and assumption behind the expected date. That evidence makes the weekly update faster and exposes optimism before it enters the total.
Forecast Outflows By Commitment And Flexibility
Enter payroll, payroll taxes, estimated income taxes, debt payments, rent, insurance, vendor bills, card payments, inventory purchases, subscriptions, and planned capital spending. Use the IRS estimated-tax guidance to verify current federal requirements and confirm state or local obligations separately.
Separate committed from discretionary Fixed or committed items have little short-term flexibility. Deferrable items may include optional equipment, experimental marketing, accelerated debt payments, or owner distributions. Do not quietly remove an outflow to make the forecast look better; move it only when someone has made and documented the decision.
Calculate Ending Cash And Find The Low Point
For each week, add inflows to beginning cash, subtract outflows, and roll the result forward. The important number is not the average balance but the first week below the minimum. If Week 5 ends at $18,000 against a $30,000 threshold, the model has identified a $12,000 gap and the time available to close it. Check formulas from beginning to end and reconcile the first week's starting cash to the books. Once the gap is visible, work backward from the low week: accelerate a collection, negotiate timing, reduce a flexible outflow, or arrange financing before the shortfall becomes urgent.
Add Base, Best, And Worst Cases
Change only assumptions that could alter a decision: a major payment arrives two weeks late, sales are lower than expected, or an inventory order must be paid earlier. Tie each case to a trigger. A delayed receipt might start a collection escalation, postpone equipment, or prompt a financing conversation. The Federal Reserve Small Business Credit Survey is a reminder that financing experiences vary; discuss options before the forecast becomes an emergency.
Update It In A Short Weekly Routine
● Replace forecast with actuals: Lock the completed week and explain material differences.
● Move dates when facts change: Do not leave an overdue receipt in the past or duplicate it in a future week.
● Add new commitments: Capture signed work, purchase orders, hires, tax notices, and approved spending.
● Assign actions: Name the person responsible for a collection call, vendor discussion, spending decision, or lender follow-up.
A 20-minute meeting is usually enough when the file is updated beforehand. Review the low point first, then the assumptions that moved it. Save a dated version so the team can learn which estimates are consistently optimistic or conservative.
Forecast For Decisions, Not Precision
The forecast does not need to predict every dollar. It needs to show the likely cash low point early enough for the owner to act deliberately. Keep the structure simple, update it every week, and connect each scenario to a real collection, spending, timing, or financing choice.
