Creator Income Tracker Spreadsheet: Free Template (2026)
A free creator income tracker spreadsheet (.xlsx and CSV): log each payout gross and net, see monthly profit, set aside tax, and map expenses to Schedule C.
Topic
Pricing, payments, bookkeeping, taxes, and cash flow for a one-person online business.
New to creator taxes? The complete creator tax guide puts every tax article and calculator here in filing order, with the 2026 numbers.
A free creator income tracker spreadsheet (.xlsx and CSV): log each payout gross and net, see monthly profit, set aside tax, and map expenses to Schedule C.
Most solo YouTubers don't need an EIN, but a few things change that. A yes/no table, what AdSense accepts on the W-9, and the IRS online steps.
Gumroad collects sales tax, not your income tax. What US sellers owe on Gumroad profit, the 2026 1099-K line, Schedule C lines, and a worked $20,000 example.
Which estimated tax safe harbor keeps a creator penalty-free in 2026 when income jumps or drops, plus what a missed payment really costs on Form 2210.
An S corp pays only when payroll tax saved beats a defensible salary, lost QBI and running costs. A 2026 break-even worksheet across eight profit levels.
Yes, usually in full this year. 2026 Section 179, bonus and de minimis rules for cameras, lenses and laptops, three worked examples, and the listed-property trap.
How sponsorships are taxed for US creators: cash fees, kept products, affiliate pay, and creator funds mapped to their 1099, return line, and SE tax.
YouTube hobby or business for the IRS: the nine factors with creator evidence, the dollar difference on $8,000 of income, and when Form 5213 backfires.
Patreon takes 10% plus 2.9% + $0.30 per payment on its standard plan, so a $5 member nets about $4.06. Payout, currency and iPhone fees at $3 to $25, compared.
Do you owe sales tax on ebooks, courses or templates? Which platforms collect it for you, which states tax ebooks, and the nexus thresholds that matter.
How the self-employed health insurance deduction works in 2026: who qualifies month by month, Form 7206 worked at $60,000 profit, and where each premium goes.
When Apple and Google Play actually pay US developers, the minimums and fees, which 1099 each store sends, and how to match 1099-K gross to your deposits.
Six coverages mapped to creators, app makers and digital product sellers, with when to skip each one, the homeowners gap, and a pre-quote checklist.
A $29 sale nets $24.46 on Gumroad after 10% + 50¢ and 2.9% + 30¢ card fees, $27.05 on Lemon Squeezy and $26.41 on Payhip Free. Full net at $5 to $299.
Owner's draw, S corp salary plus distributions, or a fixed-percentage split: how each way to pay yourself works and what the IRS taxes, with every rule sourced.
Self-employment tax explained with 2026 numbers: the 15.3% rate, the $184,500 wage base, Schedule SE worked at three profit levels, and where QBI fits in.
YouTube's own rules on RPM, CPM and Shorts pay, plus a sourced digest of the niche RPM figures third parties report, with dates, methods and caveats.
1099-NEC vs 1099-K for creators: who sends each form, IRS thresholds by year from 2021 to 2026, which platform uses which, and how to report doubled income once.
Seven business checking accounts compared from the banks' own fee pages as of September 2026, plus the SSN, EIN and DBA papers each one asks a sole proprietor for.
An LLC will not cut a YouTuber's federal taxes. See what it does protect, official 2026 fees in seven states, and a six-question decision tree.
What Stripe and PayPal leave you on a $5, $10, $29, $99 and $299 digital product, computed from both official US fee pages, plus disputes, payouts and VAT.
Every creator deduction mapped to its Schedule C line, the IRS publication behind it, and the limit that bites — plus four deductions that never touch Schedule C.
Solo 401(k) vs SEP IRA in 2026: at $100,000 profit a SEP caps near $18,600, a solo 401(k) near $43,100. Limits, deadlines, and which to open.
US YouTubers get a 1099-MISC from Google (royalties, $10 and up), not a 1099-NEC. Every YouTube tax form, where it goes, and how to file.
Who owes quarterly estimated taxes on YouTube income, the 2026 due dates and safe-harbor rules, and a worked 1040-ES example with this year's numbers.
Raptive needs 25,000 pageviews a month, Mediavine $5,000 a year in ad revenue, Journey by Mediavine 1,000 tier-1 sessions, AdSense no minimum.