Where to find this report?
Insights and Reporting > Finance > Revenue Forecast
The billing contract revenue forecast projects what you can expect to invoice each month based on your active billing contracts and their billing schedules. It's a forward-looking estimate, not a record of revenue already invoiced, and you can view it either inside the PM Forecast dashboard or as its own standalone Revenue forecast report under Insights and Reports.
Setup
You will need the following permission in your security group:
Can access the intelligence page
Click here to learn about permissions and security groups.
How to access the report
From the PM Forecast dashboard
1. Go to Insights and Reports, then click PM Forecast under Operations.
2. The Contract Revenue Forecast section near the top shows a chart and a table, split by Fixed and Do & Charge contract type, with one row per month.
3. Filter by Client or Client Group, Client Account Manager, Branch or Zone, and change the time period from the selector in the top right. Next 12 Months is the default; you can also choose Next 3 Months, Quarter, Calendar year, Financial year or a custom range of Months.
As a standalone report
1. Go to Insights and Reports, then click Revenue forecast under Finance.
2. This view breaks revenue down by product or line item instead, with one column per month across a single calendar year.
3. Filter by Properties, Clients, Client Groups or Branch, and use the arrow buttons next to the year to move between years.
What the report shows
On the PM Forecast dashboard, each month shows Contracts (the number of unique active contracts invoicing that month) and Forecast Revenue, broken out for Fixed and Do & Charge contracts plus a Total.
On the standalone report, Total contracts and Total revenue sit at the top, followed by a row for each product or line item showing its forecasted revenue per month.
Either way, revenue includes fixed-price amounts and the base amount of do-and-charge contracts, and combines multiple contracts that share a billing date. It does not include variable do-and-charge overages.
How revenue is calculated
Fixed contracts
Revenue is the line item's fixed amount multiplied by the number of billing cycles falling in the period, for example $2,000 a month × 10 months. Billing frequency sets how many times a contract bills each year: Monthly (12), Bi-monthly (6), Quarterly (4), Half-yearly (2) and Annually (1). A contract that starts mid-month still appears in that month's bucket for the full month's billing. Forecast accuracy is highest for fixed contracts.
Do & Charge contracts
Revenue comes from two parts: asset-based line items (unit price × the count of physical assets of that type) and per-visit line items (unit price × one per applicable routine occurrence). The forecast uses the base amount plus a historical average of variable charges, so actuals can vary. Accuracy is medium for do-and-charge contracts with billing history, and low for brand-new contracts.
What's included and excluded
A contract is included only if:
It's active: its start date is on or before the period and its end date is after it, and it isn't cancelled, suspended or expired.
For Fixed contracts, the line item is visible and set to type F, and the routine is active on the property.
For Do & Charge contracts, the routine has been generated, meaning a task has been created from it.
The forecast excludes:
Task-based or one-off invoicing that isn't tied to a billing contract.
Services or ad-hoc work without a linked billing contract.
Expired, cancelled or suspended contracts.
Inactive properties.
Caveats to keep in mind
The forecast assumes all active contracts continue unchanged, with no new contracts and no mid-contract price changes.
Forecast accuracy is highest for fixed contracts, medium for do-and-charge contracts with billing history, and low for brand-new contracts or do-and-charge overages.
Revenue calculations are cached for around an hour per tenant, so a recent contract change can take a short time to appear.
Inactive assets still linked to an active routine can be counted in the projection and inflate it. If a forecast looks unexpectedly high, check for inactive assets on the affected properties.