Spreadsheet to Track YouTube Ad Revenue, Sponsorships, and Affiliate Income in One Place

Here’s a question most creators can’t answer without twenty minutes and four browser tabs: how much did your channel actually make last month?

Not your AdSense number. Your total. AdSense plus that sponsor who paid net-30, plus the affiliate commissions sitting in three different network dashboards, plus channel memberships, plus the Super Thanks from your last upload. The real figure — the one that tells you whether this is a hobby or a business — lives nowhere. It’s scattered across platforms that each show you one slice and none of them add up.

That’s the core problem with creator income. It doesn’t arrive from one place, it doesn’t arrive on one date, and no dashboard was built to total it for you.

Why One Number Is So Hard to Get

A monetized channel typically earns from six streams, and every one of them reports somewhere different.

AdSense shows in Google AdSense and finalizes about a week into the following month. Sponsorships arrive as invoices you send and chase, usually paid net-30 or net-60. Affiliate commissions sit in each program’s own portal — Amazon here, a SaaS partner there — each with its own payout threshold and schedule. Merch, memberships, and Super Thanks appear inside YouTube but on separate reports. Pull one number from each and you’ll spend half an hour reconciling pay dates and currencies before you have a total you trust.

So most creators don’t. They glance at AdSense, call that “what YouTube pays,” and quietly ignore the fact that for many mid-size channels the brand deals and affiliates are the larger half of the income. You can’t grow what you don’t measure, and you can’t measure income you never assemble in one place.

The One Thing AdSense Won’t Tell You: Your Real Mix

Diversification is the single most repeated piece of advice in the creator economy, and for good reason — ad revenue alone is volatile, seasonal, and entirely at the mercy of advertiser demand. But “diversify your income” is meaningless if you can’t see your current mix.

Is AdSense 70% of your income or 30%? If one sponsor disappeared tomorrow, how big a hole would it leave? Is your affiliate income actually growing, or does it just feel like it because one good month stuck in your memory? These are the questions that decide where you spend your next month of effort, and every one of them requires the same thing: your income, broken out by source, month over month.

A revenue breakdown that does this turns vague ambition into a decision. If sponsorships are 15% of your income and climbing while AdSense flatlines, you know to send more pitches. If affiliates are a rounding error despite the links in every description, you know that experiment isn’t working. The mix is the strategy — you just have to be able to see it.

What Tracking Income By Source Actually Looks Like

The structure is simple and it’s the same one a small business would use: months down the side, income sources across the top, totals and month-over-month change calculated automatically.

Each month you enter what landed from each stream. The sheet totals the row, so you get your true monthly income at a glance, and it calculates the percentage change from the prior month so you can see momentum instead of guessing at it. Over a year you build something no platform will ever hand you — a clean picture of which streams carry your channel, which are growing, and which are quietly dead weight.

It’s also the difference between knowing your RPM and knowing your business. RPM tells you what 1,000 views are worth in ad revenue; it says nothing about the sponsor income those same videos attracted or the affiliate sales they drove. Real creator economics only show up when every stream sits in one table.

The YouTube Channel Analytics & Revenue Tracker is built around exactly this. Its Revenue Breakdown tab logs monthly income across AdSense, sponsorships, affiliates, merch, memberships, and Super Chats, totals each month, and shows the percentage change — so your income mix stops being a mystery and becomes a chart you can act on.

Don’t Forget the Other Half: Expenses

Income is only one side of a channel business. Editing software, thumbnail design, music licensing, camera gear, that studio corner you rent — these are real costs, and for a self-employed creator they’re also potential tax deductions. A revenue tracker that ignores expenses tells you your gross, never your profit.

Logging expenses by category as you go does two jobs at once: it shows you what your channel actually clears after costs, and it means that when quarterly estimated taxes come due, your deductible expenses are already sorted instead of being reconstructed from a shoebox of receipts in April.

From Scattered to Settled

You don’t need a bookkeeper or accounting software to run a channel like a business. You need one place where AdSense, brand deals, affiliate commissions, memberships, and expenses all live together, total themselves, and show you the trend.

Once your income has a single home, the questions that used to take twenty minutes and four tabs take four seconds. And a creator who can answer “how did my channel do last month?” instantly is a creator who’s actually running the business, not just feeding it.