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
How do I track inventory for my retail business?
Use a point-of-sale system with inventory features, set up every product with accurate costs and reorder points, and do regular physical counts. Connect your POS to your accounting software so inventory and financials stay in sync.
Read answerHow do I track project costs and profitability?
Set up your accounting software to assign every expense to a specific project. Track labor, materials, and subcontractor costs separately, then compare actual costs to your estimate while the work is still in progress.
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 reports do contractors need from their bookkeeper?
Contractors need job profitability reports, work in progress (WIP) reports, accounts receivable aging, and cash flow forecasts at minimum. These reports show which jobs make money, where you stand on billing, and whether you can cover upcoming expenses.
Read answerMy books are a disaster—where do I start?
Start by gathering all bank and credit card statements, then reconcile accounts month by month before worrying about categorization. Focus on the most recent tax year first if you're behind multiple years.
Read answerWhat's the difference between profit and cash flow?
Profit is revenue minus expenses according to accounting rules. Cash flow is money actually moving through your bank account. They diverge because of timing differences in collecting revenue, paying bills, and debt or equipment purchases that affect cash but not profit.
Read answer