The Orders - Local Time report can be used to view all your new memberships sold as well as membership sales for a specific period (ex: last month).
Navigate to Reports from the left panel > Sales > Orders - Local Time
Specify the date range.
Select More Filters > filter by Product Type > Memberships > Apply Filters.
Select Export to see a complete list of memberships sold.
When you export the report into Excel, the dataset will give you all the initial purchases for a membership and the membership renewals for the date range that you selected.
All new memberships will render a “FALSE” status under “Processed by the system?” as it is their first payment. Therefore, you will want to filter out those displaying "TRUE."
“Processed by the system?” will render TRUE for membership payments passed their first payment interval.