How I Track 7 Income Streams in One Notion Dashboard

When you're juggling multiple income sources—YouTube ad revenue, book sales, Etsy orders, stock trades, blog work, affiliate commissions, and API subscriptions—it's easy to lose track of what's working. I needed one place to see everything at a glance, so I built a simple Notion dashboard that logs all seven streams and calculates monthly totals automatically.

Here's exactly how I set it up, step by step, so you can do the same.

Why Separate Spreadsheets Don't Work

I used to keep a Google Sheet for each income source. YouTube had its own tab, KDP had another, and my trading journal lived in a different file entirely. Every month I'd open five or six documents, copy numbers into a master sheet, and try to remember which cell formulas I'd broken last time.

The problem wasn't the spreadsheets themselves—it was the friction. When it takes ten minutes to log a $40 affiliate sale, you stop logging. When you can't see your progress toward a monthly goal without switching tabs, you stop checking. A single dashboard fixes both issues.

The Core Structure: One Database, Seven Views

In Notion, I created a single database called "Income Log." Each row is one transaction, and each transaction has a few key properties:

  • Date: When the money came in (or when the platform reported it)
  • Source: A dropdown with seven options—YouTube, KDP, Etsy, Trading, Blog, Affiliate, API
  • Amount: The dollar figure, entered as a number
  • Notes: Optional—what the sale was for, which video earned the ad revenue, or which affiliate link converted

That's it. No complicated formulas yet, just raw entries. I log income as it happens, even if it's $3 from a Kindle sale. The goal is to build a complete picture over time.

Filtering by Source and Month

Notion lets you create multiple views of the same database. I made seven filtered views—one for each income stream—so I can click "YouTube" and see only those entries. I also added a date filter for "this month" on each view, which makes it easy to see how much I've earned from YouTube in March, for example.

To set this up, duplicate your main database view, rename it to the income source, then add two filters: "Source is YouTube" and "Date is this month." Repeat for each of the seven streams.

Auto-Calculating Monthly Totals

At the bottom of each filtered view, I turned on the "Calculate" option for the Amount column and set it to "Sum." Now Notion adds up all the rows automatically. When I log a new YouTube payment, the total updates instantly. No manual formulas, no copy-pasting.

I also created an eighth view called "All Income This Month" with just the date filter. This shows every transaction across all seven sources, with a grand total at the bottom. It's the number I check most often.

Tracking Monthly Goals

I wanted to see progress toward a monthly target without doing mental math. Here's the simplest way I found: add a formula property called "Goal Progress."

First, I set a target—let's say $3,000 per month. In the formula, I wrote something like this: prop("Amount") / 3000 * 100. This calculates what percentage of the goal each transaction represents. Then I turned on the "Sum" calculation for that column, and now the total shows my overall progress as a percentage.

If you want separate goals per income source, duplicate the formula and adjust the denominator. For example, if your YouTube goal is $500, use prop("Amount") / 500 * 100 in the YouTube-only view.

What to Log and When

I log income when it's confirmed, not when I expect it. For YouTube and KDP, that means waiting for the monthly payment report. For Etsy and Gumroad, I log orders when they clear. For trading (which I track for educational purposes only), I log realized gains or losses after I close a position, not while it's open.

Affiliate commissions are tricky because some networks pay 30 or 60 days after the sale. I log them when the commission is approved, not when I eventually get paid. That way, the dashboard reflects what I've actually earned in a given month, even if the cash hits my bank account later.

Reviewing the Data Every Week

Once a week, I open the "All Income This Month" view and scan the list. I look for patterns—did one blog post drive a spike in affiliate clicks? Did a specific Etsy product sell more after I updated the photos? The dashboard doesn't answer these questions automatically, but it makes the data easy to spot.

I also compare the current month's total to the same month last year. Notion doesn't do this natively, but I keep a simple archive view filtered by "Date is last year, same month" and glance at the sum. If I'm up 20%, I know something's working. If I'm flat, I know I need to try something new.

A Faster Option If You Don't Want to Build It

Setting this up manually takes about an hour—longer if you're new to Notion or want to customize the formulas. If you'd rather skip the setup, I built a template called Passive Income OS (Notion) that includes the income tracker, goal calculators, and a few other modules for managing projects and content. It automates the tedious parts so you can start logging right away.

Either way, the core idea is the same: one database, consistent logging, and a view that shows you the total without extra work. The tool matters less than the habit of actually tracking what comes in.

Final Thought

Tracking income across multiple streams isn't about celebrating big numbers—it's about knowing what's worth your time. When you can see all seven sources in one place, you stop guessing and start making decisions based on what's actually working.

Comments

Post a Comment

Popular posts from this blog

A Realistic Faceless YouTube Shorts Workflow for Solo Founders

We have all seen the social media threads claiming you can build a faceless YouTube empire in three clicks using AI. The reality of building a content pipeline as a busy solo founder is much more mundane. It requires reliable code, strict file formatting, and consistent execution. If you want to build a sustainable pipeline that you can actually maintain alongside your day job or main SaaS project, you need a workflow built on robust engineering, not hype. The Core Architecture of a Faceless Short To make video creation repeatable, you must treat your videos like software components. Instead of opening a heavy video editing GUI every time you want to post, break a short down into its raw programmatic assets: a plain text script, an MP3 voiceover, a vertical background video loop, background music, and a SRT or JSON subtitle file. By separating these layers, you can automate the rendering and uploading stages entirely. Step 1: Scripting and Natural TTS Generation A good short is...
Read more

A Realistic Faceless YouTube Shorts Workflow for Busy Makers

You're building a product, writing docs, answering support tickets. You know YouTube Shorts could be a solid content channel, but recording yourself on camera every day isn't realistic. Here's how to build a faceless Shorts workflow that runs on autopilot once you set it up. Why Faceless Shorts Make Sense for Makers Faceless content works when you're teaching concepts, sharing tips, or breaking down processes. Think text overlays on stock footage, voiceover tutorials, or animated explainers. No lighting setup, no makeup, no camera anxiety. The format suits educational content especially well. If you're in dev tools, productivity, design, or any niche where the idea matters more than your face, this approach lets you publish regularly without the friction of traditional video production. The Manual Workflow (Do This First) Before automating anything, run through the process manually a few times. You'll learn what works and what doesn't, and you'...
Read more

How to Auto-Publish to Blogger with AI and API

Many creators overlook Blogger in favor of modern headless CMS options or self-hosted WordPress sites, but it remains a highly stable, completely free hosting option backed by Google. If you want to manage content pipelines without running into server fees or complex database maintenance, Blogger is a surprisingly powerful choice when paired with its official API. By combining automated AI content drafting, structural ad code injection, and a cron scheduler, you can build a highly resilient automated publishing system. The Core Technical Hurdles Building an automation pipeline like this yourself requires solving three specific technical challenges. First, standard LLM outputs are typically formatted in Markdown, but Blogger requires clean, nested HTML to render correctly within its templates. Second, you cannot simply paste ad unit scripts at the absolute top or bottom of an article; they must be programmatically injected into natural breaks within the text. Finally, you must manage Go...
Read more