Skip to main content

How much did I spend with my vendors? The Orders report

Use Reports > Orders in EasyTruckShop to see purchase order spend by vendor or by part, and export the detailed file that shows every line you bought.

Written by Vladimir

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.

  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 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 EasyTruckShop profile icon menu open at the top right, with Reports listed beside Settings, TimeSheets and My Profile.

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.

The EasyTruckShop Orders report showing the date range and Shop filters, the ORDERS and TOTAL cards, and the table of vendors with archived vendors shown in red.

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.

The Grouped by menu open on the EasyTruckShop Orders report showing the Vendor and Part options.

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.

The Export menu open on the EasyTruckShop Orders report showing the Export and Export Details choices.

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.

Did this answer your question?