How to keep track of UGC collabs: briefs, contracts and payments
A simple system for tracking every brand collab: what to record per brand, the statuses that matter, a weekly check, and how to see who owes you.
Oct 22, 2026 · 5 min read
In short
Give every brand one home with its brief, its agreed terms, each deliverable's status and each invoice's status. Track work and money as two separate columns, because a video can be delivered and still unpaid. Then spend 15 minutes once a week going down the list and following up on anything stuck.
On this page
Three brands in your DMs, a contract in your email, a brief in a notes app and a payment you think arrived last week. That is how most creators run their first few collabs, and it works until one brand goes quiet and you can't remember what you agreed. Here is a small system that keeps every collab in one place and tells you what to do next.
What you actually need to track
Just landed your first brand? How to start UGC covers the first rate, agreement and invoice.
Most trackers you can buy or download are long. For a solo creator, five things per collab cover almost every problem:
- The brand and who to talk to. The company name, your contact, and who handles invoices (often a different person).
- The agreed terms. Deliverables, rate, revisions, usage rights, payment terms and the dates. The short confirmation email from how to invoice a brand is the thing to copy in here.
- The brief and the contract. The brief changes the work, the contract protects you. Store the files in one folder per brand and write down where the folder is.
- Work status for each deliverable. Where each video is.
- Money status for each deliverable. Whether it has been invoiced, and whether it has been paid.
The last two are the ones people merge into one column, and that is the mistake. "Done" means you finished the video. It says nothing about whether you can pay rent with it. Keep work and money apart and the gap between them shows you exactly who owes you.
Give every brand one home
Pick one place and put everything about a brand there, not spread over DMs, email and photos of a planner. It can be a spreadsheet, a notes app or an invoicing tool. What matters is that you never have to ask "where did I put that?" for a brand you're working with.
A simple layout for a spreadsheet or notes page: one row per deliverable, with these columns.
| Brand | Deliverable | Rate | Due date | Work status | Invoice status | Follow up on |
|---|---|---|---|---|---|---|
| Glow Co (example) | Video 1, 30s | $250 | Oct 12 | Done | Paid | |
| Glow Co (example) | Video 2, 30s | $250 | Oct 26 | In progress | Not invoiced | Oct 26 |
| Pep Snacks (example) | 4 videos / month | $1,000 | 1st of month | In progress | Invoice sent | Nov 8 |
Many ready-made trackers are built for the other side of the table. One free template, for example, tracks outreach to creators for a brand, with followers, engagement and outreach stages. That is useful if you run a brand, but it has no column for the thing you care about most: whether you got paid.
Use few statuses, and mean them
Too many statuses and you stop updating them. Use these:
Work status
- Upcoming: agreed, not started.
- In progress: filming, editing or in revisions.
- Done: delivered and approved.
Money status
- Not invoiced: nothing sent yet.
- Invoice sent: with the due date next to it.
- Paid.
- Late: past the due date.
The rule that makes the system work: the moment a deliverable moves to Done, its money status must move to Invoice sent. If you find a row that says Done and Not invoiced, that is money you are leaving on the table. Our guide on invoicing a brand says to send it as soon as the work is approved, because the payment clock only starts when the invoice lands.
Write the follow-up date, not just the status
Statuses tell you where things are. They don't tell you when to act. For every row that is waiting on someone else, write the date you will check it:
- A brief you asked a question about: follow up in 2 working days.
- A video sent for approval: follow up in 3 or 4 working days.
- An invoice: the day after its due date (with wording for each follow-up).
A date turns "I should chase that" into a line you will see. If you only remember one habit from this guide, make it this one: nothing waiting on a brand stays without a date.
Retainers need their own line
A monthly retainer is a different shape from a one-off video. It repeats, so track it as a recurring item: the amount, the number of videos covered, the invoice day each month, and how either side can stop. The full setup is in the UGC retainer guide. In your tracker, add one row per month so you can see each month's invoice and videos separately. A month where the videos were delivered but the invoice never went out is easy to miss without it.
Performance deals: track the base and the bonus apart
If a brand pays a base fee plus a bonus on results, give them separate rows. The base fee is a deliverable like any other. The bonus is a row that says what result triggers it, when the brand reports the numbers, and when it is due. That way a bonus that never arrives doesn't hide the fact that the base fee was paid. If a brand offers only commission, read performance-based UGC pay first.
A 15-minute weekly check
Pick a day, say Monday, and go down your list in this order:
- Anything Done and not invoiced. Send the invoice now.
- Anything Late. Send the next follow-up from your list of messages.
- Anything with a follow-up date today or earlier. Send the nudge and set a new date.
- Deliverables due this week. Do you have the brief, the product and the approval you need?
- New enquiries. Add each as a row only once the terms are agreed in writing.
Fifteen minutes weekly beats a panicked hour when a brand goes quiet. It also makes it obvious when you are taking on more collabs than you can finish, before you've promised dates you can't hit.
When a spreadsheet stops being enough
A spreadsheet is a fine start, and for two or three collabs it may be all you need. It starts to creak when you have five or more active brands, when you invoice every month, or when you can no longer tell at a glance who owes you what. Paid trackers help with the layout but still leave you to send each invoice somewhere else and update the status by hand. An invoicing tool that keeps the brand, the work and the invoices together removes that double entry.
Checklist
- Each brand has one home with its contact, terms, brief and contract
- Every deliverable has a work status and a separate money status
- Done always leads to an invoice sent the same day
- Every row waiting on a brand has a follow-up date
- Retainers have a row per month; performance deals have a base row and a bonus row
- You do the 15-minute weekly check on a fixed day
One page per brand, with the work and the money side by side
Each brand gets a page. Every video or deposit is a milestone with a work status (Upcoming, In progress, Done) and an invoice status beside it, and monthly retainers sit on the same page. Notes live on each milestone, and the Clients list shows what each brand still owes you. Reminders aren't built yet, so the weekly check is still yours.
Start for free