How to Generate a DTR (Daily Transaction Report)

Modified on Fri, Mar 6 at 2:15 PM

Use this guide to generate a Daily Transaction Report (DTR) in DealerWorks. The DTR summarizes all transactions posted on a selected date, organized by department. 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 the Payout Report. For a per-cashier 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. A date picker will appear. 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 appears. Click the date row to expand it and view the full transaction breakdown.
The report shows rows for each department (Sales, Service, Parts) with counts and totals for transactions and refunds.
6
To export or save the report, click the download icon in the top right of the report view.

What the DTR Shows

The DTR report is organized by date. Each row represents a processed date and expands to show the following columns:

Column	What it means
Id	The unique identifier for each report batch
Date	The posting date for the transactions in this batch
Sales / Service / Parts Transactions	Count and total dollar amount of transactions posted per department
Sales / Service / Parts Refunds	Count and total dollar amount of refunds posted per department on that date

Also Available: Cashier Report

The Cashier Report provides a filtered view of transaction activity broken down by individual cashier. Unlike the DTR, which summarizes totals by department and date, the Cashier Report lets you filter by user, date range, payment method, and department simultaneously.

To access it: from Process Transactions, click Cashier Report in the top navigation. From there you can:

Select one or more cashier names from the user list
Use Today or Yesterday for quick date selection, or set a custom date range
Filter by payment method (ACH, Money Order, BNPL, and others)
Filter by department (Parts, Body Shop, Accounting, and others)

Use the Cashier Report when you need to verify what a specific employee processed on a given day, or when reconciling a cash drawer by cashier.

If Something Looks Wrong

The DTR shows no transactions for a date I know had activity

Check: Confirm you selected the correct date. If today's transactions are not appearing, give the system a few minutes and refresh the page — same-day data may take a short time to populate.

The DTR total does not match my bank deposit

Check: The DTR shows what was posted, not what was settled. ACH and card settlements may post to your bank on a different date. Use the Payout Report to match bank deposits.

A refund is showing in the DTR but I did not authorize it

Check: Use the Cashier Report filtered by date to identify which user processed the refund. If the refund appears unauthorized, contact DealerWorks support with the transaction details before taking any action.