Discover Your Weekly Rhythm: The Sales by Day Report ποΈπ
Ever wonder if your bar sales naturally skyrocket on Thursdays, or if your food sales stay flat all week long? The Sales by Day Report is designed to answer one crucial question: "How do my sales categories, non-sales revenue, and tender types break down across different days of the week β and which days consistently drive the most of each?"
This report shares the exact same three-section structure as our standard Sales by Date Report, but it organizes your columns around the days of the week rather than specific calendar dates. It is the ultimate tool for understanding your restaurant's weekly heartbeat and spotting recurring consumer habits!
π What You'll See on the Dashboard
The report splits your financial data into three distinct tables, each featuring a handy Total column at the far right so you can keep an eye on your overall period revenue.
1. Sales Categories ππ·
This table gives you one row per active menu category, showing exactly how much revenue each area brought in on any given day of the week.
π Sales Categories Table Example
2. Non-Sales Revenue π³ποΈ
This section tracks additional operational charges that do not flow through your traditional food and beverage categories. You will get one clean row for each non-sales revenue type, including fees, automatic gratuities, alternate pricing adjustments, tips retained by the house, cash paid-ins, and gift card sales.
3. Tenders (Payment Methods) π΅π³
This layout provides one row per payment method (like Cash, Visa, or Gift Cards) that was used to close out guest checks during your selected timeframe.
π Grouping Options: Customizing Your Layout
The Group By setting is the defining feature of this report. It controls exactly how your columns are grouped together on your screen:
| Group By Setting | Column Structure | Best Used For... |
|---|---|---|
| None | One column per individual business date. | Reviewing specific calendar dates over shorter date ranges. |
| Day Totals | One column per day of the week, summed across all matching dates. | Identifying which specific days of the week drive the absolute most cash volume. |
| Day Averages | One column per day of the week, averaged across all matching dates. | Normalizing data for weeks of different lengthsβoffering the fairest weekly comparison over a month or more! |
π‘ Smart Math Note: When you utilize the Day Averages view, the final Total column continues to display your true overall period total (not an average). This ensures you always have an accurate, un-manipulated baseline sitting right next to your normalized weekly views!
ποΈ Accounting Calendar Hint: The starting day of your week columns is completely determined by your store's custom accounting setup. If your venue's accounting week starts on Sunday, your report will automatically display Sunday through Saturday; a Monday start will order columns Monday through Sunday.
π οΈ Strategic Ways to Use This Data
Master Your Weekly Rhythm: Run this report for a full month using Day Totals or Day Averages to quickly isolate your strongest days for each menu category. If your Bar category spikes on Friday and Saturday but Food stays relatively flat, you can directly use that data to make smarter front-of-house staffing and kitchen ordering choices!
Spot Hidden Category Patterns: Some menu segments have unique day-of-week patterns that get buried in flat sales reports. If you notice your Non-Alcoholic Beverage category peaks heavily on weekend afternoons, it is a great signal to feature profitable seasonal mocktails on your weekend lunch menus!
Analyze Multi-Week Trends: Running a month-long report with Day Averages generates a normalized "weekly fingerprint" for your venue. This is an incredible tool for benchmarking performance against the exact same period last year, or for establishing baseline prep and scheduling goals per day.
Audit Daily Payment Preferences: The Tenders table under Day Totals often highlights recurring spending behaviorsβsuch as cash usage spiking on days when there is a local farmers market or a heavy business lunch crowd nearby. Knowing this helps your team prep the perfect amount of register change orders.
Track Event Revenue Trends: Fee and service charge collections often swing wildly depending on the day of the week. For example, if you host private events on Saturdays that generate high automatic gratuities, the Non-Sales Revenue table will visually paint that pattern clearly across your weekend columns.
ποΈ Custom Filters Available
You can tailor your workspace in the NX Portal using three highly flexible filters to isolate the exact day-of-week data you need:
Order Types: Limit all three report tables to focus purely on specific service channels (like Dine In, Takeout, or Online Orders).
Revenue Centers: Scope your data to evaluate a specific physical area of your venue (such as the Main Dining Room vs. the Patio).
Employees: View category sales and tender collections attributable entirely to specific staff profiles.
Need Help? π‘
Why is my report starting on Monday when I want it to start on Sunday?
The report adapts automatically to your restaurant's baseline accounting configurations. To change the master week-start day for your venue, have an administrator navigate to Configuration > Venue Settings > General Settings to adjust your accounting week calendar.
Can I look up a specific customer check directly from this screen?
The Sales by Day report is an analytical summary built for finding macro-level weekly trends. If you need to track down a single order or look into an individual guest check, pull up our transaction-level Order Report instead!
Do you want to focus on a particular sales category trend next, or should we look into setting up your custom revenue centers?