Free Brand Deal Tracker Template (Google Sheets & Excel) + the Fields to Track

Published Updated

Illustration of handshake and chain-link icons connected by a stream of icons to a stack of gift boxes

Summary

6-8 min read

AI Generated

A free brand deal tracker template for Google Sheets, Excel, Numbers or Notion, with one column per thing you need to know about a deal, from the first email to the day you're paid, and what each column is for.

Key points

  • Download the Excel file (dropdowns and an Overdue column) or the plain CSV
  • Keep deal status and payment status in separate columns: done is not paid
  • A Pay by date per deal is what turns a list into something you can chase
  • Copying emails into rows is the part a spreadsheet can't do for you

A brand deal tracker is one row per deal and one column per thing you'd otherwise have to dig out of an email thread: what you owe, by when, for how much, and whether the money has arrived. Here is a template you can copy, then what each column is for and how to keep it honest.

Download the template

Free, no sign-up. Two example rows show how to fill it in; delete them when you start.

  • Google Sheets: File > Import > Upload, pick the .xlsx file, then "Create new spreadsheet". The dropdowns and the Overdue column come with it.
  • Excel or Numbers: open the .xlsx file directly.
  • Notion: Settings > Import > CSV (or type /csv on a page). Each column becomes a property; switch Status, Deal type and Payment status to Select.

The columns, and what each one is for

Every column answers a question a brand, your accountant or future you will ask. If you never need the answer, delete the column; a tracker with fewer columns you actually fill beats a long one you don't.

The deal

BrandThe company paying you, not the agency that wrote to you (put that in Notes).
Contact emailThe address that will answer about this deal. Brands often switch people mid-deal.
Deal typePaid, Gifted or Commission. It decides which money columns matter for the row.
StatusWhere the deal is: Pending, Emailed, Shipped, Received, Filming, Approval, Done or Lost.

What you get

FeeThe agreed flat fee. Leave it empty on a gifted deal, not 0.
Product valueThe retail price of what they send. Useful at tax time and when you price the next ask.
Commission %Your rate on affiliate or TikTok Shop sales, if any.
Discount codeThe code your audience uses, so you can quote it in captions.

What you owe

DeliverablesEach piece of content in one line: platform, format, count ("1 Reel, 3 Story frames").
Hashtags & mentionsExactly as the brief asks, including the disclosure tag.
Next to-doThe date of your next step (script, filming, draft), which is rarely the deadline.
DeadlineWhen the content is due to the brand or due to go live.
Usage rightsWhere and how long the brand may use the content: organic only, paid ads, 30 days, perpetual.
ExclusivityWhich competitors you can't work with, and until when.

Getting paid

Payment termsIn words, from the contract: "Net 30 from invoice", "50% upfront".
Invoice sentThe day you sent the invoice. Net terms count from here.
Pay byThe date the brand must pay by: the invoice date plus the terms, or the date the contract names.
Payment statusUnpaid, Invoiced, Paid or Issue.
Paid onWhen the money arrived.
Overdue?Fills itself in the Excel file: a Pay by date in the past on a deal not marked Paid.

Paper trail

Tracking numberFor product you're waiting on, so you know when to chase.
Brief or contract linkOne link to the document you agreed to. Disputes are settled by what it says.
NotesAnything that doesn't fit: the agency, revision rounds, what went well.

Status: one stage per step, in order

The Status dropdown follows a deal from the first email to the end. Each stage is something you can check, not a feeling:

  1. Pending: a brand wrote; you haven't answered.
  2. Emailed: you replied or pitched, and you're waiting on them.
  3. Shipped: the product is on its way (fill in Tracking number).
  4. Received: it arrived.
  5. Filming: you're scripting, filming or making changes they asked for.
  6. Approval: the draft is with the brand.
  7. Done: delivered and approved, or posted.
  8. Lost: it fell through. Keep the row: it's how you'll remember the brand next time.

Payment has its own column because it runs on its own clock. A deal paid 50% upfront is part paid while you're still filming; a Done deal on net 60 terms stays unpaid for two months. Filter on Payment status, not Status, when you chase money.

The overdue flag

The Excel file's Overdue? column shows "Overdue" on any row whose Pay by date has passed while Payment status isn't Paid. Using the CSV? Add a column after Paid on and paste this into its second row, then fill it down:

=IF(AND(Q2<>"",Q2<TODAY(),R2<>"Paid"),"Overdue","")

Q is Pay by and R is Payment status in the template; change the letters if you moved columns. Sort by that column once a week and you have your chase list. Chasing starts with a clear invoice: the free invoice generator puts your payment terms where the brand's accounts team will see them.

Keeping it up to date

  • Update the row when the email arrives, not at the end of the week. A brand that changes the deadline in a reply is the row most likely to be wrong.
  • Sort by Next to-do every morning, and by Pay by once a week. Those two sorts are the whole point of the sheet.
  • Write dates as YYYY-MM-DD so every app sorts them the same way.
  • Link the brief, don't paste it. The Brief or contract link column should point at the version you agreed to. Not sure what a brief should settle before you say yes? Run it against the brand deal checklist.

Where a spreadsheet stops working

A sheet does what you type into it. With a handful of deals that's fine. The trouble starts when each new brand email means ten minutes of copying a fee, a deadline and a list of deliverables into the right cells, and a missed reply means a wrong row.

That copying is what Collabed does for you. Forward the brand's email and it becomes a deal with the brand, fee, deadline, deliverables and hashtags filled in; the free plan includes 3 AI extractions. From there the deal moves across a board with the same stages as the template, the calendar shows deadlines and to-dos, and the Payments page lists every unpaid deal with its pay-by date, overdue ones in red. A contract scan reads the payment terms out of the brief, and the deal page makes the invoice PDF. A side-by-side with spreadsheets goes through the rest.

Keep the template if it works for you. It's built on the same fields, so moving over later means forwarding emails, not rebuilding columns.

Frequently Asked Questions

Is the brand deal tracker template free?

Yes. Download the Excel file or the CSV, no sign-up. The Excel file has dropdowns for status, deal type and payment status and an Overdue column; the CSV has the same columns as plain values.

How do I use the template in Google Sheets?

Open Google Sheets, then File > Import > Upload, and pick the .xlsx file. Choose "Create new spreadsheet". The dropdowns and the Overdue formula come with it.

Can I use it in Notion?

Yes. Import the CSV (Settings > Import > CSV, or type /csv on a page). Notion turns each row into a database item and each column into a property. Set Status, Deal type and Payment status to Select properties afterwards.

Why are deal status and payment status separate?

Because finishing the work and getting paid happen weeks apart. A deal can be Done with the invoice still unpaid, or paid upfront before you film. One column for both hides exactly the deals you need to chase.

When should I stop using a spreadsheet?

When copying details out of emails takes longer than the deal work, or when a deadline or payment slips because a row wasn't updated. Under about ten live deals a sheet is usually fine.

Sources

Or forward the email and let Collabed fill it in.

Paste or forward a real brand email and watch it become a deal: brand, fee, deadline and deliverables, no account needed.