Construction Cash Flow S Curve Excel Template Guide

How-to basics · Updated November 22, 2026

Yes. Build a construction cash flow S curve in Excel by listing each month’s planned and actual cash expenditure, calculating each series’ running total, and charting the cumulative values as lines. In Microsoft Excel for Microsoft 365 on Windows, a simple template uses columns for month, planned cash flow, actual cash flow, planned cumulative total, actual cumulative total, and variance.

What a construction cash flow S curve shows

An S curve plots cumulative project values over time. Construction spending often starts slowly while mobilization and early work get underway, rises during the busiest phases, then tapers as the project approaches completion. That pattern can resemble an S, but it is not guaranteed: the curve follows the project’s actual schedule, procurement, payment timing, and work sequence.

The curve is cumulative, not a chart of each month’s isolated spending. A monthly cash-flow series might rise and fall sharply; its running total gives the smoother line that helps show how quickly planned or actual cash use is accumulating. Comparing planned and actual cumulative values can reveal whether cash is being spent faster or more slowly than the baseline suggests. It does not, on its own, prove that construction progress is ahead or behind schedule.

Be clear about what the values represent. A contractor may model cash outflows for labor, materials, equipment, and subcontractors. An owner may instead track payments to the contractor, while a project manager may track the value of work installed. Those are related but different measures. Payment timing, retainage, billing approval, and collection delays can make cash received differ from the value of work completed.

Set up the Excel template

Start with one row per reporting period. Monthly periods are common for project forecasts, though a weekly model can be useful for short projects or close cash management. Use consistent period dates and one currency throughout the schedule. Put the following headers in row 1:

  • Column A: Month or period ending date
  • Column B: Planned cash flow
  • Column C: Actual cash flow
  • Column D: Planned cumulative cash flow
  • Column E: Actual cumulative cash flow
  • Column F: Monthly variance
  • Column G: Cumulative variance
  • Column H: Planned cumulative percentage
  • Column I: Actual cumulative percentage of the baseline

For a 12-month schedule, enter the first period in A2 and the final period in A13. Enter approved forecast amounts in B2:B13; enter actual amounts in C2:C13 as they become available. Leave future actuals blank rather than entering zero if you want the sheet to distinguish missing actuals from months with confirmed zero expenditure. Format money columns as currency and percentage columns as percentages. A date format such as mmm yyyy makes the chart labels easier to read.

For a concrete example, suppose the planned monthly outflows are $50,000, $70,000, $90,000, $110,000, $130,000, $140,000, $120,000, $100,000, $70,000, $50,000, $40,000, and $30,000. Together they total $1,000,000. If the first three actuals are $48,000, $75,000, and $85,000, the planned cumulative amount at the end of month three is $210,000 and the actual cumulative amount is $208,000.

Calculate running totals and variances

With headers in row 1, periods in A2:A13, planned amounts in B2:B13, and actual amounts in C2:C13, enter the planned running total in D2. It returns $50,000 in month one; fill the formula down through D13 to accumulate later periods.

=SUM($B$2:B2)

With actual amounts in C2:C13 and the first actual value in C2, enter this in E2. It returns $48,000 for the example’s first month. Fill down to calculate the actual cumulative series; a blank actual cell is treated as zero by SUM, so do not interpret future cumulative values as final until actuals are entered.

=SUM($C$2:C2)

With planned amounts in column B and actual amounts in column C for the same period, enter this in F2 to show monthly actual minus planned. Copy it down. A negative result means actual cash flow is below that month’s plan; in month three, $85,000 minus $90,000 returns -$5,000.

=C2-B2

With planned cumulative values in D and actual cumulative values in E, enter this in G2 and copy down. At the end of month three it returns -$2,000 ($208,000 actual cumulative minus $210,000 planned cumulative). This is the cumulative cash-flow variance, not the month-three variance.

=E2-D2

With the planned schedule in B2:B13 and planned cumulative value in D2, enter this in H2 to calculate the share of the planned total accumulated by that period. Fill down; at month three in the example it returns 21%.

=IFERROR(D2/SUM($B$2:$B$13),0)

With actual cumulative value in E2 and the same planned baseline in B2:B13, enter this in I2 and fill down. Month three returns 20.8%. Using the planned total as the denominator makes the actual curve comparable with the baseline; if final actual spending exceeds the original plan, the percentage can exceed 100%.

=IFERROR(E2/SUM($B$2:$B$13),0)

Create and read the S curve chart

To chart the cumulative series in Excel for Microsoft 365 on Windows, select A1:A13, then hold Ctrl while selecting D1:E13. Choose Insert > Insert Line or Area Chart > Line. The period dates become the horizontal axis, and planned and actual cumulative cash flow become the two lines. On a Mac, use Command instead of Ctrl to add the second selection. If selecting separate ranges is awkward, copy the month, planned cumulative, and actual cumulative columns into an adjacent three-column chart table and select that table instead.

Give the chart a descriptive title, such as Planned and Actual Cumulative Cash Flow. Format the vertical axis as currency, and check that both series use the same units and periods. If the lines are difficult to distinguish, use different colors and retain a visible legend. Avoid plotting monthly spending as the main S curve: monthly values can still be useful in a separate column chart, but they answer a different question from cumulative cash flow.

In the example, the actual line ends month three $2,000 below the planned line. That says cumulative actual outflow is lower than planned to date. It does not establish why. Work may be delayed, invoices may not have been paid yet, an estimate may be inaccurate, or actual costs may genuinely be lower. Investigate the underlying schedule and payment records before treating the gap as a performance conclusion.

Choose the right cash-flow basis and assumptions

A useful forecast states both its basis and timing convention. Decide whether each amount is incurred cost, expected payment, owner billing, cash receipt, or another defined measure. For example, a subcontractor’s work may be completed in June, invoiced in July, and paid in August. A June progress curve and an August cash-outflow curve will differ even if they relate to the same work.

Break the forecast into cost categories when the project needs that detail. Labor, materials, equipment, subcontractors, and general conditions can each have different timing assumptions. You can keep one summary curve for reporting while maintaining category-level schedules elsewhere in the workbook. Make sure the summary includes each cost only once and uses the same period dates as its supporting detail.

  • Record whether amounts include taxes, contingency, escalation, or retainage, and apply the rule consistently.
  • Separate the approved baseline from a current forecast if you need to preserve the original comparison.
  • Document assumptions for deposits, long-lead materials, payment terms, and expected billing or collection delays.
  • Use a consistent sign convention. For an expenditure-only curve, positive values are straightforward; for a net cash-flow model, define whether inflows or outflows are positive.

Do not mix an owner’s incoming payments with a contractor’s outgoing costs in a single line without explicitly modeling both sides. A contractor’s net cash position may require a separate inflow schedule, outflow schedule, and net balance. Similarly, a cash-flow S curve is not automatically an earned-value curve: earned value measures the budgeted value of work performed, while cash flow follows money timing.

Common template problems and checks

The most frequent error is confusing period values with cumulative values. If the chart rises and falls sharply, check whether monthly amounts were charted instead of running totals. If the line starts at an unexpected amount, inspect the first period and confirm that the cumulative formula begins with the correct row. If all actual values appear as zero, check whether the actual column is genuinely populated and whether the chart includes the intended range.

Check the forecast total against the approved budget or cash-flow estimate. A total that does not reconcile may indicate a missing month, a duplicated cost, a range that stops too early, or a value stored as text. Review period labels for missing or repeated months, and check that forecast and actual data cover the same period. Avoid overwriting the planned baseline with revised estimates if you still need to measure performance against the original plan; retain separate baseline and current-forecast columns or worksheets.

Actuals should be updated from a defined source, such as an accounting report or approved payment record, with a consistent cut-off date. A late invoice can make the latest period look artificially low, while a large advance payment can make it look unusually high. Add a note explaining material timing differences instead of trying to make the curve look smooth. The purpose is to show the best supported forecast, not to force an S-shaped result.

When a simple Excel curve is enough—and when it is not

A single-sheet workbook is often adequate for a small project, an early forecast, or a monthly management summary. It is quick to understand, easy to revise, and transparent when the assumptions and source data are documented. A basic version can be built without macros or specialized add-ins.

More complex projects may need separate schedules for commitments, invoices, payment dates, cost codes, funding sources, multiple currencies, or scenario forecasts. At that point, a detailed workbook with a controlled input process—or purpose-built project controls or accounting software—can reduce manual reconciliation. Excel remains useful for analysis and reporting, but a chart does not replace a cost-control system, approved schedule, or accounting record. Consider who owns updates, how changes are reviewed, and how the workbook will be versioned before adding complexity.

Frequently Asked Questions

Is there a built-in construction cash flow S curve template in Excel?

Excel provides worksheet and chart tools, but the layout above is a practical template you create in a workbook rather than a dedicated construction cash-flow template built into Excel. You can save a completed workbook as an Excel template file if you want to reuse its structure.

Should an S curve show monthly or cumulative cash flow?

The classic S curve shows cumulative cash flow over time. Keep monthly planned and actual values in the worksheet for calculations and review, then chart the cumulative columns to compare progress through the total forecast.

Why does my cash flow curve not look like an S?

The project’s timing may not create a smooth S shape, or the chart may be using monthly amounts rather than cumulative totals. Check the chart ranges and the project’s phasing, procurement, and payment assumptions. Do not alter valid data merely to create a particular shape.

Can I use the same template for cash inflows and outflows?

Yes, but label each series and define its sign convention. For a net cash position, model receipts and payments separately before calculating the net amount; otherwise, a single total can hide whether it represents money received, money paid, or both.

How often should I update the actual cash-flow curve?

Update it at the reporting interval used by the project, often monthly, after the same accounting cut-off each time. Record the data source and explain significant timing differences so readers can distinguish a genuine change from late billing or payment processing.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.