Skip to content

Reading the End-of-Day Sales Report: 5 Key Metrics for Shop Owners

A step-by-step guide to reading end-of-day sales reports for coffee shops, milk tea bars, and retail stores via 5 core metrics to control cash flow and stop leakage.

13 min read Retail & F&B
A coffee shop owner checking 5 metrics in an end-of-day sales report on a POS tablet
Table of contents
  1. Why You Shouldn't Just Look at Total Daily Sales
  2. Metric 1: Gross Revenue vs. Net Revenue
  3. How to Read and Take Action:
  4. Metric 2: Payment Method Breakdown and Shift Reconciliation
  5. How to Read and Take Action:
  6. Metric 3: Average Order Value (AOV) and Ticket Count
  7. How to Read and Take Action:
  8. Metric 4: Top Sellers and Zero-Sales Items
  9. How to Read and Take Action:
  10. Metric 5: Void History, Refunds, and Reprint Logs
  11. How to Read and Take Action:
  12. Advanced: Tracking Returning Customer Sales to See Beyond a Single Day
  13. The 10-Minute End-of-Day Sales Checklist for Owners

To read an end-of-day sales report effectively, shop owners don't need to sift through dozens of complex tables. You only need to focus on 5 core metrics: Net Revenue, payment method breakdown, Average Order Value (AOV), top/bottom-selling items, and abnormal void/discount rates. Reviewing these 5 numbers for 10 minutes each evening ensures you have a firm grasp on actual cash flow, detect checkout counter leakage early, and adjust your sales plan immediately for the following day.

Many coffee, boba, and retail shop owners have a habit of opening their point-of-sale (POS) app at 10 PM, glancing at the total revenue figure, and going to bed reassured if it's higher than yesterday. But at the end of the month, once ingredient costs, rent, and staff payroll are deducted, there is hardly any cash left in the bank.

The reason is simple: the headline total revenue figure on your dashboard is often an "illusion" unless you unpack its underlying components. From the perspective of building operational and payment digitization ecosystems for SMEs at GoMetap, I always advise shop owners to turn reading the End-of-Day Report into a disciplined yet streamlined routine.

Here is a step-by-step guide to reading the 5 most critical metrics every night when closing up shop.

Why You Shouldn't Just Look at Total Daily Sales

An End-of-Day Sales Report aggregates all sales transactions, payments, promotions, and voids that occurred from the opening of the first shift to the closing of the last shift of the day.

If you only look at the total sales figure, you overlook three major risks:

  1. The illusion of promotional revenue: Generating 10 million VND in sales but giving away 3 million VND in discounts and complimentary items means your actual intake is only 7 million VND.
  2. Actual cash flow discrepancies: The POS logs 10 million VND, but physical cash in the drawer plus bank transfers only adds up to 9.5 million VND.
  3. Hidden cashier leakage: Staff print provisional receipts to collect cash from customers and then modify the ticket, or apply unauthorized manual discounts to pocket the difference.

Instead of feeling overwhelmed by dozens of reporting tabs in your POS software, walk through the following 5 metrics one by one.

Metric 1: Gross Revenue vs. Net Revenue

Gross Revenue is the total value of all items sold at menu list prices before deducting any discounts, promotions, or returns.

Net Revenue is the actual amount the business brings in from sales after subtracting all discounts, promotions, vouchers, and product returns from gross revenue.

Metric Basic Calculation Formula Meaning for Shop Owners
Gross Revenue Sum (Item Quantity × Menu List Price) Reflects overall purchasing demand and staff operational workload for the day.
Discounts / Promotions Program Discounts + Manual Discounts Direct marketing expenses per order that must be strictly monitored.
Net Revenue Gross Revenue - Discounts - Returns Actual funds available to cover cost of goods sold (COGS), payroll, and rent.

How to Read and Take Action:

When opening the report, ask yourself: What percentage of gross revenue do discounts represent?

  • Real-world example: A boba shop runs a "Buy 2 Get 1 Free" campaign during the afternoon. At the end of the day, the report displays Gross Revenue of 8,000,000 VND, but Discounts reach 2,400,000 VND (30%), leaving Net Revenue at just 5,600,000 VND. If the shop's baseline food cost (COGS) is already 35% of list price, this promotion leaves virtually zero profit after factoring in cups, straws, and barista labor.
  • Action: If the gap between gross and net revenue is too wide without a proportional surge in new customer acquisition, stop or recalibrate the promotional terms the very next day.

Metric 2: Payment Method Breakdown and Shift Reconciliation

Shift Reconciliation is the process of comparing recorded sales on the POS software by payment method against the physical cash counted in the drawer and actual bank transaction statements.

In modern cafes and small eateries, customers typically pay via 3 primary channels: Cash, Bank Transfer (VietQR), and food delivery apps or e-wallets.

How to Read and Take Action:

Examine the fund allocation table to uphold one non-negotiable rule: POS Recorded Amount = Actual Received Funds.

  • For Cash: Opening float + Daily cash revenue - Documented counter cash payouts (ice purchases, trash bags with receipts) = Target cash expected in drawer.
  • For QR Transfers: Total bank transfers on the POS must match 100% of the shop owner's inbound bank transaction alerts.
  • Real-world example: A small cafe logs 5,000,000 VND in sales for the day: 2,000,000 VND in cash and 3,000,000 VND via bank transfer on the POS. When checking the register, cash matches at 2,000,000 VND, but the banking app shows only 2,850,000 VND. This 150,000 VND discrepancy usually stems from two causes: a staff member accidentally tapped "Bank Transfer" instead of "Cash" on the POS (in which case the cash drawer should have had a surplus; if not, there is an issue), or a customer flashed a fake or failed transfer screen during a rush hour without proper cashier verification.
  • Action: To eliminate transfer discrepancies and end-of-day manual tallying, businesses increasingly integrate dynamic VietQR directly into their POS system (such as the automated payment solutions in the GoMetap ecosystem). When customers scan the QR code for the exact amount, the system automatically confirms and closes the order on the POS, ensuring bank reports match perfectly without requiring screenshots.

Metric 3: Average Order Value (AOV) and Ticket Count

Average Order Value (AOV) is the average amount a customer spends per transaction at your venue, calculated by dividing Net Revenue by the Total Number of Completed Orders.

Many owners notice a 20% revenue drop compared to yesterday and immediately conclude that "it was a slow day." However, breaking down revenue into two variables—Ticket Count (Traffic) and Average Ticket Size (AOV)—reveals an entirely different picture.

Net Revenue = Order Count × Average Order Value (AOV)

How to Read and Take Action:

  • Scenario 1: Ticket count drops, but AOV remains stable. The issue stems from external foot-traffic drivers (rain, traffic congestion, a competitor opening nearby, or an expired ad campaign).
  • Scenario 2: Ticket count remains stable (the shop was busy), but AOV drops. The issue lies in sales execution at the counter.
  • Real-world example: A cafe-bakery typically averages an AOV of 65,000 VND (customers usually buy a 40,000 VND coffee and a 25,000 VND croissant). On Thursday evening, your report shows 100 orders—the usual volume—but revenue only hits 4,500,000 VND (AOV plunged to 45,000 VND). Looking closer, you discover that the shift was staffed by a new hire who simply took drink orders without suggesting pastries or size upgrades.
  • Action: Retrain front-of-house staff on upselling and cross-selling scripts, or bundle popular items into combos (Drink + Pastry) prominently displayed on the POS interface for seamless recommendations.

Metric 4: Top Sellers and Zero-Sales Items

An Item Sales Report lists the quantities sold and revenue share of each product on your menu over a specific timeframe.

This metric connects your checkout counter POS directly to the refrigerators in your bar or kitchen.

How to Read and Take Action:

Every evening, quickly scan your Top 5 Sellers and Bottom Sellers.

  1. Forecasting raw materials for tomorrow morning: If your "Soursop Tea" suddenly doubles in sales volume today, immediately check remaining soursop puree levels to instruct prep staff or suppliers to restock early tomorrow morning, avoiding out-of-stock situations during peak hours.
  2. Controlling waste on fresh goods:
  • Real-world example: A cafe stocks 15 portions of fresh Tiramisu each morning (2-day shelf life). By the end of day one, the item report shows only 2 portions sold. If you miss this metric at night, the morning shift will leave the pastries in the display case without pushing them. By the end of day two, you will end up throwing away over a dozen expired desserts. Conversely, spotting this early allows you to message the opening team: "Prioritize Tiramisu today—offer a 20% discount when paired with milk coffee" to recover food costs.

Metric 5: Void History, Refunds, and Reprint Logs

A Post-payment Void is a transaction previously logged as completed in the POS software that is subsequently deleted or refunded by a cashier or manager.

While the first four metrics optimize your operations, this fifth metric serves as an "audit barrier" protecting the owner's bottom line, especially when you are not physically on-site.

How to Read and Take Action:

Navigate to your POS Audit Log / Void History and monitor 3 critical numbers:

  • Number of Voided/Cancelled Orders: Staff create an order, print a provisional bill, or collect cash from the customer, then void the order on the POS once the customer departs under the guise of "customer changed mind," pocketing the cash.

  • Frequency of Manual Discounts: Staff manually input an unauthorized 10%–20% discount on a standard order (where the guest paid 100% in cash) to take home the difference.

  • No-Sale Cash Drawer Opens: A clear indicator of cash being accessed or removed outside of logged transactions.

  • Real-world example: A small eatery typically records 1–2 voids per day due to accidental ordering. However, on Saturday night, the report flags 8 voided tickets—all occurring during the evening shift, all paid in cash, and all with vague notes stating "mistake." By cross-referencing surveillance footage matching the exact timestamps of those POS voids, the owner can easily verify whether these were genuine operational errors or cashier fraud.

  • Action: Restrict POS permissions: cashiers should only edit orders before printing provisional tickets. Any post-payment voids or manual discounts must require a manager/owner PIN or mandate photo proof of the spilled or defective item.

Advanced: Tracking Returning Customer Sales to See Beyond a Single Day

Once you master these 5 core operational metrics, an advanced indicator worth observing is the Member Sales Ratio—the percentage of today's revenue generated by returning members versus walk-in guests.

If your business relies exclusively on first-time visitors with no repeat customers, customer acquisition costs will steadily climb. Connecting your POS reporting with a digital loyalty card system (such as point-earning cards stored natively in customers' Apple Wallet or Google Wallet, implemented by GoMetap for merchants) allows you to see exactly how many of today's 100 orders came from returning guests, giving you a true read on whether your product quality and service are actually driving retention.

The 10-Minute End-of-Day Sales Checklist for Owners

You do not need to be a certified accountant to keep your shop's finances on track. Save this 5-step checklist and run through it every evening once staff close their shift:

  • Step 1 - Check Net Revenue (2 mins): What percentage of the daily sales target did Net Revenue achieve? Did total discounts/promotions exceed your threshold (e.g., >15%)?
  • Step 2 - Reconcile Actual Cash Flow (3 mins): Does handed-over cash match the shift-closing report? Do total POS bank transfers match 100% of your incoming bank notifications?
  • Step 3 - Diagnose AOV & Order Count (1 min): If revenue fluctuated today, was it driven by foot traffic (ticket count) or spending per guest (AOV)?
  • Step 4 - Review Inventory for Tomorrow (2 mins): Which items experienced a sales spike that requires restocking raw materials by morning? Which fresh goods are lagging and need active upselling during the morning shift?
  • Step 5 - Audit Sensitive Actions (2 mins): Were there any unexplained Voids, Refunds, or Manual Discounts that warrant checking security cameras or following up with the cashier?

Managing a profitable small business is rarely about making monumental decisions once a year; it comes down to the clarity of small numbers monitored consistently every single night.

Frequently asked questions

How long does it take for a shop owner to review an end-of-day sales report?

If the POS system is configured properly with automated payment reconciliation, it takes owners only 5 to 10 minutes each evening to review the 5 core metrics. You don't need to pore over individual receipts—just focus on aggregated figures and abnormal transactions (voids, cash discrepancies).

How should discrepancies between POS reports and actual cash in the drawer be handled?

First, separate cash from bank transfers to identify where the variance originates. If cash is short while transfers show an identical surplus, the cashier likely selected the wrong payment method when closing out the bill. If both combined are less than net revenue, review petty cash payout vouchers at the counter and cash drawer opening logs for that shift.

Which metric is more important: gross revenue or net revenue?

Net revenue is more critical because it represents the actual cash coming into the business to pay for Cost of Goods Sold (COGS), rent, and payroll. Gross revenue merely indicates the total volume of items sold and staff workload, but it can be misleading if the business runs heavy discounts.

How can owners prevent cashiers from unauthorized bill voids and cash theft?

Restrict permissions so cashier accounts cannot void orders after printing provisional receipts or processing payments on the POS. All post-payment voids should require a manager or owner PIN, coupled with dynamic VietQR payments for automated reconciliation and a nightly review of void logs.

What is a good Average Order Value (AOV) for a coffee or milk tea shop?

There is no single benchmark AOV, as it depends on your menu pricing. However, a healthy AOV is typically 20% to 30% higher than your signature item's price, indicating that guests frequently order multiple items or add toppings and pastries.

Comments

No comments yet. Be the first to share your thoughts!

Leave a comment

Comments are reviewed to keep the discussion useful and spam-free.