How to Build a 13-Week Cash Flow Forecast for Your Small Business

A 13-week cash flow forecast is a week-by-week projection of the cash coming into and going out of your business over the next quarter. It starts from your actual bank balance, not your profit, and you roll it forward one week at a time. Its only job is to show you a cash shortfall early enough to do something about it.

The timing is worth pointing out. Start one the last week of September and it runs through the last week of December. That covers the holiday slowdown, year-end bills, bonuses if you pay them, and whatever January brings. If there is a quarter to see clearly in advance, it is this one.

Why 13 Weeks, and Why Weekly?

Thirteen weeks is one quarter. It is long enough to see a problem while you still have options, and short enough that the numbers are grounded in invoices and bills you can actually see instead of guesses about next summer.

Weekly matters because cash problems happen inside the month. A monthly view can show October ending fine while hiding the week in the middle where payroll clears before your two biggest customers pay. If you run biweekly payroll, two months a year have three paydays instead of two. A monthly budget rarely catches that. A weekly forecast makes it obvious.

What You Need Before You Start

Pull these together first. If any of them are hard to find or you do not trust them, that is useful information on its own.

• Your actual bank balance in every operating account, as of the day you start.
• Accounts receivable aging: who owes you, how much, and how late they usually pay.
• Accounts payable: bills you owe and when they are due.
• Your payroll calendar, including payroll taxes and any benefits deducted on a schedule.
• Recurring expenses: rent, insurance, software, utilities, vehicle and equipment payments.
• Credit card due dates and balances.
• Loan payments and any line of credit activity.
• Known one-offs: estimated tax payments, annual renewals, planned equipment purchases, owner draws.

All of this comes out of clean books. If your receivables list is wrong or your bills are not entered, the forecast will be wrong in exactly the places that matter. Our small business bookkeeping guide covers what needs to be in place.

How to Build It, Step by Step

1. Set up 13 columns, one per week. Label each by the Monday it starts. A spreadsheet is fine. Most small businesses are better served by a spreadsheet they understand than a tool they do not.
2. Enter opening cash for week one. Use the real bank balance, not the number on your balance sheet from last month.
3. Forecast cash in. Go through your receivables and put each expected payment in the week you think it will actually arrive. Use how each customer really pays, not your payment terms. If a customer on net 30 always pays in 45 days, forecast 45. Add new sales conservatively, and only when you have a real basis for them.
4. Forecast cash out. Payroll on its actual dates, rent on the first, card payments on their due dates, bills when you plan to pay them, loan payments, taxes, and owner draws. Owner draws are the line people most often leave out.
5. Calculate each week. Opening cash, plus cash in, minus cash out, gives you ending cash. Each week's ending cash is the next week's opening cash.
6. Draw a floor. Decide the lowest balance you are willing to carry. One full payroll plus a cushion is a reasonable starting point. Flag every week that dips below it.

What It Looks Like

Here are the first five weeks of a forecast for a hypothetical service business with a biweekly payroll of $18,000 and a $25,000 cash floor. The numbers are illustrative, but the pattern is real.

Week of	Sep 28	Oct 5	Oct 12	Oct 19	Oct 26
Opening cash	$42,000	$31,500	$37,200	$33,700	$35,900
Customer payments	+$16,000	+$11,000	+$19,000	+$9,000	+$14,000
Payroll	−⁠$18,000	$0	−⁠$18,000	$0	−⁠$18,000
Rent, software, insurance	−⁠$5,500	−⁠$800	−⁠$800	−⁠$800	−⁠$5,500
Suppliers and card payments	−⁠$3,000	−⁠$4,500	−⁠$2,500	−⁠$6,000	−⁠$3,000
Equipment loan	$0	$0	−⁠$1,200	$0	$0
Ending cash	$31,500	$37,200	$33,700	$35,900	$23,400

Nothing in October looks alarming on its own. Sales are steady and the P&L for the month would probably look fine. But October has three paydays, rent hits twice inside the five-week window, and by the week of October 26 the business is $1,600 under its floor with November still ahead. The forecast shows that in late September, which leaves four weeks to fix it. The bank balance would have shown it on October 30.

How to Use It Every Week

The forecast is only useful if it stays current. Set aside 20 to 30 minutes every Monday:

• Replace last week's forecast numbers with what actually happened.
• Add a new week thirteen at the end so you always see a full quarter ahead.
• Update expected customer payments based on what came in and what did not.
• Check every week against your floor.

Comparing forecast to actual is where you learn the most. After a month or two you will know which customers pay late, which expense lines you always underestimate, and how much of your forecast is guesswork. The forecast gets more accurate because you do.

What to Do When It Shows a Gap

A forecast that does not change a decision is just a spreadsheet. When a week drops below your floor, work through the options roughly in this order:

1. Collect faster. Call on overdue invoices now, not when you are short. Ask for deposits on new work. Tighten terms for customers who habitually pay late. Our post on automating invoicing to get paid faster covers the systems side.
2. Move payables with permission. Vendors are far more flexible when you ask three weeks ahead than when a payment bounces.
3. Delay discretionary spending. Equipment, software upgrades, and new commitments can often move a month.
4. Line up financing before you need it. A line of credit is much easier to open when the numbers look healthy than in the week you are short.
5. Adjust owner draws. Not ideal, but it is the lever you fully control.

Common Mistakes

• Starting from profit instead of cash. Revenue you have invoiced is not cash until it clears. This is the same gap behind being profitable on paper with no cash in the bank.
• Using payment terms instead of payment behavior. Your terms are what you asked for. The forecast needs what actually happens.
• Forgetting the lumpy bills. Annual insurance, yearly software renewals, estimated tax payments, and year-end bonuses do not show up in a typical month, which is exactly why they cause problems.
• Being optimistic about new sales. Forecast the work you have. Treat new business as upside, not the plan.
• Building it once. A forecast you do not update becomes wrong within a few weeks.

When to Get Help

If your books are not current, start there. A forecast built on unreconciled accounts and a receivables list you do not trust is a precise-looking wrong answer. That is bookkeeping work, and it comes first.

If the books are clean and you want someone to build the forecast, keep it current, and tell you what it means before you make a decision, that is what a fractional CFO does. If you are not sure which role you are missing, we wrote a breakdown of bookkeeper vs. accountant vs. fractional CFO.

Frequently Asked Questions

Is a cash flow forecast the same as a budget?

No. A budget is a plan for revenue and expenses, usually monthly and usually for a year. A cash flow forecast tracks actual cash, week by week, for a shorter window, and it changes every week as reality comes in. You want both, but the forecast is what keeps you out of trouble.

How long does it take to build a 13-week cash flow forecast?

The first version usually takes a few hours, mostly spent gathering receivables, bills, and recurring expenses. After that, the weekly update takes 20 to 30 minutes if your books are current.

Can I build it in QuickBooks?

Your accounting software is the source for receivables, bills, and recurring expenses, and some tools offer a cash projection. Most small businesses still get more out of a simple spreadsheet fed from clean books, because they can see and adjust every assumption.

What is a good minimum cash balance for a small business?

There is no universal number. A practical starting floor is one full payroll plus your fixed monthly bills. Businesses with seasonal revenue or slow-paying customers usually need more.

If you want help getting your first forecast built, or want to know whether your books are ready for one, let's talk. We work with small businesses across Long Island and remotely.