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.
Click your profile icon — your initials in the circle at the top right of the screen.
Choose Reports from the menu. The menu also holds Settings, TimeSheets, and My Profile.
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 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.
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.
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.



