A P&L by day, week or month, plus a custom pivot that groups profit by product, product type, vendor, country or sales channel.
How it helps
Most pivot tables start with a sales export and end in a spreadsheet you rebuild every month. The Shopify pivot table report in Profitario does the same cut with costs already included, so every cell can show net profit.
Revenue, refunds, each cost and net profit as rows, periods as columns, with subtotals on every level. Switch to weeks for a weekly profit report or to months for a monthly P&L, and the table rebuilds without a formula.
Put product, product type, vendor, country or sales channel in rows and columns. Shopify can show gross profit per location; this view adds shipping, fees and ad spend, so you see profit by product, by vendor and by country at net margin.
Ad spend per platform and account, expenses by category per month, disputes and taxes each get their own row. A cost that grows month after month stands out next to revenue.
Features
Loading 0%
P&L report
Revenue, refunds, every cost and net profit as rows, days, weeks or months as columns. Switch the period and the table rebuilds.
Rows: vendor · Columns: month
Choose what goes into rows and columns: product, product type, vendor, country or sales channel.
Days roll into weeks
Days roll into weeks, weeks into months, months into years, with subtotals on every level.
Share of total costs by month
Ad spend per platform and account, expenses per category, disputes and taxes, each on its own row.
Net margin by weekday
Pivot: weekdays by month
Sundays run at 31% margin against 22% on other days, every month since April.
In the report: Weekdays as rows, months as columns
Example: net margin by weekday, April to October.
Questions it answers
01 · You ask
Why it matters: Monthly totals hide the weeks that went wrong. Weekly profit shows when a change in pricing, ads or costs started to matter.
The report shows
Net profit per week as columns, with the quarter total at the end.
You act
Compare each week with its neighbours and look for the week where costs jumped, not just where revenue dropped.
Rows: measure · Columns: week
02 · You ask
Why it matters: Vendors with similar sales can leave very different margins. Knowing which one earns more guides what to reorder and what to renegotiate.
The report shows
Vendors as rows with revenue, costs and margin.
You act
Reorder more from the vendor with the best margin and renegotiate with the weakest.
Rows: vendor · Value: gross margin, Q3
Costs $7.4k
Costs $13.6k
Costs $6.8k
Costs $15.3k
03 · You ask
Why it matters: Shipping, duties and fees differ by country, so a country with strong sales can still lose money. Profit by country shows where to grow and where to raise prices.
The report shows
Countries as rows, months as columns, net profit as the value.
You act
If a country keeps a thin margin, adjust its shipping price or stop advertising there.
Rows: country · Columns: month · Value: net profit
04 · You ask
Why it matters: Fixed expenses creep up through new apps and services. Seeing each category per month shows which ones grow faster than revenue.
The report shows
Each expense category as a row, months as columns.
You act
Bring the table to the monthly review instead of rebuilding it in a spreadsheet.
Rows: category · Columns: month
Common questions
Help center
Operating expenses lower your Net Profit. This guide shows the row or report that holds them on each page.
Read articleCosts and expensesEvery operating expense has a category. It decides where the expense is grouped in the Expense Report and in your reports. These categories are built in.
Read articleCosts and expensesCost zones let a product cost a different amount depending on the country an order ships to. Use them when you fulfil from more than one place, for example…
Read articleCosts and expensesCost coverage tells you how much of your business already has a product cost. An order without a product cost shows too much profit, so the goal is to cover…
Read articleSettingsProfit rules decide, per payment status of an order, whether its revenue counts and which of its costs are deducted. Most stores keep the defaults.
Read articleNo credit card required. Free plan available forever.
By clicking "Accept All", you consent to our use of cookies.
Learn more