Shopmonkey: How can I use the End of Day report?

Quickly determine your shop’s daily performance through viewing key money metrics, such as for sales, payments, and more

Zack Buffum avatar
Written by Zack Buffum
Updated over a week ago

The End of Day Report has information that is great to review at the end of the day, but it can be reviewed whenever you want to get an idea of the overall status of your shop. It’s the go-to report to see how estimates are being converted into invoices, to see your profit and profitability, to see taxable vs. non-taxable items, to get a breakdown of the payments that are coming into the shop, and much more.


Filters

Like other reports, the End of Day report has filters that are used to customize the data that is displayed. The report will always start by showing the information from Today, but other date ranges can be selected. The data in the graph will include only information from orders within that date range.

Another filter for this report is the choice to show Fully Paid Date or Invoiced Date.

  • Fully Paid Date: Displays all orders that have been fully paid within the date range. Partially paid invoices will not be displayed with this filter selected.

  • Invoice Date: Displays all orders that have been converted to an invoice within the date range. Unpaid, partially paid, and fully paid invoices will be displayed with this filter.


Sales Summary

This report answers the question, “How effectively is your team presenting and closing work?” It shows the total counts of Estimates, Unpaid Invoices, and Fully Paid invoices. It also counts the hours on Estimates and Invoices.

  • Close rate can tell you how well your shop is converting estimates into fully paid invoices. It’s calculated with the following formula: (Count of paid invoices/count of estimates created) * 100.


Performance Summary

This report answers the question “How is your shop's overall performance?” It shows information for Average Sales, Average Order Profit, Average Order Profit Margin, Gross Sales, and Gross Profit.

  • Avg. Sales can tell you an estimate of how much revenue comes in from invoices. It’s calculated with the following formula: Total Sales / Total Invoices.

  • Avg. Order Profit can tell you how much profit you usually make from invoices. It’s calculated with the following formula: Total Profit / Total Invoices.

  • Avg. Order Profit Margin can show you the percentage of profit from each invoice. It’s calculated with the following formula: (Total Profit / Total Sales) * 100.

  • Gross Sales will tell you how much revenue you make for each hour your shop puts in. It’s calculated with the following formula: Total Sales / Billed Hours.

  • Gross Profit will tell you how much profit you make for each hour your shop puts in. It’s calculated with the following formula: Total Profit / Billed Hours.

  • Total Labor Cost is calculated with the following formula: Labor costs from tracked hours on invoices + general tracked hours within the selected date range.

  • The Effective Labor rate can tell you the calculated rate for the hour listed. It’s calculated with the following formula: Labor dollars on invoices / labor hours on invoices.


Order Summary

This report answers the question, “How much of your invoice totals will result in revenue?” It totals all invoice revenue for the given date range, and it shows you a breakdown of Line Items, Fees, Discounts, EPA, Shop Supplies, and Taxes. The total at the bottom will show the resulting revenue. You can quickly find how much was discounted for the day or your tax liability.

Note: Since the Order Summary totals only revenue from invoices, estimate totals and payments are not be included.


Line Item Summary

This report answers the question, “How profitable are your individual line items?” It will show totals for Labor, Parts, Tires, Subcontracts, and Fees. Each line item will have a column for each of the following categories:

  • Taxable will show the total of taxable revenue. More information is available on how to set up taxes.

  • Non-Taxable will show the total of untaxed revenue. For more information, check out the article mentioned above.

  • Tax-Exempt will show a tax-exempt total of tax-exempt customers. For more information, check out the above taxes article.

  • Subtotal adds the Total of Taxable and Non-Taxable. Any discounts applied to orders will affect these totals.

  • Discounts will show the discounted amount for each line item.

  • Total Retail is the sum of the total retail prices of the line items displayed on invoices.

  • Total Cost is the sum of line-item costs. This includes the Part, Labor, and Tire costs, and 100% of the Subcontracts are considered costs. Fees don't apply as costs.

  • Total Profit is the line item Price less the line item Cost.


Payment Summary

This report answers the question, “What payments should you be expecting in the bank?” It shows a breakdown of all payments on estimates and invoices for the set date range, and each available option in Shopmonkey is broken out. This may contain more options than your shop currently accepts. This will show totals for Cash, Check, Other, and Credit Cards like Visa, Mastercard, and AMEX among others. The report will also show totals for refunds. At the bottom of the report, subtotals show all credit card payments, cash, and check totals.


Still have questions? Feel free to reach out to us through the Chat Icon in the bottom right corner of your screen. Thanks for reading!

Did this answer your question?