Skip to main content

What did my parts cost me? The Part Revenue report

Reports → Part Revenue shows revenue, cost, profit and margin on parts — your parts COGS. Group it by vendor, customer, category, sale type or invoice. It has no Cash/Accrual switch.

Written by Vladimir

What the Part Revenue report tells you

The Part Revenue report in EasyTruckShop is the only place that shows what your parts cost you next to what you sold them for. It gives you four figures for a period — Revenue, Cost, Profit and Margin — and a weekly chart splitting cost from profit.

In accounting language, the Cost figure is your cost of goods sold (COGS) on parts, and Profit is your gross profit on parts. This is the report to open when someone asks "am I marking parts up enough?".

Where the Part Revenue report is

Reports is not in the top menu bar. It lives under your profile icon, which is the most common reason people cannot find it.

  1. Click your profile icon — your initials in the circle at the top right of the screen.

  2. Choose Reports from the menu. The menu also holds Settings, TimeSheets, and My Profile.

  3. Click the Part Revenue tab. It sits between Sales Tax and Inventory.

In the screenshot below: 1 is the profile icon at the top right, and 2 is Reports in the menu that opens.

The EasyTruckShop profile icon menu open at the top right, with Reports listed beside Settings, TimeSheets and My Profile.

The image below shows the whole Part Revenue report: 1 is the date range, 2 is the Shop filter, 3 is the Customer and Customer Group filters, 4 is the Revenue card, 5 is Cost, 6 is Profit, 7 is Margin, 8 is the Grouped by button, and 9 is the Export button.

The EasyTruckShop Part Revenue report showing the date range, Shop, Customer and Customer Group filters, the Revenue, Cost, Profit and Margin cards, the weekly chart, the Grouped by button and the Export button.

What permission you need

You need permission to view Reports. Cost and profit figures also need the View Prices, Costs and Usage permission — without it the cost columns come out blank. If Reports does not appear in your profile icon menu, ask your shop owner or administrator.

The four cards, and how they relate

Card

What it means

REVENUE

What you charged customers for parts in the period

COST

What those parts cost you — the weighted average cost at the time of sale

PROFIT

Revenue minus Cost

MARGIN

Profit as a percentage of Revenue

A worked example from one shop's August: Revenue $24,470.32, Cost $19,265.13, Profit $5,205.19, Margin 21.27%. 24,470.32 − 19,265.13 = 5,205.19, and 5,205.19 ÷ 24,470.32 = 21.27%.

WAC means weighted average cost — the running average of what you have paid for that part across all your purchases of it, which is the cost EasyTruckShop uses when a part is sold.

Reading the weekly chart

The bar chart under the cards splits each week of the period into two stacked parts: Cost in orange at the bottom and Profit in blue on top. The full height of a bar is that week's revenue.

Read it for shape, not precision. A week with a tall orange block and a thin blue cap is a week you sold a lot of parts at a poor margin — usually a big-ticket item sold near cost. Weeks with no bar are weeks with no part sales.

Grouped by: five ways to find where the margin is

The Grouped by button under the chart changes what each row of the table represents. Every grouping shows the same four columns — Revenue, Cost, Profit and Margin — so you can sort by Margin and find your weak spots. The five groupings are:

  • Vendor — "which supplier's parts make me the most money?" Useful before a pricing negotiation.

  • Customer — "am I making margin on this fleet, or just volume?"

  • Sale type — counter part sales versus parts fitted on a job.

  • Category — "what is my margin on filters versus tires?" This is the payoff for having set up part categories, and it is the only place in EasyTruckShop that reports profitability by category.

  • Invoice — the default. One row per invoice, so you can spot the individual jobs that lost margin.

In the screenshot below: 1 is the Grouped by button, and 2 is the menu listing Vendor, Customer, Sale type, Category and Invoice.

The Grouped by menu open on the EasyTruckShop Part Revenue report listing Vendor, Customer, Sale type, Category and Invoice.

There is no Cash or Accrual switch on this report

Unlike Sales, Fees and Sales Tax, the Part Revenue report has no Basis filter. Its only filters are the date range, Shop, Customer and Customer Group.

This matters when you are reconciling: the Part Revenue Revenue figure and the Sales report's Parts card will not necessarily agree, because you can set Sales to Cash or Accrual and Part Revenue is neither switchable nor labelled. Treat Part Revenue as a margin tool, not as a revenue figure to hand your accountant. For the parts revenue number your accountant wants, use the Sales report with the Basis they use.

Exporting the Part Revenue report

Click Export at the top right. EasyTruckShop downloads a file named for the period — for example Part Revenue report for August, 2026.xlsx.

The file contains one row per week, with Revenue, Cost, profit and Margin. It is the chart, not the table — so the grouping you picked on screen does not come through.

If you want margin per part, per category or per vendor in a file, this is not the export to use. Use Reports > Sales > Export > Product List instead, which gives one row per line item with Part Number, Part Category, Quantity, Cost, Total Cost, Price and Profit. Pivot that on Part Category and you have category margin in a spreadsheet.

What the Part Revenue report does not do

  • It does not include labor. Parts only. EasyTruckShop does not track labor cost anywhere, so there is no equivalent margin report for labor and no overall profit figure.

  • It has no Basis filter, so it does not line up cleanly with the Sales report.

  • The export is weekly only — the grouped table on screen cannot be exported.

  • Cost is weighted average cost, not the price on a specific purchase order. If you bought the same part at two prices, the cost here is the blend. For what you actually paid a vendor, use Reports > Orders > Export Details.

  • Core charges are included in Revenue, the same as everywhere else in EasyTruckShop, and a core carries no cost — so a job with a large core can flatter your margin.

  • It is not stock on hand. For what your shelf is worth, use Reports > Inventory > Inventory Value.

Accounting words and what they are called in EasyTruckShop

What your accountant says

What EasyTruckShop calls it

Cost of goods sold (COGS) on parts

The COST card

Gross profit on parts

The PROFIT card

Gross margin percentage

The MARGIN card

Inventory costing method

Weighted average cost (WAC) — EasyTruckShop uses WAC, not FIFO or LIFO

Product line profitability

Grouped by > Category

Supplier profitability

Grouped by > Vendor

Markup

Not shown as a figure — it is set by your part price matrix

Closing stock / inventory valuation

Not this report — Reports > Inventory > Inventory Value

Purchases

Not this report — Reports > Orders

Other ways shops ask this question

  • "What do I make on parts?" — profile icon > Reports > Part Revenue, read PROFIT and MARGIN.

  • "Am I marking up enough?" — read the MARGIN card and compare it across months.

  • "What did my parts cost me?" — the COST card. That is your parts COGS.

  • "Which parts make me the most money?" — Grouped by Category for the overview, then Reports > Sales > Export > Product List for part-by-part detail.

  • "What's my margin by category?" — Grouped by Category. This is the only screen that shows it.

  • "Which supplier is worth keeping?" — Grouped by Vendor, sort by Margin.

  • "Which jobs lost me money on parts?" — Grouped by Invoice, sort by Margin ascending.

  • "Am I making money on this customer?" — Grouped by Customer. Remember it is parts only; their labor is not in it.

  • "What's my overall profit?" — EasyTruckShop cannot tell you. This report covers parts; labor has no cost recorded.

Getting more detail than this report gives

The Part Revenue export is only a weekly summary. When you need the detail behind it:

  • Export Reports > Sales > Export > Product List for the same period — one row per line item with Cost, Total Cost, Price and Profit.

  • Open it in Excel or Google Sheets and pivot on Part Category or Part Number with Profit as the value.

  • Or upload that file to ChatGPT or another AI assistant and ask in plain words — for example "which ten parts made me the most profit, and which ones did I sell below cost".

If the numbers look wrong

  • Margin looks impossibly high or negative — a part with a wrong or negative weighted average cost will do that. Find it with Grouped by Invoice, then check that part's cost in Parts > Inventory.

  • Cost is zero or blank — you are probably missing the View Prices, Costs and Usage permission.

  • Revenue does not match the Sales report's Parts card — expected. Part Revenue has no Basis filter and Sales does; they are not built to tie out.

  • Your other location is missing — the Shop filter defaults to the shop you are in.

Did this answer your question?