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.
Learn how to add the expense fields and record expenses on your platform.
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.