Analyze profitability and drill down to the order
Revenue tells you what sold. The Profitability Report tells you what you kept. It takes your sales and subtracts the cost of goods, the fees and other costs on each order, and the overheads you record as cost entries, then lets you slice the result by brand, supplier, channel, customer, product type, ship-to country, or any product attribute. Every row drills down to the individual orders, and every order down to its own profit and loss.
Before you begin
- You need access to the Profitability Report.
- For true margins, your products need costs, so that cost of goods is right. To include overheads such as marketing, software, or rent, record them under Insights → Cost Entries first.
Set up the report
-
Go to Insights → Reports and open Profitability Report.
-
Under Date Range, choose a preset such as Last 90 Days or Year to Date, or Custom for your own dates.
-
Under Group By, choose what each row stands for: Brand, SKU, Supplier, Sales Channel, Product Type, Sub Sales Channel, Country, Attribute, Customer, or Customer Tags.
-
Choose an Interval, such as Month, for the trend columns.
-
Under Metrics, pick the measures to show. Revenue, Cost, and Profit are on by default. You can add Margin, Units Sold, # of Orders, Gross Profit, Gross Margin %, Contribution Margin, and Contribution Margin %.

-
Optionally narrow or extend the report:
- Date basis, Channel type, Sales Channels, and Customers choose which sales count and when. See Filter by channel, channel type, or customer and Count sales on the day they ship.
- Limit to top/bottom performers shows only your best or worst rows.
- Include indirect costs subtracts the overheads you recorded as cost entries. Use Indirect Cost Type to include only one type.
- Compare adds the Previous period or the Prior year next to each number.
-
Click Generate Report.
Group by any product attribute
To slice margin by something that isn't a built-in option, such as color, size, or material, group by a product attribute.
-
Under Group By, choose Attribute.
-
In Group by attribute, pick the attribute. Each one shows how many products carry it.

-
Click Generate Report.
Each row is now one value of the attribute, such as Blue or Red, with its revenue, cost, profit, and margin. To group by customer segment instead, see Segment the Profitability report by customer tag.
Group by country
To compare the markets you sell into, group by where your orders ship.
- Under Group By, choose Country.
- Optionally set Interval to Year, so each country shows its total in a single column.
- Click Generate Report.
Each row is a ship-to country, shown by its two-letter code, such as US or CA. Every order counts toward the country it ships to. Orders with no shipping address are grouped under No Country.

Group by customer
To see which accounts make you money, group by the customer on each order.
- Under Group By, choose Customer.
- Click Generate Report.
Each row is one customer, shown by name, or by company when the customer has no name. Click the name to open the customer. Orders without a customer are grouped under No Customer. Two customers with the same name share one row.
Filter by channel, channel type, or customer
These filters sit in Filters & Configuration, and apply to every number on the page: the summary, both views, the order drilldown, and exports.
-
Under Channel type, choose All, Wholesale, or Retail.
Wholesale counts the B2B Customer Portal, EDI, NuORDER, Faire, and SPS Commerce channels, plus any channel you mark as wholesale. Retail is every other channel. The line below the buttons lists your wholesale channels.
-
To choose which of your own channels count as wholesale, click Wholesale channels. In the dialog, tick each channel whose orders are wholesale, such as an API channel that carries EDI retailer orders, and click Save. Built-in wholesale channels are marked (built-in) and can't be cleared. Saving needs the Sales Channels Edit permission (
sales_channels.update), and the change applies for everyone on your team. -
Under Sales Channels, pick one or more channels to include. Leave it empty for all sales channels. Each channel shows its integration, and Wholesale when it counts as wholesale.
-
Under Customers, type to search, and pick one or more customers. Leave it empty for all customers.
-
Click Generate Report.
The chips above the report show the channels and customers you filtered to.
With a channel type, sales channel, or customer filter on, the report leaves out indirect costs, and a notice above the report says so. Indirect costs are allocated to products, brands, and channels over a period, not to orders, so they can't be split by channel or customer.
Count sales on the day they ship
By default the report counts each order in full on the day it was placed. To see what you shipped in each week or month instead, such as wholesale orders that ship in several parts, change the date basis.
- Under Date basis, choose Ship date.
- Click Generate Report.
A By ship date chip appears above the report, and a notice explains the basis. Each shipment counts in the period it shipped:
- Revenue, discounts, and costs allocated to the line, such as fees, are split by the share of the line's units in each shipment.
- Cost of goods follows the FIFO cost each shipment used up.
- Quantity that hasn't shipped yet is left out, and so are cancelled and voided shipments.
- Orders with nothing shipped, such as an order for a fee only, don't appear.
Once every unit on a line has shipped, its ship-date figures add up to the same revenue and cost of goods as the order-date report. Indirect costs stay on their own period on either basis.
Choose Order date to go back to booked sales.
Show bundles as sold or as their components
A bundle has no stock of its own, so when it sells, SKU.io records the sale against the items inside it. When you group by SKU, a Bundles switch under Group By decides how those sales appear:
- As sold, the default: each bundle sale counts once, on the bundle's own SKU. Units Sold counts bundles, and the row's revenue and cost are those of the items inside it.
- As components: each bundle sale is split into the SKUs inside it, so an item's row includes the units that left inside bundles. Use it to see how many of each item you sold.

Amazon virtual bundles don't appear as bundle rows, because Amazon reports their sales as separate component lines. When you have linked virtual bundles, an Amazon virtual bundles link beside the switch opens their own page. See Track Amazon virtual bundle sales.
Click Generate Report after changing the switch. Clicking a bundle's row lists the orders that sold it. Your choice is kept in the page's address, so a bookmarked report opens the same way.

Read the margin ladder
Summary Metrics walks your revenue down to profit in three steps:
- Revenue, then minus cost of goods gives Gross Profit.
- Minus direct costs, such as fees and shipping, and the indirect costs allocated to these sales gives Contribution Margin.
- Minus indirect costs that weren't allocated to any product, brand, or channel gives Operating Profit. Click view entries to see those costs.
Below the ladder, the Revenue and Costs cards list what makes up each side. Click the ⓘ on any tile to see how that number is worked out.

Two views sit above the summary:
- Trend View shows each row's revenue, cost, and profit for every interval, with totals and margin, and a trend chart below.
- Cost Breakdown View shows each row's revenue, COGS, gross profit, each type of cost line (such as commission, shipping, or FBA fees), indirect costs, contribution margin, and CM %. Click the arrow beside Indirect Costs to split them by type, or Ad metrics to add ad spend columns.
Sort any column to rank the rows. Click Export CSV on either view to download its table as it appears on screen.
Export the report
To download the whole view with the settings it was generated with, use the Export menu.
-
Generate the report, and click Trend View or Cost Breakdown View.
-
Click Export beside the view tabs, and choose Excel (.xlsx) or CSV (.csv).
Trend View exports one row per group per interval, with each period's start date. Cost Breakdown View exports one row per group, plus a Total row.
-
Follow the export in the job tray, which downloads the file when it's ready.
The file uses the grouping, filters, and date basis the report was generated with, and the currency on screen.
Save the report as a view
To come back to a report, or share it with your team, save it as a view. For example, save "Wholesale shipped by week by customer": Customer grouping, Week interval, Wholesale channel type, and Ship date basis.
- Set up the report, and click Generate Report.
- Click Save as view on the views bar at the top of the page.
- Enter a Name and click Save view.
Next time, click the view's chip, and the report regenerates with those settings. For the views bar's other options, see Save and pin table views.
Drill down to the orders
-
Click a row, such as a brand.
Order Drilldown opens with that row's revenue, total cost, profit, and margin, and the orders behind them.

-
Change the period with the presets, or add columns such as COGS, Cost Allocated, or Discount with the Metrics chips.
-
Click an order's revenue, cost, profit, or margin to open its own profit and loss: product lines, financial lines such as fees and shipping, allocated indirect costs, and the order's contribution margin.
-
Click the order number to open the sales order itself.
Next steps
- Report wholesale sales and units shipped by week: build the same report in Custom Reports, or total shipped units from a Shipments export.
- Read the Contribution Margin report: margin after overheads, by product, brand, supplier, or channel.
- Segment the Profitability report by customer tag: margin by customer segment.
- Monitor daily financials and margin alerts: get told when an order sells at a loss.
Video transcript
Start from the sidebar on the left: open the Insights menu, and then select Reports. Scroll down the list, and choose the Profitability Report. Pick a date range, a grouping such as brand, and the metrics you want. To group by colour, size, or any attribute, choose Attribute, then pick the attribute. Generate the report. Revenue steps down to gross profit, contribution margin, and operating profit. Click a row to see the orders behind it, then click an order's numbers for its own profit and loss. Close the drilldown with its close button, scroll back to the top, and open the filters again. To compare the markets you sell into, group by Country. Then set the interval to Year, so each one shows its full total, and generate the report. Each row is one destination, and every order counts toward its own destination. Now scroll back to the top of the page, open the filters once more, and group by SKU. A Bundles switch appears. As sold, each bundle sale counts once, on the bundle's own SKU. To count what sold, add Units Sold to the metrics. Generate the report, scroll down to the table, and use its search box to find one of your bundles. It has its own row, with units counted in bundles. Its revenue is the total of its parts. To see the parts instead, scroll back up, open the filters, switch to As components, and then generate the report again. Then search the table for one of the products in that bundle. Its row now includes every unit sold in bundles, as well as on its own.