Home / Templates / Multi-Channel Profit & SKU Tracker
Free template · 2026

Multi-Channel Profit & SKU Reconciliation Tracker

If you sell on Amazon, Shopify, and Etsy, you know revenue but rarely true profit — each channel nets out fees its own way, and the payout never quite matches the orders. Log your orders once and this template shows profit per SKU after fees and COGS, and reconciles each channel's payout. Built for Excel and Google Sheets, free to download.

↓ Download the template .xlsx · Excel & Google Sheets No signup. Free to edit and reuse.

What's inside

Orders

One row per order line: date, channel, order ID, SKU, quantity, gross revenue, channel fees, refunds. Drop-downs for channel and SKU keep entries clean. Unit cost, COGS, net payout, net profit, and margin fill in automatically.

COGS

List every SKU and its unit cost once. The Orders sheet looks up each cost from here, so profit reflects what the product actually costs you.

Profit by SKU

Units, revenue, fees, refunds, COGS, net profit, and margin per SKU across every channel — so the loss-makers stop hiding inside a healthy top line.

Channel Reconciliation

Computed net payout per channel next to the actual deposit you enter. The Difference column flags where a payout doesn't match your orders.

Once it fills up, just ask it questions

A tracker answers "what's my profit by SKU." For the follow-up — "which SKU lost money after fees last month, and on which channel?" — you can upload the same file to Quiriz and ask in plain English, no new formulas. Free to try.

Ask your spreadsheet a question →

How to use it

  1. Download and open it in Excel, or import it into Google Sheets (File → Import → Upload).
  2. Fill in the COGS sheet with every SKU you sell and its unit cost.
  3. Log each order line on the Orders sheet: pick the channel and SKU from the drop-downs, then enter gross revenue, channel fees, and refunds. The profit columns calculate themselves.
  4. Reconcile the payouts. On the Channel Reconciliation sheet, enter each channel's actual deposit. The Difference column flags anything that doesn't line up.

Frequently asked questions

How do I use the multi-channel profit tracker template?
Download the file and open it in Excel or import it into Google Sheets. On the COGS sheet, list every SKU and its unit cost. On the Orders sheet, log one row per order line: pick the channel and SKU from the drop-downs and enter gross revenue, channel fees, and refunds. The Profit by SKU and Channel Reconciliation sheets update automatically.
How does it calculate true profit per SKU?
For each order line it computes Net Payout as gross revenue minus channel fees minus refunds, then subtracts COGS (unit cost × quantity) to get Net Profit. The Profit by SKU sheet sums those with SUMIF, so you see units, revenue, fees, COGS, net profit, and margin for every product across all channels.
What does the channel reconciliation do?
The Channel Reconciliation sheet totals the net payout your orders should produce for each channel, next to the actual payout you enter from that channel's deposit. The Difference column flags any gap, so you can catch fees, refunds, or missing orders that make a payout not line up with your sales.
Does this template work in Google Sheets?
Yes. The file is a standard .xlsx. In Google Sheets, choose File → Import → Upload and select the file. The SUMIF, COUNTIF, and INDEX/MATCH formulas work the same way in Google Sheets as in Excel.

Related: inventory & reorder tracker · profit & loss tracker.