Costs and Revenue Report

The Cost and Revenue Management report allows you to compare the invoiced revenue for each month, against the project costs that were incurred for the same period. Use the graph to monitor trends in the invoiced values and costs. NEW 4.8

*Synergy Enterprise Feature* 

Getting Started

Who Can Use It?	Where Is It?
Director Administrator System Administrator	Reports > Management Reports > Costs and Revenue or click the My Synergy plugin

What is the Costs and Revenue Report?

View the difference between the monthly project revenue, and the monthly costs to complete the project work in the Graph. This report is calculated using the invoiced transactions and cost totals shown the Data tab. The type of cost shown can be either Standard or Actual costs, which is controlled using the Settings panel options.

The invoice and cost data is displayed for a 12 month period, where the invoice data is shown based on the invoice date for the transaction. The invoice value shown is excluding tax. Credit, Cancelled Invoice and Write Off values fall into the month the original invoice was created within (not the month of the credit date). Draft invoices are excluded from the report data.

Add the 'Costs and Revenue plugin' to the My Synergy dashboard to see the details as you login to Synergy. Double click on the plugin to open the Management report.

Why use the Costs and Revenue Report?

Compare the invoiced revenue for each month against the cost of running the projects.

Actions available

The Costs and Revenue Report displays the following data:

• Graph
  This displays in blue the invoiced revenue value for each month over a 12 month period. In pink the cost of the invoiced transactions is shown for each month over a 12 month period. The cost shown is either Standard or Actual costs, depending on which option is selected in the Setting panel. Administrator access level can only view Standard Costs.To learn more about Standard and Actual Project Cost review the Project Profitability topic. The graph displays 12 months of data, which are the current month and the previous 11 months.
  
• Data Tab
  A row is shown for each month that invoice data or cost exists for a project. The project number is not shown, as if there are multiple projects with the same project manager, sub project manager, cost centre, and discipline displayed then they are all merged together to show on the same row. The cost shown on this tab can be changed to be either Standard or Actual costs, using the controls in the Settings panel. Administrator access level can only view Standard Costs. To learn more about Standard and Actual Project Costs review the Project Profitability topic. The data tab can be exported to MS Excel®.

The report opens with all the filters selected. This displays the total revenue value invoiced for each month compared to the costs. The graph and data tab are interactive, and they will automatically update as the filters are changed. To learn more about how to apply filters and other management report basics, please review the Management Reports overview topic.

Example

The example below shows that there was a surge of activity that was profitable in June 2012. In this period the revenue made from the project work was higher than the cost incurred. The data table shows the report details grouped by month. Group the data like this to see the total cost or invoice value for each month shown in the graph.

Click the image above to view an example of the report with a line graph view applied.

Columns available

The following columns are available in the Data table

1. MonthThe month and year for which the invoice and costs data is shown for.
2. QuarterThe quarter number and year for which the invoice and costs data is shown for.
3. OfficeThe office that the invoiced data or project cost is linked too.
4. Project ManagerThe project manager listed on the project, which has been invoiced.
5. Sub Project ManagerThe project manager, which is listed on the Sub Project which has been invoiced.
6. Cost CentreThe cost centre listed on the Project/Sub Project which has been invoiced.
7. DisciplineThe discipline listed on the Project/Sub Project which has been invoiced.
8. InvoicedThe total value of the invoiced revenue for the month, for the project manager or sub project manager. Credit values fall into the month the original invoice was created within (not the month of the credit note date). Draft invoices are excluded from the report data.
9. CostThe total cost for the month for the project manager or sub project manager, for the invoiced transactions.

Want to learn more?

Looking for more help? Try reviewing the following topics: View Topics

© 2019 Total Synergy Pty Ltd

Open topic with navigation