The DTR is built in three layers — the totals, how the money came in, and then every transaction behind it.
1. The day at a glance
The first page opens with the total for every department your dealership runs — whichever those are, from service and parts through to a body shop, rental or wholesale counter — and the grand total for the day.
2. Transaction summary
Then a table breaking each department down by how the money came in, with three columns: Amount, the additional fee, and the Total.
So you can see at a glance that, say, Service took most of its money on cards and Parts took most of its in checks.
3. Grand total detail
Underneath, the whole day by tender: credit cards split out by card brand, then cash, cashier’s checks, insurance checks, business checks and personal checks.
This is the section that matches what you are banking.
4. Every transaction, department by department
The rest of the document is one section per department. Each one lists its Transactions — date and time, advisor, customer, invoice, payment method with the last four digits and whether it ran as credit or debit, amount, fee and total — then a Transactions Total.
After that comes a Refunds section in the same shape with its own total, and then the department’s net Total.
Refunds are listed separately and shown as negative figures. If a department’s total looks lower than you expected, check the refunds section before anything else.
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.
| ON THE DTR | WHAT HAPPENS TO IT |
|---|---|
| Credit cards, broken down by brand | Settles into your account as a payout. Nothing for you to take to the bank. |
| Cash | You bank it yourself. It will never appear on a payout report. |
| Cashier’s, personal, business and insurance checks | You bank these yourself too. |
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 layer 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, and a department you expect to see missing usually means it has no activity that day rather than a fault.
Related: Run the Daily Transaction Report · Match your deposits to the day's takings · Reports and deposits — start here
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article