Contracts and billing
Reports
Frontline PSA includes 23 built-in reports. Each one has a chart, a table with totals, and a CSV export. Reports always read live data, so what you see is current as of the moment you open it.
Find a report
Open Reports. The Report catalogue shows every report you can run as a card, grouped by area. The same list is in the side panel, so you can jump between reports without returning to the catalogue. Use the search box in the module bar to filter the catalogue by title or description.
Each card shows the report's default period (or "as of today" for reports that are a snapshot), a CSV button that downloads the report with its default settings, and a Run button.
Run a report
- Click Run on a card, or click the report's name in the side panel.
- Choose a period. Reports that cover a date range offer This week, Last week, Month to date, Last month, Last 30 days, Last 90 days, Quarter to date, Year to date and Last 12 months. Choose Custom to enter your own from and to dates.
- Narrow the results with the filters under the title. Depending on the report these are All companies, All resources and All queues. Not every report has every filter.
- Some reports can be grouped in more than one way. Use the By … buttons to switch, for example By queue, By status or By priority.
The report updates as soon as you change anything. The page address includes your choices, so you can bookmark a report or send the link to a colleague and they will see the same settings.
Snapshot reports, such as AR aging or Stock valuation, have no period. They show the position as of today.
Read the results
- The Chart panel summarises the results. Long reports chart only the top rows.
- The grid lists every row. Click a column header to sort.
- The totals row sits under the grid.
- Where a row refers to a record, such as a company, contract or project, click the row to open it.
Export to CSV
Click Export CSV at the top right. The file contains the same rows as the grid, using the period and filters you have chosen.
Who can see which reports
You need access to reports to open the Reports module at all. Six reports also contain financial figures and are marked with a finance tag. They only appear if your security level also has billing access:
- Recurring revenue (MRR)
- Revenue by month
- Revenue by billing code
- AR aging
- Project budget vs actual
- Contract profitability
If you do not have billing access, the catalogue reminds you that "finance reports need billing access" and those reports are hidden. Ask your administrator to change your security level. See Administration.
Report list
Service desk
| Report | What it shows |
|---|---|
| Tickets by status, queue, priority | Tickets created in the period, grouped by queue, status or priority, with how many are still open, waiting or done. |
| Tickets opened vs closed | Tickets created and completed each week, and the net change to the backlog. |
| SLA compliance | Percentage of first-response and resolution targets met, by queue and priority, for tickets created in the period. |
| Ticket aging | Open tickets grouped by age (0–2 days, 3–7, 8–30, over 30) for each queue, with the oldest ticket. A snapshot. |
| Top companies by volume | Companies ranked by tickets created in the period, with hours worked for them and tickets still open. |
| First-contact resolution | Share of completed tickets closed within 24 hours by one person without escalation, per technician. This is an approximation. |
Time & utilisation
| Report | What it shows |
|---|---|
| Utilisation by resource | Worked, billable and non-billable hours per person, compared with their capacity for the period. |
| Time by company | Hours worked, billable, non-billable and hours to bill for each company. |
| Time by work type | Hours by work type, and internal time by category, split into billable and non-billable. |
| Unapproved & unsubmitted time | Hours still in draft, submitted but not approved, or rejected, per person, with the oldest entry. |
Finance
All five need billing access.
| Report | What it shows |
|---|---|
| Recurring revenue (MRR) | Monthly recurring revenue and cost from active contract services, by company or by service. A snapshot. |
| Revenue by month | Invoices per month with subtotal, tax, total and how much has been paid. |
| Revenue by billing code | Invoiced amounts split by billing code: labour, materials, services, expenses and milestones. |
| AR aging | Open invoice balances by customer: current, and 1–30, 31–60, 61–90 and over 90 days past due. A snapshot. |
| Project budget vs actual | Estimated hours, budgeted revenue and budgeted cost against actuals for open and recently completed projects. A snapshot. |
CRM
| Report | What it shows |
|---|---|
| Opportunity pipeline | Open opportunities by stage, with first-year value and probability-weighted value. A snapshot. |
| Win rate by owner | Won and lost opportunities closed in the period for each owner, with win rate and won value. |
Contracts
| Report | What it shows |
|---|---|
| Contract profitability | Revenue, labour cost, unit costs and margin for each contract. Contracts under 35% margin stand out. Needs billing access. |
| Block hour burn | Hours purchased, used and remaining for each block, with the date it is projected to run out at the last 30 days' rate of use. A snapshot. |
Inventory
| Report | What it shows |
|---|---|
| Devices by type | Devices per type: active, retired, warranty expired and warranty expiring in the next 90 days. A snapshot. |
| Warranty expiring | Active devices whose warranty ends in the period, soonest first. Defaults to the next 90 days. |
| Stock valuation | Units on hand, reserved and on order, with their value at unit cost, by product or by location. A snapshot. |
| Stock below reorder point | Products where available stock is under the reorder minimum, with a suggested order quantity and cost. A snapshot. |
What reports do not do
Limit: There is no custom report builder. You can filter, group and sort the built-in reports, but you cannot add your own reports or columns.
Limit: Reports cannot be scheduled or emailed. To share results, send the page link to a colleague who has access, or export the CSV.
Many grids elsewhere in Frontline PSA, such as companies, contacts, devices and projects, also export to CSV. If a built-in report does not give you what you need, a filtered grid export is often the quickest alternative.