A membership activity report is an internal document that records who belongs to your organization, how engaged each member has been, and whether their dues are current. To fill one out, you pull together three categories of data on every member, lay them into a summary, a detailed activity log, and a financial reconciliation, have an officer certify the result, and deliver it to whichever body your bylaws designate. Done carefully, the same document feeds directly into your Form 990 and supports your tax-exempt status if the IRS ever asks questions.
Pull the Data Together First
The template is easy. The data is the work. Before opening any form, gather three things for every person on your rolls.
Identification and status. Each member needs a unique identifier, either a number your system assigns or an alphanumeric code, so that two members with the same name never get confused. Confirm each person’s current status: active, inactive, lapsed, or on probation. If your bylaws distinguish statutory members who hold voting rights from non-statutory supporters who receive perks but cannot vote on governance, flag that distinction now. Statutory members have legally recognized rights under state nonprofit law, including the ability to vote on board elections, mergers, and bylaw amendments. Treating both groups identically in the report can create confusion during audits or governance disputes.
Participation. Compile each member’s engagement history for the reporting period: board meeting attendance, committee service, outreach, professional development hours, or whichever metrics your bylaws define. If voting eligibility or good standing turns on a minimum participation threshold, note who met it and who did not.
Financial standing. For every member, record whether annual dues and any special assessments are paid in full, partially outstanding, or overdue, and note any late fees applied.
Core Sections of the Report
Executive Summary
This sits at the top and gives readers a snapshot they can absorb in under a minute. Include the total number of members at the start and end of the period, how many joined, how many left or were terminated, and any notable trend worth flagging, such as a spike in lapsed memberships after a dues increase. Do not bury the headline. If enrollment dropped 15 percent, say so in the first sentence and explain it in the body.
Detailed Member Activity Log
This is the main body. For each member, record the unique identifier, enrollment status, and participation data with specific dates and event descriptions. Vague entries like “attended events” are almost useless in an audit. Log the date, event name, and type of involvement. If your organization tracks professional development hours, record the hours completed against whatever minimum your bylaws require.
Precision pays off if tax-exempt status is ever questioned. The IRS expects exempt organizations to maintain records that demonstrate compliance with the tax rules, and a well-documented log shows your organization is actively fulfilling its charitable, educational, or professional mission rather than existing on paper.1Internal Revenue Service. EO Operational Requirements: Recordkeeping Requirements for Exempt Organizations
Financial Reconciliation
This section balances what the organization expected to collect against what actually came in. List total dues billed, total collected, and the gap between the two. Cross-reference each payment against the member’s status in the activity log. A member listed as “in good standing” whose dues show as unpaid is exactly the discrepancy that causes problems during review. Include any assessment or special charges billed during the period and their collection status.
Why the Report Needs to Be Right: Form 990
Every organization exempt from tax under Section 501(a) of the Internal Revenue Code must file an annual return reporting gross income, receipts, disbursements, and other information the IRS prescribes.2Office of the Law Revision Counsel. 26 Code 6033 – Returns by Exempt Organizations For most nonprofits that return is Form 990, and much of what it asks for comes straight from your membership activity report.
Membership dues appear on the revenue side of Form 990. The IRS instructions direct organizations to report the non-contribution portion of membership dues on the program service revenue lines and to allocate those amounts appropriately.3Internal Revenue Service. 2025 Instructions for Form 990 If dues instead purchase specific goods, services, or facility access, they may be categorized differently and could even trigger unrelated business income tax depending on the arrangement.
For 501(c)(3) organizations, dues can also affect the public support test on Schedule A. Dues treated as contributions count toward public support in the numerator, while all support (including dues) forms the denominator. To qualify as publicly supported under Section 170(b)(1)(A)(vi), the organization needs to receive at least 33⅓ percent of total support from government sources or the general public, calculated by the IRS on a cash basis over a four-year measuring period.4Internal Revenue Service. Basic Determination Rules for Publicly Supported Organizations and Supporting Organizations If your activity report tracks dues poorly, your Schedule A numbers may be wrong, and a miscalculated public support percentage can jeopardize public charity classification.5Internal Revenue Service. 2025 Schedule A (Form 990)
Signing and Submitting
If the template requires an officer’s signature certifying accuracy, an electronic signature is legally valid under the federal E-Sign Act, which provides that a signature or record cannot be denied legal effect solely because it is in electronic form.6Office of the Law Revision Counsel. 15 Code 7001 – General Rule of Validity The electronic record must be capable of being retained and accurately reproduced for later reference. The E-Sign Act does not override specific organizational requirements that mandate paper records, and some state laws impose additional formalities for certain corporate documents, so check your bylaws before going fully digital.
Deliver the finished report to the body your bylaws designate, usually the Board of Directors or a standing audit or governance committee. If your organization uses a secure internal portal, upload the report and confirm you receive an automated acknowledgment. Save that confirmation. For organizations that require physical copies, send them by certified mail or another method that generates proof of delivery.
The officer who certifies the report should actually review it. Directors and officers owe a fiduciary duty of care that requires taking reasonable steps to become familiar with the information under the board’s review and bringing informed judgment to decisions. Certifying a report you have not read is a straightforward breach of that obligation and exposes both the officer and the organization to liability if the report contains material errors.
After submission, the reviewing body examines entries for discrepancies, policy violations, and alignment between the financial reconciliation and the activity log. Once approved, the report becomes part of the permanent organizational record and a source document for your next Form 990.
How Long to Keep the Report
The IRS does not prescribe a single retention period for all documents, but it does set a floor: organizations must keep records that support items on their tax returns until the statute of limitations for that return expires, generally three years after the return’s due date or filing date, whichever is later.7Internal Revenue Service. Publication 4221-PC – Compliance Guide for 501(c)(3) Public Charities Because any data feeding into Form 990 falls under that floor, three years is the minimum for a membership activity report.
In practice, seven years is safer, since the IRS can look back further where it suspects substantial underreporting. Permanent retention is reasonable for reports that document major governance decisions like membership terminations or bylaw-triggered status changes. Articles of incorporation, bylaws, and the determination letter recognizing tax-exempt status should always be kept permanently.