Private tool for membership director
Expected columns: Member Number, First Name, Last Name, Category, Dues, Start Date, Resign Date
Expected columns: Member No., First Name, Last Name, Category, Date Requested, Effective Date
Upload the active members CSV pulled from ClubEssentials. This is the source of truth for who is currently a member. The snapshot date is set to today (the upload date). Each upload is preserved as a historical record.
Expected columns: Membership Number, MembershipType, Membership Begins, First Name, Last Name
Member numbers in this snapshot that aren't in your imported sales data. Possible data gap on the sales side.
Members marked ACTIVE in your sales data but not in this CSV. Likely resigned, review and log via the Resignations tab.
| Member # | Last Name | First Name | Type | Request Date | Resignation Date | |
|---|---|---|---|---|---|---|
| No resignations loaded | ||||||
| Member # | Last Name | First Name | Type | Monthly Dues | Start Date | Resign Date | Status | |
|---|---|---|---|---|---|---|---|---|
| No sales data loaded | ||||||||
| Member # | Last Name | First Name | Type | Monthly Dues | Start Date | End Date | Months | Total Paid |
|---|---|---|---|---|---|---|---|---|
| No revenue data loaded | ||||||||