Sales by Staff
Report for Shopify

A report designed for quick analysis of sales attributed to each staff member across all POS locations, with details from gross sales to net sales calculations.

Star

5 from 1,800+ merchants

2,000+ data fields

Trusted by 40,000+ Shopify stores

Updated June 2026

What this report is
The Retail Sales by Staff (Attributed to Sale) Report is a Shopify POS report that credits sales to the staff member who helped the customer — for a whole order or per line item — with net sales, average order value, and attribution coverage per associate. Report Pundit provides it as a free pre-built template with staff-shareable links, scheduling, and exports to Google Sheets, Excel, CSV, or PDF.
Report type
POS staff sales attribution
Best for
Retail managers, commission, staff coaching
Refresh
On run or schedule (POS data ~1–5 min)
Setup time
~5 minutes
Tracks
Net sales, AOV, attribution by helping staff member
Export to
Google Sheets, Excel, CSV, PDF
Scheduling
Yes
Shopify plan
All plans; attribution needs Shopify POS Pro
Keep up with Shopify reports
We promise we won’t spam you.
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.

Why this report matters

On a retail floor, the person who closes the sale isn’t always the person who rings it up. Credit the wrong one and commission gets unfair fast — and nothing erodes a sales team’s trust quicker than a payout that doesn’t match the effort.

Shopify’s “attributed to sale” data captures who actually helped, down to individual line items, but it requires POS Pro and the native report can’t be scheduled or safely shared with staff to verify their own numbers.

A staff-attribution report credits the helping associate — by order or line item — with net sales, AOV, and how much of their activity was attributed at all. That’s the fair basis for commission, the input for coaching, and, with shareable links, something each associate can check without admin access.

What’s included

Never just a list of column names. Every column gets a plain definition, plus a formula, a worked example, or a heads-up wherever it earns one.

Attribution

Staff (attributed)

The associate credited with helping on the sale — not necessarily who operated the register.

Heads up:  Attribution can be set per full order or per line item, and configuring it (manual or automatic) requires Shopify POS Pro. [verify]

Attribution coverage

The share of the staff member’s sales that were actually attributed.

Formula:  Coverage = Attributed sales ÷ Total sales × 100

Heads up:  Low coverage means missed credit; if a chunk is unattributed, fix the floor process before paying commission on it.

Performance

Orders & units

Transactions and items credited to the associate.

Gross & net sales

Sales credited to the associate, before and after discounts and returns.

Formula:  Net sales = Gross − Discounts − Returns

Average order value

Basket size per associate — a fair, normalized performance measure.

Formula:  AOV = Net sales ÷ Orders

Example:  Two associates at equal sales but different AOV sell very differently — one upsells, one drives traffic.

Items per order

How effectively the associate attaches add-ons.

Formula:  Items per order = Units ÷ Orders

Context

Location

The store the attributed sales occurred at, for multi-store roll-ups.

Refunds / discounts processed

Returns and discounts tied to the associate, for a complete picture.

Heads up:  Retail reports cover POS-location sales only; online orders aren’t included here.

Common added columns

Who uses this report

01

Retail manager

Situation
You run a commissioned sales floor.
Look at
Net sales and AOV by attributed staff, with coverage.
Decision
Pay commission on credited sales and coach the low-attach associates.
02

Store owner / HR

Situation
You’re reviewing performance fairly.
Look at
AOV and items-per-order by associate, not just totals.
Decision
Recognize genuine selling skill, not just who happened to be at the till.
03

Sales associate

Situation
You want to check your own numbers.
Look at
A shared, filtered view of your attributed sales.
Decision
Verify your credited sales without needing admin access.
04

Operations

Situation
Attribution looks patchy.
Look at
Attribution coverage across the team.
Decision
Tighten the floor process (manual or auto attribution) so credit is complete.

How to read the report

  • Check coverage before paying. Unattributed sales mean missed credit; low coverage is a process fix, not a performance verdict.
  • Read AOV and attach rate, not totals. Who’s on shift longest will top raw sales; AOV and items-per-order reveal who actually sells.
  • Separate helped from rang-up. This credits who helped; the ‘at register’ reports credit who processed — use the right one for the right question.
  • Share, don’t expose. Give each associate a filtered link to their own numbers rather than admin access to everyone’s.

How to build the report in Report Pundit

Under 5 minutes from install to insight. No code, no SQL.
  1. Confirm Shopify POS Pro and sales attribution are enabled so the “attributed to sale” data is captured. [verify]
  2. Open Report Pundit in your Shopify admin and choose Create Report (or the pre-built “Retail Sales by Staff (Attributed)” template).
  3. Set the data source to Retail / POS sales, grouped by Attributed staff.
  4. Add columns: Location, Orders, Units, Gross sales, Net sales.
  5. Add calculated AOV, Items-per-order, and Attribution-coverage columns.
  6. Add Refunds/discounts processed for a complete view.
  7. Set the date range to your performance or payout period and run.
  8. Confirm attribution coverage looks reasonable, then Save.
  9. Use User Management to share each associate a filtered link, and schedule a manager summary.

Sample report

What you'll see when you run the report. Fully interactive in your store — click any channel to drill into orders, customers,or products.

Customization & filters

The pre-built version covers 90% of merchant needs. For the remaining 10%, common customizations:
  • Attribute by full order or by line item.
  • Filter to one location, one associate, or a pay period.
  • Add a commission calculation as a calculated column.
  • Share a filtered, password-protected view per associate.
  • Compare attributed (helped) vs at-register (processed) side by side.

Automate & export

Once the report is set up the way you want it, automation does the rest:
  • Schedules — hourly, daily, weekly, monthly, or custom cron
  • Delivery formats — Excel, CSV, PDF, or push to Google Sheets in real time
  • Group by month or week — trends instead of a static snapshot
  • Destinations — email (multiple recipients), Google Sheets, Google Drive, FTP/SFTP, Looker Studio, BigQuery
  • Conditional alerts — get notified only if a channel's net sales drop more than X% week-over-week

Report Pundit vs Shopify's native Sales by Channel report

Shopify ships a basic version. Here's where it stops — and what Report Pundit adds.
Capability Shopify built-in Report Pundit
Credit the staff who helped (attributed) POS Pro only ✓ Any plan to report [verify]
Line-item-level attribution POS Pro
Attribution coverage metric × ✓ Calculated
Share each associate their own numbers × ✓ User management
Available on every Shopify plan POS Pro + Shopify plan & up ✓ Any plan, incl. free
Scheduled email / Slack delivery × ✓ Daily, weekly, multiple/day
Share a filtered view with staff (no admin) × ✓ User management & links
Export to Google Sheets in real time × (manual CSV only) ✓ Live sync
Add custom / calculated columns × ✓ 2,000+ fields
Multi-store reporting (Plus) ×

Frequently Asked Questions

What’s the difference between ‘attributed to sale’ and ‘at register’?

“Attributed to sale” credits the associate who actually helped the customer — even per line item. “At register” credits whoever processed the payment. They’re often different people; use attributed for commission and coaching.

Do I need Shopify POS Pro?

Attribution itself — capturing who helped, especially at line-item level and configuring manual vs automatic — requires POS Pro. Report Pundit then reports and schedules that data on any plan tier. [verify against your POS plan]

Can staff see only their own sales?

Yes. With User Management you share each associate a filtered, password-protected link to their own attributed sales — no admin access to everyone else’s numbers.

Report Not Found
Let's create it!
Your request is in! Check out all reports with the button below.
* Error. Please input correct email

Benefits

Spot Top Performers

Spot Top Performers

Assess individual staff contributions, identify top performers and areas for improvement across POS locations.
Sales Breakdown

Sales Breakdown

Provides a clear breakdown from gross to net sales, enabling transparency in sales calculations.
Get Staff Performance

Get Staff Performance

Enables data-driven decisions on staffing levels and resource allocation by analyzing staff performance in relation to sales outcomes.

Sales by Variant

Gain detailed insights into each product variant's performance with the Sales by Variant Report. Beyond basic sales data, it shows how each variant impacts your store's success. Use it to fine-tune inventory management and identify popular options, helping you make strategic decisions to boost your bottom line.

Sales by Device ID

The report displays sales data segmented by device type, such as mobile, desktop, or tablet, allowing merchants to analyze performance based on customer device usage.

Sales by Customer

The Sales by Customer Report provides Shopify merchants with valuable insights into customer purchasing behavior. This report breaks down sales by individual customers, highlighting the most valuable and active customers.

Sales by Product

The Sales by Product report offers details about each product’s sales performance over a given time frame. It provides valuable insights into which of your products are and aren’t selling well. These insights will enable you to make informed decisions about inventory management and marketing and improve your business.

Sales by Checkout Currency

This report displays the breakdown of your sales by customer currency used at the checkout with the total sales value also being displayed in your local currency.

Completed Draft Order

This report provides insights into finalized draft orders, displaying detailed information on converted orders, including product details, pricing, and customer data for analysis.

Sales by Fulfillment Location

Data reported to analyze sales based on order fulfillment locations for any specified date range, including product quantity sold and corresponding sales value.

Order Tags and Line Item Properties

A detailed report built to include order tags and line items added to each placed order, along with essential sales and product details for thorough analysis and processing.

Weekly Sales Pattern

Your true day-of-week rhythm — which days and hours actually sell — so you staff, schedule ads, and send emails when buyers are buying.

Sales by Billing Location

The Sales by Billing Location report in Shopify provides a detailed breakdown of sales based on the billing addresses of your customers. This report categorizes sales data of your customer base by country, region, or city.

Sales by Channel

The Sales by Channel report displays sales data based on the source of each sale. It's a valuable report offering insights into multichannel Shopify selling.

Sales Over Time

Leverage historical data with the Sales Over Time Report. This report covers costs, order details, sales channels, and payment methods, helping you track trends, manage sales tax returns, and assess the effectiveness of each sales channel.

Refund

Report Pundit’s Refund Report records the details of money returned by a Shopify merchant to unsatisfied customers when they return the product/service. These reports help the merchant keep track of the refunds issued, monitor customer satisfaction and have a proper record of financial transactions for filing taxes.

Sales by Vendor

The Sales by Vendor report analyzes how each vendor's products contribute to your store's success. By examining sales, purchase costs, and profitability, this report provides insights to make strategic decisions, maximize profits, and optimize inventory management based on vendor performance.

Finance Summary

The Finance Summary Report provides an overview of your store’s financial performance by aggregating key revenue, expense, and tax data. This report helps store owners understand their overall profitability, cash flow, and key cost drivers, making it essential for budgeting and financial planning

Commission

The Commission Report is the key to rewarding store staff and affiliates for sales they generate. It provides an overview of their sales performance along with calculated commissions share.

Last 24 Hours Orders

Use the Last 24 Hours Orders report to stay updated on all orders placed within the past day. It provides critical insights into sales trends, customer transactions, and order statuses, allowing you to monitor your store's recent activity and make informed business decisions.

Detailed Sales

The full-detail sales export — every line with channel, payment, tax, cost, and margin — built for deep analysis and your data warehouse.

Sales by Collections

The Sales by Collections report provides a detailed view of your product sales, inventory costs, and profitability by collection, helping you see which collections drive revenue and how they resonate with your audience, allowing you to tailor your product strategies accordingly.

Order vs Return (Monthly)

A report interpreting monthly returns by comparing the total sales value with the sales value of returned orders, including percentage calculations for both return orders and return value.

Sales by POS

The report provides detailed sales figures and net product counts, accounting for refunds, at each POS location, offering a clear view of actual sales performance and inventory movement.

Sales by Discount Code

Sales by Discount Code report in Report Pundit provides a detailed analysis of sales generated through specific discount codes over a defined period.

Last 30 days Sales Summary

A report that provides a comprehensive overview of sales performance over the past 30 days, including total revenue, order count, average order value, and product-specific sales trends for detailed analysis.

Build and automate your Shopify Reporting

Unlock the full potential of your Shopify store with Report Pundit. Gain access to over 2000 data fields, automate reports, and make data-backed decisions to grow your business.