What is on the Daily Transaction Report

Modified on Sat, Sep 12 at 3:31 PM

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 DTRWHAT HAPPENS TO IT
Credit cards, broken down by brandSettles into your account as a payout. Nothing for you to take to the bank.
CashYou bank it yourself. It will never appear on a payout report.
Cashier’s, personal, business and insurance checksYou 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

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article