How to Track Brand Deal and UGC Income as a Creator

Ask a creator with a good year behind them what they earned in March. They open a banking app, scroll, find a platform payout, remember a brand deal invoiced in February and paid in April, forget the affiliate money entirely, and give you a number they don't really believe.

That is not carelessness. Income arrives as a platform payout on a fixed date, a brand fee on net-60, an affiliate balance that only pays above a threshold, a UGC invoice settled whenever the agency runs its batch, and product sales trickling in daily. Five clocks, one bank account.

The fix is two sheets. A deal tracker, one row per deal, alive from first pitch to final payment. A revenue log, one row per payment that actually landed. The tracker is about the future; the log is about the past. Trying to make one sheet do both is what makes it fiddly enough to stop updating.

The income streams to separate

First, fix your stream labels and never improvise a new one mid-year. Six covers almost everyone:

Splitting them is not tidiness. Ad revenue and memberships can be forecast; brand deals are lumpy and can be pipelined; affiliate income lags content published weeks ago. Merged into one total, you cannot tell a good month from one where three slow invoices cleared at once.

Why a deal needs a pipeline, not just an invoice

An invoice appears at the end of a process that started months earlier. If it is your only record, you are blind for the whole stretch when you could still have acted. Give every deal a status from a fixed list, and only move it forward:

• Pitched — you sent a rate; nothing is agreed.
• Negotiating — fee, deliverables or usage are still moving.
• Contracted — signed, and the first status where the money is real enough to plan around.
• Filming / in production — work underway, costs being incurred.
• Delivered — files sent, awaiting approval. Watch this one; it is where deals silently stall.
• Invoiced — the payment clock has started.
• Paid — money received. Now, and only now, it also gets a row in the revenue log.

Two numbers fall out for free. Everything at contracted or beyond is committed revenue, which is what you plan a quiet month around. Everything at delivered or invoiced is work done and unpaid; when that exceeds a month of living costs, chasing beats filming.

The deal tracker columns

One row per deal. These columns earn their place:

• Brand and agency, separately — the agency is who pays you.
• Contact name and email — at renewal this saves an inbox archaeology dig.
• Deliverables as a count and format: "2 × 30s vertical video + 3 stills", not "content".
• Usage rights term, channels and licence start date.
• Exclusivity — the category and the number of months.
• Fee as contracted, before commission, plus commission %.
• Delivery deadline, invoice date, payment terms, due date, paid date.
• Status, from the list above.

Usage rights and exclusivity are part of the price

A brand deal sells two things at once: the work of making the content, and the licence to use it. Log only the fee and you lose money at renewal, because you have no record of what the fee bought. Say you quote $900 for two videos with a three-month organic-only licence. Nine months later: "can we keep running these?" If your tracker says "$900", you will probably quote $900 again. If it says "$900 = production + 3 months organic, no paid ads, no exclusivity", you can see that twelve months of paid social is a far bigger licence than the one you sold, and price it accordingly. Same email, completely different negotiation.

Log exclusivity the same way, with category and end date — you pay for it in deals you are not allowed to take. When you price the renewal, the UGC Rate Calculator stacks production, usage term, paid-ads whitelisting and exclusivity into an itemised quote, which is easier to defend than one round number.

The revenue log: one row per payment received

The second sheet is deliberately dumb. One row per payment that has landed: date received, stream, source, gross, fees or commission deducted, net received, and the deal ID if it is a brand deal.

Log gross and fees separately, even though only the net hits your bank. If an agency invoices $1,200 and takes 20%, record $1,200 gross, $240 commission, $960 net — not one line saying $960. Netting it down understates your revenue and deletes a business expense, and the two errors cancel on the profit line, which is why nobody notices. Platform and marketplace cuts work the same way, and those percentages change and vary by country, so read them off your own statement rather than a memorised figure.

Because every row is tagged by stream and dated by receipt, monthly totals build themselves from a pivot table or two SUMIFS.

Expenses creators forget

Creator expenses hide because most look like ordinary shopping: props for one video, products bought to review, editing software and stock music, lighting, mics and SD cards, travel to a shoot, a share of your phone and home internet, contractor editors, and the commission an agency takes — an expense even though the money never reaches you.

Two rules make this survivable. Photograph the receipt at the till, not later. And add a linked deal column, so props bought for a shoot attach to that shoot. That is what turns a $900 fee into a real margin: $900 in, $140 of props, two days of work.

Setting aside tax on lumpy income

Creator income arrives with nothing withheld, and unevenly — a bad combination for anyone's willpower. The habit that works is mechanical: the day a payment lands, move a fixed percentage into a separate savings account and treat the rest as your income.

Do it on receipt, per payment — a monthly sweep requires you to still have the money at month end, and a payment landing on the 3rd rarely survives to the 30th. Your percentage depends on your country, income level and deductible expenses, so get it from an accountant who knows your situation; the Tax Set-Aside Calculator then applies your number and shows what is left. A savings habit, not tax advice.

Getting paid

Brand and agency contracts tend to set their own payment terms rather than accept yours, and those terms can be long: net-30 and net-60 both turn up, and some contracts count the clock from the end of the month you invoiced in, which quietly adds weeks. Whatever yours says, read the payment clause before you sign and copy the exact wording into your tracker; if the terms are long, ask for a deposit rather than arguing them down.

Three things prevent most late payments. Get the PO number before you invoice, because many large brands cannot pay without one and nobody warns you. Invoice the day you deliver, since the clock starts at the invoice date. And confirm the real accounts-payable address — a marketing manager's inbox is not a payments system.

When something runs late, escalate on a schedule rather than on mood: a nudge a few days after the due date, an email copying accounts payable at two weeks, a firmer note citing the contract's payment terms at four. Work out the real due date and any contractual late fee with the Invoice Due Date & Late Fee Calculator. Assume the delay is administrative rather than hostile until you have reason to think otherwise — that tone keeps the relationship intact and usually costs you nothing.

Gifted product and barter deals

Gifting still belongs in the tracker. Create the deal row as you would for a paid one, set the fee to zero, put the item's stated retail value in a separate non-cash value column, and mark it so it can never leak into your revenue totals.

A gifted collaboration that costs a production day plus $30 of props is a real cost, and six months of these rows tell you whether gifting is a pipeline into paid work or simply unpaid work. Tax treatment of barter varies by country too — if it turns out to matter, the record either exists or it does not.

The monthly review

Ten minutes, the same day each month, three questions:

• Revenue by stream. Which streams are growing, and how concentrated are you? If one brand is 60% of your income, that is a risk, not a win.
• Effective rate per deliverable. Fee minus commission minus linked expenses, divided by deliverables, then by the days it took. A $2,500 deal that ate five days and $300 of props is worse than an $800 one shot in an afternoon.
• Who pays on time. Average days from invoice date to paid date, per brand or agency.

After a year that last column becomes a negotiating asset: you will know which agencies pay within days of the invoice and which take months, and you can price that difference into the next quote.