Skip to main content

How much money did I actually collect? The Payments list

See every payment you received in EasyTruckShop, filter by customer or payment method, and export the file that also shows credit used.

Written by Vladimir

What the Payments list tells you

The Payments list in EasyTruckShop shows every payment you received over a period — the date, the customer, how they paid, who recorded it, any note, and the amount. The bottom row totals the amounts, so it answers "how much money came in this month" directly.

In accounting language this is your cash receipts. It is money that actually arrived, which is different from money you invoiced.

Where the Payments list is

There are two ways to the same screen, and it is the same list either way:

  • Customers > Payments — Customers is in the top menu bar.

  • Reports > Payments — the last tab in the Reports row, which opens the same page. Reports itself sits under your profile icon at the top right, not in the top menu bar.

The image below shows the Payments list: 1 is the filter row with the date range, Shop, Customer, and Payment Method, 2 is the Export button, and 3 is the column headings.

The EasyTruckShop Payments list showing the date range, Shop, Customer and Payment Method filters, the Export button and the DATE, CUSTOMER, METHOD, CREATED BY, NOTES and AMOUNT column headings.

What permission you need

You need permission to view payments. Recording a new payment needs its own permission — the green New Payment button only appears for users who have it.

Reading the total

Scroll to the bottom of the list. The bold figure under the AMOUNT column is the total of every payment shown, and the line beneath it tells you how many payments that is — for example "Showing 1 to 15 of 15 results". The total always reflects the filters you have set.

In the screenshot below: 1 is the bold total under the AMOUNT column, and 2 is the "Showing X of Y results" count.

The bottom of the EasyTruckShop Payments list showing the bold total under the AMOUNT column and the results count beneath it.

The four filters

Filter

What it answers

Date range (opens on This Month)

"How much did I collect in March?"

Shop

"How much did this location collect?"

Customer

"What has this company paid me this year?"

Payment Method

"How much came in by check? By Zelle? By card?"

Why a payment can look missing when you have two locations

The Shop filter defaults to the shop you are currently working in, not all of your shops. A payment appears under the shop of the invoice it was applied to — so if a customer paid at your second location against an invoice raised at the first, it shows under the first.

If a payment you know exists does not appear, widen the Shop filter to include all your locations before assuming it was not recorded.

Exporting the Payments list

Click Export at the top right. EasyTruckShop downloads payments.xlsx, with these columns:

  • Date

  • Customer

  • Method

  • Notes

  • Credit Used

  • Total

Credit Used is only in the file. The on-screen list does not show it. It tells you how much of that payment came from credit the customer already had on account rather than new money arriving. That distinction matters when you reconcile against your bank statement: a payment with Credit Used in it did not necessarily put that much cash in the bank.

What the Payments list does not do

  • It does not show which invoice each payment was applied to. Neither the screen nor the export has an invoice number. To see how a payment was split across invoices, open the customer record and look at their ledger.

  • It does not show unapplied credit sitting on an account. A customer can be holding a credit that never appears here. That is one reason a customer's balance can disagree with the sum of their invoices.

  • It does not include sales tax separately. The amount is the whole payment; tax is not broken out.

  • It is not the same as the Sales report on Cash basis. Sales on Cash basis allocates payments back to what was sold — labor, parts, fees. The Payments list shows the payments themselves. The two totals will not match.

  • It does not show refunds as a separate report. Refunds and reversals appear in the list as their own entries.

Accounting words and what they are called in EasyTruckShop

What your accountant says

What EasyTruckShop calls it

Cash receipts / collections

The Payments list total

Deposits

The individual payment rows — group them with the Payment Method filter

Payment application

Not shown here — open the customer's ledger

Customer credit / unapplied cash

The Credit Used column in payments.xlsx

Accounts receivable (A/R)

Not this list — see Customers > Invoices and its Balance column

Revenue recognized

Not this list — see the Sales report

Remittance advice / payment note

The Notes column

Other ways shops ask this question

  • "How much did I bring in this month?" — Customers > Payments, date = this month, read the bold total at the bottom.

  • "How much did this customer pay me this year?" — set the Customer filter and the date range to the year.

  • "How many people pay by check?" — set the Payment Method filter to Check.

  • "I need my deposits for the bookkeeper" — Export and send them payments.xlsx. Point out the Credit Used column so they do not double-count.

  • "Why doesn't this match my bank?" — check the Credit Used column, check the Shop filter, and remember that a payment recorded today may clear the bank later.

  • "Which invoice did this payment go to?" — the Payments list cannot tell you. Open the customer record and look at their ledger.

  • "How much do people still owe me?" — that is not this list. Go to Customers > Invoices and use the Balance column, or filter to Open.

The file has too many rows. What now?

  • Narrow the date range, the customer, or the payment method in EasyTruckShop and export again.

  • Open payments.xlsx in Excel or Google Sheets and build a pivot table on Method and Total — that gives you a payment-method breakdown in one step.

  • Upload the file to ChatGPT or another AI assistant and ask in plain words — for example "total this by month and by payment method" or "list every payment where Credit Used is not zero".

If a payment is not showing

  • Check the Shop filter first — it defaults to your current shop, and a payment sits under the shop of the invoice it was applied to.

  • Check the date range — the list opens on This Month.

  • Check whether a Customer or Payment Method filter is still applied from an earlier search.

  • The payment exists but the invoice still says Finalized — that is expected on a partial payment. Finalized is the invoice's state, not its payment status; look at the invoice's Balance instead.

  • Still missing — export the file for a wider date range with all shops selected, and send it to support with the customer name, date, and amount you are looking for.

Did this answer your question?