{"id":862,"date":"2023-08-31T10:09:25","date_gmt":"2023-08-31T10:09:25","guid":{"rendered":"https:\/\/www.projectpro365.com\/user-guide\/?p=862"},"modified":"2025-04-14T07:56:13","modified_gmt":"2025-04-14T07:56:13","slug":"job-analysis-and-reporting","status":"publish","type":"post","link":"https:\/\/www.projectpro365.com\/user-guide\/standard\/projectpro-basic\/job-analysis-and-reporting\/","title":{"rendered":"Ch 09 – Project Analysis and Reporting"},"content":{"rendered":"

Contents<\/b><\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
1. Aged A\/R with Retention Report<\/a><\/td>\n<\/tr>\n
2. Aged A\/P with Retention Report<\/a><\/td>\n<\/tr>\n
3. Project Material List<\/a><\/td>\n<\/tr>\n
4. Actual vs Budget Cost by Task<\/a><\/td>\n<\/tr>\n
5. Actual vs Budget Price by Task<\/a><\/td>\n<\/tr>\n
6. Projects Gross Profit by APO<\/a><\/td>\n<\/tr>\n
7. Project Cost Category Summary<\/a><\/td>\n<\/tr>\n
8. Bonding<\/a><\/td>\n<\/tr>\n
9. Committed Cost Detail Report<\/a><\/td>\n<\/tr>\n
10. Project Ledger<\/a><\/td>\n<\/tr>\n
11. Project Gross Profit<\/a><\/td>\n<\/tr>\n
12. Project Purchase Order Status<\/a><\/td>\n<\/tr>\n
13. Subcontract Status by Project<\/a><\/td>\n<\/tr>\n
14. Actual vs Budget Projects Hour<\/a><\/td>\n<\/tr>\n
15. Open Sales Invoices by Project<\/a><\/td>\n<\/tr>\n
16. Customer Projects (Price)<\/a><\/td>\n<\/tr>\n
17. Actual vs Budget Price by RAPO<\/a><\/td>\n<\/tr>\n
18. Open Purchase Invoices by Project<\/a><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

1. Aged A\/R with Retention Report<\/b> <\/p>\n

Aged A\/R with Retention Report is a valuable tool for tracking and managing unpaid customer invoices while accounting for any held or retained funds as part of the overall accounts receivable process.<\/p>\n

You can access this report via your Role Center (ProjectPro Manager), as demonstrated below:<\/p>\n

\"null\"<\/p>\n

When you click on the \u201cAged A\/R with Retention,\u201d the given dialogue box will appear.<\/p>\n

\"null\"<\/p>\n

You should complete the details based on your specific requirements to initiate the report..<\/p>\n

Then the report will be generated based on the provided details.<\/p>\n

\"null\"<\/p>\n

2. Aged A\/P with Retention Report<\/b> <\/p>\n

An “Aged A\/P with Retention Report” typically refers to a financial report that provides an overview of accounts payable (A\/P) balances while considering any retention amounts that are being withheld.<\/p>\n

The Accounts Payable (A\/P) Aging Report shows you how much you owe your vendors at any point in time. The report is broken down by aging periods.<\/p>\n

You can access this report through your Role Center in ProjectPro Manager.<\/p>\n

\"null\"<\/p>\n

When you click on the \u201cAged A\/P with Retention,\u201d the given dialogue box will appear.<\/p>\n

You need to fill in the details as per your requirement to publish the report.<\/p>\n

\"null\"<\/p>\n

Then, the following report will be generated based on the details filled in.<\/p>\n

\"null\"<\/p>\n

3. Project Material List<\/b><\/p>\n

\"null\"<\/p>\n

This report is a detailed Actual Material Qty. vs Budgeted Material Qty. On the Role Centre (ProjectPro Manager) you can find this report.<\/p>\n

When you click on the \u201cProject Material List\u201d the following screen will appear.<\/p>\n

\"null\"<\/p>\n

Fill the requirements to run the report.<\/p>\n

\"null\"<\/p>\n

4. Actual vs Budget Cost by Task<\/b><\/p>\n

This report provides a comprehensive analysis of the budget versus actual costs, offering insights into the remaining budget and the percentage of the budget already utilized. For enhanced customization, you can explore the OPTION TAB, allowing you to delve deeper into specifics like Process or Operation Level, and you can also choose to incorporate any Project changes you would like to track.<\/p>\n

You can find this report on your Role Centre.<\/p>\n

\"null\"<\/p>\n

Fill in the Project no. and other details to run the report.<\/p>\n

\"null\"<\/p>\n

Click on the \u201cPreview.\u201d<\/p>\n

\"null\"<\/p>\n

5. Actual vs Budget Price by Task<\/b><\/p>\n

This report delves into the budgeted contract prices, actual billing, the pending balance to be billed, and the percentage of billing associated with Project Activity, Process, and Operations Codes.<\/p>\n

You can find this report on your Role Centre.<\/p>\n

\"null\"<\/p>\n

Fill in the Project no. and other details on the screen that runs the report.<\/p>\n

\"null\"<\/p>\n

Click on the \u201cPreview\u201d to run the report.<\/p>\n

\"null\"<\/p>\n

6. Projects Gross Profit by APO<\/b><\/p>\n

This report is showing the gross profitability by Activities, Processes and Operations with profit percentage.<\/p>\n

On the Role Center you can find this report.<\/p>\n

\"null\"<\/p>\n

Click on the option and fill in the required details on the screen that appears.<\/p>\n

\"null\"<\/p>\n

Click on the \u201cPreview\u201d to run the report.<\/p>\n

\"null\"<\/p>\n

7. Project Cost Category Summary<\/b><\/p>\n

This report is showing the cost categories vertically along with estimates, committed costs and actual costs in summary for each Project.<\/p>\n

On the Role Center you can find this report.<\/p>\n

\"null\"<\/p>\n

Click on the option and one screen will appear in front of you.<\/p>\n

\"null\"<\/p>\n

Fill in the required details and then click on the \u201cPreview & Close.\u201d<\/p>\n

\"null\"<\/p>\n

8. Bonding<\/b><\/p>\n

This report is common for bonding and insurance companies that provide special Project insurance coverage or bonding insurances. There are two options for calculating the percentage of completion. The sample shown is the first method which is calculated using actual costs divided by budgeted costs. The second option is calculated using the manually entered percentage of completion in the Project card.<\/p>\n

You can find this Report on the Role Center under \u201cProfit \u2013 Cost.\u201d<\/p>\n

\"null\"<\/p>\n

Click on the option and fill in the required details on the screen that appears.<\/p>\n

Click on the \u201cPreview.\u201d<\/p>\n

\"null\"<\/p>\n

\"null\"<\/p>\n

9. Committed Cost Detail Report<\/b><\/p>\n

On the Role Center click on the \u201cCommitted Cost Detail Report\u201d under Profit-Cost.<\/p>\n

\"null\"<\/p>\n

The following screen will pop up.<\/p>\n

\"null\"<\/p>\n

Fill in the required details and click on the \u201cPreview & Close.\u201d<\/p>\n

\"null\"<\/p>\n

10. Project Ledger<\/b><\/p>\n

This is a report that shows all types of Project entries such as usage, release, sale and earned transactions.<\/p>\n

You can find this report on the Role Center under \u201cProject.\u201d<\/p>\n

\"null\"<\/p>\n

A screen will appear on which you have to fill in the required details.<\/p>\n

\"null\"<\/p>\n

Click on the \u201cPreview.\u201d<\/p>\n

\"null\"<\/p>\n

11. Project Gross Profit<\/b><\/p>\n

This report presents the Gross Profit in Amount and % form as well which is difference between Usage Cost and Invoiced price.<\/p>\n

You will find this report on the Role Centre under \u201cProfit-Cost.\u201d<\/p>\n

\"null\"<\/p>\n

When you click on the option the following screen will pop up.<\/p>\n

\"null\"<\/p>\n

Click on the \u201cPreview & Close.\u201d<\/p>\n

\"null\"<\/p>\n

12. Project Purchase Order Status<\/b><\/p>\n

This is the report for showing each open purchase order by Project with item status: Quantity in Stock, Quantity Ordered and Quantity Received<\/p>\n

You will find this report on the Role Center under \u201cPurchasing.\u201d<\/p>\n

\"null\"<\/p>\n

Click on the option and fill the required details on the following screen that appears.<\/p>\n

\"null\"<\/p>\n

Click on the \u201cPreview & Close.\u201d<\/p>\n

\"null\"<\/p>\n

13. Subcontract Status by Project<\/b><\/p>\n

This report shows the subcontract amount, Subcontract Invoiced amount, Subcontract retention amount and paid Subcontract invoiced amount to vendor based on project no.<\/p>\n

\"null\"<\/p>\n

On the Role Center under Subcontracts, click on the \u201cSubcontract Status by Project.\u201d<\/p>\n

The following screen will appear, the fill the required details.<\/p>\n

\"null\"<\/p>\n

Click on the \u201cPreview & Close.\u201d<\/p>\n

\"null\"<\/p>\n

Percentage of Completion<\/b><\/p>\n

Project managers and accountants use this report to assess the completion of each Project. This report is used to indicate what portion of each contract has been earned.<\/p>\n

There are two options for calculating the percentage of completion.<\/p>\n

1. The first method is calculated using actual costs divided by budgeted costs.<\/p>\n

2. The second option is calculated using the manually entered percentage of completion in the Project card.<\/p>\n

You can find this report either on the Role Center under Project, Project List or on Project Card.<\/p>\n

\"null\"<\/p>\n

\"null\"<\/p>\n

\"null\"<\/p>\n

The following screen will pop up.<\/p>\n

\"null\"<\/p>\n

Fill in the required details and click on the \u201cPreview.\u201d<\/p>\n

\"null\"<\/p>\n

14. Actual vs Budget Projects Hour<\/b><\/p>\n

This is report is for comparing budgeted hours verses actual hours for each Project.<\/p>\n

You can find this report either on the Role Center or on the Project Card under \u201cReports.\u201d<\/p>\n

\"null\"<\/p>\n

\"null\"<\/p>\n

Fill in the required details on the screen that appears.<\/p>\n

\"null\"<\/p>\n

Click on the \u201cPreview.\u201d<\/p>\n

\"null\"<\/p>\n

15. Open Sales Invoices by Project<\/b><\/p>\n

To open this report, click on Search and type \u201cOpen Sales Invoice by Project,\u201d the screen will appear in which you have to fill in the details accordingly to run the report.<\/p>\n

\"null\"<\/p>\n

Click on the preview to see the report.<\/p>\n

\"null\"<\/p>\n

16. Customer Projects (Price)<\/b><\/p>\n

This report is a customer\u2019s Project report with a summary of budgeted price (contract values) and actual billings along with percent invoiced to customer.<\/p>\n

Click on the search to find this report. The following screen will appear.<\/p>\n

\"null\"<\/p>\n

Fill in the required details and run the report.<\/p>\n

\"null\"<\/p>\n

17. Actual vs Budget Price by RAPO<\/b><\/p>\n

This report is for showing all invoiced Revenue Activities, Processes and Operations along with contract values.<\/p>\n

Click on search to find this report and type \u201cActual vs Budget Price by RAPO.\u201d The following screen will appear in front of you.<\/p>\n

\"null\"<\/p>\n

Fill in the required details and click on the preview to run the report.<\/p>\n

\"null\"<\/p>\n

18. Open Purchase Invoices by Project<\/b><\/p>\n

Click on Search and type \u201cOpen Purchase Invoices by Project\u201d to open this report. A screen will appear on which you have to fill in the details accordingly to run the report.<\/p>\n

\"null\"<\/p>\n

Click on the \u201cPreview\u201d to run the report.<\/p>\n

\"null\"<\/p>\n