How to Create a Cash Flow Report in Microsoft Project

In this blog post, I’m going to walk you through one of the most useful (yet underutilized) features built into Microsoft Project: how to generate a weekly Cash Flow Report using Excel Visual Reports. If you’ve ever needed to show your project sponsor or finance team a timephased S-Curve chart comparing weekly spending against cumulative project cost, Microsoft Project can build that entire Excel PivotTable and combo chart for you automatically.

Companion Articles in This Reports, Timelines, Excel & Printing Series: Explore these connected tutorials in the same topic area to build your skills step by step:

How to Create a Cash Flow Report in Microsoft Project

YouTubeWatch the Step-by-Step Video

Prefer to follow along visually? This video demonstrates the exact steps you’ll learn below using Microsoft Project Desktop.

At a Glance: How to Generate a Weekly Cash Flow Report:

  • Applies to: Microsoft Project Standard, Project Professional, and Project Server / Project Online Desktop Client (requires desktop Microsoft Excel installed).
  • Step 1: Enter resource Standard Rates on the Resource Sheet (or assign Fixed Costs / Expense Cost Resources to tasks).
  • Step 2: Click Report → Visual Reports, select Cash Flow Report, set Select level of usage data to Weeks, and click View.
  • Step 3: In the exported Excel workbook, open the Task Usage PivotTable tab, expand Quarters down to Weeks, format Cost and Cumulative Cost as Accounting ($, 0 decimals), and rotate the chart’s X-axis labels 270°.

Need hands-on help with your schedule? Explore my $399 Microsoft Project Desktop Course, Project Server Training, or book 1-on-1 Private Training & Consulting.

How Does Microsoft Project Calculate Timephased Cash Flow?

Before generating a Cash Flow report, it helps to make sure your schedule has cost data entered so you know where the numbers are coming from:

  1. Resource Sheet Rates: On the Resource Sheet view, each work resource should have a Standard Rate entered (for example, Jen Blackbeard at $100/hr).
  2. Task Usage Roll-Up: When Jen Blackbeard is assigned 8 hours of work on a task (Define preliminary resources), Microsoft Project calculates 8 hrs × $100/hr = $800 for that assignment, rolls it up to the task’s total Cost, and distributes those dollars across the exact days and weeks the work is scheduled to occur in the timephased grid.

(Need to track non-labor costs in your cash flow too? Check out my companion articles on Entering Fixed Costs and Creating Expense Cost Resources.)

Step 1: How to Generate the Cash Flow Visual Report

To export your timephased cost schedule into an Excel Cash Flow Visual Report:

  1. Click the Report ribbon tab.
  2. In the Export section, click the Visual Reports button to open the Visual Reports – Create Report dialog.
  3. Make sure the Microsoft Excel checkbox is enabled at the top, and select Cash Flow Report in the report list.
  4. At the bottom of the dialog, click the Select level of usage data to include in the report pick list:
  5. You can choose anywhere from Days up to Years, but for most project managers and finance stakeholders, Weeks is the sweet spot. Select Weeks.
  6. Click the View button.

In the background, Microsoft Project builds a local OLAP cube on your hard drive, launches desktop Microsoft Excel, opens the Cash Flow report template, and connects the PivotTable and PivotChart to your project data.

Step 2: How to Expand the PivotTable to Weekly Cash Flow & Format Currency

When the Excel workbook first opens, you’ll see two worksheet tabs at the bottom: Chart1 (which looks pretty underwhelming at first because it is collapsed to the Year/Quarter level) and Task Usage (which holds the underlying PivotTable).

Let’s configure the PivotTable first:

  1. Click the Task Usage worksheet tab at the bottom of Excel.
  2. In the PivotTable, click the + expand buttons next to the Year and each Quarter (for example, Q2, Q3) to drill down to the individual Weeks (Week 1, Week 2, etc.).
  3. Select the column headers for Column D (Cost) and Column E (Cumulative Cost).
  4. On the Home ribbon tab in Excel:
    1. Click the Number Format pick list and select Accounting (or click the $ button).
    2. Click the Decrease Decimal button twice to drop off the .00 cents so the numbers are clean and easy to read.

Step 3: How Do I Fix Overlapping Week Labels on the Cash Flow Chart?

Now click back to the Chart1 worksheet tab (and zoom out to 90% if needed so you can see the full canvas).

Look at the difference! Expanding the PivotTable to weeks and applying Accounting currency formatting immediately transforms the chart into a dual-axis visualization showing: * Weekly Cost as vertical column bars * Cumulative Project Cost (S-Curve) as a rising line chart.

There is only one visual flaw left to fix: along the horizontal X-axis at the bottom, the week labels (Week 18, Week 19, Week 20…) are all running together horizontally. Here is how to fix that in 10 seconds:

  1. Right-click anywhere on the horizontal X-axis labels at the bottom of the chart and choose Format Axis… on the shortcut menu.
  2. In the Format Axis pane on the right side of Excel, click Text Options at the top, and then click the Textbox icon.
  3. Click the Text direction pick list and choose Rotate all text 270°.

Bingo! Every single week and quarter label now reads vertically and cleanly along the bottom axis, giving you a polished, executive-ready Cash Flow & S-Curve chart ready to drop into a slide deck or send directly to your project sponsor.

Frequently Asked Questions

Why is my Cash Flow Visual Report blank or showing $0?

The Cash Flow Visual Report pulls from timephased Cost data. If your resources have $0.00/hr Standard Rates on the Resource Sheet and you haven’t entered any Fixed Costs on tasks, total project cost is $0. Enter resource rates or fixed task costs first, then re-run the report.

Can I show Monthly Cash Flow instead of Weekly?

Absolutely. In the Visual Reports dialog box, set Select level of usage data to include in the report to Months (or expand the Excel PivotTable only to the Month/Quarter level instead of drilling down to Weeks).

Does the Cash Flow Visual Report work with Project Online or Planner Premium?

Visual Reports works identically in Microsoft Project Standard, Microsoft Project Professional, and the Project Online Desktop Client (connected to Project Online or Project Server), provided you have desktop Microsoft Excel installed on your PC. It is not available in the browser-only Planner Premium (formerly named Project for the Web) app.


Ready to master Microsoft Project? If you found this article helpful, check out my free tutorials on my YouTube channel, download my Free Microsoft Project Quality Filters, or explore my structured, expert-led training courses and 1-on-1 coaching at dalehowardmvp.com.

Leave a Reply

Your email address will not be published. Required fields are marked *

Are you human? Please solve:Captcha