Project costing report A Project Revenue Analysis Report for contracting projects focuses on assessing the financial performance related to revenue generation. This type of report helps to understand how well the project is performing in terms of revenue compared to the expectations and contractual agreements.
The Project Revenue Analysis report is located in under Project Costing - Reports - Project Revenue Analysis.The report provides detailed information on project actual revenue as compared to the revenue estimates. User can filter the data
Data can be filtered by Entity, Project, Project Task, and Status. To avoid overloading the report form with data, there is a selected fields section To manage data overload, users can choose which fields to display in the Quick Settings panel, where the user can independently specify a list of calculated fields that will be displayed in the report. By default all avaliable fields marked activewith all fields set to active by default.
Project Revenue Analysis report form
The Project Revenue Analysis report collected pulls data from Accumulation Registers and Project Estimates(with filter Project, filtered by Project status).
How system collects data into report form:
...
Each section has 3 columns: Estimated, Actual and Variance.
How to check the amounts in each section:
Quanity and Status.
It has three sections—Quantity, Price, and Amount—with each section showing Estimated, Actual, and Variance columns.
Users can view the details of a specific cell directly from the report by double-clicking it.
Quantity section:
1. Quantity estimated: it is value from The Estimate column contains the projected or forecasted revenue amounts. This value comes from the Project Estimates document. User has the opportunity to open the details of a given cell directly from the report form (by double clicking the mouse):
User Users can compare data in the Project Estimates document and in Report.
2. Quantity Actual: it is posiible to open detailed records for Actual quantity (double click on this cell):here might be following documents:The Actual column contains the revenue that has been realized or recorded up to the reporting date. Data will be picked from the below documents
- Phased Revenue Recognition;
- Invoice;
- Project Revenue Recognition.
For example detailed records:,
3. The variance column shows the difference between the estimated revenue and the actual revenue. Variance column calculated as Estimated quantity - Actual Quantity.It highlights any discrepancies between what was expected and what was achieved.
Variance=Actual Revenue−Estimated Revenue
Price Section: This section covers the financial aspects related to the project, focusing on pricing details.
Price Estimated:
itThis is the value derived from the Project Estimates document.
User has the opportunity to open the details of a given cell directly from the report form (by double clicking the mouse).
...
It reflects the figures recorded in the Project Estimates document (
...
refer to the detailed
...
report in
...
Section 1, Quantity Estimated).
...
Price
...
Actual
...
: This includes values from various documents such as:
- Phased Revenue Recognition
...
...
- Invoices
- Project Revenue Recognition
...
...
- Variance Column: This is calculated as the difference between the Estimated Price
...
- and the Actual Price.
Price Variance=Price Actual−Price Estimated
Amount Section:
...
This section combines the quantity and price data to provide a comprehensive view of the financial performance of the project.
- Estimated Amount: The projected total revenue, calculated by multiplying the Quantity Estimated by the Price Estimated.
This is the value from the Project Estimates document.
...
2. Actual Amount - same as Quantity Actual it is posiible to open detailed records for Actual price (double click on this cell): The actual total revenue achieved, based on the Quantity Actual and Price Actual.
here might be the following documents:
- Phased Revenue Recognition;
- Invoice;
- Project Revenue Recognition.
3.Variance column calculated as Estimated Amount - Actual Amount.- The difference between the estimated and actual amounts, calculated as
Amount Variance=Amount Actual−Amount Estimated
Total Revenue for the project in the report is in groupping grouping Project:
User Users can also may compare the report amounts from report with data about the Project Revenue data on the Diagrams Tab in the Project form (found in Projects Catalog) - under the Revenue and Costs diagram:
Here left column - is Revenue (Estimated) Amount, next to it - Revenue (actual).
It is also possible to check operations on Table tal with Revenue and Costs diagram..
Thank you for being FirstBit customer! #Contracting report #Project revenue analysis