Skip to main content
Free template · CSV / Google Sheets · Last updated: November 7, 2026

501(c)(7) Event Income Log Template

A social club event log for tracking member counts, guest counts, total charges, nonmember charges, payments, and advisor notes. See what this page covers.

Put it to work

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.

Full template contents

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 DateEvent NameTotal headcountMember headcountGuest headcountPublic-use headcountTotal chargesMember chargesGuest chargesPublic-use chargesSponsor chargesWho paidNotesReviewed
2026-01-20New Year Social=D2+E2+F270150=H2+I2+J2+K2350075000Members and hostsGuest charges are not classified as nonmember incomeYes
2026-02-14Valentine Dinner=D3+E3+F390300=H3+I3+J3+K34500150000Members brought guestsGuest headcount is not a nonmember classificationYes
2026-03-15Spring Formal=D4+E4+F480200=H4+I4+J4+K44000100000MembersGuest list submitted in advanceYes
2026-04-05Golf Scramble=D5+E5+F542180=H5+I5+J5+K56300270000Members paid for guest roundsDo not move guest charges to public use without advisor reviewPending
2026-05-10Derby Day Party=D6+E6+F6100500=H6+I6+J6+K62500125000Not recordedRecord who paid before advisor reviewPending
2026-06-01Pool Opening=D7+E7+F7140600=H7+I7+J7+K70000N/ANo charge. Included in dues.Yes
2026-06-15Corporate Outing=D8+E8+F80040=H8+I8+J8+K80060002000Public renterFacility rental. Public-use charges are separate from guest charges.Pending
2026-07-04July 4th BBQ=D9+E9+F9180700=H9+I9+J9+K93600140000MembersFamily 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)
GuidanceDo 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.
DisclaimerEducational 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.