Skip to main content

How to Export an Inventory Report

Reports → Inventory shows what your parts on hand are worth today or on any past date, including cores. Use the Date filter for year-end cost of inventory.

Written by Vladimir

What this report is called

In EasyTruckShop, Inventory report, inventory value report, costing report, cost of inventory, parts on hand value, closing stock and stock value all mean the same thing: the Inventory tab inside Reports.

That tab holds two reports:

  • Inventory Value — what your parts on hand are worth, today or on any past date.

  • Inventory Change — what came in and went out over a period of time.


Where do I find the Inventory report?

  1. Click your profile icon in the top right corner.

  2. Click Reports.

  3. Click the Inventory tab. Inventory Value opens by default.

In the screenshot below: 1 is the left sidebar with Inventory Value and Inventory Change, 2 is the Date filter, 3 is Categories, 4 is Vendor, 5 is Archived Parts, 6 is the three value cards, 7 is Export, and 8 is the columns for each part.

The Inventory Value report in EasyTruckShop with the sidebar, Date, Categories, Vendor and Archived Parts filters, the three value cards, the Export button and the part columns numbered one to eight.

What do PART VALUE, CORE VALUE and TOTAL VALUE mean?

  • PART VALUE — quantity on hand × what the part cost you. The cost used is the Weighted Average Cost (WAC), the average across every time you bought that part.

  • CORE VALUE — the value of the cores attached to those parts. Parts carrying a core show a yellow CORE tag next to the part number.

  • TOTAL VALUE — PART VALUE + CORE VALUE.

Example from our demo shop: 123-BP Brake Pads, 18 on hand, $1.40K part value, $300.00 core value, $1.70K total value.

More on how cost is worked out: Weighted Average Cost (WAC)


How do I see the cost of my inventory for last year?

Yes, you can. The Inventory Value report has a Date filter that shows what your inventory was worth on any past date, including year end. Nothing has to be saved in advance.

  1. Go to Reports → Inventory → Inventory Value.

  2. Click Date.

  3. Use the < arrow to move back month by month.

  4. Click the day, then click Apply.

In the screenshot below: 1 is the Date button, 2 is the < arrow that moves back a month, 3 is where you click the day, and 4 is Apply.

The Date filter open on the Inventory Value report, showing the back arrow, the day grid and the Apply button.

The three cards and the whole parts list recalculate to that date, and the Date button then shows the date you picked.

Example from our demo shop, same shop on two dates:

  • Today: part value $352.1K, core value $3.4K, total $355.5K. The MICHELIN X line shows 377 on hand.

  • As of 12/31/2025: part value $377.9K, core value $795.00, total $378.7K. The same MICHELIN X line shows 486 on hand.

In the screenshot below: 1 is the Date button now reading 12/31/2025, 2 is the three recalculated cards, and 3 is the parts list showing the quantities held on that date.

The Inventory Value report back-dated to 31 December 2025, with the Date button showing that date and the value cards and parts list recalculated.

Tip for accountants: when your accountant asks for "cost of inventory for last year", pick 12/31 of that year. That is your closing stock, with cores shown separately.


Is the Date filter a range or a single day?

On Inventory Value it is a single day. You are asking "what was on my shelf on this date, and what was it worth", so you pick one date, not a from and to.

If you want a from and to range, that is Inventory Change, further down this article.


How do I export the Inventory report?

  1. Open Reports → Inventory → Inventory Value.

  2. Set the Date first if you want a past date, plus any other filters.

  3. Click Export on the right.

  4. An Excel file downloads. Open it in Excel or Google Sheets.

Opening Reports, choosing the Inventory tab and clicking Export to download the inventory file

Does the export use the date I picked?

Yes. The file is built from the date on screen, not from today, and it is named after that date — set the Date to 12/31/2025 and the download is called 2025-12-31 Inventory Report.xlsx.

The file totals match the cards. In our demo shop the 12/31/2025 export added up to $377,902.19 part value and $795.00 core value, which is the $377.9K and $795.0 on screen.

So you can produce a year end inventory file at any time of the year.


Important: the cost column on a past-date report

On a back-dated export, the Quantity and Value columns are correct for the date you picked, but the Weighted Average Cost column shows the part's cost today, not its cost on that date.

So on a past-date file, Value ÷ Quantity will not always equal the Weighted Average Cost shown beside it. That is expected.

  • Trust the Value column and the totals — they are correct for the date, and they tie to the cards on screen.

  • Do not use the Weighted Average Cost column as the unit cost for a past date.

On a report dated today, the two agree exactly: quantity × weighted average cost = value, on every line.


What columns are in the exported file?

The file holds far more than the screen. The screen shows five columns; the export has nineteen:

id, Number, Description, Vendor, Location, Weighted Average Cost, Cost, Unit, Quantity, Core Quantity, Core Cost, Value, Core Value, Weighted Average Total Value, Manufacturer, Category, Inventory Type, Min Stock and Max Stock.

These appear only in the file, never on screen:

  • Vendor, Location, Manufacturer and Category — so you can group your inventory value by supplier, by shelf or by category in Excel.

  • Weighted Average Cost and Cost as two separate columns. Weighted Average Cost is the average you actually paid; Cost is the most recent purchase cost on the part record. They are often different.

  • Core Quantity and Core Cost — the screen only shows core value, the file shows how many cores and at what each.

  • Inventory Type, Min Stock and Max Stock.

The file also lists parts with no stock on hand, which the screen leaves out.

Too much detail in the file? Open it in Excel or Google Sheets and filter by the column you care about — Vendor, Category or Location. You can also paste it into ChatGPT and ask for the total by category, or a list of everything worth over a certain amount.


How do I filter the report by category?

  1. Click Categories.

  2. In Add Category, choose a category.

  3. Click Apply Filter.

The totals and the list then cover only that category — useful for "how much do I have tied up in filters?"


How do I filter the report by vendor?

  1. Click Vendor.

  2. Type the vendor name.

  3. Click Filter.


What does the Archived Parts filter do?

Click Archived Parts and you get two choices:

  • Include — show archived parts alongside your active parts.

  • Only — show archived parts by themselves.

Pick neither and archived parts are left out, which is the default.

This filter can change your total enormously, so set it deliberately before exporting for your accountant. In our demo shop the same 12/31/2025 date gave $377.9K by default and about $2.1M with Include switched on, because a lot of old stock had been archived. Decide with your accountant whether archived parts belong in your closing stock, then keep the same setting every year.


How do I look up one part?

Type the part number into the Part number box on the left of the filter row. The list narrows to that part, so you can see its quantity, part value and core value on the date you picked.


What is the Inventory Change report?

Inventory Value answers "what is on my shelf and what is it worth". Inventory Change answers "what moved".

Open it from the left sidebar. It shows a bar chart of Found, Lost, Sold and Ordered activity, a total dollar figure for the movement, and a table of every part that moved.

The columns are PART, START, LOST, FOUND, SOLD, ORDERED, TRANSFERRED, END, CHANGE and VALUE. START is what you had at the beginning, END is what you had at the end, CHANGE is the difference. The figures are at cost, not at the price you sold for.

In the screenshot below: 1 is Inventory Change in the sidebar, 2 is the date range button, 3 is the Shop filter, 4 is Categories, 5 is the INVENTORY CHANGES total, 6 is the movement columns, and 7 is Export.

The Inventory Change report in EasyTruckShop showing the sidebar, date range and Shop filters, the INVENTORY CHANGES total, the movement columns and the Export button.

How do I see what moved in and out last year?

  1. Open Reports → Inventory → Inventory Change.

  2. Click the date button (it starts on This Month).

  3. Pick Last Year from the list on the left, or set your own From and To dates.

  4. Click Select.

The presets are This Year, Last Year, This Quarter, Last Quarter, This Month, Last Month, This week and Last Week.


I have two locations

Inventory Change has a Shop filter that starts on the location you are working in. Stock movements at your other location are not included until you tick it too.


Why can't I see the Inventory report, or the cost columns?

  • No Reports item in your profile menu → you are missing the View Reports permission.

  • You can see the report but no cost or price figures → you are missing the View Prices, Costs and Usage permission.

Your shop owner or manager can turn these on.


Quick answers

  • "What is my inventory worth right now?" Reports → Inventory → Inventory Value, read TOTAL VALUE.

  • "What was it worth at the end of last year?" Same report, set Date to 12/31 of that year.

  • "Can I get it for a date range?" Not for value — that is a single date. Use Inventory Change for a range.

  • "Where is the core value?" The CORE VALUE card, and the Core Quantity and Core Cost columns in the export.

  • "Why doesn't Value ÷ Quantity match the cost column?" On a past-date export the cost column shows today's cost. Trust the Value column.

  • "My total looks too low." Check the Archived Parts filter.


Still need help?

Start a chat with us from inside EasyTruckShop and tell us the date you need and whether you want part value, core value or both.

Did this answer your question?