The Digital Product Sales Tracker in Google Sheets is a digital product sales tracker that fits a whole creator catalogue on one page: 16 columns per product, 1 Total Net Revenue card and 4 charts that read the product list directly. It comes with 15 sample products spread across 8 product types, 7 sales channels and 4 statuses, and 6 of its columns calculate themselves.
Most creators sell the same kind of work in several places at once: templates on Gumroad, printables on Etsy, a course on Teachable and another on Udemy, an eBook on Amazon KDP. Every platform shows its own gross figure and takes its own cut, so nobody sees what each product really keeps after refunds and fees. This tracker puts unit price, units sold, refunds and the platform fee on the same row and turns them into Net Revenue, Profit Margin and Avg Sale Value.
Key Features of the Digital Product Sales Tracker
- Total Net Revenue card: adds up Net Revenue across every product. The 15 sample products total $55.2K.
- Four charts with no helper tables: Sales Count by Product Type, Sales Count by Status, Net Revenue by Product and Gross vs Net Revenue read the data columns with Google Sheets’ built-in Aggregate option, so new products appear automatically.
- Gross Revenue and Refund Amount: Gross Revenue is Unit Price × Units Sold, and Refund Amount is Units Refunded × Unit Price.
- Net Revenue after fees: the refunds come off first, then your Platform Fee % is applied, giving the amount you actually keep per product.
- Profit Margin: Net Revenue as a share of Gross Revenue, shaded so low-margin products stand out.
- Avg Sale Value: Net Revenue divided by the units that were not refunded.
- Dropdowns fed by a List tab: Product Type, Sales Channel and Status options live on the List tab (rows 2-500), so adding a value there updates the dropdown instantly.
- Colour-coded chips: product types and statuses (Best Seller, Active, Paused, Retired) are colour-coded so the table scans quickly.
Three facts worth knowing about this digital product sales tracker: it records 10 input fields per product, it calculates 6 more (Sale ID, Gross Revenue, Refund Amount, Net Revenue, Profit Margin and Avg Sale Value), and every figure on the card and charts comes from the rows you type, with no store connection to set up.
Tracker Pages Explanation
The file has four tabs: the tracker itself, a List tab for dropdown values, a How to Use tab and an Explore More Templates tab.
Page 1: Digital Product Sales Tracker Sheet
The top band holds the Total Net Revenue card and charts including Sales Count by Product Type, Sales Count by Status, Net Revenue by Product and Gross vs Net Revenue. Below it is the 16-column table: Sale ID, Product Name, Product Type, Sales Channel, Launch Date, Unit Price, Units Sold, Gross Revenue, Units Refunded, Refund Amount, Platform Fee %, Net Revenue, Status, Profit Margin, Avg Sale Value and Notes.
In the sample data, the SEO Mastery Course leads with $12,814 gross and $11,378 net at an 8% fee on Teachable. The Lightroom Presets Pack sells the most units after the Kids Coloring Printables (512 against 640), both on Etsy at a 6.5% fee. The Productivity Masterclass on Udemy shows why the fee column matters: $3,560 gross becomes $1,691 net at a 50% fee, a 48% margin, and it is marked Paused. The Sales Count by Status donut shows 10 Active products, 3 Best Sellers and one each Paused and Retired.
Page 2: How to Use
The How to Use tab explains the four steps (enter products, automatic columns, update as you sell, dropdowns), the one-time chip display setting, how the charts read the data columns and how to change colours and the $ currency format.
Page 3: Explore More Templates
The last tab carries a WELCOME15 coupon for 15% off your next purchase and links to related templates on NextGenTemplates.com.
Digital Product Sales Tracker vs. Microsoft Excel Sales Log vs. Platform Dashboards — Feature Comparison
| Feature | Digital Product Sales Tracker in Google Sheets | Microsoft Excel Sales Log | Built-in Platform Dashboards (Gumroad, Etsy, Udemy) |
|---|---|---|---|
| Cost | ✅ $6.99 one-time | Varies; Microsoft 365 licence usually needed | Included, but fees per sale |
| All channels in one view | ✅ Every store and marketplace on one page | Only if you build it | ❌ One platform at a time |
| Setup time | ✅ Minutes: make a copy, replace 15 sample rows | Build formulas and charts yourself | ✅ None |
| Net revenue after refunds and fees | ✅ Calculated per product | Manual formulas | Varies by platform |
| Real-time team collaboration | ✅ Built into Google Sheets | Through OneDrive or SharePoint | Limited account sharing |
| Mobile access | ✅ Google Sheets app | ✅ Excel app | ✅ Vendor app or browser |
| Customizable fields | ✅ Every column, dropdown and colour | ✅ Fully editable | ❌ Vendor’s fields only |
| Automatic sales import | ❌ You enter units, refunds and fees | ❌ Manual entry | ✅ Recorded by the platform |
For creators who sell on more than one platform and want one honest net revenue figure without paying for another subscription, this tracker sits in the sweet spot.
Who Should Use This Template
Perfect for:
- Creators selling eBooks, online courses, templates, presets, printables, audio or software
- Sellers spread across Gumroad, Etsy, Teachable, Udemy, Amazon KDP, marketplaces and their own website
- Solo founders and small digital shops who want one catalogue view of units, refunds and fees
- Course and template sellers deciding which products to promote, pause or retire
Not a fit if:
- You need orders imported automatically – every figure is entered by you, per product
- You need bookkeeping, sales tax or payout reconciliation – this is a product performance tracker, not accounting software
- You want day-by-day or order-by-order history – each row holds running totals for one product
Real-World Use Cases
Priya sells Notion and spreadsheet templates on Gumroad and her own website. She logs each template with its unit price and platform fee, then compares Net Revenue across products to decide which bundle deserves her next launch email.
Marcus teaches on Teachable and Udemy. The Profit Margin column shows how much more he keeps per course on his own school than on the high-fee marketplace, so he sends his audience to the better channel and marks the weaker listing Paused.
Lena runs a small printables shop on Etsy. She tracks refunds per product, notices a clipart pack with more returns than the rest, and marks an outdated stock photo pack Retired once the new volume is live, noting “Replaced by Vol.3” in the Notes column.
Advantages of This Google Sheets Sales Tracker
- One row per product, one page per catalogue: price, channel, refunds and fees are never in separate files.
- True net figures: refunds and platform fees are taken off before anything reaches the Total Net Revenue card.
- No subscription: a one-time $6.99 purchase, and sharing with a partner or assistant is built into Google Sheets.
- Charts that maintain themselves: all 4 charts read the data columns directly, so there are no pivot tables to refresh.
- Easy to extend: new product types, channels and statuses go on the List tab and flow into the dropdowns.
Opportunities for Improvement
- Manual data entry: Units Sold, Units Refunded and Platform Fee % are typed in; there is no connection to Gumroad, Etsy, Udemy or any other store.
- Profit Margin is revenue kept, not profit: it divides Net Revenue by Gross Revenue, so it reflects refunds and platform fees only and ignores your own costs such as software, advertising or taxes.
- Running totals, not history: each product holds its current totals, so month-over-month trends need a saved copy or an extra column.
- One fee rate per product: a product sold on two platforms with different fees needs one row per channel.Digital Product Sales Tracker in Google Sheets
- One-time chip setting: Google does not let scripts set the chip display style, so it takes a 10-second manual step per dropdown column.Digital Product Sales Tracker in Google Sheets
Best Practices
- Pick one day each month and update Units Sold and Units Refunded for every product together.
- Give a product one row per sales channel when fees differ, so Net Revenue stays accurate.
- Use the Notes column to record launches, price changes and why a product was paused or retired.Digital Product Sales Tracker in Google Sheets
- Review low Profit Margin rows first; they show where a channel’s fee is eating your revenue.Digital Product Sales Tracker in Google Sheets
- Keep dropdown values tidy on the List tab; Google’s help page on data validation in Google Sheets explains the chip option.
- Share a view-only link with a partner or accountant using Google Docs sharing settings instead of emailing exports.
Explore Relevant Templates
If product sales are one of several earnings, read about the Multiple Income Streams Tracker in Google Sheets and the Side Hustle Income Tracker in Google Sheets. Store owners who want order-level analysis can look at the Seller Analytics Dashboard in Google Sheets, and creators who market with content can plan it in the Blog Content & SEO Tracker in Google Sheets.
On NextGenTemplates you can also get the Etsy Seller Analytics Dashboard in Google Sheets, the YouTube Channel Performance Tracker in Google Sheets and, for the full marketing stack, the Marketing Manager Toolkit with 9 templates.
Frequently Asked Questions
What does the Digital Product Sales Tracker in Google Sheets track?
It tracks each product’s name, type, sales channel, launch date, unit price, units sold, units refunded, platform fee %, status and notes. It then calculates Sale ID, Gross Revenue, Refund Amount, Net Revenue, Profit Margin and Avg Sale Value, and summarises everything in one Total Net Revenue card and 4 charts.Digital Product Sales Tracker in Google Sheets
Does the tracker connect to Gumroad, Etsy, Udemy or Shopify?
No. The tracker has no live store connection. You enter units, refunds and fee percentages after each sales period, and the card, formula columns and charts update instantly from those figures.Digital Product Sales Tracker in Google Sheets
Is Profit Margin the same as profit?
No. Profit Margin is Net Revenue divided by Gross Revenue, so it shows how much you keep after refunds and platform fees. Your own costs such as tools, ads and taxes are not included, so treat it as a revenue-kept figure.
How long does setup take?
Most users finish in under 15 minutes. Make a copy from the link in the PDF, add your channels and product types on the List tab, then replace the sample products with your own. The formula columns and all 4 charts work without further setup.Digital Product Sales Tracker in Google Sheets
Can I use a currency other than dollars?
Yes. The money columns use $ by default. Select them and change the format through Format > Number to show ₹, € or £.Digital Product Sales Tracker in Google Sheets
Can I add more products, channels and statuses?
Yes. Dropdown values come from the List tab rows 2-500, and the charts read the data columns directly, so new product types, channels, statuses and products appear automatically without editing any formula.Digital Product Sales Tracker in Google Sheets
About the Author
Built by PK — Microsoft Certified Professional with 15+ years of Excel, Google Sheets and Power BI experience. Founder of NextGenTemplates, reaching 300K+ subscribers across YouTube channels. Every template is hand-built and tested before release.Digital Product Sales Tracker in Google Sheets
Conclusion
If your sales are scattered across platform dashboards that each show a different gross number, this tracker gives you units, refunds, fees and net revenue for every product on a single Google Sheets page for a one-time price.Digital Product Sales Tracker in Google Sheets
👉 Click here to Purchase the Digital Product Sales Tracker in Google Sheets
✅ Instant download · One-time payment · No subscriptionDigital Product Sales Tracker in Google Sheets
🎥 Watch more tutorials: Youtube.com/@NeoTechNavigators
Last updated: September 2026Digital Product Sales Tracker in Google Sheets
