Към основното съдържание
Beancount.io LogoBeancount.io

Rolling Forecasts vs. Annual Budgets: Why 13-Week Cash Forecasts Outperform Year-Long Predictions for Small Businesses

7 минути четенеMike ThriftMike Thrift
Rolling Forecasts vs. Annual Budgets: Why 13-Week Cash Forecasts Outperform Year-Long Predictions for Small Businesses

Your annual budget said June would be your best month. It is now March, a key supplier raised prices 12%, a client delayed payment by 30 days, and the forecast that was supposed to guide decisions is already a fiction. You have two choices: pretend the budget is still the plan, or build a forecast that learns every week.

For most small businesses, a rolling 13-week cash forecast beats an annual budget for the decision that matters most: will you have cash next month, and what can you do about it today? The budget still has a role, but it is not the cash tool.

The Budget Is a Contract; the Forecast Is a Weather Report

An annual budget is a static plan, usually built in Q4 for the next 12 months, approved by owners or a board, and used to set targets, compensation, and spending authority. It is valuable as a commitment: we will spend X on headcount, we will invest Y in inventory, we will price to achieve Z margin.

A rolling forecast is a dynamic view of expected cash inflows and outflows for the next 13 weeks (or next quarter), updated every week or every month, always looking forward the same distance. Next week, it still looks 13 weeks ahead — it rolls.

The difference is behavioral:

  • A budget that is wrong invites gaming: "We are over on marketing, so let's underspend next month to hit the annual number, even though the campaign is working."
  • A forecast that is wrong invites learning: "We missed collections by $18,000 — why, and what changes next week?"

Small businesses rarely fail because the annual budget was off by 5%. They fail because cash was off by 20% for three weeks in a row and no one saw it.

Why 13 Weeks

Thirteen weeks is a quarter, which maps to reporting, tax estimates, and most vendor and payroll cycles. It is also long enough to see a cash crunch coming and short enough that assumptions stay grounded.

  • Weeks 1–4: High confidence, tied to the receivables ledger, payables ledger, and payroll calendar. You know who owes you, who you owe, and when payroll hits.
  • Weeks 5–8: Medium confidence, tied to sales pipeline and purchase orders. Apply a probability weighting.
  • Weeks 9–13: Lower confidence, tied to seasonality and trend. Use a range, not a point estimate.

An annual budget tries to be precise at week 40. A 13-week forecast tries to be accurate at week 3 and honest at week 13.

Building a 13-Week Forecast From Your Ledger

You don't need a planning module. A spreadsheet driven by your Beancount or accounting ledger is enough if it is disciplined.

Week Zero: The Opening Balance Is Not a Guess

Start with the reconciled cash balance — bank, plus undeposited funds, minus outstanding checks. That number must tie to the ledger. If your forecast starts with the wrong cash, every later week is wrong.

Cash Inflows: Where the Money Really Comes From

1. Receivables by due date, not by invoice date. Export open receivables with due date, amount, and customer. Apply a collection probability based on history: a customer who pays on average in 32 days despite 30-day terms gets a two-day slip. A new customer gets a manual hold until credit is proven.

2. Recurring revenue at contract value. Subscriptions, retainers, and maintenance contracts at contracted amount and date. Do not gross up for expected upsell.

3. Other inflows: Tax refunds, loan draws, owner contributions, and asset sales — only when committed.

Do not include "expected sales" as a single line. Break it into pipeline stages: proposals sent, contracts signed, and only then as a scheduled collection.

Cash Outflows: The Payables and Payroll Truth

1. Payables by due date. Every vendor bill with a due date, plus recurring bills (rent, software, insurance) on their scheduled date.

2. Payroll with tax. Gross payroll plus employer taxes and benefits, on the actual pay date, not a smoothed monthly average. In a bi-weekly payroll, some months have three payrolls — that month's cash is not average.

3. Debt service and owner draws. Loan principal and interest on the due date, and owner distributions as actually planned, not as hoped.

4. Taxes and compliance. Sales tax remittance, payroll tax deposits, and estimated tax payments on their statutory dates. Missing a sales tax due date by a week in a 13-week forecast is a cash surprise you created.

Net weekly change: Sum inflows minus outflows. Cumulative cash = opening cash plus sum of net changes to date. The weekly net tells you when the crunch is; the cumulative tells you whether you survive it.

The Weekly Routine That Makes the Forecast Honest

A forecast that is not updated is just a budget with a shorter name. The routine is 30 minutes every Friday:

  1. Reconcile cash. Update opening balance to the bank's closing balance. If the ledger and the bank differ, fix the ledger first — otherwise you forecast from a fiction.
  2. Refresh receivables and payables. Close what was collected and paid this week, slip what didn't arrive, and add new invoices and bills.
  3. Compare to last week's forecast. For each week, record variance: forecast vs. actual collection or payment. That variance log is the forecast's memory — it shows which customers consistently slip and which vendors you consistently pay early.
  4. Choose one action. A forecast without a decision is trivia. If cumulative cash in week 6 goes negative, the action this Friday might be: call the customer with the largest past-due, delay a discretionary purchase, or draw on the line now while the rate is lower than a late fee.

Budget vs. Forecast: Keep Both, Use Each Correctly

The annual budget is not the enemy — the misuse of it is. Use each tool for what it is good at:

  • Budget: Annual spending authority, headcount planning, and performance vs. commitment. Review monthly, but change it only with intention — otherwise you hide variance.
  • Forecast: Near-term cash decisions, vendor and payroll timing, and loan covenant compliance. Update weekly, and let it change every week.

A practical pattern: In January, the forecast and the budget agree. By March, the forecast diverges because reality diverged. In the monthly review, explain the divergence in one paragraph: what changed, whether it is temporary or structural, and whether the budget needs a formal revision.

Bookkeeping Discipline the Forecast Depends On

A 13-week forecast is only as good as the ledgers that feed it:

  • Receivables and payables must be current. If invoices sit in a drawer or in an inbox and are not entered for a week, the forecast will miss the collection.
  • Bank must be reconciled weekly during forecast season. Monthly reconciliation is too slow when cash is tight.
  • Revenue must be recognized correctly: A customer deposit is deferred revenue, not available cash for spending without a future obligation. The forecast shows cash receipt when collected and revenue recognition separately if you track both.
  • One source of truth: Every inflow and outflow in the forecast ties to a ledger entry or a committed document (contract, purchase order, loan agreement). If it is not in the ledger or a committed file, it is not in the forecast.

When to Extend Beyond 13 Weeks

Once the 13-week routine is stable, adding a 26-week or 52-week high-level view can help with capacity and financing decisions: hiring, equipment purchase, or a new lease. Keep the 52-week view at monthly granularity and low precision — it is a scenario, not a commitment. The 13-week view remains the operating tool.

Keep Your Finances Organized From Day One

An annual budget tells you whether the year is going as planned. A rolling 13-week forecast tells you whether next month will. The businesses that avoid cash surprises run both, but they run the forecast every Friday without exception.

Beancount.io keeps the ledgers that make the forecast possible — receivables, payables, and cash — as version-controlled, reconcilable facts. Build the 13-week view from the ledger, update it from bank reality, and the budget becomes a plan you manage to, not a document you explain away. Get started for free and turn cash forecasting from a year-end event into a weekly habit.

Споделете тази статия