Monthly Average Revenue per User Formula
Learn how to calculate monthly average revenue per user from gross revenue, refunds, credits, and average active users.
Monthly average revenue per user (ARPU) estimates the net revenue generated by each active user during a reporting month. It helps track monetization consistently by removing refunds, credits, and rebates before dividing revenue across the average active-user base.
- 100% Free
- No Sign-Up Required
- Private & Secure
- Mobile Friendly
Monthly Average Revenue per User (ARPU)
Where:
Subtract revenue reductions from gross monthly revenue to find net monthly revenue. Then divide that amount by the average number of active users for the same month.
Variables Explained
| Variable | What It Means | Unit |
|---|---|---|
| grossMonthlyRevenue - Gross monthly revenue | Total revenue recorded during the month before refunds, credits, and rebates. | currency |
| refundsAndCredits - Refunds, credits, and rebates | Revenue reductions issued during the same monthly reporting period. | currency |
| averageActiveUsers - Average active users | The average number of users considered active during the month under a consistent activity definition. | number |
| netMonthlyRevenue - Net monthly revenue | Revenue remaining after subtracting refunds, credits, and rebates from gross monthly revenue. | currency |
| monthlyArpu - Monthly ARPU | Average net monthly revenue generated per active user. | currency |
Step-by-Step Calculation
Record gross monthly revenue
Start with all revenue recorded for the month before any refunds, credits, or rebates are deducted.
grossMonthlyRevenue
Total revenue reductions
Add the value of refunds, customer credits, and rebates that relate to the same month.
refundsAndCredits
Calculate net monthly revenue
Subtract revenue reductions from gross revenue to calculate the revenue used for ARPU.
netMonthlyRevenue = grossMonthlyRevenue - refundsAndCredits
Determine average active users
Use an average active-user count for the month, based on the same activity definition used in prior periods.
averageActiveUsers
Calculate monthly ARPU
Divide net monthly revenue by average active users to estimate net revenue per active user.
monthlyArpu = netMonthlyRevenue / averageActiveUsers
Monthly ARPU calculation with refunds
Start with gross revenue
grossMonthlyRevenue = 50000
$50,000
Identify revenue reductions
refundsAndCredits = 2000
$2,000
Calculate net monthly revenue
netMonthlyRevenue = 50000 - 2000
$48,000
Divide by average active users
monthlyArpu = 48000 / 1000
$48.00 per user
Final Result
Monthly ARPU is $48.00 per active user, based on $48,000 in net monthly revenue and 1,000 average active users.
Assumptions
- ✓Gross revenue and all refunds, credits, and rebates relate to the same monthly reporting period.
- ✓The active-user definition is applied consistently throughout the month and across comparison periods.
- ✓Average active users reasonably represents the user base exposed to the service during the month.
- ✓Revenue is measured using the business's chosen accounting and revenue-recognition approach.
- ✓The calculation measures revenue per user rather than profitability or cash flow.
Limitations
- !ARPU can change because of differences in the active-user definition rather than changes in monetization.
- !A monthly average can conceal large differences between free, low-spend, and high-spend user groups.
- !Timing of refunds, credits, and revenue recognition can affect reported ARPU between months.
- !The calculation does not deduct operating expenses, user acquisition costs, taxes, or other costs.
- !One month may be affected by seasonal activity, promotions, annual billing, or unusual transactions.
Common Mistakes to Avoid
Using gross revenue in the final division without subtracting refunds, credits, and rebates.
Including users from a different period than the revenue period.
Dividing by ending active users when the user base changed materially during the month.
Changing the definition of an active user between reporting periods.
Using paying users as the denominator while labeling the result as ARPU.
Treating ARPU as profit per user instead of revenue per user.
Related Formulas
Frequently Asked Questions
What is the monthly ARPU formula?
Monthly ARPU equals net monthly revenue divided by average active users. Net monthly revenue is gross monthly revenue minus refunds, credits, and rebates.
How do you calculate net revenue for ARPU?
Subtract refunds, credits, and rebates that relate to the reporting month from gross monthly revenue.
Why use average active users instead of ending users?
An average user count can better reflect the user base across the whole month when users join or leave during the period.
Are refunds included in monthly ARPU?
Refunds are commonly deducted so the result reflects net revenue. The important point is to use the same treatment each month.
Can monthly ARPU be negative?
Yes. If refunds, credits, and rebates exceed gross revenue for the period, net revenue and ARPU can be negative.
Is ARPU the same as revenue per paying user?
No. ARPU uses all active users, while average revenue per paying user uses only users who made a payment.
Ready to calculate your result?
Use the calculator to get instant results with your own inputs.