The Reports page
From the main sidebar, click Reports. The item shows a Beta tag.
On the left of the page, you choose a Report Type, then a report from Available Reports. Some reports also show a Report Order card. The filters for the chosen report appear on the right. The Reset Filters, Download CSV and Generate Report buttons sit at the top of the page.
The Work in Progress Report is selected when the page opens.
Company Wide reports
These reports cover all your projects. Under Available Reports you see:
| Report | What it shows |
|---|---|
| Work in Progress Report | Each project's projected sales value, costs by type, profit and work in progress value |
| Outstanding Purchase Deliveries | Purchase Orders where less has been delivered than was ordered |
| Project Outstanding Retention Report | The retention still outstanding on each project |
| Financial Report | A financial overview of each project — values, certified amounts and projections |
| Cost Report | Each project's invoiced costs, split into site labour, materials, plant hire, travel mileage, shop labour, subcontractor labour, expenses and preliminaries |
| Regional Sales Report | Sales by region, with the number of jobs and their values |
| Client Sales Report | Sales by client, with the number of jobs and their values |
| Project Type Report | Sales by project type, with the number of jobs and their values |
| Purchase Order Over Charge | Purchase Orders where the invoiced value is more than the order value |
| Sell Value Report | Each project's Applications, Payment Notices, Invoices and money received, with the balance still to be paid |
The Sell Value Report only appears if your company is not connected to Xero, Sage or Sage 50.
Filters for Company Wide reports
The Report Filters card has these filters: Job Created, Created Between (Start), Created Between (End), Status, Created By, Region, Client, Project Manager, Site Manager, Project Type and Suppliers.
- Job Created and Created Between cannot be used together. Pick one or the other.
- Status becomes available once you have chosen a report.
- Suppliers only applies to the purchase reports — Outstanding Purchase Deliveries and Purchase Order Over Charge.
Filters for the Work in Progress Report
The Work in Progress Report has its own WIP Date Filter card instead of the standard filters:
- Budget Updated From and Budget Updated To — include only projects whose budget was updated between these two dates.
- Project Manager — include only one project manager's projects.
By Project reports
These reports focus on a single project. Under Available Reports you see:
| Report | What it shows |
|---|---|
| Job Sheet Report | A printable sheet for your engineers to write down hours and materials on site |
Choose the project in the Project Selection card.
For By Project reports you must choose a project first. Until you do, Generate Report and Download CSV stay greyed out.
Subcontractor reports
These reports check subcontractor compliance. Under Available Reports you see:
| Report | What it shows |
|---|---|
| Expired Certificates and Cards | Certificates and cards that have expired, or will expire in the next 30 days |
| Expired Insurance | Insurance policies that have expired, or will expire in the next 30 days |
| Expired CIS | CIS registrations that have expired, or will expire in the next 30 days |
In the Subcontractor Report Filters card, choose a Subcontractor to report on one. Leave it blank to include all active subcontractors. The Project box is greyed out for these three reports.
Generating a report
- 1
From the main sidebar, click Reports.
- 2
Under Report Type, choose Company Wide, By Project or Subcontractor.
- 3
Under Available Reports, choose a report. If you change the Report Type, choose your report again.
- 4
Set any filters you need on the right of the page.
- 5
If you see a Report Order card, choose Project Number or Alphabetical (A-Z).
- 6
Click Generate Report.
A Generating report... message shows, then Report ready!. The report opens in a new browser tab. Your filters are cleared afterwards. To clear them yourself at any time, click Reset Filters.
If the report does not open, your browser may be blocking pop-ups. Allow pop-ups for Project Commander, then generate the report again.
Downloading the figures as a CSV
To work with the figures in a spreadsheet, choose your report and filters as above, then click Download CSV instead of Generate Report. The file holds the figures behind the report. If there is nothing to include, a No data available to download message appears instead.
Next steps
- Introduction to Reports and Analytics — an overview of the reporting tools, including printing a single document.
- Budgets — see the budget figures that the Work in Progress Report and Cost Report draw on.
- Certificates and Cards — set up the certificates and cards that the Expired Certificates and Cards report checks.
- The Company Dashboard — view dashboard-level analytics charts.
- The Project Dashboard — view project-level budget tiles and charts.