The short answer
Your total accounts receivable in EasyTruckShop is the OPEN BALANCE card at the top of Customers > Invoices. To see who it is made up of, click the Open button and sort the Balance column.
A/R stands for accounts receivable — money customers owe you for work already invoiced.
Where to find it
Open Customers.
Click the Invoices tab.
Read the third card: OPEN BALANCE. That is your total A/R across every invoice shown.
Click the Open button to list only invoices that still have money owing on them.
The image below shows the Invoices tab: 1 is the three cards, with OPEN BALANCE on the right, 2 is the All / Open / Paid buttons, and 3 is the Export button.
Set the date button to All Time if you want your whole receivables balance. A date range gives you only invoices raised in that range, which is usually not what "who owes me money" means.
What permission you need
You need permission to view invoices. Exporting follows the same permission.
There is no aging report in EasyTruckShop
EasyTruckShop does not have an A/R aging report with 30, 60 and 90 day buckets. Rather than pointing you at something that does not exist, here is how to build one in about five minutes from the export.
Go to Customers > Invoices.
Set the date button to All Time.
Click Open so the list is unpaid invoices only.
Click Export. You get invoices.xlsx.
Open it in Excel or Google Sheets. The columns you need are Customer, Due Date, and Balance.
Add a column called Days Late with the formula =TODAY()-[the Due Date cell].
Add a column called Bucket with =IF(A<=0,"Current",IF(A<=30,"1-30",IF(A<=60,"31-60",IF(A<=90,"61-90","90+")))), pointing A at the Days Late cell.
Insert a pivot table with Customer as rows, Bucket as columns, and Balance as values. That is your aging report.
If spreadsheet formulas are not your thing, upload invoices.xlsx to ChatGPT or another AI assistant and ask it in plain words: "This is my unpaid invoice list. Build me an aging report by customer with Current, 1-30, 31-60, 61-90 and 90+ day buckets using the Due Date and Balance columns." It will do the same work.
What is in invoices.xlsx
The export 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
Balance is the unpaid amount on that invoice. Total that column and you get the same figure as the OPEN BALANCE card on screen — the two tie out exactly.
"Finalized" does not mean unpaid — read the Balance instead
An invoice's Status is not its payment status. A part-paid invoice keeps saying Finalized; it does not change to something else when money comes in, and it only shows Paid once the balance reaches zero. Billed is a manual flag you can turn on and off, not a payment state.
So when you are working out who owes you money, sort and filter on the Balance column, not on Status. Balance is the number that is actually right.
Why a customer's balance can be more than their unpaid invoices
If you add up a customer's open invoices and the figure does not match the balance shown on their customer record, one of three things is usually going on:
Starting Balance. If the customer was set up with an opening balance carried over from your previous system, that amount is in their balance but has no invoice behind it. It will never appear in invoices.xlsx. A customer can show a balance with no invoices and no payments at all for this reason.
Unapplied credit. If the customer has paid more than an invoice was for, or has a credit on account, that credit reduces their overall balance without changing any single invoice's Balance.
Multi-shop. If you have more than one location, check whether you are looking at one shop or all of them.
The rule the app follows is: customer balance = the sum of their invoice balances, minus unapplied credit, plus their Starting Balance.
Accounting words and what they are called in EasyTruckShop
What your accountant says | What EasyTruckShop calls it |
Accounts receivable (A/R) / debtors | OPEN BALANCE on Customers > Invoices |
A/R aging / aged debtors report | Not available — build it from invoices.xlsx as above |
Outstanding balance on an invoice | The Balance column |
Invoice register / sales journal | invoices.xlsx |
Opening balance carried forward | Starting Balance on the customer record |
Unapplied cash / customer credit | Credit on the customer's account — see the Credit Used column in payments.xlsx |
Bad debt / write-off | No write-off function; shops usually apply a discount or a credit |
Days sales outstanding (DSO) | Not calculated — work it out from invoices.xlsx |
Other ways shops ask this question
"Who owes me money?" — Customers > Invoices > Open, sort by Balance.
"What's my total receivables?" — the OPEN BALANCE card, with the date set to All Time.
"Which customers are past due?" — Export, then compare Due Date against today. Overdue due dates also show in red on screen.
"I need an aging report" — EasyTruckShop does not have one; build it from the export using the steps above.
"How much does this one company owe me?" — search their name on the Invoices tab with Open selected, or open their customer record.
"Why does this customer show a balance when they have no invoices?" — almost certainly a Starting Balance on their record.
"How much did I write off?" — EasyTruckShop has no write-off; look at discounts on the Sales report.
If the numbers do not tie out
OPEN BALANCE looks too small — the date button is probably set to This Month. Set it to All Time.
A customer is missing from the list — they may have a Starting Balance with no invoice, which will not appear here. Open their customer record.
Your total does not match QuickBooks — Starting Balances and unapplied credit are the two usual causes, in that order.
Rows from your other location are missing — the shop filter defaults to the shop you are in.
Still off — export invoices.xlsx and payments.xlsx for All Time with every shop selected, and send both to support with the customer name and the two figures you are comparing.

