The Invoices Report displays all membership invoices, paid and unpaid. This is available for clubs on Invoice Based Billing. 

Data Selections

• Club: the report content is limited to the club(s) selected
• Date: the date that the date range applies to  
• Date Range: the report content is limited to the invoices with the date selected within this range
• Invoice Status: the report content is limited to the invoices with the status selected

Data Filters

None

Data

Each row of the report represents an invoice; written off invoices are not included

• Club: the ID of the client where the membership exists
• Club Name: the display name of the client where the membership exists
• Account Number: the account number for the reported membership/account
• Name: the first and last name of the buyer on the account
• Due Date: the due date of the invoice
• Invoice #: the invoice number (unique identifier)   
• Status: "Paid" if the invoice is paid in full and no remaining balance is owed, "Unpaid" if there any remaining owed balance on the invoice 
• Amount: the total amount that was due on the invoice prior to any payments
• Balance: the outstanding balance owed on the invoice
• Attempts: the total count of payment attempts that have been made for the invoice; payment attempts refers to scheduled attempts made in the daily billing process, not POS payments 
• Reject Reason: the reason for the most recent reject or decline of a payment attempt for the invoice
• Payment Method: the payment method used to pay the invoice
• Draft Date: the date that the invoice's payment was collected; the most recent date if multiple payments were made

Data Summary

• Record Count: the count of records returned in the report after filters are applied
• Total Paid: the sum of amounts on invoices that are paid
• Total Unpaid: the sum of the outstanding balances on unpaid invoices

NOTE: When a term account is returned, the contract balance and past dues are tracked in reporting to represent the amount that the member contractually owes to the club at the time of return. In Invoice Based Billing, the invoices for the remainder of the term will be visible on the account. In some cases, if the invoices have not yet been generated for the remainder of the term you may see additional invoices created until the term is complete. Open-end accounts will not continue to generate any invoices after the account is returned.