Skip to main content

Download my customer list, vehicles, contacts, and invoices

The four downloads under Customers in EasyTruckShop, where each button is, exactly which columns each file has, and which one to use for the question you are asking.

Written by Vladimir

The four downloads under Customers

The Customers menu in EasyTruckShop has five tabs — Companies, Vehicles, Contacts, Invoices, Payments. Four of them can produce a spreadsheet. This article says where each button is, exactly what columns come out, and which file answers which question.

All four files are .xlsx spreadsheets that open in Excel, Google Sheets, or Numbers.

Tab

Button

File you get

Use it for

Customers > Invoices

Export

invoices.xlsx

Who owes you money; invoice history

Customers > Payments

Export

payments.xlsx

What you collected

Customers > Vehicles

Download

vehicles-YYYY-MM-DD.xlsx

Your fleet list, VINs, plates

Customers > Contacts

Download

contacts-YYYY-MM-DD.xlsx

Names, emails, phone numbers

Customers > Companies

—

none

There is no export on the Companies list

Note the button is called Export on two tabs and Download on the other two. They do the same kind of thing.

What permission you need

Each download follows the permission for the tab it is on. The Contacts download in particular needs the Download Contacts permission — if the Download button is missing on the Contacts tab, that is the one to ask your shop owner or administrator for.

Customers > Invoices — Export

Go to Customers > Invoices. The three cards at the top are INVOICES (how many), TOTAL (what they came to), and OPEN BALANCE (how much of that is still unpaid). Below them are three buttons — All, Open, and Paid — and the Export button sits on the right above the table.

In the screenshot below: 1 is the three cards including OPEN BALANCE, 2 is the All / Open / Paid buttons, and 3 is the Export button.

The Customers Invoices tab in EasyTruckShop showing the INVOICES, TOTAL and OPEN BALANCE cards, the All, Open and Paid buttons and the Export button.

invoices.xlsx has one row per invoice, with these columns:

  • Number, Status, Date, Due Date

  • Customer, Unit, VIN, P.O., type, Reference

  • Labor, Parts, Fees, Discounts, Subtotal

  • Tax Rate, Tax, Total

  • Balance — how much of that invoice is still unpaid

The Balance column is the important one. It is what makes this file your accounts receivable list. Filter it to rows where Balance is greater than zero and you have every unpaid invoice in your shop.

Before you export, set the Open button if you only want unpaid invoices, and set the date button if you only want a period. The file matches whatever is on screen.

Customers > Payments — Export

Go to Customers > Payments and click Export at the top right. You get payments.xlsx:

  • Date, Customer, Method, Notes

  • Credit Used

  • Total

Credit Used is only in the file — the screen does not show it. It is how much of that payment came out of credit the customer already had on account, rather than new money arriving. Reconciling against a bank statement without noticing this column is a common cause of "my payments don't match my deposits".

Customers > Vehicles — Download

Go to Customers > Vehicles. The Download button is at the top right, next to the green Add Vehicle button.

In the screenshot below: 1 is the Download button, and 2 is the column headings UNIT, TYPE, VEHICLE, PLATE, OWNER, CONTACT and COMPANY.

The Customers Vehicles tab in EasyTruckShop with the Download button at the top right and the UNIT, TYPE, VEHICLE, PLATE, OWNER, CONTACT and COMPANY column headings.

You get vehicles-YYYY-MM-DD.xlsx, named with today's date, containing:

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

VIN is the vehicle identification number. This file is the one to send when someone asks for your fleet list, or when you are setting up another system and need every unit and VIN in one place.

Customers > Contacts — Download

Go to Customers > Contacts. There is a Filter button next to the search box, and the Download button is at the top right.

In the screenshot below: 1 is the Download button and 2 is the Filter button. The email and phone columns have been blurred in this example image.

The Customers Contacts tab in EasyTruckShop with the Download button at the top right and the Filter button beside the search box, with email and phone columns blurred.

You get contacts-YYYY-MM-DD.xlsx, containing:

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

This is the file to use for a mailing list, a text-message campaign, or importing your contacts into another system. It contains personal contact details, so treat it the way you would treat any customer list.

Why there is no download on Companies

Customers > Companies has no Export or Download button. If you need a list of your customer companies with their balances, the closest thing is invoices.xlsx — group it by the Customer column and total the Balance column.

What these files do not contain

  • invoices.xlsx has no line-item detail. It has one row per invoice with Labor, Parts and Fees as totals. For line-by-line detail — every part number, quantity, cost and price — use Reports > Sales > Export > Product List instead.

  • payments.xlsx does not say which invoice each payment went to. There is no invoice number column. To see how a payment was applied, open the customer's ledger in the app.

  • None of these files include a customer's Starting Balance. If a customer was set up with an opening balance carried over from your old system, that amount is in their balance in the app but has no invoice behind it, so it will not appear in invoices.xlsx. This is a real cause of "my A/R total doesn't tie out".

  • None of them include unapplied credit sitting on a customer account.

  • Archived records are not included unless you have set the list's filter to show them.

Accounting words and which file to open

What your accountant asks for

Which file

Accounts receivable (A/R) / aged debtors

invoices.xlsx — the Balance column

A/R aging schedule (30 / 60 / 90 days)

invoices.xlsx — build it from Due Date and Balance; EasyTruckShop has no aging report

Sales journal / invoice register

invoices.xlsx

Cash receipts journal

payments.xlsx

Customer master list

contacts-YYYY-MM-DD.xlsx, or the Customer column of invoices.xlsx

Fixed asset / equipment schedule

vehicles-YYYY-MM-DD.xlsx — though these are your customers' trucks, not your assets

Unapplied cash / customer deposits

payments.xlsx — the Credit Used column

Other ways shops ask this question

  • "I need a list of all my customers" — Customers > Contacts > Download.

  • "Send me every truck I service" — Customers > Vehicles > Download.

  • "Who owes me money?" — Customers > Invoices, click Open, then Export. Sort by the Balance column.

  • "I need all my invoices for the year for my accountant" — Customers > Invoices, set the date range, Export.

  • "How do I get my customer emails out?" — Customers > Contacts > Download. You need the Download Contacts permission.

  • "Can I export my customer list?" — the Companies tab has no export; use Contacts, or the Customer column of the invoices file.

  • "I'm leaving EasyTruckShop and need my data" — download all four files; they cover invoices, payments, vehicles, and contacts.

  • "I'm moving to EasyTruckShop from Fullbay or other software. How do I bring my data in?" — you don't need these downloads. Our support team imports your data for you. Start a chat and ask for a human.

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

invoices.xlsx in particular can run to hundreds or thousands of rows. Three ways to cut it down to what you actually need:

  • Filter before you export. Set the date range, click Open or Paid, or search for one customer, then Export. The file always matches the screen. This is the cleanest approach.

  • Filter in the spreadsheet. Open the file in Excel or Google Sheets, select the header row, turn on filters, and filter the Balance, Customer, or Status column. A pivot table on Customer and Balance gives you a per-customer receivables total 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 Balance column by customer, biggest first" or "list every invoice more than 60 days past its due date".

If the download does not happen

  • No Download button on Contacts — you do not have the Download Contacts permission. Ask your shop owner.

  • The file is empty or missing rows — a filter is still applied from an earlier search. Clear the search box and the date range, then try again.

  • Rows from your other location are missing — the shop filter defaults to the shop you are currently in.

  • Nothing downloads at all — check your browser's download blocker, then try again in a different browser.

Did this answer your question?