ARM Help

Detailed Cost Of Parts Report

Detailed Cost Of Parts Report shows what the parts on each finalized invoice cost you against what you sold them for, one line per invoice, with a gross profit percentage on the parts. The cost is split into parts bought in for the job (OPP) and parts taken from your own inventory. Use it to find jobs where parts were sold at a loss, to spot invoices whose parts have no cost recorded, and to see the parts margin for a period.

3 how-to answers 3 screenshots Open in ARM Markdown

How do I run the Detailed Cost Of Parts Report? #

  1. From the Home Screen, click Reports → Shop Expenses & Vendor Reports → Detailed Cost Of Parts Report.
  2. Set the date range in the From / To selector. It opens on the first of this month to today, and it is matched against the date each invoice was finalized.
  3. To find one invoice, type its number in SEARCH TEXT, or leave it empty for every invoice in the range.
  4. Click SEARCH to load the report. SHOW ALL clears the search and reloads.
  5. Click DOWNLOAD to export to a spreadsheet. This report has no Print button.
Detailed Cost Of Parts Report filters
Detailed Cost Of Parts Report filters
Detailed Cost Of Parts Report searched by invoice number
Detailed Cost Of Parts Report searched by invoice number

How do I work out the parts gross profit on an invoice? #

  1. From the Home Screen, click Reports → Shop Expenses & Vendor Reports → Detailed Cost Of Parts Report, run it for your date range and pick one line.
  2. Start with Part Sale Price After Discount: what the customer paid for the parts, after any discount. Example: invoice 335221, $140.48.
  3. Take the OPP Amount: the parts bought in for this job. Example: $90.00.
  4. Add COG-Inventory: the cost of parts taken from stock. Example: $20.72.
  5. Total is OPP Amount + COG-Inventory. Example: $90.00 + $20.72 = $110.72.
  6. Gross Profit % is (Part Sale Price After Discount − Total) ÷ Part Sale Price After Discount × 100. Example: ($140.48 − $110.72) ÷ $140.48 × 100 = 21.18 %.
  7. When the parts cost more than they were sold for, the percentage goes negative, and it can be large. Example: invoice 335220 sold $15.00 of parts that cost $50.00 + $6.40 = $56.40, so ($15.00 − $56.40) ÷ $15.00 × 100 = −276.00 %. Its Gross Sales of $164.97 plays no part.
  8. The Total: row gives no percentage. Work it from the totals: (Part Sale Price After Discount total − Total total) ÷ Part Sale Price After Discount total × 100. Example: ($428.43 − $186.62) ÷ $428.43 × 100 = 56.44 % for 09-01-2026 to 09-25-2026.
Detailed Cost Of Parts Report list and totals
Detailed Cost Of Parts Report list and totals

How do I look up one invoice? #

  1. From the Home Screen, click Reports → Shop Expenses & Vendor Reports → Detailed Cost Of Parts Report.
  2. Type the invoice number in SEARCH TEXT, or pick it from the list that appears as you type. Example: 335220.
  3. Click SEARCH. The report shows that invoice's line alone, if it was finalized within the date range.
About this screen

Each line shows the Invoice #, the Finalize Date, the invoice's Gross Sales, the Part Sale Price After Discount (what the customer paid for the parts on that invoice), the OPP Amount (what you paid suppliers for parts bought in for the job), COG-Inventory (the cost of parts taken from your own stock), the Total parts cost, and Gross Profit % on the parts. The Total: row at the foot adds up the five money columns for the lines on the page you are looking at. It leaves Gross Profit % blank.

Gross Profit % is worked from the parts figures only. It does not use Gross Sales, even though that column sits beside it. Gross Sales includes labor and everything else on the invoice. The percentage compares the parts sale price with the parts cost.

A line showing 100.00 % usually means no cost was recorded, not that the parts were free. When an invoice's parts were not linked to an inventory item or an outside part purchase, the cost columns read $0.00 and the percentage comes out at 100 %. Treat such lines as invoices to check. Example: invoice 335230 sold $171.96 of parts with $0.00 cost recorded.

The Total: row covers only the page on screen, and there is no report-wide total anywhere on the page. To total a long period, set a range that fits on one page or add the pages together.

To see the outside part purchases behind an OPP Amount, run OPP & Shop Paid Outs Report for the same dates.

Ask AI