Q. Is there a Report that shows the last Month's sales to see how well we did, ie how many lost members how many joined etc?

A. The best report is the Member Movement report.

When you choose My reports > Member Reports > Member Movement this is preset to automatically populate the dates a month in advance. You will find the number of total members here and it will include signups and rejoins, transfers, and cancellations etc.