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.
