Use this guide to generate a Daily Transaction Report (DTR) in DealerWorks. The DTR summarizes all transactions posted on a selected date, broken out by department and payment method. It is the primary tool for end-of-day reconciliation.
This article does not cover the Payout Report or Cashier Report. For settlement and payout information, see Understanding the Payout Report. For a per-employee breakdown, see How to Generate a Cashier Report.
Who this is for: Accounting staff and managers performing daily or historical reconciliation.
Steps
- 1 Click Accounting in the main navigation menu.
- 2 Click DTR from the Accounting sub-menu.
- 3 Click Pick a Date and select the date you want to report on. You are selecting the date transactions were posted in DealerWorks — not the settlement date.
- 4 Click Generate DTR.
- 5 The report will download as a PDF. Open it to review or print.
What the Report Contains
The DTR is a multi-page PDF organized into two main sections: a summary page followed by a detailed transaction listing for each department.
The first page gives a store-level overview of the day's activity.
- Department totals — Sales, Service, Parts, Body Shop, and Accounting figures shown at the top of the page, along with the Grand Total for the day.
- Transaction Summary table — Breaks down each department by payment method (credit cards, cash, check, etc.), showing three columns: Amount, Surcharge, and Total. See the column guide below for definitions.
- Grand Total Detail — A full payment method breakdown for the store, with credit card totals split further by card brand (Visa, Mastercard, Amex, Discover, etc.).
If your dealership passes non-cash fees to customers: Your Transaction Summary columns will show Amount, NCO, and Processed Total instead of Amount, Surcharge, and Total. Your report will also include a Cash Price Grand Total section below the Grand Total Detail, which splits the day's total into Online Payment Grand Total (card and digital) and Offline Payment Grand Total (cash, check, and similar).
Pages 2+ — Department Transaction Detail
Each department with activity gets its own section. Each section contains a Transactions table listing every payment posted, followed by a Refunds table if any refunds were processed that day. Each table uses the same column structure:
| Column | What it shows |
|---|
| Date | The date and time the transaction was posted. |
| Advisor | The advisor or staff member assigned to the transaction. |
| Customer | The customer name on the transaction. |
| Invoice | The repair order or invoice number associated with the transaction. |
| Payment Method | How payment was collected — card type and last four digits, cash, check, BNPL, etc. |
| Amount | The amount collected on the transaction. |
| Surcharge | The non-cash pricing adjustment applied to the transaction. Shows $0.00 for most transactions and for all cash or check payments. |
| Total | The total collected — Amount plus Surcharge. |
If your dealership passes non-cash fees to customers: Your detail pages will show four financial columns instead of three:
- Cash Price — The base price before any non-cash adjustment.
- Price — The price presented to the customer based on their payment method. Matches Cash Price for cash and check; reflects the non-cash price for card payments.
- Amount Paid — The actual amount collected. Usually matches Price, but may differ if a bypass was applied. An asterisk (*) next to this figure indicates the non-cash adjustment was bypassed on that transaction.
- NCO — The non-cash pricing adjustment for the transaction. Shows $0.00 when no adjustment applied, or Bypass when the adjustment was manually waived.
Summary Page Column Guide
The Transaction Summary on page 1 uses three columns across all department and payment method rows:
| Column | What it means |
|---|
| Amount | The total collected for transactions in that row. |
| Surcharge | The total non-cash pricing adjustment collected across those transactions. Shows $0.00 for dealerships that do not pass fees to customers. |
| Total | Amount plus Surcharge. This is the figure to use when reconciling against your deposit. |
If your dealership passes non-cash fees to customers: These columns will appear as Amount, NCO, and Processed Total. The Processed Total is the figure to use for reconciliation.
If Something Looks Wrong
The DTR shows no transactions for a date I know had activity
Confirm you selected the correct date. If today's transactions are not appearing, wait a few minutes and regenerate the report — same-day data may take a short time to populate.
The DTR Total doesn't match my bank deposit
The DTR shows what was posted in DealerWorks, not what has settled to your bank. Card and ACH settlements typically arrive on a different date. Use the Payout Report to match bank deposits to settlement batches. For a detailed explanation, see Why Doesn't My Deposit Match?
A refund appears in the DTR that I didn't authorize
Use the Cashier Report filtered to the same date to identify which user processed it. If the refund appears unauthorized, contact DealerWorks support with the transaction details before taking any action.
The NCO column shows amounts I don't expect
NCO reflects the non-cash pricing adjustment applied to each transaction. If you see NCO amounts on transactions where you expected $0.00, check whether a pricing adjustment is configured for that payment method. If you see Bypass, the adjustment was manually waived on that transaction — use the Cashier Report to see which user processed it.