Using this template.
A 501(c)(7) social club should be able to explain an event without relying on memory. This log records the date, headcount split across members, hosted guests, and public use, and charges in those same buckets, plus who paid.
Guest headcount and guest charges are facts. They are not a nonmember classification. Public facility rentals go in the public-use columns. Do not divide guest charges by event revenue and compare that percentage to 35%. The 35% and 15% references use the club's annual gross receipts. Use the nonmember income worksheet for the year, and ask your advisor.
Totals are formulas. This resource is educational only. It is not legal, tax, or accounting advice.
Template columns and sample rows.
Copy the structure directly from this page or download 501c7-event-income-log-template.csv with no email required.
| Event Date | Event Name | Total headcount | Member headcount | Guest headcount | Public-use headcount | Total charges | Member charges | Guest charges | Public-use charges | Sponsor charges | Who paid | Notes | Reviewed |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2026-01-20 | New Year Social | =D2+E2+F2 | 70 | 15 | 0 | =H2+I2+J2+K2 | 3500 | 750 | 0 | 0 | Members and hosts | Guest charges are not classified as nonmember income | Yes |
| 2026-02-14 | Valentine Dinner | =D3+E3+F3 | 90 | 30 | 0 | =H3+I3+J3+K3 | 4500 | 1500 | 0 | 0 | Members brought guests | Guest headcount is not a nonmember classification | Yes |
| 2026-03-15 | Spring Formal | =D4+E4+F4 | 80 | 20 | 0 | =H4+I4+J4+K4 | 4000 | 1000 | 0 | 0 | Members | Guest list submitted in advance | Yes |
| 2026-04-05 | Golf Scramble | =D5+E5+F5 | 42 | 18 | 0 | =H5+I5+J5+K5 | 6300 | 2700 | 0 | 0 | Members paid for guest rounds | Do not move guest charges to public use without advisor review | Pending |
| 2026-05-10 | Derby Day Party | =D6+E6+F6 | 100 | 50 | 0 | =H6+I6+J6+K6 | 2500 | 1250 | 0 | 0 | Not recorded | Record who paid before advisor review | Pending |
| 2026-06-01 | Pool Opening | =D7+E7+F7 | 140 | 60 | 0 | =H7+I7+J7+K7 | 0 | 0 | 0 | 0 | N/A | No charge. Included in dues. | Yes |
| 2026-06-15 | Corporate Outing | =D8+E8+F8 | 0 | 0 | 40 | =H8+I8+J8+K8 | 0 | 0 | 6000 | 2000 | Public renter | Facility rental. Public-use charges are separate from guest charges. | Pending |
| 2026-07-04 | July 4th BBQ | =D9+E9+F9 | 180 | 70 | 0 | =H9+I9+J9+K9 | 3600 | 1400 | 0 | 0 | Members | Family event including children. Guest headcount is not a nonmember classification. | Pending |
| TOTALS | =SUM(C2:C9) | =SUM(D2:D9) | =SUM(E2:E9) | =SUM(F2:F9) | =SUM(G2:G9) | =SUM(H2:H9) | =SUM(I2:I9) | =SUM(J2:J9) | =SUM(K2:K9) | ||||
| Guidance | Do not divide guest charges by event revenue and compare the result to 35 percent. The 35 percent and 15 percent references use the club annual gross receipts. Use the nonmember income worksheet and your advisor. This log does not decide exempt status. | ||||||||||||
| Disclaimer | Educational only. Not legal or tax advice. |
Frequently Asked Questions
A social club event log for tracking member counts, guest counts, total charges, nonmember charges, payments, and advisor notes. See what this page covers. A 501(c)(7) social club should be able to explain an event without relying on memory. This log records the date, headcount split across members, hosted guests, and public use, and charges in those same buckets, plus who paid. It downloads as a CSV / Google Sheets file (501c7-event-income-log-template.csv).
Guest headcount and guest charges are facts. They are not a nonmember classification. Public facility rentals go in the public-use columns. Do not divide guest charges by event revenue and compare that percentage to 35%. The 35% and 15% references use the club's annual gross receipts. Use the nonmember income worksheet for the year, and ask your advisor. Review the fields with leadership, treasurers, or advisors before you share, file, or rely on the completed template.
Spreadsheets and text templates work well for initial planning. The basic volunteer roster is on Free ($0, 1 user). Volunteer scheduling and event ticketing start on Plus ($199/mo). When the organization needs live donor CRM, giving pages, My Workspace, and Minty, or connected fund accounting and bank feeds, AlignMint keeps those records in one system.

