Stop Guessing About Next Month: How to Forecast Your Cash Flow in QuickBooks

Have you ever looked at your bank balance on a Tuesday morning and felt that tiny knot of anxiety in your stomach? You know you have money today, but you’re not entirely sure if you’ll have enough to cover payroll next Friday, the rent on the first, and that unexpected insurance premium that always seems to sneak up on you.

If you’ve ever said, "I think we’re doing okay, but I’m not sure what next month looks like," you are not alone. Most small business owners manage their business by "bank balance accounting": looking at the app on their phone and making a gut-call.

But gut-calls are for choosing what’s for lunch, not for running a sustainable company.

I’m Susan Hagen, and as a business coach and accountant, I’ve seen brilliant businesses fold not because they weren't profitable, but because they ran out of cash. Profit is what you see on paper at the end of the year; cash is the oxygen that keeps your business breathing today.

Today, we’re going to stop the guessing game. We’re going to talk about how to use QuickBooks to look into the future using cash flow forecasting.

The Difference Between Looking Back and Looking Forward

Before we dive into the "how," we need to clarify the "what." Most of the reports you run in QuickBooks are historical. Your Profit & Loss (P&L) statement tells you what happened last month. Your Balance Sheet tells you what you owned and owed as of yesterday.

Even the Statement of Cash Flows is usually a look in the rearview mirror. It explains where your cash went, which is great for taxes, but it doesn't tell you if you can afford that new hire in June.

A Cash Flow Forecast is different. It’s a projection. It’s a weather report for your bank account. It takes your current reality and maps out the next few weeks or months so you can see the "dry spells" before they arrive.

Step 1: Meet the QuickBooks Cash Flow Planner

If you are using QuickBooks Online (QBO), you have a built-in tool that many people completely overlook: The Cash Flow Planner.

You can usually find this in the "Cash Flow" menu on your left-hand sidebar. This tool is a game-changer because it pulls in your data automatically but allows you to play "what-if" without messing up your actual books.

The planner looks at your historical patterns: like when you usually pay your utility bills or when that one big client usually sends their ACH: and predicts your future balance. However, the tool is only as good as the data you give it. If you haven't been keeping up with your bookkeeping, the planner is going to give you a very blurry picture. (If you’re struggling with the basics, check out our guide on understanding the Profit & Loss report).

Step 2: The 13-Week Cash Flow Strategy

While the built-in planner is great, I often recommend that my coaching clients build or review a 13-week rolling forecast. Why 13 weeks? Because it covers exactly one quarter. It’s long enough to see trends but short enough that the data remains relatively accurate.

Here is how we build that forecast using QuickBooks data:

1. Account Receivables (A/R) Collections

First, run your A/R Aging Report. This shows who owes you money. But here is the secret sauce: Do not use the "Due Date" for your forecast.

If "Client A" has a net-30 invoice due on the 10th, but they consistently pay 15 days late every single month, you need to forecast that cash arriving on the 25th. Forecasting based on wishful thinking is how businesses get into trouble. Use reality-based dates.

2. Projected New Sales

Look at your sales pipeline. What deals are likely to close in the next 30, 60, or 90 days? Only include the ones you are reasonably sure about. If you’re a service provider, when will the deposit hit? If you’re in retail, what do your seasonal trends look like for the upcoming month?

3. Fixed Costs

These are the easy ones. Your rent, software subscriptions (like QuickBooks itself!), insurance, and loan payments. These should be plugged into the weeks they actually leave your bank account.

4. Accounts Payable (A/P) Payments

List the bills you currently owe. This is where you get to be strategic. If Week 7 looks like it’s going to be a bit tight because of a large inventory purchase, you might look at your Net-30 bills and see if you can strategically pay one in Week 8 instead.

Step 3: Rolling the Cash Forward

The magic of a forecast happens in the "roll." The ending cash balance for Week 1 becomes the beginning balance for Week 2.

If you start Week 1 with $10,000, collect $5,000, and spend $3,000, you end with $12,000. That $12,000 is now your starting point for Week 2. When you see this visualized over 13 weeks, you might notice that in Week 10, your balance drops to negative $2,000.

That’s not a failure; that’s a gift. Because you saw it 10 weeks away, you have two months to increase sales, delay a purchase, or follow up on late invoices to fix that negative number before it actually happens.

Step 4: Avoiding the "Automation Trap"

I love QuickBooks automation, but it can be a double-edged sword when it comes to forecasting. Many owners make the mistake of letting AI handle everything without a "human gut check."

For example, if you have your bank feeds automated, sometimes transfers between accounts are mislabeled as expenses, or vice-versa. If your data is messy, your forecast will be a work of fiction. We see this a lot with business owners who are making common QuickBooks automation mistakes.

Before you trust your forecast, make sure your "Actuals" (the data from the past month) are clean and reconciled.

Step 5: Planning for the "What-Ifs"

One of the best ways to use the forecasting tools in QuickBooks is for scenario planning. As a business coach, I often walk clients through these three scenarios:

1. The "Status Quo": What happens if everything stays exactly as it is today?

2. The "Worst Case": What happens if our biggest client leaves or that major project gets delayed by a month?

3. The "Growth Case": What happens if we hire that new account manager? Can we afford their salary for the three months it takes for them to become profitable?

Seeing these scenarios side-by-side takes the emotion out of the decision. Instead of "feeling" like you can't afford a new hire, you can "see" that you actually can, provided you keep your expenses under a certain threshold. This is a core part of strategic prioritization.

How Often Should You Do This?

Forecasting isn't a "one and done" task. It’s a habit.

• For high-growth or "tight" businesses: Update your forecast weekly. You need to know exactly where every dollar is moving.

• For stable, established businesses: A monthly review is usually enough.

The key is to designate a specific time on your calendar. I call it "Finance Friday." Spend 30 minutes looking at what actually happened last week versus what you predicted would happen. If your forecast was off, ask why. Did a client pay late? Did a "hidden" subscription hit the account?

Over time, you’ll get better at predicting these movements, and that "bank balance anxiety" will start to disappear. You’ll stop reacting to your business and start leading it.

Don't Navigate This Alone

If looking at these reports feels overwhelming, remember that you don't have to be a math whiz to master your cash flow. You just need a system and a little bit of guidance.

At Your Business Accountant, we specialize in turning the "scary numbers" into a clear roadmap for your business. Whether you need a virtual bookkeeping assistant to keep your data clean or a business coach to help you plan your next big move, we’re here to help.

Stop guessing about next month. Open QuickBooks, check out the Cash Flow Planner, and start taking control of your financial future today. If you see some financial red flags during your review, don't panic: reach out. The sooner you see the problem, the easier it is to fix.

Ready to level up your financial game? Check out our online programs or join one of our upcoming challenges to get your books: and your business( on the right track.)