Your Daily Financial Snapshot: The Daily Sales Report ๐โจ
Closing out a busy day at your restaurant shouldn't mean spending hours drowning in separate spreadsheets. The Daily Sales Report is your comprehensive, end-of-day financial summary. It consolidates every single dimension of a day's businessโincluding sales, payments, taxes, discounts, voids, labor, and cashโinto a single structured document that serves as the official, authoritative record for that business date.
Whether you are a manager running the numbers at closing time, an owner keeping an eye on performance from afar, or a bookkeeper tracking daily profits, this report gives you everything you need in one clean snapshot.
๐ What You'll See on the Report
The Daily Sales Report can generate up to fifteen distinct sections depending on your venue's settings. To keep your dashboard perfectly organized, you can easily include or exclude sections to customize your view.
1. Overall Summary ๐
The ultimate top-level financial overview. This is the very first number owners and general managers look at, showing your net sales, guest counts, total checks, average check sizes, and an instant breakdown of sales versus non-sales revenue.
2. Sales by Category ๐๐ฅ
See exactly where your money came from and how much was discounted in each area. This section breaks down your net sales, gross sales, and discount totals by every active category on your menu (like Appetizers, Entrees, or Beverages).
3. Non-Sales Revenue ๐ณ๐๏ธ
Tracks all money coming in that doesn't flow through standard menu categories. This includes alternate pricing fees, service fees, automatic gratuities, tips retained by the house, cash paid-ins, and gift card activations.
4. Accountability ๐โโ๏ธ๐จ
Your go-to section for evaluating daily server performance. It provides a per-type breakdown of total financial accountability.
5. Tax Summary ๐๏ธ
Essential for accurate financial bookkeeping. It lists every tax type configured at your venue, alongside the exact taxable amounts and tax totals collected for the day.
6. Payments / Tenders ๐ต๐ณ
A master breakdown of every payment method used during the dayโincluding cash, specific credit card brands, gift cards, house accounts, and custom tenders. This section is your primary tool for reconciling your physical cash drawers and credit card processors.
7. Cash Reconciliation ๐งฎ
The formal cash accountability statement for the shift. It mathematically tracks your starting bank, cash received, safe drops, paid-outs, and tips paid out to calculate your expected ending balance.
8. Cash Over / Short ๐
Surfaces any immediate discrepancies between what the system expected the drawer to have and what your staff actually counted at closing time. A positive number means your drawer is over, while a negative number means it came up short.
9. Discounts & Voids / Deletes ๐๐ท๏ธ
High-level overviews of promotional and security activity. The Discounts section displays counts and dollar values categorized by discount code type, while Voids / Deletes shows total item removals organized by your custom void reasons.
10. Open Check Summary ๐จ
A safety-net feature that flags any guest checks or tabs that were still left open at the time the report was run. This helps managers catch unclosed tabs before finalizing the day's books.
11. Transaction Payment Details (Cash, Credit, & Other) ๐
Line-by-line, transaction-by-transaction tables detailing every single payment received throughout the business date, separated cleanly into individual lists for Cash, Credit Cards, and Other payment types (like gift cards or house accounts).
12. Tip Out Suggestion ๐ธ๐ค
If your venue uses custom tip-out rules by job role, this section automatically calculates suggested tip-out amounts for servers and bartenders based on their daily sales numbers, helping managers run tip distribution consistently.
๐ ๏ธ Strategic Ways to Use This Data
Flawless End-of-Day Closes: Run this report at the end of each business date as your formal closing document. By cross-referencing your Summary, Payments, and Cash Reconciliation sections, you can guarantee that your revenue, actual collections, and cash drawers are in perfect agreement.
Easy Ownership & Accounting Distribution: You can easily email this report directly to your bookkeeping team or restaurant owners. It contains every single data point they need for daily P&L accrual and tax bookkeeping without requiring them to log into the portal.
Pre-Shift Team Recognition: Use the Accountability metrics during your pre-shift team meetings. It's a fantastic tool to praise your top-performing servers and gently flag team members who might need an extra bit of sales coaching.
Instant Labor Cost Checks: Cross-reference your overall labor costs directly against your daily net sales figures to confirm your kitchen and floor schedules are hitting your venue's target daily labor percentages.
โ๏ธ Report Customization Checklist
When generating this report in the NX Portal, you can toggle each individual section on or off using these back-office section keys:
| Section Name | System Configuration Key |
|---|---|
| Overall Summary | SUMMARY |
| Sales by Category | SALES_BY_CATEGORY |
| Non-Sales Revenue | NON_SALES_REVENUE |
| Employee Accountability | ACCOUNTABILITY |
| Tax Summary | TAXES |
| Payments / Tenders | PAYMENTS |
| Cash Reconciliation | CASH_RECONCILIATION |
| Cash Over / Short | CASH_OVER_SHORT |
| Discounts | DISCOUNTS |
| Voids / Deletes | DELETES |
| Open Check Summary | OPEN_CHECK_SUMMARY |
| Cash Payments Detail | CASH_PAYMENTS |
| Credit Card Payments Detail | CREDIT_PAYMENTS |
| Other Payments Detail | OTHER_PAYMENTS |
| Tip Out Suggestion | TIP_OUT_SUGGESTION |
Need Help? ๐ก
Why is my "Cash Over / Short" section showing an unexpected gap?
A discrepancy usually happens if a mid-shift safe drop or a cash paid-out was physically executed but never logged into the POS software. Double-check your Cash Payments Detail and Cash Reconciliation logs to ensure every physical cash movement was entered accurately.
Can I run the Daily Sales Report for a previous business date?
Absolutely! You can select any historical business date from the calendar parameters in your NX Portal dashboard to view or re-send a past day's finalized financial summary.
I have open checks listed, and the system won't let me finalize the day.
Head over to your Open Check Summary section to locate the problem order numbers. Staff must either fully settle those orders, transfer them to a running house account, or properly void them out before your formal end-of-day sequence can close completely.