A YouTuber's sheet needs two halves: a list of every income stream, because they arrive in different ways, and a list of costs per video or per channel. Sponsorships, platform payouts and affiliate commissions each behave differently, so tag them separately. That makes it clear which stream pays for the channel and which costs belong to which video.
What are the income streams to separate?
- The platform's own payout, which arrives in a lump after its calculation period.
- Sponsorships and brand deals, billed by you or paid through an agency.
- Affiliate commissions, which arrive in small amounts from different programmes.
- Memberships, tips or merchandise, if you have them.
- Free products or services you receive for a review, which are not money but are worth noting with an approximate value.
Which costs belong to the channel?
| Category | What goes in it | Often missed |
|---|---|---|
| Gear | Camera, lenses, mics, lights, tripods | Accessories bought by UPI at a market |
| Editing | Editor, thumbnail designer, scriptwriter | Cash payments to a friend who helped |
| Software | Editing and audio tools, subscriptions | Annual plans |
| Sets and props | Backdrops, products used on camera | Items bought for a video and reused |
| Studio or room | Rent share, power, internet | The home share nobody calculates |
| Travel | Cabs, trains, hotels for shoots and collabs | Collab travel paid by someone else |
| Music and assets | Stock music, sound effects, footage | Licence receipts |
| Promotion | Paid boosts, giveaways | Giveaway postage |
What does a hypothetical month look like?
Say the platform pays ₹38,000, a brand pays ₹60,000 for a sponsored video, and affiliate links bring ₹7,000. Income is ₹38,000 + ₹60,000 + ₹7,000 = ₹1,05,000. Costs: editor ₹16,000, thumbnail designer ₹4,000, props ₹5,500, travel ₹4,200, stock music ₹1,500, software ₹2,400 and a room-rent share of ₹8,000. Together that is ₹41,600, leaving ₹63,400. Without the sponsorship, income would be ₹45,000 and the same costs would leave only ₹3,400, which tells you how dependent the month was on one deal.
How do I tag costs to individual videos?
Give each video a short code such as the topic and upload date, and put it in the note of every related cost: the editor's fee, the props, the music licence. After a few months you can compare what a typical video costs against what it brings through ads, affiliates and sponsors. You will probably find that a few videos carry the channel.
What about gifts and products received?
Make a separate list with the date, brand, product and your estimate of its value, and ask your CA how such items should be treated. Whether they count as income is a tax question and the answer can change, so do not guess. A simple list kept through the year is enough to start that conversation.
Payout timing is another reason to track carefully. Platform payments typically cover an earlier period and arrive later, sponsorship payments follow the brand's own approval cycle, and affiliate commissions can show up weeks after the sale. If you only look at the bank balance, a good video can look like a bad month and the reverse. Write the period each credit relates to, as well as the date it arrived.
A monthly routine
- Record every credit and name its stream.
- Tag costs by category and video code.
- List brand payments pending, with the invoice date.
- Add cash items, such as small payments to helpers or props from a market.
- Note anything received free, with an approximate value.
If you want to avoid retyping bank lines, SpendixAI lets you upload the statement, review the rows, and keep the channel account separate from your personal one.
Once a quarter, rank your last ten videos by what they brought in, then by what they cost. The two lists are rarely the same.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

