Frontline PSA Docs

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.

Frontline PSA
The report catalogue with reports grouped by area

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

Frontline PSA
A report with period presets, filters, a chart and the results grid
  1. Click Run on a card, or click the report's name in the side panel.
  2. 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.
  3. 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.
  4. 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

ReportWhat it shows
Tickets by status, queue, priorityTickets created in the period, grouped by queue, status or priority, with how many are still open, waiting or done.
Tickets opened vs closedTickets created and completed each week, and the net change to the backlog.
SLA compliancePercentage of first-response and resolution targets met, by queue and priority, for tickets created in the period.
Ticket agingOpen 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 volumeCompanies ranked by tickets created in the period, with hours worked for them and tickets still open.
First-contact resolutionShare of completed tickets closed within 24 hours by one person without escalation, per technician. This is an approximation.

Time & utilisation

ReportWhat it shows
Utilisation by resourceWorked, billable and non-billable hours per person, compared with their capacity for the period.
Time by companyHours worked, billable, non-billable and hours to bill for each company.
Time by work typeHours by work type, and internal time by category, split into billable and non-billable.
Unapproved & unsubmitted timeHours still in draft, submitted but not approved, or rejected, per person, with the oldest entry.

Finance

All five need billing access.

ReportWhat it shows
Recurring revenue (MRR)Monthly recurring revenue and cost from active contract services, by company or by service. A snapshot.
Revenue by monthInvoices per month with subtotal, tax, total and how much has been paid.
Revenue by billing codeInvoiced amounts split by billing code: labour, materials, services, expenses and milestones.
AR agingOpen invoice balances by customer: current, and 1–30, 31–60, 61–90 and over 90 days past due. A snapshot.
Project budget vs actualEstimated hours, budgeted revenue and budgeted cost against actuals for open and recently completed projects. A snapshot.

CRM

ReportWhat it shows
Opportunity pipelineOpen opportunities by stage, with first-year value and probability-weighted value. A snapshot.
Win rate by ownerWon and lost opportunities closed in the period for each owner, with win rate and won value.

Contracts

ReportWhat it shows
Contract profitabilityRevenue, labour cost, unit costs and margin for each contract. Contracts under 35% margin stand out. Needs billing access.
Block hour burnHours 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

ReportWhat it shows
Devices by typeDevices per type: active, retired, warranty expired and warranty expiring in the next 90 days. A snapshot.
Warranty expiringActive devices whose warranty ends in the period, soonest first. Defaults to the next 90 days.
Stock valuationUnits on hand, reserved and on order, with their value at unit cost, by product or by location. A snapshot.
Stock below reorder pointProducts 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.