What the Orders report tells you
The Orders report in EasyTruckShop shows what you bought over a period — your purchase orders. It answers "how much did I spend with TEC Equipment last quarter" and "which parts am I buying the most of".
This is the buying side of your shop. It is not sales. In accounting language this is your purchases or cost of parts purchased, and it feeds accounts payable.
A PO (purchase order) is the order you place with a vendor. The Orders report counts POs, not invoices to customers.
Where the Orders 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 Orders tab. It sits between Inventory and Service Types.
In the screenshot below: 1 is the profile icon at the top right, and 2 is Reports in the menu that opens.
The two cards at the top are ORDERS (how many purchase orders) and TOTAL (what they came to).
The image below shows the Orders tab: 1 is the filter row with the date range and Shop, 2 is the two total cards, and 3 is the grouped table of vendors.
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.
Group by Vendor or by Part
The Grouped by button under the cards changes what each row of the table represents. The Orders report offers two groupings:
Vendor — one row per supplier, with how many orders and the total spent. This is the default, and it is the one to use for "who am I buying the most from" or "what did I spend with this supplier".
Part — one row per part number, with how many orders and the total spent. Use this for "which parts am I buying the most of" or "how much am I spending on filters".
Click Grouped by and choose the one you want; the table redraws immediately. In the screenshot below: 1 is the Grouped by menu open showing Vendor and Part.
Why some vendor names are in red and say (Archived)
A vendor name shown in red with (Archived) after it is a supplier you have archived in EasyTruckShop. Their historical orders still count in the report — archiving a vendor does not remove what you already bought from them. That is correct behavior: your spend history stays intact.
Setting the period
The date button on the far left opens on This Month. Click it to choose a month, quarter, year, or custom range. Both cards and the table recalculate.
Exporting: two different files
Click Export at the top right of the Orders report. Unlike most reports, this one gives you a choice of two files. Pick the one that matches what you need. In the screenshot below: 1 is the Export menu open showing Export and Export Details.
Export — the summary file
Choosing Export downloads orders.xlsx. It is the table you see on screen, with three columns:
Vendor
Orders
Total
Use this when someone asks for spend by supplier and nothing more.
Export Details — the line-by-line file
Choosing Export Details downloads orders_detailed.xlsx. This is the useful one. It has one row for every part line on every purchase order in the period, with these columns:
Date
PO number
Receipt
Vendor
Type
Part Number
Description
Unit
Cost
Core — the core charge on that line
Quantity
Total
Destination — whether the part went to inventory (onto your shelf) or straight to a service (onto a job)
Core and Destination are only in this file. The on-screen report shows neither. If you need to know what you paid in core charges, or how much of your buying went straight onto jobs instead of onto the shelf, Export Details is the only place that answers it. A core is the refundable deposit a supplier charges you on a rebuildable part, refunded when you send the old unit back.
What the Orders report does not do
It does not show what you owe your vendors. There is no accounts payable aging in EasyTruckShop. The Orders report shows what you ordered, not what is still unpaid.
It does not have a Basis filter. Unlike Sales, Fees and Sales Tax, there is no Cash or Accrual switch here — orders are counted by their date.
It does not show what those parts sold for. For the sale side and your margin, use the Part Revenue report.
It does not show current stock. For what is on your shelf right now and what it is worth, use Reports > Inventory > Inventory Value.
It does not filter by customer. Orders are supplier purchases, so there is no Customer or Customer Group filter on this tab.
Accounting words and what they are called in EasyTruckShop
What your accountant says | What EasyTruckShop calls it |
Purchases / cost of parts purchased | The TOTAL card on the Orders report |
Purchase order (PO) | An order — one row when grouped by Part, one of the count when grouped by Vendor |
Vendor / supplier spend | Grouped by > Vendor |
Goods received | The Receipt column in orders_detailed.xlsx |
Core deposit | The Core column in orders_detailed.xlsx |
Inventory purchases vs direct-to-job purchases | The Destination column — inventory or service |
Accounts payable | Not available in EasyTruckShop — track it in QuickBooks |
Cost of goods sold (COGS) | Not this report — see Part Revenue for the cost of parts you actually sold |
Other ways shops ask this question
"How much did I spend on parts last month?" — profile icon > Reports > Orders, set the date, read the TOTAL card.
"Which supplier am I buying the most from?" — Grouped by Vendor, look at the top row.
"What am I buying most often?" — Grouped by Part.
"I need every PO for the year for my accountant" — set the year, then Export Details.
"How much did I pay in core charges?" — Export Details, then total the Core column.
"How much of what I bought went straight onto jobs?" — Export Details, then filter the Destination column to service.
"Do I owe this vendor money?" — the Orders report cannot tell you. Open the vendor's purchase orders directly, or check QuickBooks.
The detailed file has too many rows. What now?
orders_detailed.xlsx has one row per part line, so a busy year can run to thousands of rows. Three ways to cut it down:
Narrow the date range in EasyTruckShop and export again — this is the cleanest fix.
Open the file in Excel or Google Sheets, turn on filters, and filter the Vendor, Part Number, or Destination column. A pivot table on Vendor and Total answers most spend questions in seconds.
Upload the file to ChatGPT or another AI assistant and ask in plain words — for example "total the Core column by vendor" or "list the ten parts I spent the most on".
If the numbers look wrong
Spend looks too low — check the date range, and check the Shop filter, which defaults to the shop you are in rather than all locations.
A vendor is missing — they may be archived; archived vendors still appear, but in red, so check you are not skipping them.
The total does not match your vendor statement — the Orders report counts orders by order date, and does not know about credits, returns, or freight billed separately. Compare against orders_detailed.xlsx line by line.
Still off — send support the orders_detailed.xlsx file, the date range, and the shop you used.




