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 found under Project Costing - Reports - Project Revenue Analysis. It compares actual project revenue to estimates and lets users filter
Data can be filtered by Entity, Project, Task, and Status. To manage data overload, users can choose which fields to display in the Quick Settings panel, with all fields set to active by default.
...
Project Revenue Analysis report form
The Project Revenue Analysis report pulls data from Accumulation Registers and Project Estimates, filtered by Project 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.
How to check the amounts in each Quantity section:
Quanity section:
1. Quantity estimated: The Estimate column contains the projected or forecasted revenue amounts. This value comes from the Project Estimates document.
User Users can compare data in the Project Estimates document and in Report.
2. Quantity Actual: 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. It highlights any discrepancies between what was expected and what was achieved. Variance column calculated as Estimated quantity - Actual Quantity.
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.
...
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 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:
Users can also compare the report amounts with the Project Revenue data on the Diagrams Tab in the Project form (found in Projects Catalog) under the Revenue and Costs diagram.
In the left column, you'll find Revenue (Estimated) Amount, with Revenue (Actual) next to it. You can also review operations on the Table tab alongside the Revenue and Costs diagram.
Thank you for being FirstBit customer! #Contracting report #Project revenue analysis