What Is the Shopify POS Sales by Register Report?
The Shopify POS Sales by Register report brings register-level sales into one export. It shows net sales, orders, average order value and refunds grouped by Device ID, so you can review the sales recorded against each register for a selected period.
Use the report to prepare a daily sales summary or compare registers over a longer period. Keeping the same reporting window makes it easier to see where order volume, sales value or refund amounts differ.
This is a sales review, not a complete cash-drawer reconciliation. Net sales alone cannot establish how much cash should be in a drawer; that requires payment and cash-session records.
Report Overview
- Reporting period
- A selected date range.
- Data included
- Device ID, net sales, orders, average order value and refunds.
- Best for
- Preparing register sales exports and reviewing daily or periodic register activity.
- Export formats
- Excel, CSV and PDF, plus delivery to Google Sheets.
- Automation
- Scheduled delivery, including a daily sales summary.
What Can You Learn from Register Sales?
1. Where recorded order volume is concentrated
Compare order counts across registers over the same period. Different operating hours can affect the totals.
Example: Hypothetical: Register A records 180 orders while Register B records 90.
What you can do: Check register schedules before adjusting coverage.
2. Which registers have different order values
Review average order value alongside order count. A higher average does not establish better staff performance.
Example: Hypothetical: One register has fewer orders but a higher average order value.
What you can do: Review the transactions behind the difference before changing sales targets.
3. Where refund amounts need a closer look
Compare refund amounts with each register’s sales activity. The summary identifies records to review; it does not explain why refunds occurred.
Example: Hypothetical: A register with modest sales shows a large refund amount.
What you can do: Check the underlying refund records and their dates.
What Should You Check First in This Report?
Make these checks before sharing the sales summary.
- Register identity: Match Device IDs to your internal register list so the team can identify each row.
- Reporting window: Use the same date range and time zone for every comparison.
- Sales definitions: Confirm how net sales and average order value are calculated.
- Refund timing: Check how refunds are dated and assigned before interpreting an unusual amount.
When Should You Use This Report?
| When to Use It | How It Helps |
|---|---|
| Preparing a daily register sales summary | Puts each register’s reported sales figures in one export for the store team. |
| Comparing order volume across registers | Shows differences in recorded order counts over a consistent period. |
| Reviewing average order values | Helps identify register totals that deserve a transaction-level review. |
| Investigating an unusual refund amount | Highlights the register grouping whose refund records need checking. |
| Building a weekly sales archive | Provides comparable exports when the same period settings and columns are retained. |
How to Create This Report in Data Export
Start with the premade Sales by Device ID report.
- Open Data Export in Shopify and look for Sales by Device ID in the premade reports.
- Open the report and check the register grouping and actual columns against the data you need.
- Choose the reporting period and review the available filters, time zone and refund treatment.
- Generate the report, match the Device IDs to your registers and save the export in your preferred available format.
- If needed, configure daily delivery after the reporting cutoff and review the first scheduled file.
Make the Most of This Report
Keep the export consistent and easy for your team to interpret.
01 / REGISTER LABELS
Keep a Device ID reference beside the export. Confirm how register changes affect identifiers before combining historical files.
02 / DAILY CUTOFF
Agree on one reporting cutoff and time zone. Schedule delivery after the period you want to review has ended.
03 / CONSISTENT COMPARISONS
Use the same columns and date settings for recurring exports. Check operating hours separately before comparing register totals.
04 / CASH CHECKS
Use payment and cash-session records for drawer checks. Do not treat net sales as expected cash in the drawer.
Frequently Asked Questions
What does register mean in this report?
In this report, a register is a Shopify POS device identified by its Device ID. Check the report scope if your store also records online sales against a device ID.
Can this report tell me whether a cash drawer balances?
The described fields cannot establish a drawer balance. You also need cash payments, opening cash, cash movements and the closing count.
Can I schedule a daily register sales export?
Yes. Schedule daily delivery, choose the destination, and set the reporting window and delivery time so each file covers the full day.
Does it show sales by staff member or location?
No. This report groups sales by register only. Use the Retail Sales by Staff at Register or Sales by POS reports for staff and location views.
Can I compare refunds across registers?
Yes. The report shows refund amounts by register. Check how refunds are attributed and dated; a higher amount alone does not establish an error or a staff issue.