Instructions
A five-step quick start, a worked €20 sale priced out on every platform so you can check the maths yourself, a plain-English VAT and merchant-of-record explainer, and a payout troubleshooting example. Read it once and you are done.
Spreadsheet template
Digital Product Sales Tracker
You made €1,000 in sales. How much did you actually keep? This spreadsheet answers that in five seconds, because every platform's fee chain is already built into it — Gumroad direct and Discover, Etsy, Payhip, Ko-fi Shop and Lemon Squeezy.
€12 one-off · .xlsx · not on sale yet
Checkout opens shortlyEmail support@vendwright.com to be told when this template goes on sale.
See what is inside
Excel 2016+
Google Sheets
LibreOffice Calc
No macros
The problem it solves
Most sales trackers ask you to type in your own fee percentage. Most sellers then guess — and the guess is usually one number applied to every platform, which is never how the fees actually work. Gumroad takes a percentage and a fixed amount. Etsy charges you three separate times on one order. A sale Gumroad found for you through Discover costs a flat 30%; the same sale through your own link costs 10% plus a fixed fee plus card processing.
This tracker ships with those chains already written down in an editable table. You log the order, choose the platform from a dropdown, and the fee and the true net appear on that row — correct from the first sale you enter, without you looking up a single rate.
Everything downstream then works: monthly net by platform, net per product, refund rate, expenses, and profit that is actually profit rather than gross revenue with a nice chart on it.
Who it is for
- You sell digital products — templates, presets, printables, e-books, courses — on more than one platform.
- You have somewhere between a handful and a few hundred sales a month, and a spreadsheet is still the right size of tool.
- You want one number at the end of the year that your accountant or your tax return can use.
- You are comfortable typing into a spreadsheet. There is nothing to install and no account to create.
Who it is not for
If you need automatic imports from platform APIs, multi-currency bookkeeping with live exchange rates, or double-entry accounts, this is the wrong tool and you should buy proper accounting software instead. This is a spreadsheet you type into.
What is inside, tab by tab
Five tabs. The first one tells you how to use the other four.
Products & Fees
The editable fee table: Gumroad direct, Gumroad Discover, Etsy, Payhip, Ko-fi Shop, Lemon Squeezy, direct Stripe, and a spare row for anything else. Percentage fee, fixed fee, processing percentage and processing fixed fee are separate yellow cells. Below it, your product list, which feeds the dropdown on the Sales tab.
Sales
One row per order, 1,000 rows of capacity, formulas pre-filled to the last row. Date, platform, product, quantity and unit price are yours to type; platform fee, net, net after refunds and the month key are formulas that read the fee table live. Mark a row refunded and it drops out of net revenue but still counts towards your refund rate.
Payouts & Expenses
Enter each deposit with its period, and the sheet compares it against what your sales log says you were owed — green inside a euro, amber for a small gap, red for a real one. Underneath, a categorised expense list so the profit figure has your costs taken out of it.
Dashboard
Nothing to type. Net by month and platform as a table and a stacked chart, a product ranking by net revenue with average net per unit, this month's net, year-to-date net, expenses, profit, and refund rate as headline figures.
Twelve months of sample data
The file arrives filled with a fictional template shop growing from about €240 to about €1,850 a month, including a chargeback, a refund and one deliberately mismatched payout, so you can see every feature working before you trust it. Clearing it takes about two minutes and the Instructions tab tells you exactly which rows to delete.
What it looks like
Screenshots of the actual file, sample data and all. Open one in a new tab to see it full size.
Specifications
| Format | One .xlsx file, roughly 130 KB |
|---|---|
| Works in | Microsoft Excel 2016 or newer (Windows, Mac, Microsoft 365), Google Sheets, LibreOffice Calc |
| Macros | None. No VBA, no scripts, no add-ons, no permission prompts |
| Tabs | Five: Instructions, Products & Fees, Sales, Payouts & Expenses, Dashboard |
| Capacity | 1,000 sale rows with formulas pre-filled, 30 payout rows, 100 expense rows |
| Platforms covered | Gumroad direct, Gumroad Discover, Etsy, Payhip, Ko-fi Shop, Lemon Squeezy, direct Stripe, plus a spare row you can name yourself |
| Currency | Formatted in euros out of the box. Change the cell format to any single currency you like; it does not convert between currencies |
| Fee rates | Shipped accurate as of August 2026 and dated on the sheet. When a platform changes its pricing you edit one yellow cell |
| Delivery | Not on sale yet. When checkout opens: instant download after payment. No account, no subscription, no email course |
| Licence | For your own business. Do not resell or redistribute the file |
| Updates | None promised. The file is yours as it is on the day you buy it, and it keeps working whether or not we touch it again |
Questions worth asking first
Does it connect to Gumroad, Etsy or Payhip automatically?
No. You type your sales in, or paste them from a platform export. There is no API connection, no sync and no login. That is the honest trade for a file that costs €12, has no subscription, and will still open in ten years.
What happens when a platform changes its fees?
You open the Products & Fees tab and edit the yellow cells for that platform. Every row on the Sales tab recalculates, including rows you entered before the change — so if you want history to stay accurate at the old rate, add a new platform row instead of editing the old one. The rates in the file were correct in August 2026 and are dated on the sheet, but no spreadsheet updates itself, and you should check them against the platform's own pricing page. Our free platform fee calculator keeps a dated fee table you can copy from.
Does it handle VAT or sales tax?
Not as a calculation, no. It records what you were paid and what the platform took. The Instructions tab explains who is the merchant of record on each platform and therefore who is remitting VAT on your sales, which is the question most sellers actually need answered — but it does not produce a VAT return, and it is not tax advice.
Will it work in Google Sheets?
Yes. Upload the file to Drive and open it with Sheets. The formulas, dropdowns and conditional formatting all carry over. The two charts are rebuilt by Google on import and sometimes lose their colours; the Instructions tab has a short section on what to expect in Sheets and LibreOffice.
Can I use it for physical products too?
Partly. The fee maths is built around a percentage plus a fixed fee, which describes most marketplaces, so an Etsy print-on-demand order will calculate correctly. But there is no cost-of-goods, shipping or stock column, so the "net" it shows you is net of fees, not net of what the item cost you to make. If you sell physical goods, you want a different tool.
Is there sample data, and can I get rid of it?
There is, and yes. Twelve months of a fictional shop, clearly marked, in rows 4 to 516 of the Sales tab plus the payout and expense lists. The Instructions tab tells you which ranges to select and delete. Two minutes, and none of the formulas break.
How many sales can it hold?
1,000 rows with formulas already in place. You can drag them further down if you outgrow that, but at a few thousand rows a month a spreadsheet is the wrong answer and you would be better served by real bookkeeping software.
Does it do multiple currencies?
No. It works in one currency, formatted as euros by default and changeable to any other. If you are paid in dollars and euros, the honest options are to keep one copy per currency, or to convert each payout as you enter it. Live exchange rates are outside what a plain spreadsheet should promise.
Is it protected or locked?
No password, no protected ranges, no hidden sheets. Every formula is visible and editable. If you want to add a column, add one.
What if it is not right for me?
It is a digital download, so read this page and the screenshots first — they show the real file. If it does not open, or does not do what this page says it does, email support@vendwright.com. Our refund policy is the current word on this.
Digital Product Sales Tracker
One file, €12, no subscription. Every fee chain built in, twelve months of sample data to learn from, and 1,000 rows waiting for your own.
Checkout opens shortlyEmail support@vendwright.com to be told when this template goes on sale.
Try the free fee calculator