Free spreadsheet template

Digital Product Sales Tracker, free

You made €1,000 in sales. How much did you keep? This spreadsheet answers that in five seconds, because every platform's fee chain is already written into it: Gumroad direct and Discover, Etsy, Payhip, Ko-fi Shop and Lemon Squeezy.

Free the whole file, not a sample · nothing to buy

The link starts the download. No email address, no account, no sign-up, no follow-up. The zip holds the .xlsx and a short readme telling you how to open it in Excel, Google Sheets or LibreOffice.

Free Excel 2016+ Google Sheets LibreOffice Calc No macros

The problem it solves

Most sales trackers ask you to type in your own fee percentage, so most sellers guess, and the guess is usually one number applied to every platform. Fees do not work like that. 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.

Those chains are already in the file, in a table you can edit. Log the order, pick the platform from a dropdown, and the fee and the true net appear on the row. Right from the first sale, without 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 want automatic imports from platform APIs, multi-currency bookkeeping at live exchange rates, or double-entry accounts, buy proper accounting software. 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.

Instructions

A five-step quick start, one €20 sale priced out on every platform so you can check the maths yourself, a plain-English explanation of VAT and merchant of record, and a worked payout mismatch. Read once, keep.

Products & Fees

The fee table, and it is yours to edit: Gumroad direct and Discover, Etsy, Payhip, Ko-fi Shop, Lemon Squeezy, direct Stripe, and a spare row for whatever else you sell on. Percentage, fixed fee, processing percentage and processing fixed fee each get their own yellow cell. Your product list sits underneath and feeds the dropdown on the Sales tab.

Sales

One row per order, 1,000 of them, formulas already filled to the last row. You type the date, platform, product, quantity and price. The fee, the net and the month are worked out from the fee table live. Mark a row refunded and it leaves net revenue but still counts towards your refund rate.

Payouts & Expenses

Enter each deposit with its period and the sheet checks it against what your sales log says you were owed: green inside a unit of your own currency, 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 here. Net by month and platform as a table and a stacked chart, products ranked by net revenue with the average net per unit, and headline figures for this month, the year to date, expenses, profit and refund rate.

Twelve months of sample data

The file arrives holding a fictional template shop growing from about €240 to about €1,850 a month, chargeback and refund included, plus one payout that deliberately does not reconcile so you can watch the flag fire. Clearing it takes about two minutes; the Instructions tab says which rows.

What it looks like

The actual file, sample data and all. Open one in a new tab for full size.

The Dashboard tab: headline figures for this month's net, year-to-date net, expenses, profit and refund rate, a net-revenue-by-month table split by platform, a stacked column chart of the same data, and a product ranking table and bar chart.
Dashboard. Headline figures, net by month and platform, and a product ranking. Everything here updates itself.
The Sales tab: one row per order with date, platform, product, quantity, gross per unit, gross total, platform fee, net, refunded flag, net after refunds, month key, country and notes. Refunded rows are struck through and shaded.
The sales log. Platform fee and net are formulas, and refunded rows strike themselves out.
The Payouts and Expenses tab: a payout reconciliation table comparing expected net against the amount actually received for each deposit, with the difference coloured green, amber or red, and an expense table below it with date, category, vendor and amount.
Payout reconciliation and expenses. The red row is the worked example the Instructions tab walks through.
The Products and Fees tab: an editable fee table with one row per platform and separate columns for percentage fee, fixed fee, processing percentage and processing fixed fee, with the editable cells shaded yellow, and a product list underneath.
The fee table. Yellow cells are yours to edit; the Sales tab reads them live.

Specifications

Everything worth knowing before you download it. It costs nothing either way, but if something here rules it out for you, better to find out now.
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 A dropdown on the Instructions tab (EUR, GBP, USD, CAD, AUD, CHF, SEK, NOK, DKK, PLN, NZD) or type your own symbol. Every money heading follows it and no cell has a currency baked into its number format. One currency at a time: it does not convert between them
Fee rates Shipped accurate as of August 2026 and dated on the sheet. When a platform changes its pricing you edit one yellow cell
Price Free. It is not sold anywhere, at any price
Delivery A direct download from this site, about 93 KB. No payment, no account, no email address, 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 download it, and it keeps working whether or not we touch it again

Questions worth asking first

Why is it free? What is the catch?

There is no catch, and there is no cut-down version you get charged for later. This is the whole workbook. We built it to sell, then went and looked at what the people already selling one were earning, and the answer was nothing worth building a business on. So it does a different job now: it is the thing that brings people to this site, some of whom will later want a template we do sell. That is the entire return we expect from it, and we would rather say so than pretend it is a gift.

What we are not doing is taking your email address for it. There is no list here to join, as the privacy page says, and a download that asks for nothing is cheaper for us to run than one that does.

Does it connect to Gumroad, Etsy or Payhip automatically?

No. You type your sales in, or paste them from a platform export. No API, no sync, no login. That is the trade for a file that costs nothing, 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. 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. It records what you were paid and what the platform took. The Instructions tab explains who the merchant of record is on each platform, and therefore who is remitting the VAT on your sales, which is the question most sellers actually need answered. 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 a percentage plus a fixed fee, which describes most marketplaces, so an Etsy print-on-demand order calculates correctly. There is no cost-of-goods, shipping or stock column though, so the "net" here is net of fees, not net of what the item cost you to make. Selling 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. Select those ranges and delete. Two minutes, and no formula breaks.

How many sales can it hold?

1,000 rows with the formulas already in place, and you can drag them further down. At a few thousand rows a month a spreadsheet is the wrong answer and real bookkeeping software is the right one.

Does it do multiple currencies?

Not at once. Picking the currency is a dropdown on the Instructions tab, eleven codes or your own symbol, and every heading in the workbook follows it. What it will not do is hold two at the same time. Paid in dollars and euros? Keep a copy per currency, or convert each payout as you enter it. Live exchange rates are more than 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?

Delete it. You paid nothing, so there is nothing to refund and nothing to cancel. The screenshots above are the real file, so you can mostly tell before you download. If it will not open, or does not do what this page says it does, email support@vendwright.com and it gets fixed. Free does not mean unsupported.

Take it, it is free

One file, no subscription, nothing asked for in return. Every fee chain built in, a year of sample data to learn from, and 1,000 rows waiting for yours.