What is on the Daily Transaction Report

The DTR has three parts — a summary for the whole dealership, the grand total detail by tender, and then every transaction, department by department.

1. The summary at the top

The first page opens with a summary for the whole dealership — not broken out by department. It shows your grand total for the day, then your DealerWorks transactions, refunds and disputes, each split into Base, NCO (the additional fee) and Total, plus anything entered as an internal, offline payment.

Underneath that are two calculated totals: Total DMS, the total your DMS (dealer management system) should show for the day, and Total Payout, what you should expect to see deposited into your bank account.

2. Grand total detail

Next, the whole day by tender: Payment Method, Processed Amount, Fees and Settled Amount, with credit cards split out by card brand. Only the tenders you actually took that day are listed — there are no zero rows here.

This is the section that matches what you are banking.

3. Every transaction, department by department

The rest of the document is one section per department. Each one lists its Transactions — date and time, invoice, advisor, customer, payment method with the last four digits and whether it ran as credit or debit, then Base, NCO, Total and Settled — then a Transactions Total.

After that comes a Refunds section in the same shape with its own total, and then the department's net Grand Total.

When a fee is bypassed on a payment, the NCO column reads Bypass rather than an amount.

Which parts you bank, and which arrive on their own

The grand total detail is the section to work from at the end of the day, because it splits the takings the way the money actually behaves.

So the card line is what you tie to your deposits, and the rest is what you tie to what you physically took to the bank. See Match your deposits to the day's takings.

It mirrors your dealership, not a standard template

Every section of the DTR is built from the departments and payment types your dealership actually uses. A store with a body shop, a rental counter or a wholesale parts desk gets a section for each; a store without them will not see an empty heading.

So two dealerships’ DTRs can look quite different.

Related: Run the Daily Transaction Report · Match your deposits to the day's takings · Reports and deposits — start here