Cash Flow Forecast Template for Service Business: 13-Week View

Why You Need a 13-Week Cash Flow Forecast

Imagine knowing exactly how much money will be in your business bank account each week for the next three months. That's what a 13-week cash flow forecast does for your service business. It’s not about guessing; it's about looking forward with clear eyes. Many business owners only look at their bank balance today, but that's like driving by looking in the rearview mirror. You need to see the road ahead, especially when unexpected bumps come up. This simple forecast helps you avoid those bumps. For an HVAC company, this could mean knowing if you’ll have enough cash to buy critical parts for a big job next month, or if you can afford to pay for that new truck you need. Without this view, you might make a decision today that causes a cash crunch next month, leading to stress and missed opportunities. It lets you plan for payroll, unexpected repairs, or even seasonal slowdowns before they become major problems. It's your financial roadmap for the near future, giving you peace of mind and control.

What is a 13-Week Rolling Cash Flow Forecast?

A 13-week rolling cash flow forecast is a simple tool that shows you your business's expected cash ins and outs for the next 13 weeks, and you update it every single week. "Rolling" means that each week you complete, you add a new week to the end of your forecast. So, you always have a 13-week view into the future. This keeps your view fresh and relevant. Think of it like this: if you have a business loan payment of $2,000 due in Week 5, but you only expect $1,500 in payments from customers that week, your forecast will flag a problem. This gives you four weeks to find another $500, either by speeding up customer payments or delaying a non-essential expense. It's different from a profit and loss statement because it focuses only on *cash*. Your profit might look great on paper, but if customers aren't paying quickly, you could still run out of cash. This forecast is all about real money in your bank account, not just what you've earned or spent on paper.

Building Your Simple 13-Week Template

You don't need fancy software to get started. A simple spreadsheet works best. Create columns for each of the next 13 weeks, labeled 'Week 1,' 'Week 2,' and so on. Then, create rows for your starting cash, all your cash coming in, and all your cash going out. It's that simple. Here's a basic outline: * **Row 1: Starting Cash Balance.** This is how much money you have in the bank at the start of Week 1. * **Cash In (Income):** List all the ways money comes into your business. * Customer payments (from completed jobs, service contracts, etc.) * New loans or lines of credit (if expected) * Other income (e.g., selling old equipment) * **Cash Out (Expenses):** List every payment your business makes. * Payroll (including taxes and benefits) * Rent/Lease payments * Utilities (electricity, gas, water) * Material costs/Parts for jobs * Subcontractor payments * Loan payments * Insurance * Marketing/Advertising * Vehicle fuel and maintenance * Office supplies * Other expenses (e.g., professional fees, equipment repairs) Underneath, add a row for **Net Cash Flow (Cash In - Cash Out)** for each week, and then an **Ending Cash Balance (Starting Cash + Net Cash Flow)**. The Ending Cash Balance of Week 1 becomes the Starting Cash Balance for Week 2, and so on. Keep it focused only on money touching your bank account.

Forecasting Your Cash In: Be Realistic, Not Hopeful

When you predict money coming in, be honest with yourself. It's easy to be overly optimistic, but that will lead to problems. For a service business like HVAC, most of your cash comes from customer payments. Look at your past billing and payment habits. If customers usually pay 30 days after you finish a job, then a job completed today won't bring cash in for a month. Don't count a sale as cash until you expect it to actually hit your bank account. Here are some tips for predicting cash in: * **Current Invoices:** List all outstanding invoices and their due dates. Adjust for how quickly customers *actually* pay, not just the due date. For example, if you have $10,000 in invoices due next week, but usually only collect 80% on time, forecast $8,000 for next week. * **Scheduled Work:** If you have jobs scheduled for future weeks, estimate when those payments will arrive. Be conservative. If a job is estimated at $3,000, and you get 50% upfront, forecast $1,500 when you expect it. * **Recurring Revenue:** If you have service contracts, predict those payments precisely. * **Historical Trends:** Look at your previous years. Did revenue drop in the winter months? Build that into your forecast. If your busy season brings in $50,000/week but the slow season only $20,000, reflect that.

Forecasting Your Cash Out: Don't Forget the Small Stuff

Predicting cash going out is often easier because many expenses are fixed or predictable. Start with the big ones and then dig into the smaller, but equally important, costs. Missing just one regular payment can throw off your whole forecast. Always assume you'll pay on time, or even early if you get a discount. Here’s how to predict your outflows: * **Payroll:** This is usually your biggest outflow. Include salaries, hourly wages, and all payroll taxes. If you pay bi-weekly, make sure to show those two big payments in the right weeks. Example: For a team of 5 techs earning $25/hour for 40 hours, plus 2 office staff at $2,000 bi-weekly, your bi-weekly payroll could be around $14,000 including taxes. * **Rent/Mortgage:** A fixed monthly cost. Divide by four to get a weekly average if needed, or put the full amount in the week it's due. * **Utilities:** Look at past bills. They might fluctuate seasonally. Average them out or use the actual bill due dates. * **Supplier Payments:** If you get parts on credit, when are those bills due? If you pay cash for materials, estimate based on your planned jobs. * **Loan Payments:** Exactly when are they due and for how much? * **Taxes:** Don't forget sales tax, quarterly estimated taxes, or other regular tax payments. These can be huge and often overlooked. * **Owner's Draw/Salary:** Be sure to include your own pay or distributions.

Making Decisions with Your Daily Cash View

Imagine it's Monday morning. You get your daily brief showing your upcoming cash position. This brief doesn't just show you today's bank balance; it highlights your 13-week forecast, pointing out any weeks where your ending cash might dip too low. Let's say your forecast alerts you that in Week 7, your cash balance is predicted to fall to $1,500, and your minimum safe cash balance is $5,000. This is a red flag! Without the forecast, you might not know about this problem until Week 6, leaving you scrambling. With the alert in Week 1, you have six weeks to act. What decision does this change? * **Collect Faster:** You might call customers with overdue invoices and offer a small discount for immediate payment. Getting $3,000 in early payments by Week 4 could solve the problem. * **Delay Spending:** You might hold off on ordering that new diagnostic tool for $2,000 until Week 9, after the cash crunch passes. * **Negotiate Payment Terms:** You could talk to a supplier about extending terms on a large parts order due in Week 6, pushing the payment out to Week 8. * **Boost Sales:** You could run a small promotion in Weeks 2-4 to bring in more high-margin service calls, aiming to bring in an extra $3,000-5,000 in cash by Week 5. This early warning allows you to proactively adjust, rather than react in a panic. It moves you from guessing to knowing, transforming financial problems into solvable puzzles.

Review and Update: Keep It Rolling

The 'rolling' part is key to keeping your 13-week forecast useful. Each week, after the week you just completed has passed, you simply update your spreadsheet. Look at what *actually* happened last week compared to what you *expected*. Did more money come in? Did less go out? Use this information to make your predictions for the remaining 12 weeks even better. Then, add a new Week 13 to the end of your forecast. This way, you always have a fresh 13-week outlook. For example, if you expected to collect $8,000 from customers last week but only got $6,000, that tells you something. Maybe your collection process needs work, or your estimates for future collections need to be more conservative. If you expected to spend $500 on office supplies but only spent $200, that's good news for your cash balance. Use these real numbers to tweak your predictions for future weeks. This weekly review takes a short amount of time but gives you massive clarity and control. It’s not a set-it-and-forget-it tool; it’s an active guide that gets smarter with every update you make.

Beyond the Basics: What Your Forecast Can Tell You

Once you get comfortable with your basic 13-week cash flow, it becomes much more than just a warning system. It becomes a powerful tool for growth and smart business decisions. Here are a few ways it can help: * **Identify Growth Opportunities:** If your forecast consistently shows you'll have a surplus of $10,000 for several weeks, it might be time to invest. Can you afford that new piece of equipment, hire another technician, or launch a new marketing campaign? * **Manage Working Capital:** This helps you see if you have enough money to cover your day-to-day operations. If your forecast shows you're constantly scraping by, it might indicate you need to adjust your payment terms with customers or suppliers, or explore a line of credit. * **Prepare for Seasonal Swings:** Many service businesses have busy and slow seasons. Your forecast can clearly show you when cash will be tight during slow periods, allowing you to save during busy times or plan for alternative revenue streams. * **Assess Impact of Big Purchases:** Thinking about buying a new work van for $60,000? Plug that large outflow into your forecast and see how it impacts your cash over the next 13 weeks. This helps you decide if now is the right time, or if you need to secure financing first. Your cash forecast isn't just about avoiding problems; it's about seeing opportunities and making confident, informed choices that drive your business forward. It's your compass for navigating the financial landscape of your service business.

Minimum Cash Balance: Your Financial Safety Net

A critical part of your cash flow forecast is setting a

• If your bank balance gets too low, it can trigger fees, declined payments, and lost trust with suppliers.
• A good rule of thumb for a service business is to have at least 1-2 months of operating expenses in cash. If your monthly expenses are $20,000, aim for $20,000-$40,000 in your bank account.
• Some businesses use a fixed dollar amount, like $10,000 or $20,000, as their safety net.
• Look at your historical lowest cash points. Your minimum should be higher than those to avoid past problems.

Bringing It All Together with Your Virtual CFO

Building this forecast manually is a great start, but keeping it updated every week can take time. This is where having a virtual CFO comes in handy. While you focus on running your business, they help keep your cash flow forecast current, often pulling data directly from your QuickBooks. Instead of just a spreadsheet, imagine getting your daily Morning Brief. This brief doesn't just show you your bank balance; it shows you your projected cash for the next 13 weeks, highlighting any potential shortfalls or surpluses. Your virtual CFO can then help you interpret these numbers. For example, if your forecast shows a cash dip in Week 7, your virtual CFO won't just tell you there's a problem. They'll work with you to explore solutions, like:

• How can we speed up collections from customers?
• Should we delay a non-essential payment?
• Is a short-term line of credit an option if needed?
• Can we pull forward some higher-margin service calls to boost cash?
• What are the long-term impacts of these decisions on your profit and growth?

Questions people ask