Shopify Commission Report

The Shopify Commission Report shows order sales alongside the commission owed, so you can calculate and pay staff, vendor, and affiliate payouts without a spreadsheet.

FIND IT ON THE
Shopify App Store
Book a Demo

Table of contents

-

What Is the Shopify Commission Report?

The Shopify Commission Report shows your order sales next to the commission owed on them, in one view. It is built for stores that pay commission to sales staff, partners, vendors, affiliates, or internal teams.

For the period you choose, it lists each order with its sales figures and a commission column, so the payout sits beside the sale it was earned on. Shopify has no native commission report, so most stores work this out by hand in a spreadsheet every pay cycle. This report does the calculation for you and can be saved, exported, and scheduled to run again on its own.

The one thing worth settling before you read it is which sales figure the commission is based on. The report shows Gross Sales, Net Sales, and Total Sales together, and the same order produces a different payout depending on which one you pay against.

Which Fields Are Included in the Shopify Commission Report?

These fields let you see each order, the sales behind it, and the commission owed.

Field What it shows
Date The date of the order the commission is calculated on.
Order Name The Shopify order reference, such as #1001, so each commission line traces back to a real order.
Order Count The number of orders in the row.
Gross Sales Product price multiplied by quantity sold, before discounts, returns, tax, and shipping.
Net Sales Gross Sales minus discounts and returns, still before tax and shipping.
Shipping The shipping amount charged on the orders.
Total Sales Gross Sales minus discounts and returns, plus tax and shipping. The widest sales figure Shopify reports.
Commission The commission amount for the row, based on the rate you apply to the sale.

You can adjust the pre-made report by adding, removing, or reordering columns so it matches how you pay.

Important Insights You Can Find in This Report

Which sales figure are you paying commission on?

Gross Sales, Net Sales, and Total Sales sit side by side in the report. Paying on Gross Sales rewards the sale before discounts and returns are taken out; paying on Net Sales rewards it after. Total Sales adds tax and shipping on top. Decide which figure the rate applies to before payday, because the same order pays out a different amount under each one.

Is the payout coming from many orders or a few large ones?

Read Order Count against the sales columns. A high commission total built on a small order count means a few large sales are driving it; the same total spread across many orders means steady, smaller sales. That difference tells you whether an incentive is rewarding volume or value, which matters when you set rates for the next period.

How much of a Total Sales payout is shipping rather than product?

If you calculate commission on Total Sales, shipping and tax are baked into the base. Compare Total Sales with Gross Sales to see how far apart they are. When the gap is wide, part of what you are paying out is riding on shipping, not on the goods the seller actually sold.

THE ANALYST'S READ

Watch the gap between Gross Sales and Net Sales for the same period. If you pay commission on Gross Sales but Net Sales is much lower, discounts and returns mean you are paying on money the store did not keep. When that gap is wide and recurring, it is worth moving the rate onto Net Sales before the next cycle.

How Can You Automate the Shopify Commission Report?

Open the pre-made Commission Report in Report Pundit. The columns are already set, so you press Save. To build it yourself, go to Custom Reports, add the fields above, set your date range, add a filter if you want to narrow it, and Save.

From there you can schedule it to email you daily, weekly, or monthly, and have it auto-send to your team, your VA, or your accountant on the same schedule. Export it as Excel, CSV, or PDF, or push it to Google Sheets or Google Drive so the numbers land where you already work.

Frequently Asked Questions

Does Shopify have a native commission report?

No. Shopify has no built-in commission report, so stores usually calculate it manually. This report shows the sales and the commission owed together.

Which sales figure is commission calculated on?

You choose. The report includes Gross Sales, Net Sales, and Total Sales, so you can apply the rate to whichever figure matches how you pay.

Who can I pay commission to with this report?

It works for sales staff, partners, vendors, affiliates, and internal teams. You apply the commission to the sales attributed to each one.

Can I change the fields in the report?

Yes. Add, remove, or reorder columns so the report matches the way you review payouts.

Can I schedule the Shopify Commission Report?

Yes. Set it to email daily, weekly, or monthly, and have it sent automatically to your team or accountant so you never rebuild it by hand.

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

Related Reports

Sales by Collections

See how each Shopify smart collection performs. The Sales by Collections report shows order count, net quantity, and total sales for every collection.

Sales Over Time

The Shopify Sales Over Time report groups revenue by date, one row per day, showing order count, gross sales, discounts, returns, net sales, tax, and total sales.

Finance Summary Report

A Shopify Finance Summary Report that breaks each order down from gross sales through discount, returns, net sales, shipping, tax, and total sales in one view.

Order vs Return (Monthly)

See Shopify orders vs returns by month with return order rate and return value rate, so you can spot a rising return trend before it quietly eats your margin.

Sales by Variant

See Shopify sales for every product variant that sold, with units, gross and net sales, discounts, returns, tax, and total sales grouped by SKU.

Detailed Sales Report

The Shopify Detailed Sales Report combines each order's sales, customer, product, tax, and fulfillment details into one row-level export you can filter and schedule.

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 Fulfillment Location

See which warehouse, store, or 3PL each Shopify order shipped from, with net units and total sales per fulfillment location for any date range.

Order Tags and Line Item Properties

See order tags, order notes, and line-item properties like engraving or gift messages beside product and sales detail on every Shopify order.

Order Report

A date-grouped Shopify order summary: order count, gross sales, discounts, returns, net sales, tax, duties, and total sales per period. Filter and schedule it

Sales by Product

See how each product in your Shopify store performs, with net quantity, gross sales, discounts, returns, and net sales together in one report.

Last 30 days Sales Summary

See your Shopify store's last 30 days of sales in one report: order count, gross and net sales, returns, tax, shipping, duties, fees, and total sales.

Sales by Discount Code

See how each Shopify discount code performs, with gross sales, discount, returns, and net sales per code, so you can tell which promotions earned back what they gave away.

Sales by Customer

The Shopify Sales by Customer report breaks revenue down per buyer, showing gross, net, and total sales and whether each is a first-time or returning customer.

Refund Report

See every returned item in your Shopify store for any date range, with each refund split into net, shipping, and tax returns for accurate reconciliation.

Weekly Sales Pattern

See Shopify net sales grouped by hour of day and day of week to find the recurring windows when customers actually buy, then time ads, emails, and staffing.

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 Channel

See how each Shopify sales channel, from Online Store and POS to connected marketplaces, contributes to revenue, with gross sales, discounts, returns, net, and total sales per channel.

Completed Draft Order

See which Shopify draft orders converted into paid sales, with gross sales, discounts, returns, net sales, duties, tax, and total sales for each one

Last 24 Hours Orders

See every order placed in the last 24 hours on Shopify, broken down by product, variant, and sales value in one rolling report that refreshes on its own.

Sales by Checkout Currency

See Shopify sales grouped by the currency customers paid in at checkout, with each currency's total converted to your store currency so the figures compare cleanly.

Sales by POS

The Shopify Sales by POS report breaks down in-store sales by point of sale location, showing net units sold and total sales for each retail store.

Sales by Vendor

The Shopify Sales by Vendor report groups sales by product vendor, showing net quantity, gross sales, discount, returns, net sales, tax, and total sales per supplier.

Sales by Staff

See Shopify POS sales by the staff member who rang up each order, split by date and location, with order count, gross, net, and total sales.

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 makedata-backed decisions to grow your business.

Start Free Trial
Book a Demo