Forum Discussion

PageAndSquire's avatar
PageAndSquire
Copper Contributor
Nov 21, 2025
Solved

Cashflow Visual report export

Hi,    When I export from Visual reports using the cash flow template, my data uses Years, Quarters, and Weeks. This is fine; however, I want to edit this data. I want to show actual sequential dat...
  • John-project's avatar
    John-project
    Nov 21, 2025

    PageAndSquire,

    It sounds like you want a cash flow for accounting months used by your company. Unfortunately that isn't an easy ask as Project has no functionality for producing output in anything other than calendars periods.

    For Visual Reports you won't be able to display weekly dates so you have to do some interpretation to get the accounting month periods you want. It gets a little better if you export days but that's a much larger pivot table and you still need to interpret start and end days for each period.

    When faced with the need to report Project data in accounting months I use VBA.

    Not the answer you wanted, but it's a basic limitation Project has had since day 1.

John-project's avatar
John-project
Silver Contributor
Nov 21, 2025

PageAndSquire,

It sounds like you want a cash flow for accounting months used by your company. Unfortunately that isn't an easy ask as Project has no functionality for producing output in anything other than calendars periods.

For Visual Reports you won't be able to display weekly dates so you have to do some interpretation to get the accounting month periods you want. It gets a little better if you export days but that's a much larger pivot table and you still need to interpret start and end days for each period.

When faced with the need to report Project data in accounting months I use VBA.

Not the answer you wanted, but it's a basic limitation Project has had since day 1.

Resources