What This Report Shows

The End of Day report gives you a complete financial picture of your shop for any period you choose — a single day, a week, or a full month. Unlike most reports that show a list of individual orders, this report shows everything rolled up into summary sections: how many orders you invoiced and how many are still unpaid, where your revenue came from (labor, parts, tires, etc.), how payments came in by tender type, and key performance numbers like your close rate and profit margin. Use it to close out a business day, review a week's performance, or prepare for a conversation with your accountant.

Filters

Select Filters to choose which data is displayed in the summaries.

Primary Date

Default: Invoiced — this month.

A dropdown next to the date picker lets you choose what the date range means:

• Invoiced — use this when you want to see data about completed jobs. An order appears in this view based on when you closed and invoiced it. This is the right choice for questions like "what did we finish this week?" or "how much work did we invoice in March?"

• Fully Paid — use this when you want to see data about money that came in, regardless of which jobs it relates to. An order appears in this view based on when the customer's final payment was received. This is the right choice for questions like "how much cash did we collect this week?" or "what's actually in my account from this period?"

The key difference: an invoice sent March 31 but paid April 2 appears in March's Invoiced view and April's Fully Paid view. Neither is wrong — they answer different questions.

Note: Estimates are always counted by the date they were created, regardless of which mode you choose. Estimates can't have an invoice date — so the system uses their creation date instead.

Secondary Date (Optional)

When you use one primary date mode, a second date picker appears for the other mode. If you fill in both, orders must match both date ranges at the same time — orders invoiced in March AND fully paid in April, for example. This is a narrow intersection and is mainly useful for reconciliation. For routine reporting, leave the secondary date blank.

Paid Status

Default: All invoices shown.

Filter to see only paid, unpaid, or overdue invoices. Note: if you filter to "Unpaid," invoices where you've received some payment (but not the full amount) won't appear — they fall between Paid and Unpaid. Leave this blank to see everything.

Service Writers

Default: All service writers shown.

Filter down to orders handled by specific service writers. Former employees appear in the list with "(Deleted)" — their historical orders are still included if selected.

Understanding Each Number

Sales Summary

Total Estimates / Total Invoices / Total Orders

What they mean: Total Estimates counts your Estimate and Repair Order status jobs created during the period. Total Invoices counts jobs you've invoiced. Total Orders is the two added together.

When they're useful: At a glance, these tell you how much work came through the door versus how much was completed and billed.

Total Orders includes estimates. If your Total Orders seems much higher than your Total Invoices, you have a lot of estimates that haven't been converted yet.

Unpaid / Partial Invoices

What it means: How many invoiced jobs haven't been fully paid yet — including both completely unpaid and partially paid jobs.

When it's useful: Tracking your outstanding receivables at the end of a period.

Fully Paid Invoices

What it means: Jobs that have been both invoiced and fully paid.

Estimated Hours / Invoiced Hours

What they mean: The total labor hours entered on your estimate jobs (Estimated Hours) and your invoiced jobs (Invoiced Hours). These are the hours set on each labor line item — not how long your technicians actually clocked working.

When they're useful: Comparing estimated vs. invoiced hours shows how your jobs evolved from estimate to invoice. If invoiced hours are consistently lower than estimated, you may be under-billing.

Close Rate

What it means: The percentage of all orders (estimates + invoices) that resulted in a completed invoice. Total Invoices ÷ Total Orders.

When it's useful: Tracking how often estimates convert to invoiced jobs. A low close rate may indicate pricing, trust, or follow-up opportunity.

Performance Summary

Avg. Sales

What it means: Your average invoice size — total revenue divided by the number of invoiced orders.

When it's useful: Benchmarking your typical job value. If this drops over time, it may indicate a shift toward smaller jobs.

Avg. Order Profit / Avg. Order Profit Margin

What they mean: Your average profit per job (in dollars and as a percentage of revenue). Profit = what you charged minus the wholesale cost of parts and labor.

What they don't include: Time clock cost (how long your techs worked). That's tracked separately in Labor Cost (Time).

Gross Sales / Gross Profit

What they mean: Revenue and profit earned per billed labor hour. A way to see how efficiently your shop converts technician hours into revenue and profit.

When they're useful: Comparing these numbers over time helps identify whether your effective billing rates are improving or slipping.

Labor Cost (Order)

What it means: The total wholesale cost of all labor items on your invoiced orders — the cost you entered in the Labor Cost field on each labor line item.

What it doesn't include: Time your technicians clocked on the job. That appears in Labor Cost (Time) below.

Labor Cost (Time)

What it means: The total cost of time your technicians clocked on invoiced orders, calculated from their hourly pay rates. Only Order, Service, and Labor clock sessions count — general time (cleaning, meetings) is excluded.

If it shows $0: Your technicians may be on flat-rate pay (no hourly rate configured), or no time was clocked against invoiced orders in the period.

Order Summary

How much of your invoice totals will result in revenue? This summary totals all invoice revenue for the given date range and shows you a breakdown of line items, fees, discounts, EPA, shop supplies, and taxes. The total at the bottom shows the resulting revenue. This report is a great way to easily view the amount of discounts you’ve given and your tax liability.

Please Note: The Order Summary only totals revenue from invoices. Estimate totals and payments are not included.

Line Item Summary Table

This table breaks your revenue down by type of work — Labor, Parts, Tires, Subcontracts, and Fees.

Taxable / Non-Taxable / Tax Exempt

What they mean: How your revenue is split by tax treatment. Taxable = amount that had tax applied. Non-Taxable = amount not subject to tax. Tax Exempt = amount on orders for customers with a tax exemption on file.

Subtotal / Discounts / Total Retail

What they mean: Subtotal = revenue before discounts. Discounts = total discounts applied (shown as a negative number). Total Retail = what was actually charged after discounts.

Total Cost / Total Profit

What they mean: Total Cost = what the items cost your shop (wholesale price). Total Profit = Total Retail minus Total Cost. A negative Profit means items were sold below cost — worth investigating.

Payment Summary Table

This table shows how payments came in, broken down by payment type.

Payment Type

Cash and Check are combined into one "Cash + Check" row. Customer Credit (payments made from a customer's account balance) is always shown as a separate row and is NOT included in the Total — it is not new cash coming in, just a draw against stored credit.

Count

Number of payment transactions per tender type. A single transaction split across two tender types (part cash, part card) counts as one.

Amount

Total collected for each tender type. The Total row at the bottom excludes Customer Credit.

Important: The Payment Summary always shows payments by the date money was received — it does NOT change when you switch the primary date to "Fully Paid." A payment received today for an order invoiced last month will appear in today's Payment Summary.

Common Questions

Q: Why doesn't my Payment Summary total match my Order Summary total?

A: They measure different things and use different dates. The Order Summary shows the total value of orders invoiced (or fully paid, depending on your primary date setting) during the period. The Payment Summary shows the total amount of money received during the period, regardless of when those orders were invoiced. An order invoiced March 31 but paid April 2 will appear in March's Order Summary and April's Payment Summary.

Q: Why are my End of Day totals different from my Sales Summary report?

A: The most likely reason is the primary date setting. End of Day can be set to either "Invoiced" or "Fully Paid" — Sales Summary always uses the invoice date. If your End of Day is set to "Fully Paid," it will only include orders that have been completely paid, which is a different set of orders from everything that was invoiced.

Q: Why are some invoiced orders missing?

A: Check a few things:

1. Is the Paid Status filter active? Partially paid orders won't appear under "Paid" or "Unpaid" — they only show when no status filter is applied.
2. Is the primary date set to "Fully Paid"? Invoiced-but-not-fully-paid orders won't appear.
3. Is a Service Writers filter active? Orders not assigned to the selected writers are excluded.

Q: Why is my Total Estimates count different from what I expected?

A: Estimates are always counted by the date they were created — not by invoice date or fully paid date. If you switch the primary date to "Fully Paid," it doesn't change how estimates are counted. An estimate created on March 10 will appear in March's count regardless of your date mode.

Q: Why is Labor Cost (Order) different from Labor Cost (Time)?

A: They measure two different things. Labor Cost (Order) is the wholesale cost you entered on each labor line item — what the shop pays to deliver that service. Labor Cost (Time) is calculated from how long your technicians actually clocked working on invoiced jobs, multiplied by their hourly pay rate. A technician can spend 2 hours on a job but you bill 1.5 hours — both costs are real, they just come from different places.

Tips for Getting the Most Out of This Report

• Ask yourself one question before choosing a date mode: "Am I looking at completed jobs, or cash received?" Use Invoiced for completed jobs; use Fully Paid for cash received. The primary date toggle is powerful — switch to Fully Paid when you want to know exactly what cash you've collected and closed, not just what you've billed.
• Check the Line Item Summary's Total Cost column to find margin problems. If any category shows a Total Profit close to zero or negative, that's a signal that items in that category may be priced too close to cost — or that cost prices need to be updated.
• Compare the Payment Summary total to your Order Summary total at end of day. The gap between these two numbers tells you how much revenue you've invoiced but not yet collected. A growing gap means more outstanding invoices and is worth addressing in follow-up with customers.

Still have questions? Feel free to reach out to us through the chat icon. Thanks for reading!