Subscription Payments

To find out how many subs have been paid, the total received and the total still owing:

You need to find all the subs invoices.
on Manage Transactions, filter by date (make the start and finish dates equal to the date subs invoices were created, or a date range if you created subs invoices individually or by batch transaction upload), and filter by transaction type (INVOICE), then move to the Download tab and tick get a spreadsheet of subscription invoices.
The spreadsheet includes the amount of each invoice, and a 0/1 column indicating whether paid. The paid status is based on the member paying their outstanding balance after the invoice was created, or if their credit balance was sufficient when the invoice was created, or if you have turned on the Configuration Item PAY_SUBS_INVOICE, the member may have paid just their subscription. Also an administrator can mark a subscription invoice as paid (if you do this, it’s also up to you to advance the member’s paid-to date).