A step-by-step workshop on seeing cash crunches weeks before they hit, setting a reserve target and an owner pay number you can count on, and what to do when a red week shows up. It comes with the free 13-week cash flow tracker we build live.
Free Google Sheet. Enter your starting bank balance and the cash you expect in and out each week, and it charts your balance and flags the weeks you dip below your reserve target. Works best on a computer.
A 13-week cash flow forecast shows what your bank balance will be at the end of each week for the next quarter. You start with today's balance, add the cash you expect to land in the bank each week, subtract the cash you expect to leave, and carry the ending balance forward. Any week that drops below your reserve target is a red week, and you'll see it in time to do something about it.
Thirteen weeks is one quarter. It's long enough to see trends and plan big decisions like hiring or buying equipment, and short enough to stay accurate, because a business can change a lot in three months. Update it every week and roll it forward, so you always have a full quarter in view.
A cash flow forecast tracks money moving through your bank account, not income and expenses. Sending an invoice isn't cash in. Charging something to a credit card isn't cash out. The card payment is. That's why a forecast catches things your P&L doesn't: loan principal, tax payments, inventory, and owner distributions.
Customer payments, recurring subscriptions, collections on open invoices, interest, refunds you're owed, and any owner contributions or line of credit draws. A draw is cash in your account, even though it's debt.
Payroll with taxes and benefits, rent or mortgage, loan payments, income tax, sales tax and payroll tax payments, inventory purchases, major software, and owner distributions.
Utilities, insurance, marketing, equipment, and professional services. If you only want totals, one line for all other spending works fine.
In the live walkthrough, a business starting with $50,000 in the bank had one week where a $40,000 tax payment came due on top of normal expenses. That week's ending balance went negative. Nothing was wrong with the business. It was timing.
Paying that tax bill as four $10,000 payments instead of one lump kept every week positive. The business still spent the same total over the quarter, but it never ran out of cash. Seeing it weeks ahead is what turned a crisis into a small scheduling change.
Start with your baseline monthly cost: the expenses you have to pay to keep the business running, plus the minimum you need to pay yourself. Then:
| Stage | Reserve target |
|---|---|
| First milestone | One month of baseline costs, to cover the normal ups and downs |
| Long-term goal | Two to three months, to ride out seasonality, slow projects, or a bad market |
In the workshop example, baseline costs were $80,000 a month and the business had $50,000 in the bank. A three-month goal is $240,000, which is $190,000 away. The first milestone, one month, is only $30,000 away. The forecast shows which week you'll hit it.
Hold more in reserve if you're seasonal, project-based, growing fast, or wait a long time to get paid. You can hold less with predictable recurring revenue, fast payments, several revenue streams, or a long track record.
“The best time to get a line of credit is when you don't need it.”
Ian Hogan, from the workshopWhen you're in a crunch, you'll take whatever terms you can get. Be especially careful with loans that take a percentage of your revenue as it comes in. They can make next month's cash flow even tighter unless you put those payments in your forecast.
A business that pays its owner well is also the kind people want to buy, and lenders want to fund.
A red week is any week your forecast drops below your reserve target, or below zero if you don't have reserves yet. You have three levers.
Call your top five receivables yourself, and lead with curiosity, not blame. Offer a small discount for paying now. Set up automated reminders, and require bigger deposits on large projects.
Delay purchases that can wait. Ask vendors for longer terms. Most would rather work out a plan than chase you. Split bills that all land on the 1st, and spread out tax payments.
Sort spending into essential, important, and deferrable. It's also a good time to cut the expenses you no longer need, and to check whether your team costs line up with what they bring in.
A 13-week forecast is the close-up view. Line it up with your revenue by month over the past few years and a one-year projection, and you'll see whether a red week is a one-time timing issue or a crunch that comes back every October. If it comes back every year, start building reserves ahead of it.
This is a lightly edited transcript of the teaching portion of the workshop. We removed attendee names and the live Q&A with individual clients, and shortened the spreadsheet walkthrough.
Will: If you've been in business longer than three months, you've probably felt a cash crunch. We've looked under the hood of over 300 businesses, and I don't think there's one that hasn't dealt with one at some point. It's not that something is wrong with you or your business. It's almost inevitable when you're scaling.
Ian: We're never going to fully fix it. The goal is to recognize it as early as possible so we can make adjustments and enjoy the process, instead of it being stressful and painful. Today we'll cover why cash flow matters, build a 13-week rolling cash flow together, talk about setting smart reserves and an owner pay number, and then the red week playbook: what to do when you see negative weeks coming.
We've all had the stories. I remember the first time rent, payroll, and all the big expenses came out in one week, right after two or three of our biggest clients had left. Or a tax bill shows up on top of something else and you run to find a line of credit. Then there's seasonality. A lot of businesses are project-based or have huge summer or winter seasons. And there's growth that actually hurts your cash position, like tying up a lot of cash in inventory that you can't easily turn back into cash. On the flip side, if you know you'll have extra cash, you can prepay for things or buy in bulk at a discount.
Thirteen weeks covers a full quarter. It's long enough to see trends and plan ahead, but short enough to stay accurate, because a business can change drastically in three months. It shows when cash will be tight, when you have a surplus to invest, when to time major decisions, and your true cash runway.
This isn't a profit and loss statement. Cash in and cash out mean what literally came into or left your bank account. If you're used to accrual accounting, it's not when you send the invoice. It's when the money lands. Cash in includes customer payments, subscriptions, seasonal patterns, pipeline deals weighted by probability, interest, refunds, and contributions or line of credit draws, because those are cash in your account too. The tracker doesn't track debt or liabilities. It just shows what came in and what went out.
Be conservative on timing. Account for collection delays, because a payment might not hit your bank for three to seven business days. Factor in seasonal dips. Personally I'm very conservative: unless it's signed and the card has cleared, I don't count it as cash in. But if your history is consistent, you can use it.
Start with the big ones: payroll, rent or mortgage, and loan payments. Most P&Ls don't show principal payments going out, and that's what kills a lot of businesses. Then tax payments, quarterly estimates and sales tax, which usually aren't on your P&L either. Inventory purchases, unless you expense them. Major software. And owner pay. Distributions don't show up on your P&L, but they show up here. That's how an owner sees why they made $50,000 of net profit last month but only have $10,000 in the bank: a distribution, debt principal, and a big tax payment.
Use the actual dates these hit your bank account. If you don't like QuickBooks, just use your bank statement. Map payroll to the actual withdrawal dates, with all taxes and benefits, and account for holidays and bonuses. Do you pay quarterly estimated taxes or one lump sum? Sales tax monthly or quarterly? Some payroll companies hold payroll taxes for you and some don't. Put loan payments on their exact due dates, include balloon payments, and estimate variable rates. Align inventory purchases with when you're almost guaranteed to have cash, and account for payment terms like net 30.
Reserves are cash sitting in your account to cover you during tough times. Some people use lines of credit or credit cards as reserves. That can work for a stretch, but you're accruing interest and kicking the can. The goal is knowing how much you need and why, and making changes so it doesn't keep piling up.
You need more reserves with high seasonality, long customer payment cycles, variable project-based revenue, economic uncertainty, or rapid growth. You need less with predictable recurring revenue, fast customer payments, a stable mature business, and multiple revenue streams.
Will: What are the common knee-jerk reactions when someone hasn't built reserves and hits a crunch?
Ian: The best time to get a line of credit or a loan is when you don't need it, because that's when you get the best terms. When you really need it, you'll take worse terms. I've seen a lot of businesses use revenue-based loans that take a percentage of revenue right back out as it comes in. They can be helpful if you forecast for it. But some owners don't, and then they keep needing more money, because the loan makes short-term cash flow even tighter. The most common reactions are very high interest loans and running up credit cards.
Will: I also see people looking for an investor or a partner to inject cash, and when I ask if they want that, they say it seems like their only option. That's usually a symptom of not having done this work first.
Ian: As a rule of thumb, we like to see at least one month of expenses in active reserves to cover the normal ebbs and flows. Two to three months is solid once you're more mature, because when bigger seasonality or a strange market hits, you have time to step back and adjust. If you don't have reserves, you as the owner are the reserves. I always ask what helps you sleep at night, because that's when you make better decisions.
Pay yourself too little and you have personal cash flow problems. Pay yourself too much and the business has cash flow problems. Have a fixed base minimum that you need personally and include it in the forecast. Don't remove that first when things get rough. Look everywhere else first, because paying yourself nothing while working 80-hour weeks creates resentment. Add a variable bonus when you have a surplus, often quarterly. And account for the taxes on distributions and profit.
Will: Knowing your number lets you reverse engineer your sales targets. A revenue goal that isn't tied to a profit number that hits your personal income goal doesn't mean much. Sometimes an owner wants $3 million, and the math says $1.2 million hits their income goal. You take on all the responsibility and risk, and you deserve to be paid for it. And if you want to sell someday, would you buy a business where the owner doesn't make any money?
Ian: It breaks people's brains when you show them they could make less revenue and take home twice as much. We often scale right into paying ourselves less. And the highest price you'll get for your business is when it's so profitable you wouldn't want to sell it.
Enter the first day of the week, and the tracker fills in the next 13 weeks. Pick a day, like Sunday, and stay consistent. Enter your starting balance, what's in the bank on the day you start. That's extremely important. Then enter cash in for each week, using deposits from your bank statement or QuickBooks. Then cash out by category. Remember, you're not entering expenses. If you put something on a credit card, the credit card payment is the outflow.
The tracker charts your ending balance each week and turns red when it drops too low. In my example, I started with $50,000, and one week the ending balance went negative. What happened? A big tax payment. Is that a trend, or can I time it differently? If I split that $40,000 payment into four payments of $10,000, I'm still down over the quarter, but I never go negative. That one move changes everything. You'll also see things like the month with three payrolls if you pay every other week.
You can use it for what-ifs, too. If a big receivable might come in early, or you're thinking about a line of credit draw, add it to cash in and see what happens. If you're planning an inventory purchase, try it in different weeks and see where your ending balance stays where you want it.
For your reserve target, figure out what you'd need each month to pay all your baseline expenses and your minimum owner pay. Say it's $80,000. If you want three months of reserves, your target is $240,000. If you're starting at $50,000, you're $190,000 short, but only $30,000 short of your first one-month milestone, and the forecast shows when you'll hit it. It's called rolling because each week you update it and shift it forward.
Where do I get weekly cash-in numbers? If you have recurring revenue, total what's scheduled. If you invoice, look at how long customers usually take to pay and what's outstanding. Otherwise use history. In QuickBooks you can run a cash-basis P&L by week. If you're seasonal, use the same period last year, not last month. Or just list the deposits from your bank statement and look for patterns.
A red week means your balance is below your reserve number, or negative if you don't have reserves. Three levers. First, collections. Call your top five receivables. Offer small discounts for paying now. Call or email personally as the owner and lead with curiosity: is everything okay, how can we get you caught up? I can't tell you how often I've seen hundreds of thousands of dollars in receivables that the owner didn't want to deal with. It's your money. You already worked for it. Automated follow-up sequences help, and so does requiring larger deposits on big projects.
Second, timing. Delay non-essential purchases and negotiate longer terms with vendors. If a customer called you and said they were struggling and wanted a payment plan, you'd be glad they called. Your vendors feel the same way. Move discretionary spending to future weeks.
Third, expenses. List your essentials, your important expenses, and the ones you can defer. It's also a good time to check for expenses you can let go of. The hardest one is usually team: is the return sustainable for the team you have?
Will: If you're only looking week to week, a crunch might really be a seasonal pattern that happens every year.
Ian: We use a revenue trends tool that lines up revenue by service line over several years, and a one-year projection with what we call the “oh crap” line, the balance you don't want to drop below. Zoom in with the 13 weeks, zoom out with the year, and you'll know what's coming.
Our fractional CFOs build a 13-week cash flow forecast and a one-year projection for your business, update them with you every month, and help you set reserves and an owner pay number you can count on.
Book a Free Intro Call See our fractional CFO servicesIt's a week-by-week projection of your bank balance for the next quarter. Each week starts with the previous week's ending balance, adds the cash expected to arrive, and subtracts the cash expected to leave. It shows which weeks will be tight before they happen, and you update it every week so it always looks 13 weeks ahead.
Start with today's bank balance. For each of the next 13 weeks, list the cash you expect to land in the bank and the cash you expect to leave, including payroll, rent, loan payments, taxes, inventory, and owner distributions, using the dates the money actually moves. Subtract to get each week's ending balance and watch for weeks that drop below your reserve target.
Often it's timing, not profit. Big payments like payroll, rent, taxes, and loan payments land in the same week, customers pay late, or a lot of cash is tied up in inventory. Debt principal, tax payments, and owner distributions also don't show on your P&L, so a profitable month can still leave the bank account short. A weekly forecast shows those collisions ahead of time.
Start with at least one month of baseline costs, meaning the expenses you have to pay plus your minimum owner pay. Build toward two to three months, especially if your business is seasonal, project-based, growing fast, or slow to get paid.
Pull three levers. Speed up collections by calling your largest overdue customers and offering a small discount for paying now. Move the timing by delaying non-essential purchases, asking vendors for longer terms, and spreading out large payments. Then prioritize expenses into essential, important, and deferrable. If you're a contractor, our contractor cash flow forecast template is built for job-based businesses.