Club Account Statement Report

Club Account > Club Account Statement > Club Account Statement

This report is intended to create club account statements to send to members. Each statement appears on a different page.

Below is an example of one of these club account statements:

Column Name Column Description
Address The member's address as it is entered on the member page.
Agreement # The member's agreement number.
Balance Due The current club account invoice amount.
Barcode The member's barcode.
CityStateZip The member's city, state, and zip code, as listed in the Demographics section of the Personal tab on the member page.
Club Address The address of the associated club as it is listed in the Address 1 field on the General tab of the Edit Club page.
Club City State Zip The city, state, and zip code of the associated club as listed in those fields on the General tab of the Edit Club page.
Club Name The name of the club associated with the club account, as listed in the Club Information section on the General tab of the Edit Club page.
Club Nbr The number of the club associated with the club account.
Date of Sale The date of the club account transaction, as listed in the Transaction Date column on the Invoices tab of the member page.
Member Name (first last) The member's name.
Receipt # The receipt number associated with this club account transaction.
Receipt Header This is a static field that displays the text "Receipt #".
Report Name This is a static field that displays "Club Account Statement."
Run Date The date this report was run.
Sale Date Header This is a static field that displays the text "Date of Sale."
Total Amount Header This is a static field that displays the text "Total Amount Due."
Zip The member's zip code, as listed in the Demographics section of the Personal tab on the member page.
Due Date The invoice due date, as listed on the Invoices tab on the member page.
Due Date Header This is a static field that reads "Due Date."
Member Name (first) The member's first name.
Member Name (last) The member's last name.
Net Due Header This is a static field that reads "Net Due."

 

Report Type Sorted by Set Filters Runtime Filters
Advanced Club Name
Member Name (last)
Member Name (first)
Due Date
Date of Sale
none Club Nbr = in list
Due Date ≤ (date chosen at runtime)
Barcode = in list
Club Account Payment Method = Statement
Billed by ABC = No