Commission Report for Shopify
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.
5 from 1,800+ merchants
2,000+ data fields
Trusted by 40,000+ Shopify stores
Updated June 2026
.png)
.png)
.svg)
.svg)
.svg)
Why this report matters
Commission is one of the most error-prone numbers a store calculates, and Shopify gives you nothing for it. Managers export sales, attribute them by hand, apply a rate in a spreadsheet, and hope no one was missed before payday.
That manual process breaks the moment rates vary — a different percentage by product, a tier above a threshold, a separate affiliate rate. One wrong formula and someone’s paycheck is wrong, which is exactly the kind of error that erodes trust on a sales floor.
A commission report attributes each sale to a seller and applies your rules automatically, so payout is a report you run, not a spreadsheet you rebuild. Because it’s driven by calculated fields, it flexes to whatever your commission scheme actually is.
What’s included
Seller (staff / vendor / affiliate)
Who the sale is credited to — a POS staff member, a vendor, or an affiliate code.
Heads up: Attribution depends on clean data: staff sign-ins at POS, the vendor field, or an affiliate/discount code. Shared logins or blank fields break the credit.
Order & date
The order the commission is calculated on and its date, for the payout period.
Sales basis
Commissionable sales
The sales figure commission is calculated on — your choice of gross, net, or net of refunds.
Formula: Commissionable = Net sales (or your defined basis)
Heads up: Decide up front whether commission is paid on gross or net, and whether refunds claw back — it materially changes the payout.
Units
Quantity sold by the seller, for per-unit commission schemes.
Commission
Commission rate
The percentage (or tier) applied — fixed, per-product, or threshold-based.
Example: 8% on net sales; 10% above a $10k monthly threshold.
Commission amount
The calculated payout owed to the seller.
Formula: Commission = Commissionable sales × Rate (per tier)
Example: $12,500 net × 8% = $1,000 commission.
Who uses this report
Retail manager
Finance / payroll
Affiliate / partner manager
Owner
How to read the report
- Confirm the basis first. Gross vs net vs net-of-refunds changes every number below it; agree the basis before reading the payout.
- Check attribution coverage. Unattributed sales mean missed credit; if a chunk has no seller, fix sign-ins or the source field before paying.
- Read tiers at the boundary. Sellers near a threshold are the ones to sanity-check — a few dollars can flip them into a higher rate.
- Treat refunds deliberately. If refunds claw back commission, a late return can reduce a payout after it was earned; make the rule explicit.
How to build the report in Report Pundit
- Open Report Pundit in your Shopify admin and choose Create Report (or the pre-built “Commission Report” template).
- Set the data source to Sales / Orders and confirm how sellers are attributed (staff, vendor, or affiliate/discount code).
- Group the report by Seller.
- Add columns: Orders, Units, and your Commissionable sales basis (gross, net, or net of refunds).
- Add a calculated Commission rate field — fixed, per-product, or tiered with a threshold condition.
- Add a calculated Commission amount column (commissionable × rate).
- Set the date range to your payout period and decide whether refunds claw back commission.
- Run, reconcile one seller’s commission by hand once to validate the formula, and Save.
- Schedule it to run at the close of each payout cycle and deliver to finance and managers.
Sample report
Customization & filters
- Set fixed, per-product, or tiered/threshold commission rates.
- Choose the basis: gross, net, or net of refunds.
- Attribute by staff, vendor, or affiliate/discount code.
- Add a clawback rule so refunds reduce commission.
- Group by seller then product to show what each sale was on.
Automate & export
- 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
Frequently Asked Questions
No. Shopify has no native commission report, so most stores calculate it by hand in a spreadsheet. Report Pundit builds it with calculated fields that apply your own rules automatically.
Yes. Commission can be a flat percentage, vary by product, or step up past a threshold — the calculated rate field models whatever scheme you run.
Staff (via POS sign-in), vendors (via the product vendor field), or affiliates (via a discount/affiliate code). Attribution is only as clean as that underlying data.
Benefits
Commission by Time
Boosts Morale
Optimize Strategies
Related Reports
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.
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 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.
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.
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.
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 Staff
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.
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.
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
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 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 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 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 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.
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 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.
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.
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.