1. Your Shopify files
Transactions: Shopify admin → Finances (or Settings → Payments) → Shopify Payments → Transactions → Export (columns “Transaction Date”, “Type”, “Order”, “Card Brand”, “Card Source”, “Payout Status”, “Amount”, “Fee”, “Net”, …). Orders (optional, for per-product profit and discount codes): Orders → Export → CSV for Excel, Numbers, or other spreadsheet programs.
Choose a transactions file or paste its text, then click Analyze. You can type costs in the table afterwards.
Result
Where the money goes
| Line | Amount | % of charges |
|---|
Effective fee rate by card
| Card · source | Charges | Amount | Fees | Rate |
|---|
By payment method name
| Payment method | Charges | Amount | Fees | Rate |
|---|
Profit by product
Sorted by sales after discount. Type a unit cost to fill in profit; figures update as you type. Net includes shipping customers paid you, and excludes sales tax the Orders export reports; shipping you pay is not in either file.
| Product | Units | In refunded orders | Sales after discount | Fees | Refunds and disputes | Net to bank | Unit cost | Profit | Margin |
|---|
Discount codes
| Code | Orders | Discount given | % of product sales | Share of all discounts | Net to bank per order |
|---|
Net to bank per order
| Order | Charged | Fees | Refunded | Disputed | Net to bank | % of charge |
|---|
By month
| Month | Charges | Fees | Refunds | Disputes | Adjustments and other | Net |
|---|
The model, and what it leaves out
- Every transaction row lands in one line: charges, processing fees, third-party gateway fees, refunds, chargebacks, dispute fees, adjustments, other. A row's Net is split into its amount and its fee, so the lines always add up to the sum of the Net column. Payout rows only move money already counted, so they are excluded and shown as “paid out”. Row types the tool does not recognise go to “Other rows”; rows it cannot read are listed with line number and reason.
- Per order, net to bank is the charge less the fee, refunds, chargebacks and dispute fees on the same order name (#1001).
- Per product, each order's net (less the sales tax the Orders export reports, in proportion to what was not refunded) is split across its line items by their price after the order's discount. Fees not tied to an order stay at shop level.
- Profit is that amount minus unit cost × units, except that a fully refunded order returns its units to stock if the box is ticked.
- Not modelled: your time, shipping you pay, packaging, the Shopify plan and app fees, ad spend, income tax, currency effects on your bank account, partial refunds beyond the refunded amount, and orders paid through other gateways (their processor fees are not in the file).
Common questions
Can I see profit per product from my Shopify payouts without paying for an app?
Yes. In Shopify admin open Finances → Payments (Shopify Payments) → Transactions and export the CSV for the months you want, then export Orders as CSV for the same period. Drop both in here, type a cost per unit for each product, and the tool splits every order's net-to-bank across its line items. Nothing is uploaded and no app needs access to your store.
Why do I need two files?
The transactions export has every charge, fee, refund, dispute and payout but names orders, not products. The Orders export names the products and the discount code on each order. Joining them by order name (#1001) is what turns a shop-level fee total into profit per product. The transactions file on its own still gives the fee waterfall, net-to-bank per order and the effective fee rate by card.
What does “net to bank” mean here?
For each order it is everything that reached or left your Shopify balance because of it: the charge, less the processing fee, less any refund, less any chargeback and dispute fee. Payout rows are not counted, because they only move money that is already counted. The waterfall adds up to the same total as the sum of the Net column.
How are chargebacks and dispute fees handled?
A chargeback row takes the disputed amount out of the balance and carries a dispute fee. If you win, a reversal row returns the amount and usually not the fee. The tool shows the disputed amount and the fees separately, counts opened and won disputes, and warns when the share of orders disputed is high.
Where do unit costs come from?
You. Neither Shopify file knows what a product costs you to make or buy, or what you pay for shipping. Type a cost per unit next to each product, or paste lines like Merino Beanie - Charcoal,9.50 (a SKU works in place of the name). Products without a cost are left out of profit rather than counted as free.
What about orders paid with PayPal or another gateway?
They are not in a Shopify Payments transactions file, so their processor fees are missing. If they appear in your Orders export they are counted and listed, and if you enter a third-party transaction fee rate the tool shows an estimate of it separately. It is not added to the waterfall.
What does the tool not see?
Your time, shipping you pay, packaging, the Shopify plan fee and apps, ad spend, income tax, sales tax beyond what the Orders export reports, currency effects on your bank, and anything sold off Shopify. Rows Shopify files under types this tool does not know are shown as “other” so they are visible rather than lost.
Is this financial advice?
No. It applies arithmetic to the files you provide and does not replace your own records or a qualified accountant.