Tracking Creator Revenue: Read, Reconcile, Find the Gap

You have three numbers for the same month: the one on the platform, the one your agency sends you, and the one that reaches your bank. None of them matches the other two, and nobody has explained why. Tracking creator revenue starts there, not with a chart, but with knowing what each of those three documents counts, which one is authoritative for what, and where the money sits when it is in none of them.

Why do three documents never agree on the same month?

Because they measure different periods and different bases, and one of them is retroactive.

• The platform statement counts sales by the date they happened, including sales that can still be reversed.
• Your agency’s count applies your contract to some base (displayed prices or money net of the platform’s cut), and often over a shifted period.
• Your bank counts transfers by the date they arrived, whatever month the sales behind them belong to.
• Refunds rewrite a month that is already closed. They land as negative lines later.

So there is one rule that saves time. Never compare two of these documents before you have aligned the period and the base. It is only an anomaly if a gap survives both alignments. The vocabulary matters here too, because contracts use it loosely: net revenue and a payout are not the same thing, and neither is the same as gross.

How do you read a platform statement line by line?

By holding three dates apart: the date of the sale, the date the money becomes available, and the date it is transferred. The wording changes between platforms; the mechanics do not.

What you read	What it means	The trap
Gross earnings	The sum of displayed prices	Contains sales that can still be reversed
Fees, commission	The platform’s own cut	Sometimes already deducted from the column, sometimes not
Pending	Sold, not yet available	Not money you hold
Available	Transferable now	A snapshot that changes daily
Refund, chargeback	A sale cancelled after the fact	Usually appears in a later month, as a negative
Payout	What left towards your bank	Dated by the transfer, not by the sales it pays for

Only two of these are worth writing down each month: gross earnings for the closed month, and total refunds. Everything else can be recalculated from those.

Which columns does a reconciliation need beyond a basic tracker?

Fourteen (one row per closed month, per account), the eleven a plain tracker carries plus three that exist only so a gap can be explained: split base, split rate, and prior-period adjustments. Ten of them you copy or label without deciding anything, three are calculated, and the last one exists to name the gap.

#	Column	What goes in it	Where it comes from
1	Period	The closed calendar month	You
2	Account	Platform and handle, if you run more than one	You
3	Platform gross	Sum of displayed prices for the month	Platform statement
4	Platform cut	What the platform took	Platform statement
5	Net revenue	Gross minus platform cut	Calculated
6	Refunds this month	Reversals recorded in the month	Platform statement
7	Prior-period adjustments	Reversals belonging to earlier months	Platform statement
8	Split base	Gross or net, exactly as your contract words it	Contract
9	Split rate	The percentage that applies	Contract
10	Agency commission	Rate applied to the base in column 8	Calculated
11	Agreed deductions	Advances, content costs, promotion you approved in writing	Your own records
12	Creator net due	What should reach you	Calculated
13	Paid out	What actually landed, with date and exchange rate	Bank
14	Variance, named	Column 13 minus column 12, plus the reason	You

Column 8 is the one people skip and the one that decides the year. Column 14 is the point of the whole file. If your agency gives you a view of your own numbers, compare it against this file rather than replacing the file with it. The plain monthly version of these columns is in revenue tracker template.

Where do the gaps between statement and bank actually come from?

From six places. Work down them in this order, cheapest to check first.

1. Period mismatch. Sales from the end of the month are paid in the following one. It is the one cause you can settle with two dates.
2. Base mismatch. The split was applied to gross where you expected net, or the reverse. It repeats every month, always in the same direction, which is how you recognise it.
3. Refunds from an earlier month. A negative line in a month whose sales were normal.
4. Platform schedule and minimum. Money can be earned, available, and still not moving because a threshold or a release delay has not been met.
5. Transfer fees and exchange rate. Small, unavoidable, and worth ignoring below any threshold you set for yourself.
6. Deductions you did not agree in writing. The only item on this list that is a dispute rather than a mechanism.

Causes 1 to 5 are structural: they will recur next month and they are not errors. Only cause 6 needs a conversation, and the way you tell them apart is that the first five can be reproduced from documents you can open yourself.

How do you reconcile a month in six steps?

Read the statement, apply the contract, compare with the bank. In that order, once a month, on a month that has fully closed.

1. Note platform gross and refunds from the statement.
2. Deduct the platform’s cut if the contract says net.
3. Apply the contract’s rate to the contract’s base.
4. Deduct advances and costs you approved in writing, nothing else.
5. Compare with the transfer received, at that day’s rate.
6. Write the difference in column 14 with its cause, or flag it.

A difference of a few dollars either way comes from fees and exchange rates and is not worth raising. A difference that repeats at the same proportion every month is a base problem. See agency commission for how the shares stack.

How often should you look, and at what?

Four cadences, and only one of them takes real time.

Cadence	What you look at	Time it takes	What it is for
Daily	Available balance, nothing else	A glance	Spotting an account problem early
Weekly	Sales by day and by hour	Minutes	Seeing which slots produce
Monthly	The full reconciliation, closed month	The six steps above	Checking, not observing
Quarterly	Trend per account, refund rate	Half an hour	Deciding what to change

The weekly view is the one that changes behaviour rather than just reassuring you. Across a corpus of 38,879 sales, the hour of the day moves conversion sharply: the 2am-6am window collapses it, and evenings maximise it. Your own revenue by hour should show the same shape, and if it does not, that is a genuine finding about your audience. How that translates into when messages get written is covered in managing fan conversations.

What do you do when a gap will not close?

Ask for the line-by-line detail of one named, closed month, in writing, and stop discussing totals until you have it. A statement is justified by dated lines, not by a screenshot and not by a total, and asking is normal, not an accusation: an agency running proper books can produce it in an afternoon.

Three things make that request easy to answer, and they are all in your control: name a single month rather than a period, state the figure you calculated and how, and ask for the same lines you have in your own tracker. If the detail does not exist, that is itself the answer, and it is worth knowing before the relationship gets larger rather than after. Keep your own platform login and your own copy of each closed month’s statement, because the creator dashboard someone else operates is a convenience, while the account in your name is the record.