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 and Exporting
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.
You can export the data from this report into an excel spreadsheet. By clicking the export button, the spreadsheet will download to your computer. In the spreadsheet format, you can manipulate the data and graph to your needs.
You also have the option to print this report. When you click the print button, it will open the print options for your browser and will preview the report in a printable format.
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 invoices/count of estimates created) * 100.
The 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.
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.
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. For more information on how to set up taxes, check out this article.
Non-Taxable will show the total of untaxed revenue. For more information, check out the article mentioned above.
Subtotal adds the Total of Taxable and Non-Taxable. Any discounts applied to orders will affect these totals.
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.
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.