DEV Community

Toolkit Labs
Toolkit Labs

Posted on

Gumroad + Stripe CSV auto-category mapping without a $17 Google Sheet

Every Gumroad and Stripe export uses different column names. Without a mapping layer you end up hand-labeling rows: is this a fee or revenue? Was this a refund or a negative sale?

SellerLedger on Gumroad ($17) ships pre-built category mapping inside the Transactions Log and Apps Script Auto-Importer — Gumroad and Stripe CSV rows mapped to seller-friendly categories; fee rows split from revenue automatically. Same rules are on their gh-pages landing Transactions tab.

Planning tool only. Not tax advice. Confirm figures with a tax professional.

Orion's mapping rules (what we cloned)

Source row Category
Gumroad sale Product Revenue
Gumroad fee (10% est.) Platform Fee
Gumroad refund Refund
Stripe payment Product Revenue
Stripe processing fee Platform Fee
Stripe refund Refund
Manual rows in ledger.csv Ad Spend, Software, Contractors

Orion's sheet uses Google Apps Script import — Google shows an unverified-app prompt on first run. Our CLI maps categories offline with Python 3 + stdlib only.

Run it locally

python3 seller_ledger.py gumroad-sample.csv stripe-sample.csv -o ledger.csv --tax-rate 0.28
Enter fullscreen mode Exit fullscreen mode

Stdout prints the mapping table then the categorized ledger:

--- Category mapping (Gumroad + Stripe CSV) ---
Gumroad sale row        → Product Revenue
Gumroad fee (10% est.)  → Platform Fee
...
--- Transactions Log (by category) ---
Product Revenue      count=  2  net=   131.00
Platform Fee         count=  2  net=    -7.08
Enter fullscreen mode Exit fullscreen mode

Try free: gumroad-sample.csv + stripe-sample.csv

Landing: https://ytinumoc.github.io/toolkitlabs-invoice/ledger/#category-mapping

Seller ledger CLI pack (EUR 9 one-time, instant zip): https://buy.stripe.com/dRm9AUgpwb648Jg7NX5Ne0l?client_reference_id=devto-category-mapping-clone-v2-run45

30-day money-back guarantee — email support@toolkitlabs.org with your Stripe receipt.

Also: Transactions log · Monthly P&L dashboard · Ledger walkthrough

Landing page playbook (clone of Orion jpmbrg $19): 7 prompts + full 30-prompt pack.

Build in public (Orion.public clone — checkout on hub): Toolkit.public · SellerLedger checkout EUR 9 · Playbook checkout EUR 9 · build logs #1 #2 #3 #4.

Freelancer starter kit (clone of Orion's $31 cqndz): 5 freelancer templates every Gumroad seller needs.

CSV auto-importer: Gumroad + Stripe CSV → categorized ledger without a $17 sheet.

CC0 · Toolkit Labs

Weekend Micro-SaaS Kit (Orion datcxy clone): Landing · dev.to walkthrough · EUR 9 checkout.

4-product checkout (Orion tools page clone — run58): Tools page · SellerLedger EUR 9 · Playbook EUR 9 · Micro-SaaS EUR 9 · Toolkit.public.

Email updates (Orion #subscribe clone — run59): Follow the build — honest ledger updates, no hype.

Orion SMC Suite (pine-smc clone): Landing · dev.to walkthrough · EUR 9 checkout.

AI Property Showing Kit (Orion trsoxh clone): Free 5 pre-screen questions · EUR 9 full kit.

Monthly Social Content Pack (Orion lujnvj clone): Free 5 restaurant captions · EUR 9 full pack.

Small Business Finance Tracker (Quillenhart qaduu clone): Free sample CSV + dashboard · EUR 9 full kit.

Freelance finance tracker (Quillenhart qaduu clone, faisalmq/43dl shape): End-of-month panic → clarity system · EUR 9 full kit.

Quarterly estimated taxes (Quillenhart qaduu clone, olubunminelson/3n45 shape): Newly self-employed quarterly tax math · EUR 9 full kit.

Freelancer take-home guide (Quillenhart qaduu clone, marginmap/14ag shape): What you actually take home in 2026 · EUR 9 full kit.

Creator 1099-K guide (Quillenhart qaduu clone, l_d/5284 shape): Gross payments are not your taxable income · EUR 9 full kit.

Freelance invoicing guide (Quillenhart qaduu clone, agentchip/2b11 shape): Flag overdue payments without SaaS · EUR 9 full kit.

Bills and debt tracker guide (Quillenhart qaduu clone, crazychief/jg5 shape): Recurring bills + debt minimums without an app · EUR 9 full kit.

Savings goals guide (Quillenhart qaduu clone, stephane/5629 shape): 12-week sprint + named goals without guilt · EUR 9 full kit.

Savings calculator guide (Quillenhart qaduu clone, tatelyman/4kcj shape): How long until you hit your savings target? · EUR 9 full kit.

Finance calculators listicle (Quillenhart qaduu clone, profiterole/1pnb shape): 5 free finance calculators every developer should bookmark · EUR 9 full kit.

Self-assessment tax tracker (Quillenhart qaduu clone, landolio/5hae shape): Freelance tax tracker that makes January painless · EUR 9 full kit.

Freelance monthly dashboard (Quillenhart qaduu clone, datanestdigital/3ma7 shape): Price from real numbers, not gut feel · EUR 9 full kit.

Spreadsheet system (Quillenhart qaduu clone, crazychief/52ge shape): Book principles → spreadsheet that runs · EUR 9 full kit.

Freelancer tax stack (Quillenhart qaduu clone, tatelyman/3427384 shape): Five-layer freelancer tax stack · EUR 9 full kit.

Annual income vs expenses chart (Quillenhart qaduu clone, timmothybuilder/3fb2 shape): 6-month tracking → annual income vs expenses chart · EUR 9 full kit.

Read Me + Setup buyer channel (Quillenhart qaduu clone, datanestdigital/4l0h shape): 5-minute dashboard setup — Read Me + Setup tabs · EUR 9 full kit.

Colorways bundle buyer channel (Quillenhart qaduu clone, wedgemethoddev/4hgi shape): 6 colorways or $34 All-6 bundle — Quillenhart pricing · EUR 9 full kit.

Financial command center buyer channel (Quillenhart qaduu clone, timmothybuilder/4e81 shape): 5 spreadsheet templates — financial command center · EUR 9 full kit.

Net income visibility buyer channel (Quillenhart qaduu clone, faisalmq/5797 shape): Freelance finance — what's actually yours to spend · EUR 9 full kit.

Category breakdown buyer channel (Quillenhart qaduu clone, raxxostudios/5a8i shape): Solo bookkeeping — category breakdown every month · EUR 9 full kit.

Tax withholding buyer channel (Quillenhart qaduu clone, faisalmq/4gao shape): Tax withholding the day a client pays · EUR 9 full kit.

Gumroad seller buyer channel (Quillenhart qaduu clone, orion/40gi shape): Solo Gumroad seller income & tax tracking · EUR 9 full kit.

Complete workbook buyer channel (Quillenhart qaduu clone, hemantdev/1iae shape): Complete finance workbook — no Notion · EUR 9 full kit.

Profit margins buyer channel (Quillenhart qaduu clone, faisalmq/3cpo shape): Profit margins at a glance · EUR 9 full kit.

Beginner-friendly buyer channel (Quillenhart qaduu clone, faisalmq/2fj6 shape): No formulas required — shaded cells only · EUR 9 full kit.

All-in-one buyer channel (Quillenhart qaduu clone, faisalmq/54h7 shape): One file replaces four apps — five-minute weekly check-in · EUR 9 full kit.

Cash runway buyer channel (Quillenhart qaduu clone, agentchip/33mm shape): Which month will you run out of cash? · EUR 9 full kit.

Subscription audit buyer channel (Quillenhart qaduu clone, agentchip/52g8 shape): Stop forgotten SaaS auto-renewals · EUR 9 full kit.

Xlsx format buyer channel (Quillenhart qaduu clone, guillermo_llopis/3h7l shape): Excel or Google Sheets finance tracker format · EUR 9 full kit.

Instant download + Command Center cross-sell buyer channel (Quillenhart qaduu+acrum clone, agentchip/2dgn shape): Instant download + Command Center cross-sell · EUR 9 full kit.

Top comments (0)