How do I create a cash flow forecast?
A cash flow forecast projects your future cash position by estimating when money comes in and when it goes out. It’s different from your profit and loss statement. P&L shows revenue and expenses when earned or incurred. Cash flow tracks when money actually moves through your bank account.
Start with your current bank balance. That’s your baseline. Then list expected inflows over the coming weeks, including customer payments based on your AR aging, expected deposits, and any recurring revenue. Be conservative here. If your average customer pays in 45 days, don’t project they’ll suddenly pay in 15.
Next, list your expected outflows. Start with fixed expenses you know are coming, such as payroll, rent, insurance premiums, loan payments, and estimated taxes. Then add variable costs like vendor bills, materials, and subcontractors. The more thorough you are on the outflow side, the fewer surprises you’ll face.
Most small businesses use a 13-week rolling forecast. Thirteen weeks gives you enough runway to see problems coming while staying close enough to forecast with reasonable accuracy. Each week, update actuals for the prior week, adjust your projections, and add a new week at the end. Working with local bookkeepers who understand your business can help you build and maintain this rhythm without adding to your workload.
The format can be simple. A spreadsheet works fine for most businesses. Rows for each inflow and outflow category, columns for each week, with a running cash balance at the bottom. You’re watching for weeks where the balance drops too low or goes negative. Those are the warning signs you want to catch early.
For contractors and project-based businesses, tie your forecast to job schedules. When do you expect progress payments? When are material purchases due? When are subs getting paid? Matching cash movements to project timelines gives you much better visibility than general estimates.
The common mistake is building a forecast once and never touching it again. A forecast from two months ago doesn’t help you today. Weekly updates take about fifteen minutes and keep the projection useful. Our cash flow planning service includes weekly updates, variance tracking, and scenario testing so you can see what changed and plan accordingly.
The point isn’t perfect prediction. It’s seeing potential problems early enough to act. A good forecast tells you in week two that week seven looks tight. That gives you five weeks to speed up collections, delay a purchase, or arrange a credit line before you actually need it.
Greater Boston's Trusted Bookkeeping Partner
The Next Step:
A Short Conversation
We'll ask a few questions, figure out what you need, and give you a straightforward quote.
More Questions
Why does my business have cash flow problems?
Cash flow problems usually come from timing mismatches, not lack of profitability. Money is going out before it comes in. The most common causes are slow-paying customers, paying vendors too quickly, or seasonal revenue swings without reserves to cover the gaps.
Read answerHow often should a small business do bookkeeping?
Monthly is the absolute minimum for accurate books. Weekly transaction review catches errors while they're fresh and prevents the dreaded backlog. Most small businesses benefit from consistent monthly closes with weekly check-ins during busy periods.
Read answerShould I outsource bookkeeping or do it myself?
The answer depends on your transaction volume, how much your time is worth, and whether you'll actually keep up with it. DIY works for simple businesses that stay current. Most owners fall behind and end up paying more to fix the mess.
Read answerCan someone clean up my QuickBooks for me?
Yes. A bookkeeper who knows QuickBooks can reconcile your accounts, fix miscategorizations, and get your books current. Most cleanups take a few weeks depending on how many months are behind.
Read answerWhat's WIP reporting and do I need it?
WIP (Work in Progress) reporting shows whether your open jobs are making or losing money before they're finished. If you run multi-month projects with progress billing, you probably need it.
Read answerWhat does a bookkeeper do for a small business?
A bookkeeper records transactions, reconciles accounts, categorizes expenses, and produces financial statements that show how your business is actually doing. They keep your records accurate month to month so you have clarity on profits, cash flow, and what you owe.
Read answer