ChamberMaster/MemberZone: Year End
The end of year inevitably creeps up before we expect, bringing with it extra work. There are financial reports to prepare, billing updates to apply, and membership dues to change, not to mention that you need to ensure that members have their latest and greatest data provided and more…
Here is a checklist of all the things you should be doing with your ChamberMaster/MemberZone database at the end of each year.
Year End Checklist
1. Review Chart of Accounts:
- Review your chart of accounts to ensure that all names of accounts in CM/MZ match names in your accounting software.
- De-activate any accounts that you are no longer using (DO NOT DELETE) to clean up your database
- Knowledge Base articles:
2. Review Fee Items:
- Do you need to increase your prices and/or change descriptions?
- De-activate any fee items that you are no longer using (DO NOT DELETE) to clean up your database
- Knowledge Base articles:
3. Update Your Membership Application
- If you have changed pricing for your membership dues, the change will not automatically update the Membership Application.
- Knowledge Base articles:
4. Review Member Data for Billing Completeness:
- Generate a Custom Member report to check for Fee Schedules, Fee Items, Renewal Month, Billing Contact
- Update Member Billing details if necessary
- If using ePayment, use the ePayment Fee Assignment Report to verify credit card expiration dates
- Knowledge Base articles:
5. Review/Manage Past Due Invoices:
- Generate the Invoice Summary report to identify and resend Overdue Invoices
- Generate Collections Report
- Generate Collections Letters
- Review Open Credits/Unapplied Payments
- Write-off Invoices as needed
- Knowledge Base articles:
6. Generate Invoice Batches
- Generate Invoices for Membership Dues
- Review Invoice list for Events & One-time Fees to determine if invoices need to be generated to complete the year’s billing
- Knowledge Base articles:
7. Sales by Item Report
- Generate this report to review the sales from this year for better budgeting.
- Knowledge Base articles:
8. Scheduled Sales by Month Report
- Generate this report to view expected sales for the coming year
- Knowledge Base articles:
9. Membership Renewals
- Generate this report to view renewals by month for the coming year for better budgeting purposes
- Knowledge Base articles:
10. Growth Report
- Generate this report to view growth and drops over the previous year
- Knowledge Base articles:
11. Take year snapshots of member statistics
- How many members were active this year? How many new members? How many drops! Take snapshots of this information for future historical comparison and to include in your year-end calculations.
- Knowledge Base articles:
12. Membership Calculations
- Retention Rate
- Lapse Rate
- Renewal Rate
- Average Membership Tenure (AMT)
- Member Lifetime Value (MLV)
- Member Acquisition Cost (MAC)
- Knowledge Base articles:
13. Revenue Reports
- Sales Summaries – Membership Dues
- Sales Summaries – Non-Dues Revenue
- Knowledge Base articles:
14. Contact Cleanup
- Merge Duplicates
- Review/Update Prospect vs. Non-Member – update as needed
- Send Member Update Email to get members to update their information
- Drop Members
- Review and Update Community Member record
- Knowledge Base articles:
15. Group Cleanup
- Create new groups for the coming year
- Disable reps no longer participating
- Disable groups no longer needed
- Knowledge Base articles: