Meta: Track Gumroad sales accurately in a spreadsheet: the export pipeline, the columns that matter, refund handling, and how to automate weekly sync so the numbers never lie.
Gumroad sales tracking spreadsheet
You can't run a digital-products business on the Gumroad dashboard alone — it shows today, resets context, and doesn't talk to your books. A spreadsheet you control is the fix. The problem is keeping it accurate when sales, refunds, and fees arrive in different exports. Here's the setup that stays honest.
The columns that matter
`` date | product | customer_email | gross | fee | net | refunded | payout_status `` Eight columns. Not twenty. Gross/fee/net per row is what makes every later calculation (tax estimate, product profitability) possible.
Keeping it accurate — the three rules
- One row per sale, never aggregate. Aggregates hide refunds and fee changes.
- Record refunds as negative rows, not deletions. Deletions erase history; negatives keep the story true.
- Reconcile monthly against payouts. Your spreadsheet net should match what actually landed in your bank. If it doesn't, you have a fee-timing or refund-window issue — better found monthly than at tax time.
Manual vs automated sync
- Manual: Gumroad → Sales CSV export → paste → format. ~15 minutes/week, error-prone exactly when you're busy.
- Automated (free): n8n pulls the export on schedule, appends new rows, dedupes by sale ID. Your job shrinks to a Friday glance at the reconciliation.
The Seller Ops Digest pack ($39) automates the sync *and* emails the weekly digest (revenue, units, refunds, top product) — free tiers to run. The free Gumroad → Stripe reconciler handles the monthly payout check in your browser, no upload.
The payout catch most sellers miss
Gumroad pays out on a schedule; Stripe receives *net of fees*. If you compare "Gumroad gross" to "Stripe deposits" you'll always see a gap that isn't a loss. Compare like-for-like: Gumroad net (after fees/refunds) against Stripe deposits for the same period — that's what the reconciler automates.
What you can now answer (that the dashboard can't)
- Which product actually makes money after fees?
- What's the 90-day trend, not the today-number?
- What will my estimated tax bill look like this quarter?
One spreadsheet, synced weekly, reconciled monthly — and the numbers stop being a mystery you solve in March.