Skip to main content

Which export file has the data I need?

Every export in EasyTruckShop, the exact columns inside each file, and which columns exist only in the file and never appear on screen.

Written by Vladimir

What this article is for

EasyTruckShop has sixteen different downloads spread across the Reports and Customers screens. This article lists every one of them: where the button is, the exact filename you get, and the columns inside. Use it when you know what number you need but not which file has it.

Every file is an .xlsx spreadsheet. Every file matches the filters that were set on screen when you clicked the button — the date range, the Shop, the Basis, and any customer filter. Set your filters first, then export.

Where the Reports are

Reports is not in the top menu bar. Click your profile icon at the top right — your initials in the circle — and choose Reports. The Customers downloads are different: those are under Customers in the top menu bar.

Fastest route: pick your question

If you know the question but not the report, start here.

What you are trying to get

Which file

Who owes me money

invoices.xlsx — the Balance column

What I collected

payments.xlsx

What I sold, by customer

Sales > Export > Summary

Every invoice with its totals

Sales > Export > Invoice List, or invoices.xlsx

Every line item with cost, price and profit

Sales > Export > Product List

What my stock is worth

Inventory > Inventory Value > Export

What my stock was worth on 31 December

Inventory > Inventory Value, set the Date, then Export

What moved in and out of stock

Inventory > Change > Export

What I make on parts

Part Revenue > Export

What I spent with vendors

Orders > Export Details

My sales tax figure and taxable sales

Sales Tax > Export

My fee income

Fees > Export

What work I did and the hours

Service Types > Export

My fleet list and VINs

Customers > Vehicles > Download

My customer emails and phone numbers

Customers > Contacts > Download

Five columns that only exist in the file

These columns never appear on screen. If you need one of them, exporting is the only way to get it.

Column

In which file

What it gives you

Taxable

Sales Tax export

The sales amount the tax was calculated on — what a tax return asks for

Credit Used

payments.xlsx

How much of a payment came from existing credit rather than new money

Core

orders_detailed.xlsx

What you paid your supplier in core deposits

Destination

orders_detailed.xlsx

Whether a purchased part went to inventory or straight to a service

Cost, Total Cost, Profit

Sales > Product List

Line-by-line margin, which the Sales screen never shows

Downloads under Customers

Four of the five Customers tabs produce a file. The button says Export on two of them and Download on the other two.

Where

Button

Filename

Columns

Customers > Invoices

Export

invoices.xlsx

Number, Status, Date, Due Date, Customer, Unit, VIN, P.O., type, Reference, Labor, Parts, Fees, Discounts, Subtotal, Tax Rate, Tax, Total, Balance

Customers > Payments

Export

payments.xlsx

Date, Customer, Method, Notes, Credit Used, Total

Customers > Contacts

Download

contacts-YYYY-MM-DD.xlsx

Company, Role, First Name, Last Name, Email, Phone, Extension, Notes

Customers > Vehicles

Download

vehicles-YYYY-MM-DD.xlsx

Unit, VIN, Make, Model, Year, Type, Plate, Customer

Customers > Companies

—

none

There is no export on the Companies list

Downloads on the Sales report — three different files

The Sales report's Export button offers three choices, and they are very different files. This is the most common place people take the wrong one.

Choice

Filename

One row per…

Columns

Summary

Cash Revenue for <Month>, <Year>.xlsx

Customer

Customer, Labor, Parts, Fees, Discounts, Sales Tax, Total

Invoice List

invoice-list.xlsx

Invoice

Invoice, Type, Customer, Unit, VIN, Vehicle Type, P.O., Date, Due Date, Status, Labor, Parts, Fees, Discounts, Subtotal, Tax Rate, Tax, Total, Balance

Product List

invoices-details.xlsx

Line item

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

Product List is the most detailed file in EasyTruckShop. It is the only export with a per-line Profit column, and the only one that shows every individual part number and labor description. If someone asks a question the other files cannot answer, this is usually the file.

Downloads on the other Reports tabs

Where

Button

Filename

Columns

Reports > Fees

Export

fee-report.xlsx

Fee Name, Times Added, Average Charge, Total Charged

Reports > Sales Tax

Export

Sales Tax Report (Cash).xlsx — the basis is in the filename

Name, Rate, Taxable, Tax Collected

Reports > Part Revenue

Export

Part Revenue report for <Month>, <Year>.xlsx

One row per week: Revenue, Cost, profit, Margin

Reports > Inventory > Inventory Value

Export

<date> Inventory Report.xlsx — named for the date you set

Part number, description, quantity, weighted average cost, value, core value, and vendor and location detail

Reports > Inventory > Change

Export

inventory-change-report.xlsx

Part Number, Description, Start, Lost, Found, Sold, Ordered, Transferred, End, Change, Value

Reports > Orders

Export

orders.xlsx

Vendor, Orders, Total

Reports > Orders

Export Details

orders_detailed.xlsx

Date, PO number, Receipt, Vendor, Type, Part Number, Description, Unit, Cost, Core, Quantity, Total, Destination

Reports > Service Types

Export

service-type-report.xlsx

Name, Quantity, Time Spent (min), Time Billed (min), Estimated (min), Total Charged

Note on the Service Types file: the three time columns are in minutes in the file, not in hours and minutes as they appear on screen. A row showing 14:00 Hours is 840 in the file.

Set the Basis before you export

Three reports have a Basis filter that switches between Cash (counted when paid) and Accrual (counted when invoiced): Sales, Fees and Sales Tax. The setting carries into the exported file, and the totals can differ substantially.

The defaults are not the same across them — Fees opens on Accrual while Sales and Sales Tax open on Cash — so check the button before you export, and label the file with the basis when you send it to anyone.

Part Revenue, Inventory, Orders and Service Types have no Basis filter at all. That is worth knowing when you are reconciling: the Part Revenue Revenue figure and the Sales report's Parts card are not built to tie out.

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

Product List and orders_detailed can run to thousands of rows. Three ways to get to the answer:

  • Narrow it in EasyTruckShop first. Shorten the date range, filter to one customer or customer group, or pick one shop, then export again. The file always matches the screen, and this is the cleanest fix.

  • Filter in the spreadsheet. Open the file in Excel or Google Sheets, select the header row, turn on filters, and filter the column you care about. A pivot table answers most totalling questions in one step.

  • Ask an AI assistant. Upload the file to ChatGPT or a similar tool and ask in plain words — for example "total the Profit column by Part Category" or "list every invoice with a balance over 60 days past due". The column names in this article are the words to use in your question.

What no export contains

  • A customer's Starting Balance. If a customer was set up with an opening balance carried over from an old system, it has no invoice behind it and will not appear in invoices.xlsx.

  • Unapplied credit on an account. Only Credit Used on a payment shows credit, and only when it was actually used.

  • Which invoice a payment was applied to. payments.xlsx has no invoice number.

  • Labor cost. EasyTruckShop tracks labor revenue and hours, not what those hours cost you. The Profit column in Product List is a parts figure.

  • A profit and loss statement. There is no P&L report and no export that produces one.

  • An A/R aging schedule. Build it yourself from invoices.xlsx using Due Date and Balance.

  • Archived records, unless the list's filter is set to include them.

If a download does not work

  • The button is missing — you do not have the permission for that screen. The Contacts download needs the Download Contacts permission specifically.

  • The file is empty — a filter from an earlier search is still applied. Clear the search box and widen the date range.

  • Rows from your other location are missing — the Shop filter defaults to the shop you are currently in, not all of them.

  • The numbers do not match the screen — check that the Basis and date range have not changed since you last looked at the report.

Did this answer your question?