Payment Types answers the question "how did we get paid?" — it groups the payments your shop took in by the method used (Card, Cash, Check, custom types you've set up) and, for card payments, by the brand (Visa, Mastercard, Amex, etc.). The body of the report is a single table that shows, for each type, a Count, an Amount, and a Percent of Total; the bold rows at the bottom add it all up into summary totals — refunds, card total, cash-plus-check total, and the overall total. Use this report to see your payment mix at a glance, spot shifts in how customers are paying you, and reconcile big-picture totals with your bank deposits and accounting system.
Filters
| Filter | Default | What it does |
|---|---|---|
| Countries | your shop's country | (Multi-location headquarters view only.) Limits the Locations picker to one country at a time. You won't see this filter if all your locations are in the same country. |
| Locations | all of your locations | (Multi-location headquarters view only.) Only count payments from the locations you check. Leaving them all unchecked is the same as selecting all. |
| Order Status | all statuses | Only count payments on orders in the statuses you check — Estimate, Repair Order (if you use them), and Invoice. Estimates rarely have payments on them unless you take deposits, so this filter usually has no effect. |
| Invoiced Date | no date filter until you pick one — "I want data about completed/closed jobs." Picks up the jobs invoiced in the period. | Narrows the report to payments for jobs that were invoiced during the dates you pick. Tip: the picker shows "This Month" when you open the page, but it is not actually applied until you open the picker and pick a period. |
| Payment Type | all | (Only shown if your shop has the Debit Cards in Reports feature on.) Limit to specific payment methods — Card, Cash, Check, Other, your custom types, and (if turned on for you) Customer Credit. |
| Card Type | all | (Only shown if your shop has the Debit Cards in Reports feature on.) Limit to specific card brands — Amex, Mastercard, Visa, or Other. |
| Charge Type | all | (Only shown if your shop has the Debit Cards in Reports feature on.) Limit to debit cards only or credit cards only. Picking anything here narrows the report to card payments. |
| Paid Date | no date filter until you pick one — "I want data about money that came in, regardless of which jobs it relates to." | Narrows to payments received in the dates you pick. Uses the payment date you entered on the payment (falling back to the system date if you didn't enter one). Tip: like the Invoiced Date picker, it shows "This Month" but is not applied until you pick a period. |
| Customer Type | both Customer and Fleet | Limit to retail customers, fleet customers, or both. |
| Customers | all | Limit to specific named customers. Attribution is to the job's customer, so if someone else paid on behalf of your customer, the payment still counts for your customer. |
Date Filters
Invoiced Date and Paid Date answer different questions: Invoiced Date is "which completed jobs?" and Paid Date is "which cash receipts, no matter which job?" If you use both at once, the report only includes payments that satisfy both — a narrow, reconciliation-style view. Most routine reporting uses just one. Neither mode is more "correct" — they answer different questions.
Understanding Each Number
| Card | What it means | What it doesn't include | When it's useful | Notes |
|---|---|---|---|---|
| Payment and Card Type (column) | The kind of payment — Cash, Check, a specific card brand, or one of your custom types. | — | Seeing your mix at a glance. | If you see an unfamiliar name on a row, it's likely a custom payment type you or another user set up. |
| Count (column) | How many payments of that type you took in the current view. A bulk payment you applied to five orders counts as one. | — | Understanding volume, not just dollars. Great for questions like "how many checks a month are we still processing?" | The same bulk payment will show as one here and as multiple rows on the All Payments report — they're counting different things. |
| Amount / Total (column) | The dollars you collected of that type. | Refunds are not subtracted from this column. A $1,000 charge that was fully refunded still shows $1,000 here. | Comparing the sizes of different tender types. | The column is labeled "Amount" or "Total" depending on your shop's settings — the number is the same either way. |
| Percent of Total (column) | This tender's share of your overall payments total in the current view. | The denominator is the overall Total row at the bottom, which excludes Customer Credit. | Spotting mix shifts — "are we taking more cash than last quarter?" | Percentages don't always add to 100%: refunds show as negative, some card rows overlap with each other, and Customer Credit is excluded. |
| Refund Total (footer) | The dollars refunded during the period, shown as a negative. | — | Seeing how much of your activity was refunds. | This is the only place refunds appear — the per-row Amounts above do not subtract them. |
| Credit Card Total (footer) | Total dollars on credit cards. If your shop has the Debit Cards in Reports feature on, this is credit only. If the feature is off, it is all card payments. | — | Reconciling to your card processor's statement. | Because the meaning depends on your settings, don't compare this number between two shops unless they're on the same settings. |
| Debit Card Total (footer) | (Only shows if your shop has the Debit Cards in Reports feature on.) Total dollars on debit cards. | — | Understanding how much of your card activity is debit vs credit. | — |
| Card Total (footer) | (Only shows if your shop has the Debit Cards in Reports feature on.) Total dollars on all cards (debit + credit). | — | A single all-cards number when the feature is splitting debit and credit into separate rows. | — |
| Cash + Check Total (footer) | Total cash and check dollars. | — | Reconciling deposits to your bank. | Payments entered outside a cash drawer session still count here (but might not show on the End of Day report — End of Day only reconciles drawer-tied entries). |
| Total (footer) | Your overall total for the period — the one and only refund-net number on the report. | Customer Credit is excluded. | The single headline number if you only look at one row. | Because per-row Amounts above don't subtract refunds, the Total row is often a bit lower than the sum of the row Amounts above it. The difference is exactly the Refund Total. |
| Customer Credit (footer) | (Only shows if your shop has Customer Credit turned on.) Credits you applied between orders. | This is excluded from the main Total row because a credit just moves money you already received from one job to another. | Seeing how much intra-customer credit movement is happening. | Percent is intentionally blank here. |
Common Questions
Q: Why is the bottom Total row lower than the sum of the Amounts above it? A: Because the per-type Amount rows don't subtract refunds — the Refund Total row shows them separately. Only the bottom Total row subtracts refunds. If you add up the tender rows yourself, you're double-counting the refunds that the Total row is subtracting.
Q: Why don't the Percent of Total numbers add up to 100%? A: Three reasons: (1) the Refund Total row's percent is negative; (2) on shops with the Debit Cards in Reports feature, the Credit Card Total and Debit Card Total rows together equal the Card Total row — they overlap; and (3) Customer Credit is excluded from both the numerator and the denominator. If you sum just the non-overlapping tender rows (skipping Card Total and Customer Credit), you'll land very close to 100%.
Q: Why doesn't my Payment Types total match my All Payments total? A: The two reports default to different date filters. All Payments starts with "Paid Date = This Month" applied automatically; Payment Types starts with no date filter applied. Set both reports to the same dates and the totals will line up (with one small caveat — Payment Types counts a bulk payment once, while All Payments shows one row per order the bulk payment was applied to).
Q: Why is my Card Total on Payment Types different from my card processor's statement? A: A few possibilities: (1) your processor's statement is in a different date range; (2) if your shop has the Debit Cards in Reports feature on, the row you're reading might be "Credit Card Total" which excludes debit — look at the Card Total row for all card activity; (3) refunds are on a separate footer row here, so compare a refund-net number (the overall Total row) to your processor's net number.
Q: Why doesn't my cash show up the same way on End of Day? A: End of Day only counts cash and check that were tied to a cash drawer session — so if you took a cash payment outside a drawer (for example, on a public payment page), it counts here on Payment Types but not on End of Day.
Q: Why is a payment missing from this report? A: The most common reasons: (1) the Invoiced Date or Paid Date filter excludes it — check what you actually picked in the date pickers (remember the picker shows "This Month" as a default preview but isn't applied until you open it and choose); (2) the payment's type is blank or missing for some reason; (3) the Order Status filter doesn't include the status of the payment's order; (4) if you're on a multi-location headquarters view, the payment's location isn't checked in the Locations filter.
Q: What does "(Debit)" mean next to a card brand? A: (Only appears if your shop has the Debit Cards in Reports feature on.) It means the card the customer used was a debit card. The classification comes from your payment processor — if the customer used their bank's debit card, the processor flags it as debit automatically.
Tips for Getting the Most Out of This Report
- Use Paid Date for cash-flow questions, Invoiced Date for completed-work questions. A customer who paid in April on an invoice closed in March will show up under April for Paid Date, and March for Invoiced Date. Neither is wrong — pick the one that matches the question you're asking.
- When reconciling to your processor's statement, look at the Card Total footer, not the individual brand rows. The individual rows don't subtract refunds. For a refund-net comparison, use either the bottom Total row (all tenders) or the Refund Total row to see the refund amount you need to subtract manually.
- Set both date pickers only when you need a narrow reconciliation view. Most of the time, just one date filter answers your question. Using both is an "and" — a payment has to satisfy both to appear — and can look unexpectedly narrow.
- Export to Excel when you need the full footer block for reconciliation. The XLS export preserves the Refund Total, Card Total, Cash + Check Total, Total, and (if turned on) Customer Credit footer rows as they appear on the report, making it easy to paste into a bank-reconciliation sheet.
Still have questions? Feel free to reach out to us through the chat icon. Thanks for reading!
Comments
0 comments
Article is closed for comments.