How to Run a Monthly OnlyFans Revenue Audit (With a Leakage Worksheet)

How to Run a Monthly OnlyFans Revenue Audit (With a Leakage Worksheet)

How to Run a Monthly OnlyFans Revenue Audit (With a Leakage Worksheet)

Monthly OnlyFans revenue audit worksheet showing subscription income, PPV sales, tips and potential revenue leaks.

Why a total is the least useful number you have

Most creators check one figure: the month's total. It goes up, they feel fine. It goes down, they panic and change everything at once. Both reactions come from the same mistake. A total is the sum of several separate engines, and each engine can rise or fall for a different reason.

A monthly revenue audit is a short, repeatable review that pulls the total apart. It takes about an hour. It tells you which stream moved, which stage of the fan journey weakened and which single change deserves your next two weeks. It does not require special software, and it does not require an agency. You need your own statements, a spreadsheet and a willingness to write down numbers you may not enjoy.

This guide gives you the full process and a worksheet you can copy. It is a method, not a benchmark. No source reviewed for this article establishes a normal conversion rate, a normal renewal rate or a normal month for a creator, so every figure below is an illustration with its assumptions visible. If your total has already fallen and you want a broader diagnosis, our guide on subscriptions versus messages explains how the two main revenue streams behave differently, and this audit is the routine that keeps you from needing an emergency diagnosis in the first place.


Step one: build a clean baseline

Before you analyze anything, fix the period and the source. Use calendar months so that comparisons are like for like, and pull the numbers from your own account statements, not from memory or from a screenshot someone sent you.

Record these figures for the month:


Line

What to record

Gross subscriptions

New subscriptions plus renewals, before any fee

Gross messages

Pay to view sales and paid message income

Gross tips

Tips on posts and in messages

Other gross

Anything else the platform reports

Platform fee

The deduction the platform takes, taken from your statement

Agency or manager fee

If you pay one, the amount and the base it was calculated on

Other costs

Editing, software, paid promotion, props, chatters

What you kept

Gross less every deduction above


Check the current platform fee in the platform's own terms. This article uses 20 percent in its illustrations only because it keeps the arithmetic simple, and you should not treat it as the live rate.

Then add the previous two months beside this one. A single month is noisy. Three months show a direction. If you have more history, keep adding columns. The habit of recording the same lines in the same order every month is more valuable than any one number.

Here is a fictional creator, used throughout this guide. Call her Mara. Her last three months look like this.


Line

Month 1

Month 2

Month 3

Gross subscriptions

$2,600

$2,500

$2,150

Gross messages

$2,900

$2,700

$2,400

Gross tips

$400

$350

$300

Total gross

$5,900

$5,550

$4,850


Her total fell from $5,900 to $4,850, a drop of $1,050. That is about 18 percent. The total alone says she has a problem. It does not say where.


Step two: split the drop by stream

Subtract each stream from the month before. For Mara, between month 1 and month 3:

Subscriptions fell by $450. Messages fell by $500. Tips fell by $100.

That already changes the conversation. Subscriptions and messages fell by almost the same amount, so this is not simply a message selling problem or simply a subscriber problem. When both streams move together, the likely cause sits upstream, in how many people are arriving or how many are staying. When only one stream moves, the cause sits inside that stream.

A rule of thumb that follows from the arithmetic: if messages fall while subscription income holds, look at what you are offering and how it is priced. If subscriptions fall while message income per fan holds, look at traffic and renewals. If both fall together, count fans first.

The same guide explains why these two streams respond to different levers, and it is worth reading beside this worksheet.


Step three: count the fan journey

Revenue is people multiplied by value per person. To see which factor moved, count the people. Pull these numbers for the month:

New subscribers. Renewing subscribers, meaning those who were active last month and stayed. Expired subscribers, meaning those who were active last month and left. Fans who bought at least one paid message. Fans who bought nothing but a subscription.

You may not be able to pull every figure directly from your dashboard. Mark anything unavailable as unavailable, and do not fill the gap with a guess. A blank you admit to is more useful than a number you invented.

Mara's counts, again illustrative:


Count

Month 1

Month 3

New subscribers

180

120

Active at start of month

310

300

Renewed

215

205

Expired

95

95

Fans who bought a paid message

140

128


Look at what the counts reveal. Expiry was identical at 95 in both months, so churn did not get worse in absolute terms. New subscribers fell from 180 to 120, a loss of 60 people. That one line explains most of the subscription decline. Her retention is about the same as before, so the pressure is at the top of the funnel.

Now divide to see the shares. Month 1 renewal share was 215 out of 310, which is about 69 percent. Month 3 was 205 out of 300, which is about 68 percent. Essentially flat. If she had spent that month rewriting her renewal messages, she would have solved a problem she did not have.

This is the central discipline of the audit. Let the counts choose the fix. Keep raw counts beside every percentage, because a rate on its own can mislead. A change from 12 percent to 15 percent sounds large, and it means something very different if it is 36 out of 300 versus 3 out of 20.


Step four: measure value per fan

Next, check whether the fans you do have are worth less than before. Divide each stream by the relevant fans.

Message income per active fan is messages revenue divided by active fans. For Mara in month 1, that is $2,900 divided by 310, about $9.35. In month 3 it is $2,400 divided by 300, which is $8.00. A fall of about $1.35 per fan, around 14 percent.

Message income per buying fan is messages revenue divided by fans who bought. Month 1 is $2,900 divided by 140, about $20.70. Month 3 is $2,400 divided by 128, about $18.75. Buyers are slightly fewer and each is spending slightly less.

Put together, Mara's message decline has two sources. About 12 fewer buyers, and a lower average spend per buyer. Neither is dramatic. Together with the loss of 60 new subscribers, they explain the whole $1,050.

Try the same split for yourself. Which of these three is yours: fewer people arriving, fewer people staying, or less value from the people who stay? Most months, one of the three dominates. Occasionally two do. Rarely are all three moving at once, and when they are, something larger has changed, such as a long absence, a platform change or a shift in your content.

Our guide to selling more PPV without spamming goes deeper on the value per buyer problem, and our article on why subscribers do not renew covers the retention side.


Step five: find the leaks, not just the losses

A loss is a number that went down. A leak is a place where value is escaping that you could plug. They are not always the same thing. Walk through this list and note anything that applies.

Unrenewed audience. Fans whose subscription lapsed and who received no message, offer or reason to return.

Unanswered messages. Fans who wrote and waited. Check your response time on the messages that were most likely to lead to a purchase.

Unsold content. Items sitting in your vault that were never offered, or offered once and never again, to fans who might want them.

Mispriced content. Offers that sell out instantly, which may be priced too low, and offers that nobody buys, which may be priced too high or described badly.

Fee drag. Costs you stopped noticing. Software you do not use, editing you no longer need, a percentage fee applied to a base you did not expect. Our guide on what an OnlyFans agency costs shows how far gross and retained income can diverge when fee bases differ.

Untracked traffic. If new subscribers fell, do you know where the previous ones came from? If you cannot say, that is itself a leak, because you cannot protect a source you cannot see.

Write each leak as a sentence with a number where you have one. "Roughly 95 lapsed fans received no win back message" is useful. "Retention could be better" is not.


Step six: choose one fix and one test

The most common audit failure is choosing six fixes. Pick one, because you cannot tell what worked if you changed everything.

Use a simple ranking. For each leak, estimate three things: how many dollars it could plausibly recover, how much work the fix takes and how quickly you would see a result. Then choose the leak with the best combination.

For Mara, the biggest driver was 60 fewer new subscribers. Suppose she estimates that restoring even half of that, 30 subscribers at an average first month value of $12, would recover $360 a month. That is real money, and it depends on traffic work that takes weeks to show. Meanwhile, the buyer spend drop of $1.95 per buyer across 128 buyers is about $250 a month and might respond to an offer rewrite within a week.

Neither is wrong. The point is to decide deliberately, write the reasoning down and set a review date. A reasonable format is one line: "This month I will do X, expecting Y, and I will check it on date Z." Our guide to what makes OnlyFans traffic actually work is a good companion if your leak turns out to be arrivals.


The copyable worksheet

Paste this into a spreadsheet and fill it in on the first weekend of each month.


Section

What you fill in

Period

Calendar month and the two months before

Gross by stream

Subscriptions, messages, tips, other

Deductions

Platform fee, agency fee if any, other costs

What I kept

Gross less deductions, with the percentage of gross

Movement by stream

Change in each stream against last month

People counts

New, renewed, expired, buyers, non buyers

Rates with counts

Renewal share and buyer share, with raw numbers beside them

Value per fan

Messages per active fan, messages per buyer

Biggest driver

Fewer arrivals, weaker retention or lower value per fan

Leaks noticed

Sentences with numbers

One fix

What, why and expected effect

Review date

When I will check the result

Unknowns

Anything I could not measure this month


Keep every month's copy. After three or four months you will see patterns you could not see from memory: a seasonal dip, an effect of a price change, the delay between a traffic push and a renewal bump.


When the audit says it is not your tactics

Sometimes the worksheet shows nothing fixable. Your retention is steady, your value per fan is steady, and arrivals are down because you posted less during a stretch of poor health, travel or burnout. That is a legitimate finding. The right response may be rest and a slow restart, not a new funnel. We cover that situation in our guide on reviving an account after a slow month.

Sometimes the audit shows a problem that is real but bigger than your available hours. You can see that you need steady chatting coverage, or traffic work you cannot sustain alongside filming. That is the point at which outside help is worth pricing, and our guide on whether you need a manager or just a chatter lays out the options.

And sometimes the honest conclusion is that you should do nothing different. A month that is down 6 percent after a record month, with counts that look normal, is variation. Chasing variation with new tactics is a good way to create a real problem. If your three month direction is flat or rising, keep auditing and keep your changes small.


Common audit mistakes

Auditing after the fact only when things are bad. The audit is most useful in good months, because it records what a healthy month looks like and gives you a baseline for later comparison.

Mixing gross and net. Compare gross with gross and kept income with kept income. A rise in gross with a fall in what you kept is its own finding.

Ignoring timing. A subscription bought late in the month may appear mostly in the next. If your numbers jump between months for no clear reason, check the dates.

Trusting a rate with a tiny count. Eight buyers out of fifty is a result, and the next month may look completely different because three people were away.

Crediting yourself or anyone else by default. If you cannot attribute a rise to a cause, label it unknown. This is also the standard to hold anyone else to who reports on your account, and our guide on what a good agency report includes explains it.


Revenue audit questions

How often should I run a revenue audit? Monthly is enough for most creators. A short weekly look at new subscribers and message sales helps if you are testing something, but the full audit is a monthly habit.

What if my dashboard does not show every number? Record what it does show and mark the rest unavailable. You can still audit streams, totals and what you kept. Over time you can build your own tracking for the missing pieces, such as a note of where each traffic push was posted.

Should I include costs like editing and promotion? Yes. Revenue without costs is a vanity figure. What you kept after every cost is the number that pays for your life.

Is this the same as hiring an agency to audit my account? No. You can do this yourself. An outside review adds a second pair of eyes and perhaps knowledge of other accounts, but the method here is the same one anyone would start with.

What if the audit shows everything is fine but I still feel stuck? Then the issue may be growth ambition and not leakage. Look at your targets, your available hours and whether the account supports the income you want. That is a different conversation from a leak.


If you want a second pair of eyes

Run the worksheet on your own three months of numbers first. It gives you a baseline that makes any conversation about outside help far more useful. If you decide you want a management team to take the work on, you can apply to FameU and be considered. Whoever you speak to, judge them by whether they start from your counts, not from a pitch.

Circle Shape
Circle Shape