How To Calculate Annual Revenue per User in Sage Intacct | Arithmix

Calculating annual revenue per user is an important metric for any business. It helps you understand how much revenue each customer is generating for your company on an annual basis. This information can be used to make informed decisions about pricing, marketing, and customer retention strategies. In this article, we will discuss what annual revenue per user is, when it is valuable to calculate, and how to calculate it.

What Is Annual Revenue per User?

Annual revenue per user, also known as ARPU, is a metric that measures the average amount of revenue generated by each customer over a one-year period. It is calculated by dividing the total annual revenue by the number of active users during that same period. This metric is commonly used by subscription-based businesses, such as SaaS companies, to track the performance of their customer base.

For example, if a SaaS company has 1,000 active users and generates $1 million in annual revenue, the ARPU would be $1,000. This means that on average, each customer is generating $1,000 in revenue for the company each year.

When Is It Valuable To Calculate Annual Revenue per User?

Calculating annual revenue per user is valuable for any business that relies on recurring revenue. It can help you understand the value of each customer and identify areas for growth. Here are some specific situations where calculating ARPU can be particularly useful:

• When launching a new product or service: Calculating ARPU can help you set pricing for your new offering based on the revenue generated by your existing customers.
• When evaluating customer retention: If your ARPU is decreasing over time, it may be a sign that you are losing high-value customers. This can help you identify areas for improvement in your customer retention strategies.
• When analyzing customer segments: Calculating ARPU for different customer segments can help you identify which segments are the most valuable to your business.

How to Calculate Annual Revenue per User

Calculating annual revenue per user is a straightforward process. Here are the steps:

1. Determine the time period you want to measure (e.g. one year).
2. Calculate the total revenue generated during that time period.
3. Count the number of active users during that time period.
4. Divide the total revenue by the number of active users to get the ARPU.

It's important to note that the definition of an "active user" may vary depending on your business. For example, a SaaS company may define an active user as someone who has logged in to the platform at least once during the measurement period.

By following these steps, you can easily calculate your annual revenue per user and use this metric to make informed decisions about your business.

How Do You Calculate Annual Revenue per User in Sage Intacct

Sage Intacct itself isn’t naturally geared towards letting you calculate complex metrics like Annual Revenue per User. As an alternative, teams typically use products like Arithmix to import data from Sage Intacct and build out dashboards.

What is Arithmix?

Arithmix is the next generation spreadsheet - a collaborative, web-based platform for working with numbers that’s powerful yet easy to use. With Arithmix you can import data from systems like Sage Intacct, combine it with data from other systems, and create calculations like Annual Revenue per User.

In Arithmix, data is organized into Tables and referenced by name, not by cell location like a spreadsheet, simplifying calculation creation. Data and calculations can be shared with others and re-used like building blocks, vastly streamlining analysis, model building, and reporting in a highly scalable and easy to maintain platform. Data can be edited, categorized (by dimensions) and freely pivoted. Calculations are automatically copied across a dimension - eliminating copy and paste of formulas.

Arithmix is fully collaborative, giving your entire team access to your numbers and the ability to work together seamlessly.

Calculating Annual Revenue per User in Arithmix

Calculating metrics like Annual Revenue per User is simple in Arithmix. Once you've created your free account, you’ll be able to import your Sage Intacct data, and use it to create natural language formulas for metrics like Annual Revenue per User.

Arithmix is designed to give you the power to build any calculations you want on top of your Sage Intacct data, while also being easy to use and collaborate on. You can share your dashboards with users inside and outside of your organisation, making it easy to empower your whole team.