Digital Product Seller's Profit Dashboard
Profit on a digital product is gross revenue minus platform fees, payment processing, attributed ad spend, refunds, and the one-time build cost (design hours, fonts, stock-photo licenses) amortized across units sold. Most digital sellers track the gross and ignore the rest, so they cannot tell which listings actually earn money — and which look like bestsellers but quietly lose money to Offsite Ads or platform fees. This Excel workbook makes the math per listing visible, then tags each one Top earner / Healthy / Underperformer / Loss-making / Bundle candidate so you know what to do next.
A six-tab Excel workbook for sellers of printables, templates, digital planners, and downloadable products who need to know which listings actually earn money once platform fees, payment processing, and ad spend are honestly attributed. The Listings tab is your catalog (one row per product); the Sales Log is one row per transaction with a VLOOKUP that pulls the product name from the Listings tab and a Net column that subtracts platform fees, payment processing, attributed ad spend, and refunds from gross. The Monthly Summary pivots the entire log into Jan–Dec totals (gross, fees, ads, refunds, net profit, units) for quarterly tax planning. The Product Performance tab is the dashboard itself — every listing rolled up into units sold, gross revenue, total fees, ad spend, net profit, and margin %, with a Signal column that tags each listing as Top earner / Healthy / Underperformer / Loss-making / Bundle candidate based on configurable thresholds you can edit on the Reference tab. Reference also carries typical platform fees for Etsy, Gumroad, Payhip, Shopify, and Stripe direct, plus a glossary explaining build cost, variable net, attributed ad spend, and the bundle-candidate logic. Sample data — eight listings, twenty-three sales — is wired in so the formulas demonstrate themselves the moment you open the file; replace it with your real catalog and sales.
- A Listings tab — one row per digital product with SKU, type, primary platform, list price, build cost (your one-time amortizable design and licensing cost), version, launch date, active flag, and notes
- A Sales Log tab — one row per transaction; type the SKU and the product name pulls in via VLOOKUP, then drop in gross, platform fee, payment processing fee, attributed ad spend, and refund — Net and Effective fee % calculate themselves; thirty padding rows so you can keep adding sales without rebuilding formulas
- A Monthly Summary tab — Jan–Dec pivot of units, gross, platform fees, payment fees, ad spend, refunds, and net profit; edit the year cell to roll forward; year-total row at the bottom feeds your quarterly estimated tax math
- A Product Performance tab — per-listing rollup with units sold, gross, fees, ad spend, net profit, margin %, and a Signal column tagging each listing Top earner / Healthy / Underperformer / Loss-making / Bundle candidate based on thresholds you control
- A Reference tab with editable signal thresholds (top-earner net floor, margin floors, bundle-candidate triggers), typical platform fees for Etsy / Gumroad / Payhip / Shopify / Stripe, and a glossary covering build cost, variable net, attributed ad spend, and bundle-candidate logic
- Honest ad-spend attribution baked in — every Sales Log row has its own Ad spend column so a Pinterest ad you ran for one listing does not get smeared evenly across the catalog
- Sample data wired in: eight believable listings (wedding planner pack, budget spreadsheet, Notion template, calendar bundle, meal planner, invoice template, wallpaper pack, watercolor mini-course) with twenty-three sales spanning Jan–Apr — replace with your own in a few minutes
Educational tool only — not legal, tax, or financial advice. Platform fees (Etsy, Gumroad, Shopify, Payhip, Stripe, etc.) change frequently and vary by country, plan, and listing type — confirm current fees on each platform's pricing page before relying on the defaults in the Reference tab. Profit numbers are estimates that reflect the inputs you type in; the platform's official statement is the authoritative record. Consult a qualified accountant for tax filing and a qualified attorney for licensing or contract questions.
More about this resource
Why "zero inventory cost" is a marketing pitch, not an income statement
The pitch on every passive-income blog is that digital products have zero cost of goods. Technically true: you do not pay for paper, ink, or shipping. Practically wrong: you paid for the 40 hours of design time, the $200 font license, the $50/month stock-photo subscription, the $300 freelancer who wrote the sales copy, and the $15/day Pinterest ads pointing at the listing. None of that goes away because the product is delivered as a PDF.
The Build cost column on the Listings tab captures the one-time amortizable cost — design time × hourly rate, plus license fees, plus contractor work — and the Product Performance tab subtracts it from total net before computing margin. Per-sale fees (platform commission, payment processing, attributed ad spend, refunds) come out of every sale on the Sales Log tab. The result is a real per-listing profit number, not the inflated gross-revenue figure your platform dashboard reports.
How attributed ad spend changes the picture
Etsy Offsite Ads charge 12–15% of the sale price when the buyer arrived through the ad — but only on those sales. Promoted Listings (Etsy's on-platform CPC ads) cost whatever you bid and convert at whatever rate the listing supports. Pinterest and Meta ads cost daily budgets that may or may not pay back per click. The mistake almost every digital seller makes is averaging ad spend across the whole catalog instead of attaching the spend to the listing the click actually drove.
The Sales Log tab has a per-row Ad spend column for exactly this reason. A $4 wallpaper pack that earns $2.40 net before ad spend looks fine on the platform dashboard. Once you charge the $1.20 Offsite Ads fee back to the listing that drove the click, that listing earns $1.20 a sale — and at $0.46 platform fee plus $0.37 processing on a $4 sale, the listing is clearing about 30% margin, not the 60% the gross-only number suggested. Multiply that by 50 sales a year and the difference between the two views is a full coffee-budget mistake.
What the Top earner / Healthy / Underperformer / Loss-making / Bundle candidate signals mean
The Product Performance tab tags every listing with one of six signals based on the thresholds in the Reference tab. Top earner: net profit ≥ $500 AND margin ≥ 50% — promote more, build variants, this is where your hours pay back the highest. Healthy: margin ≥ 30% — leave alone, do not break what is working. Underperformer: margin between 10% and 30% — worth keeping but not worth promoting; consider repricing.
Loss-making: margin under 10% — ad spend or platform fees are eating the listing; pause ads first (free), delist later (permanent). Bundle candidate: more than 5 units sold AND margin under 30% — a low-price item that does not earn its keep alone but adds perceived value when bundled with a top earner. No sales yet: under 60 days post-launch, ignore — the listing has not had enough traffic to perform yet.
All six thresholds live in editable cells on the Reference tab. If $500 is too high a top-earner floor for your business stage, change it to $200 and the Signal column updates instantly. The point is to make the rules visible and tunable, not to dictate them.
How to use the dashboard in a 30-minute monthly review
On the first of every month, export your Etsy / Gumroad / Payhip / Shopify sales for the prior month and paste them into the Sales Log (one row per transaction; type the SKU exactly as it appears on the Listings tab). Drop in any ads run that month against the listings they pointed at. Open the Product Performance tab and read the Signal column top to bottom.
Action list: Top earners get a variant launch this quarter. Healthy stays untouched. Underperformers get a price-test (the "Should I Raise My Prices?" decision tool linked from the Read Me runs the +10/+20/+30% math). Loss-making listings get their ads paused immediately and a 60-day decision window before delisting. Bundle candidates get folded into a new bundle SKU on the Listings tab. The whole pass takes 20–30 minutes once you have the routine; the alternative is to keep guessing which listings to promote and finding out at year-end that the wallpaper pack you ran ads on was the one losing money.
Or skip the spreadsheet entirely
A spreadsheet asks you to copy every Etsy CSV, Gumroad export, and Stripe payout into the right column by hand — and stops being right the moment you forget to. Ardent Seller pulls each sale into the right listing automatically, tracks platform fees and ad spend as their own line items, and the Reports tab shows revenue, expenses, net profit, and per-product performance for any date range without typing anything in. The same dashboard, but it updates itself.
Income, expenses & per-product reports
See revenue, expenses, net profit, and per-product performance for any date range — the dashboard, on every listing, updated automatically as sales come in.
Digital products & services
Track digital listings alongside any physical inventory you also sell, with version, list price, and platform metadata — so the catalog and the sales reports stay in sync.
Bundles & kits
Group an underperforming listing with a top earner into a bundle that prices and tracks as one product, so the math the workbook flags actually shows up in your sales reports.
Frequently asked questions
How do I calculate true profit on a digital product after platform fees and ad spend?
True profit per sale = Gross sale price − platform commission (Etsy 6.5%, Gumroad 10%, Payhip 5/2/0%, Shopify $0/sale + Stripe 2.9% + $0.30) − payment processing (3% + $0.25 on Etsy US, absorbed on Gumroad, ~3% + $0.30 on Stripe direct) − attributed ad spend (Offsite Ads 12–15% only on ad-driven sales, Promoted Listings CPC, Pinterest/Meta daily budget) − refunds. True profit per listing = total true profit per sale across all units sold − one-time build cost (design hours × rate + font and stock-photo licenses + contractor fees). This Excel workbook does both calculations automatically once you fill in the Listings and Sales Log tabs.
What are typical platform fees for Etsy, Gumroad, Shopify, and Payhip?
Etsy charges $0.20 per listing every 4 months, 6.5% transaction fee, ~3% + $0.25 payment processing (US), and 12–15% Offsite Ads only on ad-driven sales. Gumroad is a flat 10% per sale (payment processing absorbed). Payhip is 5% on the Free plan, 2% on Plus ($29/mo), 0% on Pro ($99/mo), plus your own payment processor (~3% + $0.30). Shopify is no per-sale fee but $39/mo Basic + Stripe 2.9% + $0.30 per sale. Stripe direct on your own site is 2.9% + $0.30 (US). All five tiers are listed on the Reference tab in this workbook for sanity-checking your numbers — verify on each platform's pricing page since fees change.
Is "passive income" a real thing for digital products?
Not in the way the marketing pitch implies. Digital products do not require shipping or restocking, but they do require ongoing version updates (annual planners, 2026 calendar refreshes), customer support tickets, ad spend if you want consistent traffic, platform-fee absorption, and the up-front build hours that almost never get accounted for. A more accurate description is "non-zero ongoing cost with very low marginal cost per sale" — meaning the third sale of a listing is nearly free, but the first sale paid for everything before it. This dashboard makes the build-cost amortization visible so you can see when each listing has actually paid back.
Should I attribute ad spend evenly across my whole catalog or to individual listings?
Attribute it to individual listings. Etsy Offsite Ads, Etsy Promoted Listings, Pinterest ads, and Meta ads all generate clicks that land on a specific listing — that is the listing whose margin should bear the cost. Smearing ad spend evenly across 30 listings hides which products the ads actually paid back and which silently lost money. The Sales Log tab in this workbook has an Ad spend column on every row precisely so you stop pretending. If you ran a brand awareness campaign that benefits the whole catalog, leave Ad spend blank on the per-sale rows and add a single expense line in your accounting tool — the workbook will not double-count it.
How do I know if a listing is a "bundle candidate" or just an underperformer?
Bundle candidates have demonstrated demand (more than 5 units sold) but margin too thin to stand alone (under 30%). Underperformers have weak demand AND thin margin — they are not earning their listing fee. The distinction matters because bundling a $4 wallpaper pack with a $24 calendar bundle takes a thin-margin listing and uses it to add perceived value to a top earner; bundling an underperformer with a top earner just dilutes the top earner. The Product Performance tab in this workbook tags listings automatically based on thresholds you can edit on the Reference tab.
When does it make sense to delist a digital product?
After it has had 60+ days of traffic AND its margin signal is consistently Loss-making AND pausing ads has not moved the margin into the Healthy range. Delisting is permanent on Etsy in the sense that the listing's SEO history evaporates; on Gumroad, Payhip, and your own site you can soft-disable without losing the URL. The Active flag on the Listings tab is exactly for this — set it to N to stop including the listing in the Product Performance dashboard without deleting any history. The workbook keeps the historical sales for tax and trend purposes; it just stops grading the listing forward.
How does this workbook help with quarterly estimated taxes?
The Monthly Summary tab pivots all your sales into Jan–Dec totals with a Net profit column. Q1 (Jan–Mar) is due Apr 15, Q2 (Apr–May) due Jun 15, Q3 (Jun–Aug) due Sep 15, and Q4 (Sep–Dec) due Jan 15. Sum the Net profit rows for each quarter and feed that number into a quarterly estimated tax worksheet (the Quarterly Estimated Tax Worksheet linked from the Read Me does the SE-tax + federal income-tax math). Net profit on this dashboard already nets out platform fees, payment processing, ad spend, and refunds — the four expense buckets that almost always get under-tracked at tax time.
Can I track sales from multiple platforms in one workbook?
Yes. The Sales Log has a Platform column on every row precisely so a single SKU can sell on Etsy, Gumroad, and your own Shopify store and roll up into one Product Performance row. Type the platform name into the Platform column the same way every time (Etsy / Gumroad / Shopify / Payhip / Own site) so future filtering and sorting work. The Listings tab has a Primary platform column for the listing's home channel, but the per-sale Platform column on the Sales Log tab is what determines which fee structure you should be applying.
Related resources
Product Pricing Calculator
A working Excel pricing calculator — materials, labor, packaging, and platform fees in, a defensible retail price out. Plus a batch tab that shows what 50 vs. 10 actually costs.
Should I Raise My Prices? Decision Tool
A live web tool that runs the +10% / +20% / +30% price-hike math for one product — including the volume drop that comes with each — and tells you which scenario clears the most monthly profit.
Schedule C Tax Expense Tracker
A working Excel expense tracker organized by IRS Schedule C category. Drop-down picker on every row, a Monthly Summary that builds itself, a year-end Schedule C view, and a mileage log with the deduction calculated for you.
Quarterly Estimated Tax Worksheet
A working Excel worksheet for self-employed makers — log income, set filing status, and the four quarterly estimated-tax payments calculate themselves. SE tax (15.3%) plus federal income tax math built in, with a safe-harbor escape hatch on its own tab.
Spreadsheet vs Inventory Software: The Decision Guide
When a spreadsheet is enough, when it stops working, and how to tell the difference before it costs you.
End-of-Month Closeout Checklist
Seven steps to a clean monthly close — sales reconciliation, inventory counts, expense review, P&L, planning, reordering, and backup. Print one each month.
Small Business Tax Deduction Cheat Sheet
Every Schedule C line that matters to a maker — what belongs, what doesn't, and the mistakes that cost money.