In this article
The following article explains the recommended process for reporting on event profitability in Arlo. Note: This process is only available for customers on Professional or Enterprise plans. If you would like to upgrade, contact Arlo Sales.
- Add expense fields to your platform
- Report on event expenses
- Report on event performance and establish profitability
Add expense fields to your platform
Note: This step only needs to be completed once, when initially setting this feature up for use.
Report on event expenses
- Open the Reports menu.
- Select Event List (Advanced).
- Add conditions to return the events with expenses you would like to report on.
- Include the following fields in your report output in this order:
- Event Name
- Start Date
- Fixed Expenses
- Variable Expenses
- Additional Expenses (if included).
- Current Registration Count (This will only pull through approved registrations).
- Press Preview to display the results.
- Press Export. You can now calculate the total expenses for the event using a formula in excel.
- The formula to use is Fixed Expenses + (Variable Expenses * Registrations).
- In cell F2 enter the formula '=(C2+(D2*E2))' and press enter - This will calculate the total cost of each event. Note: If you are also using a column for additional costs, you'll need to use column G and use this formula instead '=(C2+E2+(D2*F2))'
- Drag the expense formula down the column list. You now have the total expense for each event. For example:
Report on event performance and establish profitability
- For the same event/s, run the Event Performance report.
- Ensure that the Total - orders less credits (Value) is selected as an output. Note: This field does not take into consideration order discounts applied to orders made with the event, as order discounts can be applied to orders with multiple registrations and multiple events.
- Compare the value of orders earned against the expenses of the event to establish profitability.
Example: The event below was not profitable, as the costs were $835, yet it only generated $700 in paid orders.