Digital Seller Payout and Profit Tracker Google Sheets

Seller's description

Reconcile marketplace payouts, fees, refunds and profit in one Google Sheets dashboard built for digital sellers.

AT A GLANCE
English only. Instant digital download: 1 Google Sheets-ready XLSX workbook with 9 tabs + 4 PDF guides. Import the XLSX into Google Sheets and save a private Google Sheets copy. A free Google account is recommended.
Digital files only: no physical item, standalone app, consultation or seller-managed cloud service.
One reporting currency per workbook. No marketplace/bank connection, automatic import or tax filing.

HOW TO START
1. Import the XLSX into Google Sheets.
2. Enter amounts from statements manually.
3. Record the payout and bank deposit.
4. Review variances and monthly results.
Keep Google Drive General access set to Restricted and invite only authorized people. Desktop setup is recommended; wide tables can require horizontal scrolling on a phone.

WATCH THE PRODUCT PREVIEW
The listing video shows actual workbook previews with fictional data: Enter the actual bank deposit. A mismatch is flagged for review. Previews are rendered in LibreOffice from copies of the delivered XLSX, not recorded in Google Sheets. Appearance may differ after import.

Your sales total, platform balance, payout and bank deposit are different numbers. Digital Seller Payout & Profit Tracker gives Etsy, Gumroad and multi-channel digital sellers one connected Google Sheets-ready system for following money from each transaction to the amount that actually reaches the bank.

This is not another generic income-and-expense list. It separates marketplace-remitted tax, refunds, order-level fees, account-level charges, reserves or credits, platform-reported payouts and bank deposits so you can see exactly where a difference appears. The same records also produce product contribution and a monthly management P&L.

WHAT YOU RECEIVE
- Google Sheets-ready XLSX workbook with 9 connected tabs
- Sales Ledger with 500 transaction rows
- Expense log with 300 rows
- Payout Reconciliation with 200 payout rows
- Product catalog and automatic product-name matching
- Product profitability by units, net sales, refunds, fees and variable cost
- Monthly P&L for the reporting year you select
- Dashboard with profit and reconciliation controls
- Editable platform and expense-category lists
- Fictional Etsy and Gumroad examples showing the complete workflow
- Four PDF guides: Quick Start, Monthly Reconciliation Checklist, Etsy & Gumroad Data Entry Map, and Privacy & Scope

THE NINE TABS
1. Start Here - setup sequence, the three-number reconciliation method and boundaries.
2. Settings - reporting year, currency, shop label, platforms and expense categories.
3. Products - stable Product IDs, names, list prices and optional variable delivery cost.
4. Sales Ledger - sale date, platform, reference, product, units, buyer total, remitted tax, refund and actual fees.
5. Expenses - operating costs not already recorded as order fees.
6. Payout Reconciliation - ledger order net, signed adjustments, reported payout, bank deposit and two variance checks.
7. Product Profitability - automatic totals and contribution margin for every Product ID.
8. Monthly P&L - net sales, fees, variable costs, operating expenses, result, payouts and deposits.
9. Dashboard - year-to-date performance plus unreconciled sales, open payouts, variances and missing IDs.

THE THREE-NUMBER RECONCILIATION
The workbook deliberately keeps three figures separate:

1. Ledger order net: net sales minus actual order-level fees for the payout period.
2. Platform-reported payout: what Etsy, Gumroad or another channel says it sent after account-level charges, reserve movements or credits.
3. Actual bank deposit: what arrived in the bank or payment account.

The first variance shows whether the transaction ledger plus documented adjustments agrees with the platform payout. The second shows whether the reported payout agrees with the bank deposit. This helps locate the stage where a difference needs review.

WHY THERE ARE NO BUILT-IN FEE PERCENTAGES
Fee schedules vary by platform, country, payment method, currency, advertising source and account status, and can change. Instead of presenting a temporary estimate as accounting truth, this workbook asks you to enter actual transaction and payout values from your current reports. Historical records remain understandable after a platform changes pricing.

PRODUCT PROFITABILITY
Give every listing a short Product ID and use it in Sales Ledger. Product Profitability automatically shows:
- Units sold
- Buyer-paid total
- Platform-remitted tax
- Refunds
- Net sales
- Actual order fees
- Configured variable delivery cost
- Contribution and contribution margin

Shared operating expenses stay separate in Monthly P&L so they are not silently assigned to the wrong product.

WHAT YOU ENTER MANUALLY
- Product catalog and stable Product IDs
- Completed sales from current transaction records
- Tax collected and remitted by a marketplace, when shown
- Refunds and actual order-level fees
- Operating expenses not already captured in Sales Ledger
- Payout dates, IDs, covered periods and reported amounts
- Signed account-level charges, credits or reserve movements
- Actual bank deposits and explanatory references

WHAT IT DOES NOT DO
- It does not connect to Etsy, Gumroad, a bank or accounting software.
- It does not import CSV files or transactions automatically.
- It does not calculate or file taxes.
- It does not decide accounting or tax classifications.
- It does not replace source statements, receipts or professional advice.
- It does not guarantee every platform export uses the example labels.

PRIVACY BY DESIGN
Buyer names, email addresses, postal addresses and payment details are not needed. Use an order number, shortened reference or internal reference instead. Never store platform passwords, recovery codes, API keys, tax IDs, full bank account numbers or banking credentials in the file. Keep Google Drive General access set to Restricted.

COMPATIBILITY AND DELIVERY
- Instant digital download; no physical item is shipped
- Designed for Google Sheets; a free Google account is recommended
- Delivered as XLSX plus four PDF guides
- Modern Microsoft Excel can open the workbook, but chart styling and layout should be checked after import
- Desktop is recommended for initial setup and monthly reconciliation
- Dashboard and quick reviews can be used on a phone or tablet
- Workbook and guides are in English

IMPORTANT SCOPE
This is a manual recordkeeping, business-organization and reconciliation template. It is not accounting, tax, legal, financial or business advice. Monthly P&L is an internal management summary, not a tax return, statutory account, audited statement or platform report.

Platform interfaces, exports, tax handling, reserves, fees and payout timing can change. Verify each figure against current records and ask a qualified professional to review reporting, retention and classification requirements where appropriate.

SINGLE-BUSINESS LICENSE
One purchase is for use by one buyer in one business. Files may not be resold, redistributed, sublicensed, shared as a template or used to create a competing product.

FREQUENTLY ASKED QUESTIONS

Does it connect directly to Etsy or Gumroad?
No. It is intentionally manual. You enter relevant values from your current reports, so no password, API access or subscription is required.

Does it calculate platform fees automatically?
It totals the actual fees you enter. It does not assume a fee percentage because fees vary and change. This product is for reconciliation, not a pre-sale fee estimate.

Can I use another platform?
Yes. Shopify, Stripe, PayPal, Direct and Other are included as optional channels. Use the report concepts that apply and document any difference.

Can I use more than one currency?
Use one reporting currency per workbook. Convert foreign-currency values consistently and keep the exchange-rate source with separate records.

Is Monthly P&L ready to file with tax authorities?
No. It is an internal management summary. Verify figures and classifications under applicable rules with a qualified adviser.

Can I track physical products?
The rows can record them, but this version is designed for digital sellers. It does not include inventory, shipping labels, physical COGS batches or stock controls.

Can I use several shops?
Several channels can share one workbook when they belong to the same reporting setup and currency. Use separate copies when businesses, entities, currencies or obligations differ.

© 2026 HOST-C. All rights reserved. Etsy is a trademark of Etsy, Inc.; Gumroad is a trademark of Gumroad, Inc. This independent product is not affiliated with or endorsed by either platform.