10 Cash Flow Forecasting Template Excel Resources

A polished cash flow forecasting template in Excel won’t automatically give an HVAC, plumbing, electrical, or roofing company reliable cash visibility. A historical cash flow statement tells you what already happened. A monthly projection organizes expected receipts and payments across a longer planning horizon. A rolling 13-week forecast answers the operational question that usually matters most: will the company have enough cash when payroll, taxes, suppliers, debt, or an equipment purchase comes due?

That distinction determines which workbook deserves your time. The useful comparison isn’t about colors, dashboards, or how many tabs a download contains. It’s about cadence, input detail, adaptability to trades operations, documentation, and the decisions the model can support. Microsoft’s current guidance frames a cash flow template around a start date, opening cash balance, income sources, fixed expenses, variable expenses, and a selected timeline, with Copilot support for analysis in Excel. That makes the template a structured planning tool, not merely a blank worksheet. Microsoft’s cash flow forecasting guidance reflects that continuing shift toward editable, reviewable forecasting workflows.

The resources below are ranked by the job they need to perform. Some are best for a quick diagnostic, some for a lightweight weekly tracker, some for lender-ready planning, and others for building a customized operating model. The strongest choice depends on the cash question you need answered now.

1. Cash Flow Scorecard for Home Services

The Cash Flow Scorecard from Profit & Grit CFOs isn’t an Excel workbook. That’s precisely why it belongs at the top of this list. Before choosing formulas, you need to know whether the business has a forecasting problem, a data problem, a process problem, or all three.

The free, self-serve scorecard uses 15 focused questions and produces a concise one-page readout. Its value is diagnostic rather than computational. It helps an owner identify which weaknesses deserve attention first, including gaps in weekly cash visibility and the operating pressures that can make payroll, tax, or equipment decisions uncomfortable.

For a home-service company, that focus is more useful than downloading another generic template and assuming the numbers are trustworthy. A forecast built on incomplete books, inconsistent job classifications, or unreliable collections data can create false confidence. The scorecard’s recommendations connect forecasting with practical remediation, including corrected source data, accounting cleanup, and a path toward a 13-week model.

Best fit for a trades operator

Profit & Grit CFOs specializes in HVAC, plumbing, electrical, and roofing businesses, so the diagnostic is aligned with field operations, labor timing, job costing, and the relationship between ServiceTitan and QuickBooks. It’s particularly relevant for operators who need immediate clarity before committing to a larger forecasting process.

Pros

• Fast assessment: The scorecard takes a self-serve approach and returns a one-page readout.
• Prioritized actions: Recommendations point toward weekly cash visibility instead of vague financial advice.
• Trades-specific context: The questions reflect payroll, tax, equipment, field operations, and job-costing pressures.
• Clear implementation path: It connects naturally with Profit & Grit CFOs’ practical conversation about fixing cash flow and its broader CFO services.

Cons

• Not a forecasting workbook: It identifies priorities, but it won’t build or maintain the forecast for you.
• Input-dependent: Messy books or missing information can limit the depth of the readout.

Use the scorecard when you’re unsure what to fix first. It can prevent a common mistake, customizing a spreadsheet before establishing whether the underlying data and weekly workflow can support it.

Visit the Cash Flow Scorecard

2. Microsoft Excel Small Business Cash Flow Forecast Templates

Excel is a practical starting point when the finance lead and operating managers already work in spreadsheets. Microsoft’s small-business cash flow forecast and projection workbooks use standard formulas, run online or on desktop, and support shared review through the Microsoft ecosystem. Users can enter opening cash, receipts, expenses, and ending balances without adopting another forecasting platform.

The trade-off is that familiarity does not make a generic workbook operational. A service contractor must adapt the file to the timing of cash events, not just record monthly totals. Separate customer collections from invoices issued, schedule payroll on actual pay dates, give tax payments their own rows, and show equipment or vehicle purchases as distinct disbursements.

Match the workbook to the job

Use this option for a monthly projection, a planning file, or a clean starting structure for inflows and outflows. Microsoft’s financial-management templates provide the broader collection, including files that organize income, fixed expenses, variable expenses, opening cash, and ending balances across a selected timeline.

For HVAC and plumbing companies, the rows should distinguish deposits, completed-job collections, supplier payments, payroll, and tax remittances. Electrical contractors may need progress billings and equipment purchases separated from routine operating costs. Roofing companies often need collection timing that reflects different job types. The workbook cannot make those distinctions until someone defines them and maintains the source data.

A weekly process also requires manual redesign. Convert monthly columns into weekly periods, add a rolling 13-week view, and tie each line to a source that the accounting or field team can verify. That extra work improves visibility, but it creates maintenance responsibility and increases the chance of formula or data-entry errors.

Practical rule: Treat Microsoft’s workbook as a clean shell. Rebuild its rows around payroll, taxes, job costing, equipment, and customer cash events.

Pros

• Familiar format: Existing Excel users can begin without learning a new interface.
• Shared review: Online editing and OneDrive sharing support manager review.
• Simple formulas: Basic operation does not depend on macros.

Cons

• Generic categories: Trade-specific job and payment timing requires customization.
• Monthly orientation: A weekly forecast must be added and maintained manually.
• Data quality exposure: Incorrect invoice status, pay dates, or opening cash will distort the result.

Use Microsoft’s option when the immediate need is a credible baseline. A related hiring ROI calculator for service-business decisions can connect staffing decisions with cash planning.

3. Smartsheet Free Cash Flow Forecast Templates

Smartsheet is most useful when the task is choosing a model shape, not downloading a finished trade-specific forecast. Its library includes Excel files for simple cash flow forecasts, small-business projections, and longer monthly planning. The templates cover receipts, disbursements, and ending cash, while the accompanying explanations clarify how the workbooks are structured.

Use the collection to compare jobs a forecast must perform. A monthly planning sheet can expose seasonality. A statement-style layout can organize cash movement. A short-term model can support immediate payment decisions. The Excel files work independently, although some pages also promote Smartsheet’s software.

For an HVAC, plumbing, electrical, or roofing company, the useful step is conversion. Replace generic rows with customer collections, payroll by pay group, supplier bills, tax remittances, equipment purchases, debt service, and owner distributions. Convert monthly columns into weekly periods, add a rolling 13-week view, and assign each line to a source the accounting or field team can verify. This creates a usable weekly process, but it also introduces formula maintenance and data-entry risk.

Collection timing needs its own design. A roofing company may separate storm work from retail work. An electrical contractor handling project-based jobs may track deposits, progress billings, retainage, and final collections separately. The workbook cannot distinguish these events until the operator adds the rows and maintains accurate job status.

Rather than treating every file as interchangeable, match it to the decision:

• Simple forecast: useful for a first cash schedule and basic receipts and payments.
• Small-business projection: a better starting point for recurring payroll, suppliers, taxes, and operating costs.
• Longer monthly plan: useful for seasonal capacity and equipment planning, but it needs redesign before weekly use.

The main trade-off is flexibility versus maintenance. Documentation lowers setup friction, while generic categories leave job costing and phase-level cash timing to the user. Some pages also market Smartsheet even though the Excel downloads can be used separately.

Smartsheet fits a finance lead who is still selecting the right structure. Before finalizing assumptions, compare them with Profit & Grit CFOs’ home-services benchmark report, then test whether the weekly forecast supports payroll, taxes, equipment decisions, and collection follow-up.

4. Vertex42 Cash Flow Statement Template

Vertex42 fits a reporting job first. Its statement-oriented foundation uses the indirect method and separates operating, investing, and financing activities. Explanatory comments, protected cells, and compatibility with Excel and Google Sheets give the workbook more structure than a basic inflow-and-outflow grid.

That design helps an owner review how accounting records present cash movement. It can also sit alongside other Vertex42 financial statement templates. The trade-off is that clear accounting categories do not automatically produce a usable weekly cash schedule for a service business.

Reworking a statement for weekly decisions

The workbook is historical by default, not a short-term liquidity model. It can explain past cash movement, but it will not tell an HVAC, plumbing, electrical, or roofing manager whether next week’s payroll, taxes, materials, subcontractors, or equipment payments fit the bank balance.

Adapting it requires forward-looking periods, expected receipts and payments, and a closing balance that carries into the next opening balance. Add rows for customer collections, supplier timing, job costs, and equipment purchases where the standard classifications hide operational detail. Mark each value as actual or assumed, then lock completed periods so later edits do not blur the record.

This approach works when financial reporting is the immediate task. It takes more maintenance when the goal is a weekly operating process.

Choose Vertex42 for a clean statement review. Choose another workbook, or redesign this one, when the decision concerns near-term cash timing.

Advantages

• Strong spreadsheet design: Layout and documentation give Excel users a structured starting point.
• Clear classifications: Operating, investing, and financing sections support accounting review.
• Compatibility: The workbook can suit teams working in Excel or Google Sheets.

Limitations

• Backward-looking default: It needs edits before supporting forward cash decisions.
• No weekly liquidity view: A 13-week operating forecast must be built separately.

For a trades company, the adapted version should reconcile to the books while tracking collection dates, payroll, taxes, vendor bills, and equipment commitments separately. That keeps the statement useful for reporting without mistaking recorded revenue for available cash. Review the Vertex42 cash flow statement template.

5. QuickBooks Free Excel Cash Flow Statement Template

QuickBooks’ Excel template is built for a reporting job, not a weekly dispatch meeting. It suits companies already using QuickBooks that need a familiar way to present historical cash movement. The downloadable file includes an example tab and plain-English instructions, giving an owner or office manager a workable starting point without requiring an accounting background.

Its main advantage is alignment with existing records. When bank activity, books, and reporting categories already sit in QuickBooks, the workbook can organize operating, investing, and financing activity for review. That makes it useful for explaining results to an owner who wants the financial story without working through a complex planning model.

A monthly statement can still hide a cash problem. An HVAC company may show strong billed revenue while waiting on commercial collections. A plumbing or electrical contractor may have payroll, tax deposits, materials, subcontractor invoices, and equipment payments due before those customer receipts arrive. The template records or presents cash activity, but it does not schedule those future movements for you.

Use a separate weekly grid if the operating decision is, “What can we pay over the next few weeks?” Enter expected customer receipts by likely collection date, then list payroll, taxes, vendor bills, job costs, and equipment commitments on their expected payment dates. Mark each item as actual, committed, or assumed, and reconcile completed weeks to QuickBooks. Data quality matters more than a polished format. An invoice should not enter forecasted cash until its collection timing has a defensible assumption.

The example tab helps non-finance users learn the intended structure, while the standard presentation supports accounting conversations. The trade-off is maintenance: a direct-method weekly process requires additional inputs and regular updates.

Treat it as an accounting foundation, not the company's only cash-control workbook. Download the QuickBooks cash flow resource.

QuickBooks also produces the report natively, and it is more useful than the template for understanding a month that already happened. Here is how to run and read it.

6. SCORE Cash Flow Projection Model

SCORE's cash flow projection model serves a planning job, not immediate dispatch-day control. Its connected sheets tie revenue, cost of goods sold, payroll, capital expenditures, and owner draws to monthly cash summaries. That structure can support a lender package or an internal growth plan, provided the inputs have clear owners and reliable source data.

A roofing contractor planning equipment purchases can separate the purchase from the related financing assumptions. A plumbing company evaluating a hire can model added payroll and expected revenue. An electrical firm preparing for financing can show how operating assumptions affect cash over time. These are useful planning questions, but they differ from deciding which bills can be paid this week.

Where the model fits

The workbook is more detailed than a basic tracker, so setup takes time. It is better suited to monthly planning and statement-oriented review than to a service manager who needs a quick weekly balance. SCORE chapters and downloads may also vary, which means the user should inspect the formulas, tabs, and category definitions before connecting the file to an existing reporting process.

For HVAC, plumbing, electrical, and roofing companies, the practical adaptation is to keep SCORE for the plan and build a weekly control layer beside it. Convert projected sales into expected collections, separate labor, materials, subcontractors, payroll taxes, equipment, and owner draws, then assign each cash movement to the week it should occur. The monthly model can show whether a growth plan works. The weekly layer shows whether payroll or a supplier payment creates a near-term shortfall.

A detailed workbook earns trust only when assumptions have an owner and completed periods can be reconciled to accounting records.

• Connected schedules: Revenue, COGS, payroll, CapEx, and owner draws roll into cash summaries.
• Planning depth: The structure supports financing and growth conversations.
• Broader business view: Several operating drivers can be modeled in one file.
• Operational drawback: Its setup and monthly orientation can slow weekly decisions.
• Version variation: Different SCORE downloads may not use identical structures.

Use SCORE when the question is how the business will fund a longer-range plan. Open SCORE's cash flow projection model Keep a separate weekly schedule when collection timing, payroll, taxes, job costs, or vendor commitments require closer control.

7. Xero Free Cash Flow Forecast Template

Xero's standalone Excel cash flow forecast is useful when the immediate job is to start forecasting without adopting a full accounting system. Its inflow-and-outflow layout, basic categories, and independent file give an owner a workable first version.

The trade-off is planning depth. Opening cash, expected receipts, planned payments, and the resulting balance are easy to follow, but the workbook does not organize the operational detail behind those figures. A small HVAC, plumbing, electrical, or roofing company will need to add job collections, materials, subcontractors, payroll, payroll taxes, equipment, and owner draws if those items drive cash decisions.

Turning a monthly file into a weekly cash process

The monthly layout can conceal a short-term squeeze. Payroll may fall before a customer payment, while a tax remittance or supplier bill lands in the same week. Create weekly columns, assign each receipt and payment to its expected cash date, and carry each closing balance into the following week's opening balance.

Keep billed work separate from collected cash. A completed job can increase accounts receivable without increasing the bank balance. Add expected deposit, progress-payment, or final-collection dates, especially when project labor and material purchases occur before customer payments.

Use the workbook as a weekly control sheet, not just a monthly summary. Compare completed weeks with accounting records, update collection assumptions, and flag any week in which payroll, taxes, equipment purchases, or job costs exceed available cash.

Where it fits

• Easy starting point: Non-finance users can enter and review the core cash movements.
• No platform requirement: The file can be used without moving the business onto Xero.
• Familiar format: The accounting brand may make adoption easier for a small office team.
• Manual conversion: Weekly control requires rebuilding the period columns.
• Limited detail: Financing discussions and detailed job costing may require supporting schedules.

Use Xero for a first working forecast, then add the weekly schedule before using it to time payroll, supplier payments, taxes, or equipment purchases. See Xero's cash flow forecast template

8. Expensify Free Cash Flow Forecast Template

Expensify's template suits a business that needs a usable forecast before it needs a detailed planning model. It works in Excel and Google Sheets, includes step-by-step guidance, and keeps inflows, outflows, and assumptions visible. That makes the file accessible to an owner or operations manager who must start forecasting without a long setup.

Its main trade-off is detail. The workbook can establish an updating habit, but it will not automatically show whether a service call, replacement project, or roofing phase will fund its own upcoming costs. Add rows for deposits, customer collections, credit-card settlement timing, materials, subcontractors, payroll, payroll taxes, insurance, vehicles, equipment, debt, and owner draws. For project work, include a job or phase reference beside expected receipts and related payments.

A weekly process requires another adjustment. Create weekly columns, move completed weeks to actual results, and record the reason for material variances. This matters when payroll or taxes fall before collections, when equipment purchases change the plan, or when job costs are coded late.

Use it when

• Speed matters: The walkthrough helps a non-finance user build a first forecast.
• The team needs format flexibility: Excel and Google Sheets support different working habits.
• The business is establishing ownership: A smaller file makes review responsibilities easier to assign.

Watch for

• High-level categories: Job and phase timing needs supporting detail.
• Manual weekly conversion: The finance lead must create the cadence, dates, and actual-versus-forecast review.
• Data quality limits: Forecast results are only useful when field-system activity, accounting records, and expected collections are updated consistently.

For HVAC, plumbing, electrical, and roofing companies, Expensify works best as the front end of a weekly cash routine. Add the trade-specific rows, assign each major receipt and payment to a week, then review the next payables, payroll, taxes, and equipment commitments before approving spending.

Open Expensify's cash flow forecast template if you need a quick starting file and can supply the planning detail yourself.

9. Excel.TV Cash Flow Forecast Template

Excel.TV is built for a narrower job than a large planning workbook: showing when cash should arrive and when it will leave. Its plain .xlsx file requires no macros, sign-up, or external connection, so a finance lead can inspect the formulas and begin adapting it without much setup.

The practical fit is short-term control. Convert the columns into a rolling 13-week view, classify receipts by expected collection date, and schedule outflows by the date cash will be paid. That makes the workbook more useful for weekly decisions than a historical cash flow statement, although it does not replace accounting reports or a three-statement model.

A lighter file also makes ownership clearer. The updater can trace assumptions, reconcile changes, and explain variances to the owner. The trade-off is that Excel.TV supplies less guidance and fewer connected schedules than larger resources such as SCORE or Smartsheet, so the business must document its own rules.

For HVAC, plumbing, electrical, and roofing companies, adapt the model around operating commitments rather than generic categories. Separate customer collections from new sales. Give payroll, payroll taxes, materials, equipment, vehicles, and subcontractors their own payment lines. Job costing still needs support from the field or accounting system, because a late-coded material purchase can make the forecast look healthier than available cash really is.

At each weekly close, lock the completed week, replace estimates with bank activity, and record the reason for material variances. This creates a usable process for spotting a payroll gap, a tax payment, or an equipment purchase before approving additional spending.

Pros

• Operational focus: It centers the forecast on near-term cash timing.
• Low friction: No macros, external connections, or sign-up process are required.
• Adaptable: Small edits can support weekly liquidity management.

Cons

• Limited guidance: The team must document categories, ownership, and update rules.
• Narrow scope: It is not a full financial model or connected reporting system.

Download the Excel.TV cash flow forecast template for a clean starting file for weekly cash control rather than a lender package.

10. Shopify Cash Flow Forecast Template

Shopify's cash flow template is built for accessible small-business planning, with language shaped around products and ecommerce. For HVAC, plumbing, electrical, and roofing companies, its value depends on how quickly those labels become an operating forecast. The workbook can provide a clear starting point for a service company that needs to map expected receipts and payments without building a connected accounting model.

Its product orientation is useful when a home-service company sells equipment, parts, or other products alongside labor. Keep product sales and service collections separate so a strong sales month does not hide slow job payments. The forecast should show customer deposits, completed-job collections, materials, field labor, subcontractors, payroll, payroll taxes, vehicles, equipment, and debt payments as distinct cash lines.

The practical limitation is process, not just formulas. Shopify's file does not establish a weekly close, reconcile bank activity, or distinguish an issued invoice from money collected. Set up a weekly cash view beside the monthly plan, enter expected payment dates, and replace each completed week with actual bank activity. Record the reason for material variances, especially before approving payroll, taxes, equipment, or additional materials.

A gated download can also create access friction for a team that needs to start immediately. That trade-off matters less for an owner testing a first forecast than for a finance lead requiring controlled versions and documented update ownership.

Pros

• Beginner-friendly: The language and layout are accessible.
• Timing-oriented: It keeps attention on cash entering and leaving the business.
• Adaptable product context: It can separate service receipts from product-related cash after customization.

Cons

• Ecommerce framing: Labels must be rewritten for trades.
• Access friction: The download may require email registration.
• Limited governance: Versioning, reconciliation, and job-cost data quality remain the operator's responsibility.

Review Shopify's cash flow template for an approachable starting format, provided you are prepared to customize it substantially.

Top 10 Excel Cash Flow Forecast Templates, Comparison

Turn the Download Into a Weekly Operating Rhythm

The best cash flow forecasting template in Excel depends on the decision in front of you. Use the Cash Flow Scorecard when you need to identify weaknesses before building anything. Choose a lightweight file such as Excel.TV, Expensify, Xero, or Microsoft Excel when the immediate need is a usable tracker. Use SCORE for longer-range planning and lender conversations. Choose Vertex42 or QuickBooks when the priority is a statement-oriented accounting foundation.

The download is only the starting structure. For an HVAC, plumbing, electrical, or roofing company, the forecast becomes useful when it reflects the way cash moves through field operations. A monthly projection can support planning, but a rolling weekly process is usually better for seeing whether upcoming obligations will collide.

If you want the wider picture first, cash flow for home service companies is the guide this sits inside. It covers where the money actually goes and why a profitable month can still leave you short.

Build the workflow in this order:

• Define weekly opening cash: Start each period with cash that can be reconciled to the bank, not an unverified spreadsheet balance.
• Separate collections from invoicing: Record when customers are expected to pay, not merely when jobs are sold or invoices are issued.
• Map payroll and tax timing: Put payroll, payroll taxes, insurance, and other employment-related payments in the periods when the bank account will feel them.
• Add major disbursements: Show equipment, vehicles, debt payments, large material purchases, subcontractors, and owner draws separately.
• Connect job and accounting data: Reconcile field-platform activity with QuickBooks or the accounting system so the forecast reflects both operational work and actual cash.
• Compare forecast with actual weekly: Replace completed assumptions with actual bank results, investigate variances, and roll the forecast forward.

A 13-week rolling model works because the closing cash balance from one period becomes the opening balance for the next, creating a continuous view rather than a one-off report. Practitioner guidance also commonly recommends using historical transaction data to establish assumptions, projecting operating, investing, and financing cash flows, and updating the file as actuals replace estimates. This Excel cash flow forecasting guide describes that connection between transaction history, forward assumptions, and a rolling weekly model.

If you are building one from scratch, how to build a 13-week cash flow forecast walks through it week by week.

The minimum governance process is simple but essential. Name one owner, record the update date, identify the source of every material input, preserve a prior version, reconcile the opening balance, and lock completed periods. If accounting cash and bank cash diverge, stop and resolve the difference rather than layering new assumptions onto an unreliable balance. Current guidance on Excel cash flow forecast templates and workflow controls also emphasizes actual bank cash, period-based receipts and payments, carried balances, minimum cash thresholds, and regular updates.

Scenario discipline matters too. Keep expected assumptions separate from downside assumptions for collections, payroll, taxes, and capital purchases. Don’t bury a large equipment decision inside general expenses, and don’t treat optimistic job awards as cash until the collection timing is defensible.

Your downside case needs a floor to measure against. How much cash an HVAC company should keep in the bank is where I set that number, and why a profitable company runs out of cash explains what usually eats it.

A workbook cannot repair corrupted source data by itself. If the company needs deeper cleanup, a dependable 13-week forecast, scenario planning, or ServiceTitan-to-QuickBooks integration, Profit & Grit CFOs can help connect field operations, accounting, job costing, and weekly decision support. Its cash flow services for home-service businesses are designed for owners who need a forecast that people maintain and use.

If you want to hear how this plays out in real businesses, three conversations from my podcast are worth your time.

Carmen Reino of Anchor Pest Control walked away from commercial work running 10 to 20% gross profit and rebuilt the company around residential at 40%. The margin was only half the reason. Commercial customers pay slow, and residential pays now, so the pivot fixed her cash flow and her profitability in one move. She’s also the guest who gave me the line I now repeat to clients: get your numbers at halftime, not at the end of the game.

Stephanie Allen of AirWorks Solutions is the episode I’d hand any owner who thinks cash flow problems only happen to badly run companies. A slow summer plus overspending nearly bankrupted them in 2025. What saved the business was shifting the whole company’s focus from margin to cash and the founders getting back into the details. It’s an honest conversation about a year most owners wouldn’t talk about publicly.

Bob Beall learned the lesson the way a lot of contractors do: growth almost broke him. Back in 2005, three excavators and eight new hires went out faster than the profit came in, and the crunch forced him to start pricing for profit instead of volume. His interview is about what happens when the top line grows and the bank account doesn’t, which is the cash flow trap hiding inside every growth story.

Profit & Grit CFOs provides fractional CFO support for HVAC, plumbing, electrical, and roofing companies, including source-data cleanup, QuickBooks and field-platform integration, 13-week cash forecasting, scenario planning, job costing, and weekly reporting. If your Excel forecast keeps breaking because the books, collections, payroll, or job data don’t reconcile, book an Intro Meeting to discuss a practical cash visibility process.

Please leave this field empty

Real Talk.
Real Profits.

A weekly show built for blue-collar entrepreneurs in the trades who want to grow, profit, and build something that lasts.

You’ll only hear from us when new episodes drop.
No spam, ever!

Check your inbox or spam folder to confirm your subscription.