The Revenue Report in Member365 facilitates the export of all transaction data in your system! You can download your financial history as an Excel file, and use it for accounting purposes as needed.
This article will show you where to find the Revenue Report, and how to use its filters to pull the set of transactions that you need!
How to find the Revenue Report
1. From the Member365 Administrator Dashboard, click ‘Financial’ at the top of the screen.
2. On the page that follows, click ‘Reports’.
3. Choose ‘Revenue Report’ from the list of Reports.
How to use the Revenue Report
Before exporting your Revenue Report to Excel, you can use a series of filters to customize the set of transactions that you wish to pull. An overview of each filter option will follow:
Date Range – Use the calendar icons to specify the ‘Start Date’ and ‘End Date’ for your export. The report will pull transactions within the range that you set.
Date Type – Select a Date Type from the drop-down menu. The Date Type will change which transactions appear in the Date Range you have selected.
There are four options on the ‘Date Type’ drop-down menu.
Reported Date – Export Invoices whose Issue Dates lie in the Date Range.
System Date – Export Invoices that were created in the Date Range.
Payment Date – Export Invoices that were paid in the Date Range.
Refund Date – Export Invoices that were refunded in the Date Range.
For more on how Reported Date and System Date differ, consult this Knowledge Base article.
Sub-Ledger Filter – Specify transactions on a specific Sub-Ledger by checking its box. To simply pull a full list of transactions within your Date Range, leave everything unchecked.
The intent of Sub-Ledgers is to organize your transactions in Member365.
In the example above, the Revenue Report will pull all transactions tied to the ‘Events’ Sub-Ledger: i.e. all event purchases within the Date Range, unless you customized your Events to use a different Sub-Ledger.
For more on Sub-Ledgers in Member365, continue reading here.
When you are satisfied with your set of filters, click the ‘Generate Report’ button to export your Revenue Report to Excel!
Congratulations, you now know how to find the Revenue Report in Member365, and how to customize the data it pulls to suit your accounting needs!