Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

financial reports

ResolvedVersion 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...

Cash Flow by Code.docx

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.

MS Project tip:

Autofit column width – Project (all versions)

At the top of the columns where each column name is located (Task Name, Duration, etc.), hover over the vertical column line which you want to move.

A short bold vertical line will appear, with horizontal arrows pointing left and right.

Left click and hold this icon and it will permit you to grab the column line, allowing you to move it left or right to your desired location.

View all MS Project hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.