Creator Income Tracker Spreadsheet: Free Template (2026)

Creator income lands from five directions on five different calendars, and none of it has tax withheld. A spreadsheet fixes that only if it records the right things: what each platform collected, what it kept, when the money actually reached you, and which tax form should show up in January. Below is a free creator income tracker spreadsheet you can download right now, no email required, plus how each tab works, when the big platforms actually pay, and how to get it into Google Sheets.

This is general recordkeeping information, not tax advice, and Paschal is not licensed to give it. The rules behind every column come from the IRS, mainly the Schedule C instructions and the Form 1099-K instructions. The full set of creator tax guides, in filing order, lives at Creator Taxes.

Download the free template

Two files, both free:

• creator-income-tracker.xlsx, the full workbook with six tabs and working formulas
• creator-income-tracker.csv, the income log on its own, for apps that only take CSV

The workbook’s tabs:

1. Income log: one row per payout, with date earned, platform, gross amount, platform fee, net payout (calculated), payout date, and the 1099 form you expect.
2. Platform list: YouTube/AdSense, sponsorships, Patreon, Gumroad, Payhip, Lemon Squeezy, Stripe, affiliate programs, and the App Store, with the tax form and payout timing for each where an official page confirms it.
3. Monthly summary: gross, fees, net, expenses, and profit for each month, plus a gross-by-platform breakdown with each source’s share.
4. Tax set-aside: your own percentage, the amount it implies each month, what you actually moved, and the running balance of your tax savings.
5. Expenses: each cost tagged to a Schedule C line from a dropdown, with a business-use percentage and a totals block per line.
6. Read me: the instructions, in case you open the file in six months and forget how it works.

Yellow cells are inputs. Everything else calculates. The formulas were checked by recalculating the file in LibreOffice and comparing every monthly total against an independent recount of the example rows; they matched to the cent. The example rows are invented numbers, marked EXAMPLE, and they are not platform fee rates. Delete them and the summaries drop to zero.

There’s one thing it won’t do. It doesn’t connect to your bank or pull payouts on its own. That is deliberate. A tracker you type into once a month is one you actually understand, and the five minutes of typing is where you notice a sponsor who hasn’t paid.

What to log for every payout

Three money columns matter, and most paid templates collapse them into one.

Gross amount is what the customer or the platform’s gross line says before any cut. Platform fee is what the platform kept: its percentage, payment processing, an app store commission. Net payout is what hit your bank, and the sheet calculates it as gross minus fee.

Why bother with all three? Because the IRS forms are built on gross. The Form 1099-K instructions define box 1a as the gross amount, without adjustment for credits, fees, or refunded amounts. If you log only the deposits, your income will look smaller than the 1099-K, and the gap will be exactly the fees you forgot to write down. The Schedule C instructions add that line 1 should include amounts properly shown on your 1099-NEC forms, and that you should attach a statement if the forms total more than what you report.

So log gross on the way in. Then claim the fees on Schedule C line 10, Commissions and fees. The Expenses tab adds every fee from the income log to its line 10 total automatically, which means you should never type a platform fee into the expenses tab as well.

Here is what four rows look like, using the template’s made-up examples:

Notice the January ad revenue doesn’t arrive until late February. That lag is the reason the log has two date columns.

When each platform actually pays you

I ran a YouTube channel solo for years, and the first lesson AdSense teaches is that the money for a month’s views shows up the following month. That’s fine once you expect it. It is a problem if your spreadsheet only has one date column and you are trying to work out why March looks rich and February looks broke.

Here’s the payout timing for the platforms in the template, taken from each company’s own help pages as of October 2026:

Gumroad, Payhip, Lemon Squeezy, and affiliate programs are marked “confirm” in the template’s Platform list tab rather than filled with guesses. Their timing depends on settings and on which payment processor sits underneath.

Patreon has one more wrinkle worth a column of its own. Its help page says web sales can sit pending for up to 7 days and iOS in-app sales for up to 75 days before they become available. A creator who launches a membership in December can earn in one tax year and see the cash in the next.

That brings up which date counts. Most one-person businesses use the cash method, and IRS Publication 538 says that under it you include income you actually or constructively received during the year. Constructive receipt means the amount was credited to your account or made available without restriction. So the Monthly summary groups income by payout date, not earned date. If you leave a large balance sitting in a platform account over New Year, ask a tax professional which year it belongs to.

Which tax form each income line should produce

The “1099 form expected” column exists so January doesn’t surprise you. Three forms cover nearly everything a creator receives:

• 1099-NEC from a brand or client that paid you for services. For payments made in 2026, the reporting threshold rose to $2,000, per the IRS instructions.
• 1099-K from payment platforms such as Patreon or PayPal. The IRS threshold is more than $20,000 in more than 200 transactions.
• 1099-MISC for royalties of $10 or more. That’s the form Google’s AdSense help page says it issues for US royalty payments.

A missing form changes nothing about what you owe. The IRS says plainly that you must report income whether or not a 1099-K arrives. The column is a checklist, not a filter: in February, sort by it and tick off each form as it lands.

If a sponsor paid you through PayPal, the same dollars can show up on a 1099-K from PayPal and not on a 1099-NEC from the brand. The 1099-NEC vs 1099-K guide covers how to report doubled income once, and YouTube tax forms walks through where each form goes on your return.

The monthly summary and the tax set-aside

The Monthly summary tab needs one input: the year, in cell B2. Every other cell pulls from the logs with SUMIFS formulas that match on payout date for income and expense date for costs. Net payouts minus deductible expenses gives monthly profit, and a running column shows profit for the year to date.

Below that sits a breakdown by platform. If one source carries more than half of your gross, you’ll see it there in a single number. I learned how much that number matters the expensive way: my ebook sold while I paid for ads and stopped the moment I turned them off. Concentration is easier to see in a column than to feel in a bank balance.

The Tax set-aside tab is where most templates hard-code “25%” or “30%” and move on. This one leaves the rate blank on purpose, because the right number depends on your profit, filing status, deductions, and state, and a pre-filled guess quietly becomes the number people trust.

Here’s how to pick yours:

1. Estimate this year’s profit. The Monthly summary’s running total, scaled to twelve months, is a reasonable start.
2. Enter it in the estimated tax calculator, which includes income tax and self-employment tax. If you only want the self-employment piece, use the self-employment tax calculator.
3. Divide the estimated total tax by your expected profit. That decimal goes in the yellow cell.
4. Re-run it whenever income jumps or drops by a meaningful amount.

The tab then multiplies each month’s profit by your rate, with loss months set to zero, and compares it to what you actually moved into tax savings. The gap column is the honest one.

A set-aside is a savings habit, not a tax return. If you expect to owe $1,000 or more when you file, the IRS generally expects quarterly estimated payments, and the quarterly estimated taxes guide has the 2026 dates and the safe-harbor rule. There’s a column for those payments too, so the savings balance stays accurate. If you are also working out how much to pay yourself after tax, the pay yourself guide picks up where this tab stops.

Expenses mapped to Schedule C lines

Every expense row gets a Schedule C line from a dropdown. The labels match the 2025 Schedule C (Form 1040), the latest version on irs.gov when this was written. Check the current year’s form when you file, because line numbers do move: the 2025 form put “Other expenses” on line 27b and gave line 27a to the energy efficient commercial buildings deduction.

The lines creators tend to use most, with the exact form labels:

Where a software subscription belongs depends on the item and on how your tax preparer reads it. The template doesn’t decide for you. It gives you a consistent place to put it and a total per line at year end. For the full list of what’s deductible and the limits on each, see the creator tax deductions map.

The business-use column handles mixed costs. Type 40% next to a phone bill and only 40% of it lands in the totals. Car expenses and the home office are the exceptions; both have their own IRS methods, and the template notes that rather than pretending a percentage covers them.

Import it into Google Sheets

Google’s help page for importing files lists .xlsx and .csv among the supported types, so either download works. On a computer:

1. Open Google Sheets and create a blank spreadsheet.
2. Go to File > Import and pick the downloaded file.
3. Choose an import location. “Create new spreadsheet” opens a fresh copy; “Insert new sheet(s)” adds the tabs to the sheet you have open.
4. For the CSV, leave the separator on automatic detection or set it to comma.
5. Click Import.

Import the .xlsx if you want every tab and formula. The CSV carries only the income log as plain values, which is useful for pasting into another tool or merging with an export from a platform.

After importing, check one thing: the dropdowns. The platform dropdown on the income log reads from the Platform list tab, so add new income sources there first and they’ll appear in the menu.

A 20-minute monthly routine

The template works if it gets fed once a month and fails if it gets fed once a year. Running several businesses solo, I keep that kind of task alive the only way that has stuck for me: a recurring block in Google Calendar, a short checklist, and an AI assistant to do the boring parsing.

The routine, in order:

1. On the first weekday after the 26th, by which point AdSense has paid, export last month’s payout reports from each platform.
2. Paste the rows into Claude or ChatGPT and ask for them as gross, fee, net, and payout date in the template’s column order. Check the totals against the platform’s own report before pasting anything into the sheet.
3. Add the month’s receipts to the Expenses tab and tag each line.
4. Move the set-aside amount to a separate savings account and type what you moved.
5. Save a copy of the file. The IRS default for keeping records is three years, longer in some cases, so each year’s workbook should live on as its own file.

Having worked in finance before going independent, I’d put the most weight on step 2’s check. AI is fast at reshaping a messy export and capable of quietly dropping a row, so the platform’s own total is your control number.

Download the .xlsx, delete the example rows, and enter last month’s payouts tonight, one row per deposit, gross and fee included.