End of Day Report

At the end of your work day, you’re going to want to see what revenue came into your shop for the day. With our end of day report, you will have a better pulse on how your shop is performing, and where you need the shop to improve if needed. Below we’ve highlighted some key metrics that will provide valuable information when reviewing your reports. 

1. Total RO’s - this data point will give you a pulse check on volume and how many cars came into your shop during a certain period of time. 
2. Close Ratio - this metric lets you know the percentage of quoted jobs that get approved by customers. 
3. Effective Labor Rate - average dollar amount you are bringing in per hour on labor. Should be relatively close to your default labor rate in shop settings. 
4. ARO (Average Repair Order) - on average, how much are you charging your customers per repair order. 
5. ARO Profit Margin - Of the dollar amount sold, how much is actually going to be a profit to your shop (this metric is considering your part cost and technician cost). 

We recommend listening to this great podcast by Aaron Stokes on Ratchet and Wrench where he talks about knowing your numbers to understand and grow your business. 

The End of Day Report contains several KPI metrics plus sales, profit and payment summary tables for the period selected. The data on this report is generated only from repair orders with a posted date in the selected date range. We have broken each component of the EOD report below: 

Functionality:

• You can choose a preset date range or choose a custom date range.
• The report overall is filterable by Service Writer.
• The report can be printed as a PDF.

Key Performance Indicators (KPIs) & Metrics: 

• Total ROs - This is the number of posted ROs for the period.
• Hours Presented - Total number of hours presented to the customer on posted ROs.
• Hours Sold - Total number of hours sold/approved on posted ROs.
• Close Ratio - Total dollars sold / Total dollars presented.
• Effective Labor Rate - Total Labor Dollars Sold (after discounts) / Labor Hours Sold.

Key Performance Indicators broken down with and without tires and batteries: 

• Avg. RO Sales  - Total Sales Dollars - Discounts (subtotal sales)  / Total ROs.
• Avg RO Profit - Total Profit Dollars / Total ROs.
• Avg RO Profit Margin - Total Profit Dollars / Total Sales Dollars.
• Gross Sales per Hour - Total Sales Dollars / Hours sold on posted ROs.
• Gross Profit per Hour - Total Profit Dollars / Hours sold on posted ROs.

Data Tables:

• RO Summary - This table starts with raw sales dollar earned for labor, parts and fees, less discounts, plus sales tax dollars collected.
  • The "Total" here should reconcile with the "Total" in the Payments table below (after A/R and pre-payment reconciliation). 
• Sales after Discounts - This table shows your sales across labor, parts, sublets, and fees less discounts that were applied. This table will not reconcile with the Sales Detail report headers since that report shows data before discounts and this data has already had discounts taken out. In addition, it will also break down tires and batteries as well as net sales. 
  • The bottom right Total of this table should equal the "Subtotal" line of the "RO Summary" table. 
  • The taxable dollars are what is presented to the customer on the repair order. 
• Profit Summary - This table takes the sales after discount amount from the last row of the "Sales after Discounts" table above and subtracts the costs to get the profit dollars in each category. It breaks down the sales, discounts, net sales, costs, profit dollars, and profit percentage. In addition, tires and batteries are broken out and the total with and without fees is displayed. 
• Payments - The payments table summarizes the payments received for the period selected across categories to sum to "Total Cashiered" for the day. Since the total cashiered for the day could include payments made on ROs that were not posted for the day, we need to back those payments out to reconcile the payments received with actual sales: 
  • Posted to A/R - We add back the sales dollars recorded for the day but sent to A/R and thus not included as cash collected. 
  • Cleared from A/R - We subtract payments received for the day that are not aligned with an RO that was posted / recorded as a sale today.
  • Previous Advanced Pay - Some customers might have pre-paid deposits on their ROs from a prior period, but their RO was posted and recorded as a sale today. To match up the sale recorded today with the payments received, we need to add those prior period deposits back in. 

  • Advance Pay - Our Total Cashiered for today might also include deposits on ROs that are still not posted. Thus, we need to subtract out those "extra" payments on ROs that will posted in the future. Whenever those ROs are posted down the road, these pre-payments will become a part of the "Previous Advanced Pay" line item. 

    

• Credit Applied - Amount added to total cashiered from any store credit balances used as a payment towards posted ROs
• Credited - Amount subtracted from total cashiered for store credits that can be used toward future services (i.e., deferred revenue)
• Returned Credit - Store credit returned to the customer, which removes the liability for future services.