Skip to main content

The Sales report: how much did I sell?

Reports → Sales gives your revenue split into labor, parts, fees and tax, on a cash or accrual basis, with three different export files.

Written by Vladimir

What the Sales report tells you

The Sales report in EasyTruckShop is the answer to "how much did I sell". It breaks your revenue for a period into six figures — Net Sales, Labor, Parts, Discounts, Fees and Sales Tax — and then lets you slice the same money by customer, by truck, by job type and more.

This is the report your accountant means when they ask for your revenue or turnover for a month, a quarter or a year.

Where the Sales 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 Sales tab. It is the second tab, right after Dashboard.

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 Sales report: 1 is the date range, 2 is the Shop filter, 3 is the Basis filter, 4 is the Customer / Customer Group / Ownership / Sale Type / Vehicle Type filters, 5 is the six summary cards, 6 is the Group by button, and 7 is the Export button.

The EasyTruckShop Sales report showing the date range, Shop and Basis filters, five filter chips, the six summary cards, the Group by button and the Export button.

What permission you need

You need permission to view Reports. If Reports does not appear in your profile icon menu, ask your shop owner or administrator to grant it.

What each of the six cards means

Card

What it counts

NET SALES

Labor + Parts + Fees, minus Discounts. Sales tax is not in it.

LABOR

Everything charged as labor or service work

PARTS

Everything charged as parts — including core charges

DISCOUNTS

What you took off, shown as a positive number and subtracted from Net Sales

FEES

Shop supplies and every other fee. Same figure as the Fees report on the same basis.

SALES TAX

Tax on top. Same figure as the Sales Tax report on the same basis.

A worked example, so the arithmetic is clear

Here is one shop's August on Accrual basis, straight off the report:

Labor

$11,868.35

Parts

$24,335.32

Fees

$1,693.91

Discounts

− $0.00

NET SALES

$37,897.58

Sales Tax (on top, not in Net Sales)

$499.25

11,868.35 + 24,335.32 + 1,693.91 = 37,897.58. That is exactly the Net Sales card. The $499.25 of tax sits outside it.

Two useful cross-checks fall out of this. The FEES card matches the Fees report exactly when both are on the same basis, and the SALES TAX card matches the Sales Tax report exactly on the same basis. If any of the three disagree, the Basis filters are set differently.

Cash or Accrual — check this before you copy a number

The Basis filter changes every figure on the page.

  • Accrual counts money the day you invoiced the job, paid or not.

  • Cash counts money only when the customer's payment arrives.

The Sales report opens on Cash. Note that the Fees report opens on Accrual, so the two do not agree until you set them the same way. The heading above the table always tells you which one you are looking at — it reads "Accrual Revenue for August, 2026" or "Cash Revenue for August, 2026".

In the screenshot below: 1 is the Basis menu open, showing Cash and Accrual.

The Basis filter open on the EasyTruckShop Sales report showing the Cash and Accrual options.

Group by: seven ways to slice the same money

The Group by button under the cards changes what each row of the table represents. The totals never change — only how they are divided up. The Sales report offers seven groupings:

  • Customer — the default. "Who are my biggest customers?"

  • Customer Group — the same question for a whole fleet at once.

  • Ownership — splits by how the truck is owned.

  • Sale Type — separates service work from counter part sales.

  • Vehicle — spend per truck. This is the one fleet managers want: what has unit 1442 cost this year?

  • Vehicle Type — trucks versus trailers versus other equipment.

  • Invoice — one row per invoice.

In the screenshot below: 1 is the Group by button, and 2 is the menu listing Customer, Customer Group, Ownership, Sale Type, Vehicle, Vehicle Type and Invoice.

The Group by menu open on the EasyTruckShop Sales report listing Customer, Customer Group, Ownership, Sale Type, Vehicle, Vehicle Type and Invoice.

Exporting: three very different files

Click Export at the top right of the table. The Sales report is the only report that offers a choice of three files, and picking the wrong one is the most common export mistake in EasyTruckShop.

In the screenshot below: 1 is the Export button, 2 is Summary, 3 is Invoice List, and 4 is Product List.

The Export menu open on the EasyTruckShop Sales report showing the Summary, Invoice List and Product List choices.

Summary

Downloads a file named after what is on screen — for example Cash Revenue for August, 2026.xlsx. One row per customer, with columns Customer, Labor, Parts, Fees, Discounts, Sales Tax, Total. Use it for a quick revenue breakdown.

Invoice List

Downloads invoice-list.xlsx. One row per invoice, with Invoice, Type, Customer, Unit, VIN, Vehicle Type, P.O., Date, Due Date, Status, Labor, Parts, Fees, Discounts, Subtotal, Tax Rate, Tax, Total and Balance.

Product List — the most detailed file in EasyTruckShop

Downloads invoices-details.xlsx. One row for every line on every invoice, labor lines included: Record Type, Invoice Number, Status, Date, odometer, operating hours, P.O., Customer, Unit, VIN, Type, Labor Type, Description, Part Number, Part Category, Quantity, Cost, Total Cost, Price, Profit, Tax Rate, Total.

Cost, Total Cost and Profit appear in no other export. If a question cannot be answered from any other file, it can almost always be answered from this one.

What the Sales report does not tell you

  • Net Sales is not profit. It is revenue. EasyTruckShop does not track labor cost at all, so there is no profit-and-loss report and no complete profit figure anywhere in the product. The closest thing is parts margin on the Part Revenue report.

  • Sales tax is not part of Net Sales. If you need gross including tax, add the two cards together.

  • Core charges are inside Parts, not broken out. A part sale with a core will make Parts look higher than the parts themselves.

  • It does not show who has paid. Even on Cash basis this is revenue, not receivables. For who owes you money, use Customers > Invoices and the Balance column.

  • It does not show hours. Labor here is money. For hours, use Service Types or TimeSheets.

Accounting words and what they are called in EasyTruckShop

What your accountant says

What EasyTruckShop calls it

Revenue / turnover / gross sales

NET SALES — note it excludes tax

Service income

The LABOR card

Product / merchandise sales

The PARTS card

Other income

The FEES card

Sales returns and allowances

The DISCOUNTS card

Sales tax payable

The SALES TAX card

Revenue by customer

Group by > Customer

Revenue by cost centre / by asset

Group by > Vehicle

Sales journal / invoice register

Export > Invoice List

Cost of goods sold (COGS)

Export > Product List, the Total Cost column — parts only

Gross profit

Not available. Parts margin is on Part Revenue; labor has no cost.

Other ways shops ask this question

  • "How much did I make last month?" — profile icon > Reports > Sales, set the date, read NET SALES. Check the Basis.

  • "What are my sales for the year?" — same, with the date set to the year.

  • "Who are my biggest customers?" — Group by > Customer, sort by Net Sales.

  • "How much have I spent on this truck?" — Group by > Vehicle. This is the fleet question.

  • "How much of my business is parts versus labor?" — compare the PARTS and LABOR cards.

  • "I need my revenue for my accountant" — set the Basis their books use, then Export > Summary, and tell them which basis you used.

  • "I need every invoice for the year" — Export > Invoice List.

  • "What did each part cost me and what did I make on it?" — Export > Product List.

  • "What's my profit?" — EasyTruckShop cannot tell you. There is no labor cost, so no P&L. Parts margin is on Part Revenue.

The file has too much data in it. What now?

  • Narrow it before exporting. Shorten the date range, or set the Customer, Customer Group or Shop filter, then Export again. The file always matches the screen.

  • Filter in the spreadsheet. Open the file in Excel or Google Sheets, turn on filters, and use a pivot table. Product List pivoted on Part Category with Profit as the value answers most margin questions in one step.

  • Ask an AI assistant. Upload the file to ChatGPT or similar and ask in plain words — "total the Profit column by Part Category" or "which customer had the highest parts spend".

If the numbers look wrong

  • Different from last time you looked — check the Basis. On Cash basis, a payment on an old invoice changes an earlier period's figure.

  • Net Sales does not match your invoice totals — invoice totals include sales tax; Net Sales does not.

  • Fees or Sales Tax cards do not match their own reports — the Basis filters are set differently. Sales opens on Cash, Fees opens on Accrual.

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

  • Still off — export the Invoice List for the same period and basis and send it to support with the date range, basis and shop you used.

Did this answer your question?