Guides

YouTube brand deal tracker spreadsheet: pitch to paid without losing deals in email

Track YouTube sponsorships from pitch to payment — quoted vs agreed vs paid, outstanding and overdue totals, and follow-up dates — in one spreadsheet built for solo creators.

Published

YouTube brand deal tracker spreadsheet for sponsorship pipeline and unpaid invoices

A YouTube brand deal tracker spreadsheet stops sponsorships from vanishing between your inbox and your bank account. If you pitch brands, negotiate rates, deliver a video or Short, invoice, and then wait — you need one place that shows what is still open, what is late, and what you have actually been paid.

Why email and notes docs fail for sponsorships

A thread that says "invoice sent" is not a pipeline. Without quoted vs agreed vs paid columns, partial payments look like finished deals. Without payment-due dates, you chase the wrong brand first. A dedicated deal log turns scattered emails into numbers you can act on.

Statuses built for YouTube sponsorships

Use a flow that matches how solo creators actually work: Lead → Pitched → Negotiating → Signed → In production → Posted → Invoiced → Paid (or Lost). Generic CRM stages like "qualified opportunity" do not map to "video is live but invoice is 30 days late." YouTube-native statuses keep your sheet honest.

Quoted, agreed, and paid — partials included

Log three money columns: what they first offered, what you agreed, and what has hit your account. Partial payments stay visible instead of marking a row Paid when half the fee is still outstanding. Pair this with deliverable types — dedicated video, mid-roll, Short, mention, package — so you know what you owe before you chase cash.

Dates that drive follow-ups

Track pitch date, deliverable due, go-live, invoice sent, payment due, and next follow-up. The dashboard should surface overdue deals (payment due + still unpaid) before outstanding pipeline (contracted but not yet due). That order saves awkward emails to brands who are not late yet.

Dashboard callouts worth checking weekly

Four top cards do most of the work: total pipeline value, contracted cash still open, cash outstanding (earned but unpaid), and overdue deal count. Decision callouts should literally tell you what to do next — chase outstanding, work follow-up dates, optionally mark rows Logged? when you record the cash in your books elsewhere.

Tracker vs channel P&L — pick one or both

The Brand Deal Tracker is standalone — you do not need a full finance workbook to use it. When you want monthly net profit across AdSense, expenses, and tax summaries, add the Channel P&L spreadsheet guide or get Channel P&L on Gumroad. Many creators start with the pipeline and add P&L once AdSense and costs need one monthly picture.

Creator Ops Brand Deal Tracker (Gumroad)

We published Creator Ops · Brand Deal Tracker v1 on Gumroad: Google Sheets + Excel template, sample data, setup PDF, deal log, dashboard, and outstanding/overdue flags. Instant download, one-time purchase. Get the Brand Deal Tracker.

Related: collaboration outreach for small channels, affiliate marketing without spam, channel P&L vs generic trackers.

Once sponsorships pay off, protect the videos brands sponsor. Try GuardMyVideos trial scans on your highest-value uploads — AI-assisted analysis, not legal advice.

Frequently asked questions

What should a YouTube brand deal tracker track?
Every sponsorship from first pitch through payment: status (lead, pitched, negotiating, signed, in production, posted, invoiced, paid, or lost), quoted vs agreed vs amount paid, deliverable type, key dates, and flags for outstanding contracted cash and overdue payments.
How is a brand deal tracker different from a channel P&L?
A brand deal tracker is a sponsorship pipeline — it shows which deals are moving and which invoices are late. A channel P&L logs all income and expenses for monthly net profit. They complement each other but work standalone.
What counts as outstanding vs overdue?
Outstanding is contracted cash you have earned but not received yet. Overdue means payment was due and is still unpaid — a harder chase signal than a deal still in production.
Do you need a CRM like Notion for YouTube brand deals?
Not necessarily. Solo creators often need a simple deal log with dates and payment status more than a multi-platform CRM. A spreadsheet with YouTube-native statuses beats a notes doc that hides totals.