Revenue report is available in the Advanced Work and Advanced Finance core app add-ons and in the legacy Standard, Pro, Ultimate, Growth, Performance, and Enterprise plans. Learn more about our Plans & Pricing.
Scoro's real-time revenue report provides a complete revenue overview so you can confidently plan for the future. It tracks revenue from quotes and projects. For projects with role-based pricing, the revenue report can also show bookings-based revenue. Any changes in quotes or projects will instantly update the report, giving you an accurate and concise revenue overview that reflects reality.
This article shows you how to enable and read the revenue report.
Jump to...
1. Accessing the revenue report
The revenue report can be accessed by users with the 'View revenue report' permission in their permission set. Site admins can manage permission set access rights under Settings > Administration > Permission sets.
Users with that permission can access the revenue report in the Reports module under Reports > Financial > Revenue report.
Learn more about permission sets.
2. How to read the revenue report
You can find the revenue report in Reports > Financial > Revenue report.
The revenue report is based on quotes and projects, but it does not include invoices. You can also view bookings-based revenue alongside your project data.
The Revenue report will help you get answers to questions such as:
- How much revenue have we generated?
- How much revenue are we guaranteed over the coming months?
- How much potential revenue do we have in the pipeline?
2.1. Grouping the data
By default, the data is grouped by Projects | Quotes. However, if you track your revenue per account, grouping the data by clients will let you see better how much business each of your accounts is bringing in and how the accounts are progressing over time.
2.2. Filters
You can filter the revenue report by:
-
Source:
- Selecting Quotes as the source will display the forecasted revenue that you can expect to earn based on the quotes that are in your sales pipeline.
- Selecting Projects as the source will show you the total revenue data based on the Revenue row in the project Revenue subtab.
- Selecting Quotes as the source will show you the revenue calculated from your tentative and fixed project bookings at the project's role prices. Bookings-based revenue is only available for projects with role-based pricing.
- Project type – you can exclude the internal projects to focus only on the revenue-generating work
- Project status
- Quote status
- Date range – when Bookings is selected as a source, the date filter for projects and quotes is named Project / Quote, and an additional date filter named Bookings becomes available. This lets you set one time range for projects and quotes and a different timeframe for bookings.
- Responsible party – for quotes, it’s the quote author. For projects, it’s the project manager. This filter enables you to analyze how much revenue specific people are bringing in or have in their pipeline.
- Clients – this filter is helpful if you want to understand how a particular client contributes to your revenue.
- Project tags.
- If you select "quotes" as the source, the report will display the forecasted revenue that you can expect to earn based on the quotes that are in your sales pipeline.
- If you select "projects" as the source, the report will show you the total revenue data based on the Revenue row in the project Revenue subtab.
If you select "bookings" as the source, the report will show you the revenue calculated from your project bookings.
Examples of various filtered views
Check out what questions the revenue report can help you answer and how to filter the report view:
How much revenue have we generated?
To determine how much revenue you have generated in the last six months, apply the following filters:
- Source: Projects
- Project status: Completed
- Date range: the last six months
How much revenue are we guaranteed over the coming months?
How much revenue are we guaranteed over the coming months?
To learn how much revenue you are guaranteed for the next six months, apply the following filters:
- Source: Projects
- Project status: Active projects
- Date range: the next six months
How much potential revenue do we have in the pipeline?
To find out how much potential revenue you have in the pipeline for the next six months, apply the following filters:
- Source: Quotes
- Quote status: Active quotes
- Date range: the next six months
2.3. Bookings-based revenue
Select 'Bookings' and 'Projects' in the revenue report's Source field to see how much your bookings were worth and how much you actually earned against them. In the revenue chart, the blue bars are the project data, teal bars are the bookings, and the striped parts of the blue bars are quotes. Quotes and bookings show theoretical revenue, while projects show actual revenue (what you invoice).
Projects and bookings have separate date filters – Project / Quote and Bookings – so you can look at both timelines at once, e.g., projects from this quarter and bookings for the next six months.
Once bookings are selected as a source, the revenue table in the revenue report shows two rows of values for each project:
- Top row (in black) – the actual values
- Bottom row (in grey) – the bookings-based values.
If you don't need the bookings data in the revenue report, disable the 'Show bookings-based revenue' toggle to declutter the view.
Keep in mind that:
- Bookings-based revenue is not displayed for projects with service-based pricing.
- For projects with the Fixed fee and Time & Material capped revenue models, only bookings-based revenue up to the project budget is counted. Any amount over the budget is disregarded.
- Bookings-based revenue comes through projects, so projects remain visible in the table even if you disable Projects and Quotes as sources.
- Bookings-based revenue is a separate value to track. It doesn't affect revenue recognition or forecasting.
2.4. View settings
You can change the View settings for the report according to your needs. For example, you can sort the quote and project list below the graph from newest or oldest or vice versa.
You can also choose to Use weighted values for quotes if you want to take into account the quotes' closing probability as well.
Weighted values are calculated using the probability percentage assigned to each quote status in your pipeline.
If you tick that option, the report will factor in the closing probability of each quote and adjust the forecasted numbers accordingly.
To round the values in the revenue table, click View > View options and enable the 'Round values to whole numbers' checkbox. Rounding applies to both the actual and bookings-based values.
Example
For example, let’s say you have submitted two quotes for Client X in the first six months of 2024:
- Quote 43 in the Scoping status (50%)
- Full value: EUR 9,000
- Weighted value: 9,000 x 0.5 = EUR 4,500
- Quote 44 in the Proposal status (80%)
- Full value: EUR 9,000
- Weighted value: 3,000 x 0.8 = EUR 7,200
To generate a report on the revenue you can expect to receive from "Client X" between January 2024 and June 2024, apply the following filters:
- Source: Quotes
- Quote status: Active quotes
- Client: Client X
- Time period: 01.01.2024 to 30.06.2024
As the two quotes are not confirmed yet, and you want to factor in their pipeline status while forecasting your revenue, tick the Use weighted values for quotes option.
The report now considers the probability of each quote being accepted and its current status in your pipeline to show you an updated revenue forecast.
Accurate and well-informed revenue forecasting and recognition are essential for businesses to achieve sustainable growth and success. It enables companies to monitor their financial performance, evaluate profitability, and confidently plan for the future.
Learn more about how revenue forecasting and recognition work in Scoro here.
3. Creating dashboard widgets and charts
You can now use the revenue report as a source when creating dashboard widgets and charts, letting you view revenue data alongside other KPIs you track on your dashboard in real time.
Learn more about dashboard setup.
4. Exporting data
You can export data from the revenue report based on the filters you've applied for further analysis outside Scoro:
- Click the Export button above the revenue table.
- Select the file type you want to download – CSV or XLS – and click Export to download the data.
The revenue report export file includes everything in your filtered view, including bookings-based revenue data even if you disabled the 'Show bookings-based revenue' toggle before exporting.
See also: