Forum Discussion
Cashflow Visual report export
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.
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.
Thanks, John.
I was beginning to think there was no easy solution, and now I know! I don't really do VBA, so I guess I will have to learn some simple tricks.
PageAndSquire,
You're welcome and thanks for the feedback.
There is another option albeit a manual exercise. Set up either Usage view to show Cumulative cost with a weekly timescale. Copy the weekly data per your accounting month and paste into an Excel Worksheet. Create the cash flow graph from there. That's a "simple" trick I've seen other users use. In effect, it's a transition from page to squire. The knight will use VBA :-)