---
title: "Report 185 - Job Profitability"
canonical: "https://technology.bytangram.com/space/TGKB/770113559/Report%20185%20-%20Job%20Profitability"
format: markdown
---
This job profitability report shows a breakdown by client, project manager, and account manager, detailing estimated financials, contribution margin, and gross profit. It helps provide an overall view of client and job financial health.
> ✅ **Tips **
> ✅
> ✅ - This report brings data in based upon the jobs filtered within the jobs list. Always check your job filter before filtering further when running the report.
> ✅ - This report is best run on** closed jobs** as it will then show final profitability on these jobs.
| **ON THIS PAGE YOU WILL FIND:** |
| --- |
| > Macro (toc) |
---
## NAVIGATION
With your **jobs filter **set up to show the jobs you want to report on, in the **jobs** module:
- Go to the **reports** icon > select **job profitability (185)**
---
## SET REPORT CRITERIA
- **Include data by:**
- **Posting Date: **looks at all records that have a posting date within the date range
- **Job End Date:** will only pull job data for jobs with an end date in the date range
- **Include Invoice Drafts: **will include invoices that are **not finalised**
- **Include Price Quote Drafts: **will include **unapproved** price quotes
- **Show job details: **enables you to view financial health by job
- **Hide jobs with no data: **removes any jobs that have no data from the report
- **Include Approved POs as External Cost: **will show approved, unsettled POs as a cost alongside and creditor invoices on the job
- **Include all adjustments: **will include monthly write on/write off as well as adjustments made at job closure
---
## VIEWING THE REPORT
- Go to the icons in the top right and select either:
- View as a PDF
- Export as an email
- Export as a PDF, Excel, CSV file
| **NUMBER** | **COLUMN NAME** | **DETAILS** |
| --- | --- | --- |
| **1** | **Dimension** | As set in your report criteria groupings |
| **2** | **Customer** | Identifies the client linked to the job, based on the customer record selected when the job was created |
| **3** | **Date** | Displays either the Job End Date or the Posting Date, depending on the filters applied to the report |
| **4** | **Total (PQ)** | Total of **approved** price quotes |
| **5** | **Purchases (PQ)** | 3rd party costs on **approved** Price Quotes |
| **6** | **NR (PQ)** | PQ Net Revenue = (4) Total PQ less (5) PQ purchases |
| **7** | **Pct (PQ)** | Percent PQ estimated = Net Margin/Net Revenue
> 📝 Note: Net margin percentage denominator (revenue or net revenue) depends upon system variable 267 |
| **8** | **Internal (Exp)** | Value of Time & Materials logged on job |
| **9** | **Purchases (Exp)** | Charge out rate of approved POs &/or posted creditor invoices
> 📝 Note: Includes PO data only if selected in the report criteria |
| **10** | **Total (Exp)** | Total = (8) Internal + (9) Purchases |
| **11** | **Revenue (Inv)** | **Finalised **invoices to date |
| **12** | **Purchases cost price (Inv)** | Cost of approved POs &/or posted creditor invoices
> 📝 Note: Includes PO data only if selected in the report criteria |
| **13** | **NR (Inv)** | Net revenue = (11) Revenue less (12) purchase cost price |
| **14** | **CM (Inv)** | Contribution Margin = (13) NR less cost of hours & materials logged on job |
| **15** | **CR (Inv)** | Contribution Ration - (14) Contribution Margin / (13) Net Revenue
> 📝 Note: Net margin percentage denominator (revenue or net revenue) depends upon system variable 267. |
| **16** | **Up/Down** | **Finalised** invoices less total expenditures, sales price |
| **17** | **WIP adjustment** | Job WIP adjustments to date |
---
### Related articles
> Macro (contentbylabel)