The Revenue Details dashboard shows total revenue and revenue for any selected period, broken down by each recorded fee.
All data presented does not include taxes.
Before you start
Dashboard overview
The Revenue Details dashboard displays total revenue and revenue for any period, broken down by each recorded fee.
Depending on the widget, you can left-click or right-click any part of a chart to drill down and explore the underlying data.
Using the Identify Revenue Account By control, you can choose how Revenue accounts are represented on the dashboard:
The four widgets at the top of the dashboard summarize the revenue generated for the selected period. You can see:
The total revenue for the period (excluding tax)
The top 5 locations ranked by revenue
The top 5 revenue accounts ranked by revenue
The proportion of non-invoiced items from the total calculated revenue
How is data calculated?
The dashboard lists every entity with which you have a direct commercial relationship. It can show Companies, Company Members (if they have personal fees/memberships), and/or Individual Members.
The dashboard includes data for all fees and credit transactions, regardless of their invoicing status. This includes:
Membership fees
One-off fees (including bookings and deposits)
Credit Notes
Overpayments
Data | Description |
Invoices | Fees that have been invoiced will appear on the dashboard with their invoiced amount, and fees that have yet to be invoiced will appear with their original amount.
Recurring memberships invoiced for more than a month in the same invoice will have their invoiced amount distributed proportionally between the months covered by the invoice, with proration applied in the first month if needed. |
Line items | Manually created line items in invoices will appear in this report. Always void invoices before detaching line items from them to avoid duplicate data. |
Membership fees | Membership fees that have been invoiced will appear on the dashboard with their invoiced amount, and fees that have yet to be invoiced will appear with their original amount.
Membership fee transactions are recorded based on the following:
|
One-off fees | One-off fee transactions are recorded based on the start date of the fee. Fees that have been invoiced will appear on the dashboard with their invoiced amount, and fees that have yet to be invoiced will appear with their original amount. |
Booking fees | Booking fees are recorded based on the booking's start date. Fees that have been invoiced will appear on the dashboard with their invoiced amount, and fees that have yet to be invoiced will appear with their original amount. |
Deposits | Deposits and processing fees will appear as line items in this report. To remove them, use the "Revenue Account" filter. |
Examples:
A one-off fee starting November 5 will appear on the same date: November 5.
A membership with a start date of February 15, an end date of April 31, and a billing date on the first day of every month will appear:
On February 15
On March 1
On April 1
Important:
Tax is excluded from the total amount of each transaction.
Detaching a line item without voiding the corresponding invoice will result in the item being included twice. To ensure the accuracy of the data, we recommend voiding the invoice before detaching any items.
Why does a line item have a negative amount?
A negative amount will appear as a line item if:
you have created a fee with a negative value. In this case, the transaction will be recorded based on the start date of the negative fee.
a fee/membership was credited (a Credit Note was issued, or an Overpayment was used to credit it). In this case, the transaction is recorded:
on the current date if the transaction you're crediting is in the past
ORon the start date of the line item being credited if the transaction you're crediting is in the future.
Revenue details
This table contains all fees that comprise the total revenue shown at the top of the dashboard. You can interact with the table:
by hovering over it to see a description of the column
by clicking any value with the (...) symbol to get a link to the respective page in the Admin Portal
by clicking any column name to sort it
by clicking and dragging the column name to re-order the columns
by clicking on any value in the Amount w/o Tax column to drill into it
Revenue split by location and revenue account
This table provides an overview of revenue by location and revenue account. You can interact with the table in the same way as Revenue Details. Additionally, you can expand and collapse the subtotals for each location.
Revenue split by location and customer
This table provides an overview of revenue by location and revenue account. You can interact with the table in the same way as Revenue by Location and Revenue Account.