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.
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.
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 get separate Commission Reports for each country or sales territory?
Yes. Report Pundit can filter the Commission Report by country and save each version as its own report, so every country or territory gets a separate report that can be scheduled, exported or shared. A territory can be set up as a group of countries.
To build one, add a Shipping Country or Billing Country column to the Commission Report, filter to the country or list of countries, and save it under a clear name such as “Commission Report: DACH”. Duplicate it for each territory and change the filter. Merchants with a store per region can also pick which connected shops a report covers with Select Multi-Store(s).
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.
Can I add the PO number to the Commission Report?
Yes. Report Pundit’s Commission Report can show a PO number as an extra column, as long as the number is stored on the order in Shopify, for example in the order note, a note attribute, or an order metafield. Save the report once and every run includes it.
To add it, open the report in the report designer. Use Add Columns for the order Note, or Custom Properties for Note Attributes or Order metafields. Select the key, name the column (for example “PO Number”), and save. Orders with no PO value show a blank cell