Digital Product Sales Log

Who this is for

Every download sale, and what you kept. Record each sale or each day's sales of ebooks, presets, templates, courses and other files, with the fee the platform took and any refunds, and the sheet works out gross and net. The totals show what the period actually earned.

Creators and small sellers with digital products on a shop, marketplace or their own site, keeping a record of their own alongside the platform's reports.

What this helps you track

• Each sale or batch of sales, with the product and platform
• Units sold and the price charged
• Gross takings, platform fees and refunds
• What you actually kept on each line
• Total units, total net and average net per unit for the period

How to use it

1. Write your name or shop, the platform or shops you sell on and the period the sheet covers.
2. Enter each sale, or each day's sales of one product, with the units and the price you charged.
3. Copy the platform fee and any refund from the platform's own statement rather than working them out yourself.
4. Gross, net, totals and the summary are worked out in the browser and the Excel workbook; on paper multiply units by price and take off fees and refunds.
5. To see totals by product in the workbook, filter the product column; on paper, add up each product's rows at the end of the period.

Formats

• Printable PDF (A4 and US Letter)
• Fillable PDF with form fields
• Fill in online, saved in your browser
• Excel / Google Sheets workbook

The printable is laid out inside a box that fits both A4 and US Letter, so the two files are identical and neither one is scaled. The fillable PDF has real form fields. The workbook uses plain formulas only — SUM, IF, COUNTIF and the like — so it opens in Excel, LibreOffice and Google Sheets without anything breaking, and every calculated cell is grey so you can see which figures it worked out.

How to print

Download the A4 or US Letter file to match the paper in your printer, open it in a PDF reader and print at 100% — not "fit to page", which shrinks the writing space. Both files leave a 14 mm margin, which clears the unprintable edge on home printers. To print the online version with your entries in it, use the Print this sheet button, which prints only the sheet and none of the page around it. More on printing.

Questions

Should I record every sale or a daily total?

Either works as long as you keep to one. A few sales a week can go in one at a time. If you sell many, one row per product per day or per payout keeps the sheet to a manageable length.

Where do I get the fee figures from?

From your platform's order or payout report. Fees vary by platform, plan and payment method, so copy the actual amount taken rather than applying a percentage.

How do I find my best-selling product?

Filter or sort the product column in the Excel workbook, or add each product's units on paper at the end of the period. The summary gives overall totals rather than a per-product ranking.

Does this replace my bookkeeping?

No. It is a sales record you can hand to whoever does your books or copy into your own accounts. Check the rules where you are for what records you need to keep.