How To Run Job Costing Reports (Estimated vs. Actual)
Compare what a job was expected to cost with what it actually cost: per invoice line on the Invoice Cost Comparison list and the invoice's cost pages, and in labor time per order line on Estimated vs Actual Time.Updated Nov 9 2026
Before you start
- Cost Comparison is under Sales > Invoices and needs the Sales role.
- Est. Vs Act. Time is under Production > Mgmt and needs the Manager or Supervisor role.
- The invoice's DETAILS/SERIALS and COST ANALYSIS menu items show only to users who can see cost and labor cost.
- Estimated labor comes from the part's labor plan; actual labor comes from time logged on the work order. A job built without logged time shows 0 actual labor.
-
Compare estimated and actual cost by invoice
- Go to Sales > Invoices > Cost Comparison. The list is headed Invoice Cost Comparison and opens on invoices shipped from a week ago to a week ahead (the Date is between … chip, next to Business Type is All), one row per invoice line.
- To find a job, click the filter search bar (Filter or search…), pick Invoice, Customer, Prcpart, Trans Code (choose Build for built jobs) or Date, set the value and click Apply (n). Remove the Date chip, or change its range, to reach older invoices.
- Read across the row:
- Est Labor Minutes and Invoice Labor Minutes, Est Labor Cost and Invoice Labor Cost – estimated against actual labor.
- Est Overhead and Invoice Overhead, Est Material and Invoice Material – estimated against actual overhead and material.
- Invoice Outsource and Expenses – outside processing and expenses charged to the job.
- GM – gross margin of the line, green when positive and red when negative.
- To total by invoice or by part, set View By to Header or Prcpart and click Apply (n).
-
Review an invoice's cost details
- On Sales > Invoices > Cost Comparison, click the number in the Invoice # column. The invoice opens.
- Click DETAILS/SERIALS in the invoice's left-hand menu. For each line, COST BREAKDOWN
shows:
- Material Est against Material Unit, Labor/Outsource Est against Labor / Outsource Cost, and Overhead Est against Overhead Unit, each with its Extended total;
- SCRAP / STD COST – Total Scrap (material lost to scrap), the standard cost and the deviation from it;
- COMPONENT DETAILS – every component used, with the PO and Receipt it came from, lot, serial and cost, so you can trace sold material back to its purchase.
- Click COST ANALYSIS (on a multi-line invoice, COST ANALYSIS (n) and then the line) to see setup, labor, overhead, outsource, expense and material cost rolled up through the bill of materials. Expand All / Collapse All open or close the levels.
-
Compare estimated and actual labor time
- Go to Production > Mgmt > Est. Vs Act. Time. The list is headed Estimated vs Actual Time and shows order lines with a ship date in the last month (the Ship Date is between … chip), one row per order line and person who logged time (View By is User).
- To narrow it, click the filter search bar (Filter or search…), pick Customer, Order #, Part #, Username, Work Location, Status or another date (Work Start Date, Dock Date, Entry Date, Invoice Date), and click Apply (n).
- Compare Estimated Time (Hrs) with Actual Time (Hrs); Delta Amount (Hrs.) is the difference and Efficiency the ratio. The row colour shows how far the line is through production: green from 75 % of pieces completed, yellow from 26 % to 74 %, red below.
- To see time by step instead of by person, set View By to Work Location and click Apply (n); the actual time columns are then headed Total Time Logged. Set Show Totals? to Yes for a Totals row at the end.