For club officers and secretaries

How to Organize Club Data So the Next Officers Can Find It

A setup that survives turnover has four parts: one club account, one folder layout, one member list and one event log. Here's how to set each one up.

Arden Pala

Arden Pala, founder of Helptivo

Updated · 4 min read

In short

  • Make one club Google account that owns every file. Officers get edit access, never ownership.
  • Use one top folder with numbered subfolders, and start every file name with the date (2026-09-12).
  • Keep exactly one member list and one event log. Everything else hangs off those two.
  • Spend ten minutes a month filing strays and removing access for people who left.

Search your club's Drive for "members." You'll probably get "Members," "Members 2025," "Member list FINAL" and "Copy of Members (1)." Each one is a little different, and nobody knows which is right.

A club's files don't need a fancy system. They need four things: one account that owns them, one folder layout, one member list and one event log. Set those up once and the next officers can find anything in a minute.

One club account that owns everything

Start with a Google account for the club itself. If your school gives clubs an official account, use that. If not, make a plain Gmail like yourclub.officers@gmail.com. Don't use any officer's own school account, because it can close when they graduate.

Every club file should be created by that account or moved into it. Officers get edit access through sharing. They never own the files. That one rule is what lets records survive a handoff.

  • Keep the password in a password manager the officers share, or with your advisor.
  • Set the recovery email and phone to ones that won't graduate, like the advisor's (ask first), and update them at every handoff.
  • If your files are stuck in old officers' accounts right now, our data recovery guide covers how to move them.

A folder layout anyone can follow

Number the folders so they always show up in the same order. Put a short "Start here" doc at the top that says what's where and who to contact. A new officer should be able to open it on day one and find their way around.

Club Drive folder structure

[Club name] (owned by the club account)

00 Start here
   Read me first (what's where, who to contact)
   Officer handoff checklist
   Notes for next year

01 Members
   Member list (the only one)
   Join form responses

02 Events
   Event log (one sheet, every event)
   2026-09-12 Welcome meeting
      Flyer, sign-in sheet photo, photos
   2026-10-03 Beach cleanup
      Partner info, sign-up responses, photos

03 Money
   Budget 2026-27
   Receipts 2026-27

04 Partners and contacts
   Contacts (org, person, email, phone, notes)

05 School and rules
   Constitution or bylaws
   Registration forms and approvals

06 Media
   Logos
   Photos by school year

99 Archive
   2025-26
   2024-25

Make the folders empty first, then move files in. It goes faster than you'd think.

What goes in the "Read me first" doc

Keep it to one page. A new officer should be able to read it in two minutes and know where to start.

  • What each numbered folder is for, in one line each
  • Who has the club account password, and where it's stored
  • The advisor's name and email, and the student activities office contact
  • Where the member list and event log are (with links)
  • The dates that come back every year: the fair, re-registration, budget requests
  • Who wrote the doc and when, so the next person knows how old it is

Update it at every handoff. If something in it is wrong, fix it the moment you notice, not "later."

Name files so they sort themselves

Start every file and event folder with the date, written year first: 2026-09-12. Files then line up in order without anyone sorting them. After the date, say what the file is in plain words.

  • Good: "2026-10-03 Beach cleanup sign-ups"
  • Bad: "signups final," "Copy of Form Responses," "beach v2"

Never make a "v2" or "final" copy. Google Docs and Sheets keep a version history, so the old version is still there if you need it. One file per thing. At the end of the year, move the whole year's event folders into Archive.

One member list

There should be exactly one member list, in 01 Members. Every sign-up form, join form and attendance sheet feeds into it. If someone makes a second list "just for this event," copy the new names into the main list afterward and delete the extra one.

Which columns to collect, and what to leave out (especially for members under 18), is a topic of its own. Our guide to building a member database has the full column list.

One event log

The event log is a single sheet with one row per event. It tells new officers what the club did, what worked and who to call. It also answers the questions advisors and schools ask at the end of the year.

Event log columns

Date | Event | Type (meeting, social, service, fundraiser) | Place | Signed up | Came | New people | Volunteer hours (if service) | Partner and contact | Cost | What worked | What to change

Paste this as the header row of a Google Sheet. Fill in each row within a day of the event, while you remember.

Keep it to five minutes per event. A row with numbers and one honest sentence is worth more than a perfect write-up nobody finishes.

How we handle this in Helptivo

In Helptivo, each event keeps its sign-up list, who checked in and the hours people earned. You don't keep a separate event log for those numbers.

When you need it on paper, the event report lets you pick events and download them as a PDF, CSV or Excel file. You'd still write down what worked in your own doc, since that part only you know.

Past events keep their own sign-ups and attendance, so the event history builds itself. (Tap to enlarge.)

Who gets access, and a monthly cleanup

Officers get edit access to the whole club folder. Your advisor gets view or edit access, whichever they prefer. Members get links to only what they need, like a calendar or a flyer. The member list has personal contact info, so it stays with officers.

Then, once a month, someone spends ten minutes on this:

  • Move stray files into the right folder.
  • Delete duplicates (check which one is newest first).
  • Make sure every event from the past month has a row in the event log.
  • Remove access for anyone who left the board or graduated.

That's the whole system. It's simple on purpose, because the next officers have to keep it going without you there to explain it.

Questions people ask

How should a club organize its Google Drive?

Make one club Google account that owns everything, then one top folder with numbered subfolders for members, events, money, partners, school paperwork and media. There's a layout you can copy in this post.

Should a club use a personal or school Google account?

Use your school's official club account if it gives you one. If not, make a separate Gmail just for the club. Avoid any officer's own school account, since it can close when they graduate.

How do I stop ending up with duplicate spreadsheets?

Keep one file per thing, never make a "v2" copy, and use the built-in version history in Google Sheets to see older versions. Put a date at the start of every file name so files sort themselves.

What should a club event log include?

At least the date, the event, how many signed up, how many came, how many were new, and one line on what worked. Fill it in within a day of each event.

Written by Arden Pala

Arden started Helptivo after running Sports4Kids, a youth sports nonprofit, on spreadsheets, Google Forms and group chats. He builds Helptivo and writes these guides from what clubs run into on it.

Run your club in one place

Sign-ups, QR check-in, hours and reports. Free for clubs with up to 150 members, with no time limit and no card needed.

Try Helptivo free

Keep reading