Creator Revenue Tracker Template: Columns and Formulas

Most creator revenue tracking is a screenshot of a balance and a rough memory of what landed last month. That works until the month a payout looks light and there is nothing to check it against.

This page is the file itself. Copy the header row, add one row per closed month, type the four formulas once, and you have something that answers the only question that matters: does what arrived match what should have arrived.

What is a revenue tracker template for, and who uses it?

It exists to compare two documents that nobody normally puts side by side: the platform statement and the bank. Everything on the sheet serves that comparison.

• The creator keeps it, because the platform account is in their name and they are the only person who can read the statement without asking permission.
• The manager or agency fills the commission and deductions columns, and gains from doing it: a variance explained the same month is a conversation, a variance discovered a year later is a dispute.
• Whoever handles the books gets a closed month with a source named against every figure, instead of a folder of screenshots.
• Whoever renegotiates the deal has twelve rows showing what the current terms actually produced, which is a stronger position than an opinion.

It is not an accounting system and not a forecast. There is no projection column anywhere on this sheet, on purpose.

What does the complete tracker look like?

Eleven columns, one row per closed month per account, under a header block that records every decision those columns depend on. Start with the header block: it sits above the table so nobody re-derives a base mid-month.

Creator: ______________________    Account handle: ______________________
Currency of the sheet: ______      Platform statement currency: ______
Commission base, in the contract's exact words: ______________________
Commission rate: ____%             Platform fee, as stated: ____%
Payout schedule agreed: ______________________
Variance threshold below which we do not investigate: ______
Sheet owner: ______________  Last month reconciled: ____________

Then the header row. Paste this straight into row one of a blank spreadsheet.

Month | Account | Platform gross | Platform cut | Net revenue | Agency commission |
Agreed deductions | Creator net due | Paid out | Variance | Variance reason

#	Column	Copied or calculated	Where it comes from
1	Month	Copied	The closed calendar month, never an open one
2	Account	Copied	Platform and handle
3	Platform gross	Copied	Statement: sum of displayed prices sold
4	Platform cut	Copied	Statement: the fee line, however it is worded
5	Net revenue	Calculated	Gross minus platform cut
6	Agency commission	Calculated	Rate applied to the base named in the header
7	Agreed deductions	Copied	Only items approved in writing, itemised
8	Creator net due	Calculated	Net minus commission minus deductions
9	Paid out	Copied	Bank, with the transfer date and the rate that day
10	Variance	Calculated	Paid out minus creator net due
11	Variance reason	Written	One clause, or the cell stays flagged

Four formulas, typed once and dragged down:

Net revenue       = Platform gross − Platform cut
Agency commission = base × rate      (base = Net revenue OR Platform gross, header decides)
Creator net due   = Net revenue − Agency commission − Agreed deductions
Variance          = Paid out − Creator net due

And the single-month working, for when you would rather check one month on paper than trust a dragged formula:

Month: ____________   Account: ____________

  Platform gross (statement)                 ____________
− Platform cut (statement)                   ____________
= Net revenue                                ____________
− Agency commission (____% of ____________)  ____________
− Agreed deductions (itemised below)         ____________
= Creator net due                            ____________
  Paid out (bank, ____________, rate ______) ____________
= Variance                                   ____________

Deductions, itemised:  ______________________________________
Variance reason:       ______________________________________

Refunds and reversals get their own small log, because they belong to a month that has already closed and would otherwise silently rewrite a row you reconciled.

Date recorded	Month it belongs to	Amount	Type	Where it appears
______	______	______	Refund / chargeback / adjustment	Which row it was netted into

How do you fill each column?

In one order, once the month has fully closed. Filling out of order is what produces a variance that has to be unpicked backwards.

1. Copy columns 3 and 4 from the statement. Two numbers, nothing interpreted.
2. Let column 5 calculate. Never type over a calculated cell, ever.
3. Check the base in the header, then let column 6 calculate.
4. Fill column 7 only from written approvals, itemised in the log, or leave it at zero.
5. Copy column 9 from the bank, dated by the transfer and at the rate on that day.
6. Read column 10, then write column 11. The reason is the work; the number is the prompt.

Three columns cause every argument. The rest are transcription.

Column	The decision behind it	Get it wrong and
Platform cut	Whether the statement’s earnings figure is before or after the fee	Gross is double-counted or the fee vanishes, and net is wrong in the same direction every month
Agency commission	Which base the rate applies to, word for word	The variance repeats at a fixed proportion and looks like rounding for a year
Variance reason	Whether anyone owns the difference	The column fills with blanks and the file stops being evidence

If the same variance appears at a steady proportion month after month, it is a base problem rather than a fee problem: creator agency commission sets out how the two shares stack, and net revenue is the term contracts use most loosely.

Which three mistakes ruin a revenue tracker?

One column called “revenue”. Collapsing gross and net into a single figure is the expensive mistake, because it hides the base question rather than answering it. Gross and net are different numbers, they diverge every month, and a commission worked out on the wrong one is invisible in a sheet that only records the total.

Plugging the variance. Adjusting a copied figure until the difference reaches zero destroys the file in one edit. Copied cells come from a document or they stay empty. If the variance will not close, that is the finding, not a formatting problem. Ask for the line-by-line detail of one named month, as described in tracking creator revenue.

Rows for open months. A month still running always disagrees with the bank, for reasons that are not errors: a payout is dated by the transfer, not by the sales behind it. Reconcile closed months only, and keep any provisional row below the reconciled ones and clearly marked.

When do you revise it?

Fill it monthly; change its structure rarely, and never mid-year without keeping the old version.

• On the same date each month, once the month has closed, whether or not anything looks wrong. Undated habits stop happening in a busy month.
• When the deal changes. A new rate, a new base or a new deduction rewrites the header block, and the row where that starts should say so.
• When a new account opens. New row, same columns, never a second file.
• When a refund arrives late. Log it, then note in column 11 of the affected row that it was rewritten and when.
• Quarterly, read down column 10 rather than across. A column of small variances in the same direction is a structural finding, and a revenue split discussion is easier to open with twelve rows than with an impression.

Never restructure the columns because one month was awkward. Comparability across rows is the only thing the file has, and it disappears the moment two months mean different things.