Search Posts

Transaction Report – Detailed

Print Friendly, PDF & Email

The detailed Transaction Report is designed to help you investigate sales and invoice activity and to find errors in specific transactions. Along with the successful sales transactions, you can see all the sales transactions that were not completed. These include aborts, voided transactions, no-sales, reprints, and deletes. Each invoice used during the day should correspond to an event on this report. The midday till closing is also printed on this report. The summary Transaction Report is automatically printed after the detailed report.

Note: The transactions are printed in chronological order by start time.

With this information you can identify disrupted or incomplete sales. These are important events to track because they decrease efficiency and profits.

Note: For reprinted invoices, the message From Vehicle History prints as the explanation of the transaction.

Printing the Report

Use the following steps to print a detailed Transaction Report:

  1. On the Main Menu, select Lubrication Menu.
  2. Select Lubrication Reports Menu (3).
  3. Select Transaction Report (2).
  4. Use the following field definitions to create a report according to your needs.
This report generally prints at least a page per day for each date you request. This can take a long time and use a lot of paper if you request a large number of days.
Field Definition
Range of Dates Fill in the beginning and ending dates you want to include on your report. Leave blank to print the report for the current date.
Print Time on Report Printing the time helps you identify the most current report when the same report is printed more than once during a day. This field defaults to Y to print the time on the report. If you do not want the time to print on a report, type N. We recommend that you always print the time on a report.
Summary Only This field appears for reports with both detailed and summary versions. Enter N to print the detailed report. We recommend printing a detailed report only if you need detailed information.
Duplex This field appears for terminals that have report type 2 enabled in the Set Up Printer Controls screen. Duplex mode enables printing on both sides of the paper.

Note: This will only function on printers that support Duplex mode.
Landscape This field appears for terminals that have report type 2 enabled in the Set Up Printer Controls screen. It prints horizontally on the paper.
Number of Printed Lines per Page This value tells the computer how many lines to print on each page of the report. A typical 11-inch page can contain up to 66 lines, but this field defaults to 60 to allow three-line margins at the top and bottom of the page.

If you type 0 (zero) in this field, the report header does not print and the form feeds do not work.
Total Number of Lines per Page This field indicates the length of the paper in the printer. A typical 11-inch page contains 66 lines. Your system interprets a 0 or 66 in this field to mean that standard 11-inch paper is loaded in the printer. Because a 66 causes a form feed to take more time, accepting the default, 0, is recommended.
Print Report To This field tells the computer where to send the report. The following list contains the different selections available for this field.

  • 0 Printer – Sends report to the terminal’s default report printer immediately. (Default)
  • 1 Screen – Provides an on-screen view of a report. This can be used as a preview before you print it or when a hard copy of the report is not needed. The function keys at the bottom of the on-screen version allow you to move around to view the entire report.
  • 2 Disk file – Useful when you want an electronic copy of the report. If you select this option, you receive a prompt to enter the name of the report file. The file that is created can be copied to a USB drive or viewed later. This option is for advanced computer users.
    • If you use this option, we suggest you precede your report name with /tmp/. For example, at the prompt to enter the report name for a customer list, you might type /tmp/custlist. This is a good storage directory for temporary files.
Command Line Options The line at the bottom of the screen contains commands to print the report and to save or change the report settings.

  • Save – Press [F4] to save the current settings for the report. This is useful if a report is generated repeatedly with the same options. Do not save date selections because they may not be useful in the future.
  • Start – Press [F7] to submit the report to print on the printer, on the screen, or in a disk file. (Reports print in the order they are submitted.)
  • Again – Press [F9] to return to the top of the screen. This allows you to change any of the information you have entered on the screen before you submit the report.
  1. Press [F7] to start the Transaction Report. When the processing is complete, you return to the Lubrication Reports Menu.

You can also set up this report on the Set Up Closing Processes screen (1-6-3) to print automatically during closing processes.

 

Report Contents

Transactions are listed in order by start time, when the invoice is sent to the cashier screen. Information on sales transactions includes the following:

  • Bay number
  • Transaction number
  • Gross sales amount of invoice
  • Coupon, discount, and warranty amounts
  • Gift certificate/card sales
  • Net sales amount of invoice
  • Tax applied to invoice
  • Ticket total
  • Taxable and non-taxable amounts on the invoice
  • Start and end time of the invoice, and the total time for service

Totals for all sales transactions are shown at the end of the report. These should correspond to figures on the summary Transaction Report. Voided transactions, which are also listed, have an associated invoice number but no sales amount. For other events, the transaction number is not associated with an invoice number. Information for all non-sales events includes the following items:

  • Transaction type
  • Reason for transaction
  • Employee who processed the transaction
  • Time of the transaction

 

Item Description
Date Range Range of dates for the report information.
Bay Number of the bay where the transaction occurred.
Transaction Transaction number. The first six digits identify the date in the YYMMDD format (for example, 030930 refers to 09/30/2003). The remaining figures identify the invoice number.
Gross Cost of the service before taxes, coupons, discounts, or warranties.
Promo Total amount of coupons and discounts applied to the transaction. Shows C for coupon, D for discount, or B for both.
Warr Warranty. Total amount of all items or services with warranties.
Net Net sales amount of the transaction after promotions and warranties are applied.

Net = Gross – Coupon – Warr – Disc

GC Sales Amount of gift sales if a gift certificate/card was sold on the invoice.
Tax Total taxes for the invoice.
Ticket Ticket total, which equals the net amount plus tax and gift sales.

Ticket = Net + Gift Sales + Tax

Txable(1) Amount of the invoice to which Tax #1 applies.
Nontxbl(1) Amount of the invoice to which Tax #1 does not apply

Note: Net Sales = Txable(1) + Nontxbl(1)
Start Time the invoice was started at a bay station.
End Time the invoice was sent to the cashier.
Time Difference between the start time and end time. This field is empty if the difference is more than 30 minutes, indicating the vehicle was on hold.
Totals Total amount of each column for the entire report.

Recommendations for Using This Report

This report is important for tracking store sales activity. You should set it up to print automatically during the daily close. If you do this, you receive the summary report as well. The totals should always match on the detailed and summary pages. When you receive this report, take time to look through the list of transactions. Specific items to watch for include:

  • Transactions that took over 30 minutes. This may indicate a problem in the bay, especially if several occurred in the same bay.
  • Warrantied items that were replaced each day. This report can direct you to each invoice that included a warranty replacement.
  • Aborts, no-sales, and reprints. High numbers of these may indicate training issues or improper use of these processes.