Quickvee Help Center

Daily sales total report

🚧 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 → ReportingSales Reports → select Daily Sales Totals from the report dropdown

1_Quickvee Web (merchant backend) → Reporting → Sales Reports-20260602-091335.jpg
1_Sales Reports → select Daily Sales Totals (1)-20260602-091409.jpg


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

1_The Filter Bar (5)-20260602-091421.jpg


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

1_Reading the Table (2)-20260602-091456.jpg

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

SUM(amt + cash_back_fee) + SUM(gift_card_amount)

Refund Amount

SUM(amount − loyalty_point_amt) (loyalty point refund excluded)

Net Daily Sales

Order Amount − Refund Amount

Grand Total

SUM(All Daily Net Sales Amounts)

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.

Internal reference

Source ticket: MM-506 — Sales - Daily Sales Total