How do I open Reports?
Click your profile icon in the top right corner.
Click Reports.
Across the top you get nine tabs: Dashboard, Sales, Fees, Sales Tax, Part Revenue, Inventory, Orders, Service Types and Payments.
In the screenshot below: 1 is the profile icon, 2 is Reports in the dropdown, and 3 is the row of nine report tabs.
What question does each tab answer?
Dashboard — "how is the shop doing overall?" Revenue, labor, parts, fees, parts profit, orders received, inventory value, clocked and invoiced hours, efficiency.
Sales — "how much did I sell?" Net sales split into labor, parts, fees, discounts and sales tax. This is your revenue report.
Fees — "how much did I charge in shop supplies and other fees?" One row per fee name, with how many times it was added.
Sales Tax — "how much sales tax did I collect?" One row per tax rate.
Part Revenue — "what did my parts cost me and what did I make?" Revenue, cost, profit and margin.
Inventory — "what is my stock worth, and what moved?" Two reports: Inventory Value and Inventory Change.
Orders — "what did I buy from my vendors?" Purchase orders grouped by vendor.
Service Types — "which jobs do I do most, and how long do they take?" Quantity, time spent, time billed, estimated and total charged per service type.
Payments — "what money came in?" This tab opens the Payments list under Customers.
My accountant asked for something — where is it in EasyTruckShop?
Accounting words on the left, the EasyTruckShop screen on the right.
Revenue / sales / turnover → Reports → Sales, the NET SALES card. Note that net sales does not include sales tax.
Accounts receivable (A/R) / "who owes me" → Customers → Invoices, the OPEN BALANCE card.
A/R aging → there is no aging report. Export Customers → Invoices — the file has Date, Due Date and Balance, so you can age it in Excel.
COGS (cost of goods sold) → Reports → Part Revenue, the COST card. Parts only.
Gross margin on parts → Reports → Part Revenue, the MARGIN card.
Inventory on hand / closing stock → Reports → Inventory → Inventory Value. Set the Date for a past date such as year end.
Inventory movement / roll-forward → Reports → Inventory → Inventory Change.
Purchases → Reports → Orders.
Sales tax collected / tax payable → Reports → Sales Tax. The export adds a Taxable column showing the amount the tax was charged on.
Cash receipts / deposits → Customers → Payments.
Customer deposits / unapplied cash → these are credits in EasyTruckShop. They show on the payment record as Available Credit.
Labor revenue → Reports → Sales, the LABOR card.
Profit and loss → not available. EasyTruckShop gives you parts cost and margin, and labor revenue and hours, but it does not produce a P&L.
Labor cost / labor margin → not available. Labor has revenue and hours but no cost figure.
A/R means accounts receivable, the money customers owe you. COGS means cost of goods sold, what the parts cost you rather than what you charged.
Cash or accrual — which numbers am I looking at?
Several reports have a Basis button with two settings, and they answer different questions:
Accrual — what you invoiced in the period, whether or not the customer has paid.
Cash — what you collected in the period, no matter when the invoice was written.
The tabs do not all start on the same setting. Sales and Sales Tax open on Cash. Fees opens on Accrual. Part Revenue, Inventory, Orders and Service Types have no Basis button at all.
So if the Fees figure on the Dashboard does not match the Fees tab, that is usually cash sitting next to accrual, not an error. Check the Basis button on each screen before comparing two numbers.
Tip: when your accountant asks for sales figures, ask them whether they want cash or accrual. Then set Basis to match before you export.
In the screenshot below: 1 is the Basis button on the Sales tab, 2 is the Cash option and 3 is the Accrual option.
Date range or a single date?
Inventory Value uses a single date — "what was on my shelf on this day". Pick one day and click Apply.
Every other report uses a date range — a From and a To. The presets are This Year, Last Year, This Quarter, Last Quarter, This Month, Last Month, This week and Last Week. Click Select to apply.
I have more than one location — which shop am I seeing?
If your business has more than one location, most reports have a Shop filter and it starts on the location you are currently in. Numbers from your other location are not included until you tick it as well.
This catches people out most often on Payments: a payment is listed under the shop of the invoice it was applied to. If a payment seems to be missing, open the Shop filter and tick every location.
How do I get a report out as a file?
Every report tab has an Export button on the right. Set your date, basis and any filters first — the file is built from what is on screen.
Two tabs give you a choice of file instead of a single download:
Sales → Export offers Summary, Invoice List and Product List.
Orders → Export offers Export and Export Details.
The files usually contain more columns than the screen shows. Cost and profit per line, the taxable amount behind the sales tax, and the vendor and location for each part are all file-only.
Why don't I see Reports at all?
If there is no Reports item in your profile menu, you are missing the View Reports permission. If you can open reports but cost and price figures are hidden, you are missing View Prices, Costs and Usage. Your shop owner or manager can turn these on.
Still need help?
Start a chat with us from inside EasyTruckShop and tell us what you are trying to find out and for what period. We will point you at the right tab.


