98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Project Training and help » Financial reports
Financial reports
Resolved · Low Priority · Version 2013
Steve has attended:
Project Intermediate course
Financial reports
Are there any reports to give you cost breakdowns by the codes that you input for them? As account code break downs may be useful!
RE: Financial reports
Hi Steve
Yes you can create a custom report that includes the Code field from the Resource sheet.
For example in the project example we used on training 'Rollout Complete' you can create a cash flow dashboard report which includes the Code field and groups costs by Code.
Rather than edit an existing dashboard go to
File, Organizer and select the Reports tab. This allows you to copy the Cash Flow report to current project Rollout Complete and give it a different name say 'Cash Flow by Cost Code'.
Select the Close button in the Organizer and then there will be a copy of Cash Flow in Reports, Custom.
Editing the Report
View the Cash Flow by Cost Code report then click inside the table below the graph. As with Excel Pivot Tables you can add additional fields.
Select Resources at the top
Expand Other Fields
Click on Code
To reposition drag the Code field up so it appears after Name
Change the Level to 2
Group by Code if you wish.
Hope this helps. We didn't have time to look in detail at Reports on the training session.
Regards
Doug
Best STL
Attached files...
Will be marked as resolved in 5 days
Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.
Thu 12 Nov 2015: Automatically marked as resolved.
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
MS Project tip:Link tasks using predecessor column - projecta. First, note ID number of the task you want to link to (predecessor). Then, in the predecessor column of the task you want to link to (successor), type the predecessor task's ID number. |