🚧 Draft article — source ticket MM-506 is still in To Do.
The Daily Sales Totals report is the simplest report in the Sales Reports group: one row per day in the selected range, with that day's total sales. No charts, no breakdowns by tender or category — just a clean day-by-day snapshot of gross daily revenue, with a grand total at the bottom.
Access path: Quickvee Web → Reporting → Sales Reports → select Daily Sales Totals from the report dropdown
Merchants use it for at-a-glance daily reconciliation, week-over-week trend spotting, and as the starting point for any deeper investigation that other reports then drill into.
The filter bar
Date range
-
Quick filters — Today, Yesterday, Last 7 Days, Last 30 Days
-
Manual — pick a Start Date and End Date with the calendar pickers for any custom range
Unlike most other sales reports, Daily Sales Totals has no additional filter section — no category, no order type, no discount type. Every report is just days in range × total sales. Adding filters would defeat its purpose as the cleanest read in the Sales Reports group.
Outlet
For multi-store accounts, the Outlet dropdown selects which location.
Search & Export
-
Search — applies the current filters and reloads the table
-
Export Report (top right) — downloads for sharing or Excel
Reading the table
|
Column |
What it shows |
|---|---|
|
Date |
One row per calendar day. Days with zero sales appear showing $0.00 — confirming the report ran for that day rather than skipping it |
|
Total |
Sum of all paid sales for that day, net of refunds. Gross of taxes — what the customer paid that day, all-in |
Sorting
-
Date descending (default) — most recent day at the top, natural for end-of-day reconciliation
-
Date ascending — oldest day at the top, useful when reading a trend left-to-right
-
Total descending — ranks days by revenue, surfacing your best day at the top
-
Total ascending — surfaces slowest days first, useful for finding weak days to target with promotions
The Grand Total
The bottom row of the table is Grand Total — the sum of every day in the table. This is the single most important number on the report: gross revenue for the entire date range, comparable directly with the dashboard, Sales by Order Type, and daily till closeout totals.
Common workflows
"Show me last week"
Quick filter → Last 7 Days → Search. Read the Grand Total at the bottom.
"Find my best day of the month"
Quick filter → Last 30 Days → Search. Sort by Total descending. The top row is your single best day.
"How does this week compare to last week?"
Run for Last 7 Days, note the Grand Total. Manually set Start Date and End Date to the 7-day window before that, run again. The difference is your week-over-week change.
"Reconcile end-of-day cash"
Quick filter → Today (or Yesterday) → Search. Compare the single-day Total against the day's register close-out.
"Find slow days for a promo target"
Run for Last 30 Days, sort Total ascending. The top of the sorted view is your softest revenue days. Cross-reference against day of week to spot a pattern.
Important notes
The total is gross of tax, net of refunds. Each day's Total includes the tax the customer paid. Refunds processed on that day reduce that day's total — a refund of yesterday's order processed today reduces today's Total, not yesterday's.
Cancelled orders are excluded. Held orders that are paid later contribute to the day they are paid.
Both In-Store and Online orders are included. To split by channel, use Sales by Order Type.
Days with zero sales are shown. If a store was closed on a Sunday and the range includes that Sunday, the row appears with $0.00.
Filters do not auto-apply. Changing the date range or outlet requires tapping Search.
Sort order persists between Searches. Re-tap the Date column header to return to chronological order.
Calculation reference
|
Field |
Formula |
|---|---|
|
Daily Sales Amount |
|
|
Refund Amount |
|
|
Net Daily Sales |
|
|
Grand Total |
|
Only paid/completed orders are included. Gift card amounts are included in total sales. Loyalty point refunds are excluded from the refund calculation. Business timing is handled from inventory_setting.