Rules, tax and records

How to track your posts, codes, sales and earnings (free template)

Free tracker for posts, codes, sales, payouts and expenses, with a UK tax-year column. Opens in Google Sheets, Excel or Numbers, plus a printable version.

By the UGC Creator Partners team · Updated · 5 min read

The short version

  • Track four things: what you posted, which code or link it used, the sales and commission it led to, and every bit of money in and out.
  • Our free tracker comes as three spreadsheets (CSV) and a printable sheet. It opens in Google Sheets, Excel or Numbers.
  • Ten minutes a week is enough: log new posts, copy in sales from each dashboard, file payout statements and receipts.
  • Good records answer two questions: what content actually sells? and what do I need to declare for tax?

Most new creators track nothing until a tax form or a missing payment forces them to. A simple log from day one saves you that scramble, and it tells you something even more useful: which of your posts actually make money. Here's a system that takes about ten minutes a week, and a free template to run it.

What to track (and why)

TrackWhat to noteWhy it helps
PostsDate, platform, link, brand, format, hook, whether it was labelled as an adShows which formats and hooks lead to sales; proves you labelled ads correctly
Codes and linksWhich code or link each post used, where it was placed (caption, bio, on screen)Different programmes, different codes; easy to mix up
Sales and commissionOrders, commission, status (on hold, available, paid) from each programme's dashboardYou can check every payout adds up
Money in and outEvery payout, fee, brand payment and gifted item; every expense with a receiptTax records and a real picture of your profit

Download the free creator tracker

Three spreadsheets and a printable version. Each spreadsheet has an example row to show you how it works: delete it and start logging.

Posts and sales logDate, platform, link, format, hook, code, #ad check, views, taps, orders, commission

Download CSV

Income and expenses logPayouts, brand fees, gifted items, kit and other costs, receipts, tax year

Download CSV

Brand deals and pitchesWho you pitched, follow-ups, deliverables, fees, usage rights, invoices

Download CSV

Printable tracker (A4)All three logs on paper, or saved as a PDF from your browser

Open printable

How to open the files

  • Google Sheets: File → Import → Upload, choose the CSV, then "Insert new sheet". Do this once for each file and you'll have three tabs in one spreadsheet.
  • Excel: open the CSV, then File → Save As → Excel Workbook (.xlsx) so your formatting and formulas are kept.
  • Numbers (Mac/iPhone): open the CSV directly; Numbers converts it.

Add running totals. In the posts log, put =SUM(M2:M200) under the Commission column; in the income log, use =SUMIF(B2:B500,"Income",G2:G500) and =SUMIF(B2:B500,"Expense",G2:G500) to total money in and out. (In some countries Excel uses semicolons instead of commas in formulas.)

A ten-minute weekly routine

  1. Log the week's posts. One row per post, with the link and the hook you used. Tick whether it had #ad up front.
  2. Update the numbers on last week's posts. Views after seven days are a fair like-for-like comparison.
  3. Copy in sales from each dashboard. Orders, commission and status. Note any refunds.
  4. File any payouts. Add each one to the income log with its reference, and save the PayPal or Wise statement.
  5. Snap your receipts. Kit, props, apps, postage: photo or PDF into one folder, one row each in the log.
  6. Write one line of "next time". What worked, what didn't, what to test next week.

Tracking UGC Creator Partners sales

Your dashboard already lists every order made with your code: the date, brand, what was ordered, what the buyer paid, the profit, your rate, your commission and its status, plus your payouts with their references. A few things to know when you copy it into your tracker:

  • On hold means the order is inside the 30-day return window; Available means it counts towards your payout; Paid means we've sent it.
  • You can request a payout from £40 available. Each payout has a reference: put it in your income log so you can match it to the PayPal or Wise statement.
  • We pay in pounds. If your PayPal or Wise account converts it, record both the pounds we sent and the amount that arrived in your currency.
  • If an order is refunded after you've been paid, the difference comes off your next payout. Log it as a negative line so your totals stay right.

New to the programme? See how it works, step by step.

Working out which posts actually sell

A discount code tells a brand the order was yours, but not which post it came from. To get a useful picture anyway:

  • Line up order dates against post dates in your tracker. Sales usually cluster in the day or two after a post that worked.
  • Change one thing at a time (the hook, the format, where you put the code) and compare like with like.
  • Ask! "Which video brought you here?" in a comment or story gets honest answers.
  • Watch the ratio of taps to orders: lots of taps and no orders can mean the audience isn't in the shop's delivery area (The Jigsaw Atlas is UK only).

Records you'll want at tax time

Wherever you live, creator income usually has to be declared, and gifted products can count too. Keep:

  • every payout statement (PayPal, Wise, bank) and a copy or screenshot of the matching sales from each programme's dashboard;
  • invoices you've sent to brands and their payments;
  • a list of gifted items with dates and approximate value;
  • receipts for anything you bought for your content.

How long? In the UK, HMRC asks Self Assessment filers to keep records for at least 5 years after the 31 January filing deadline. In the US, the IRS generally says three years from filing, and longer in some cases. More in our UK and US tax basics.

Common questions

Is the tracker really free?

Yes. No sign-up or email needed: download the CSV files or print the sheet and use them however you like.

Can I see which post a sale came from?

Not exactly, with any code-based programme: a code tells us the order was yours, not which video it came from. Compare order dates with your post dates in the tracker and you will usually see which posts moved the needle.

What is the difference between "on hold" and "available"?

Commission from UGC Creator Partners is on hold for 30 days after each order, the window in which a buyer can cancel or return. After that it becomes available and counts towards your £40 payout minimum.

Should I record gifted products?

Yes, note what you were sent, the date and roughly what it would cost to buy. Gifts given in return for content can count as income for tax, so it helps to have the list. See our UK and US tax guides.

Do I need accounting software?

Not at the start. A spreadsheet is fine for most small creators. If your income grows, or you fall under Making Tax Digital in the UK, look at software that connects to HMRC.

General information, not tax or financial advice. Rules on records differ by country; check HMRC or the IRS, or talk to an accountant, about your own situation.