FOSL membership database

Overview

Friends of the Staunton Library (FOSL) is a non-profit membership organization dedicated to supporting the Staunton Public Library. Like many volunteer-run groups, their work spans member engagement, donor stewardship, event coordination, and the financial record-keeping that keeps everything running. Vistoso Creative works with FOSL on an ongoing retainer covering newsletters, social media, platform maintenance, and event support.

As that relationship deepened, a clear need emerged: a single, organized place to manage membership data. Most small membership organizations live somewhere between spreadsheets and paper forms, and while that works up to a point, it creates friction as the organization grows and the number of moving parts increases. Off-the-shelf donor CRMs designed for large nonprofits bring overhead and complexity that a focused volunteer organization simply does not need. What FOSL needed was something sized to them.

What we built

We designed and built a custom membership management database: a private web application for the FOSL leadership team. The system is organized into five modules, each handling a specific part of how the organization operates.

Overview dashboard

The opening screen gives the team a quick read on where things stand: membership activity, recent additions, and anything that needs attention. No digging through tabs to find the current picture.

Member records

A structured record for each member, searchable and sortable. Contact details, membership status, and history all live in one place instead of across multiple files.

Financials

Financial tracking scoped to what the organization needs: dues, donations, and a clear view of income over time. The goal was to replace the mental overhead of cross-referencing a spreadsheet with something purpose-built and reliable.

Needs-review queue

Not every record comes in clean. The needs-review queue surfaces entries that require a human decision before they move into the main database. It is a small thing, but keeping that review step explicit prevents the kind of quiet data drift that plagues manual processes.

Acknowledgements

Saying thank you is a core part of donor and member stewardship. The acknowledgements module tracks which members and donors have been thanked, when, and how, so nothing falls through the cracks during a busy stretch.

Approach

The system is built on Payload CMS with a Next.js frontend and a PostgreSQL database. We chose this stack for the same reason we use it across our client work: it gives us a structured, typed data model, a clean admin interface, and the flexibility to shape the experience around how the organization works rather than fitting their work around the tool.

Because this is an internal tool rather than a public website, the design priorities were clarity and speed of use: information-dense layouts where appropriate, consistent navigation, and no unnecessary steps between the team and the data they need.

What it means for FOSL

Five modules, one application. The FOSL team now has a single source of truth for their membership, replacing the dispersed and fragile arrangements that small organizations inevitably accumulate. Records are consistent, the acknowledgements process has a proper home, and the needs-review queue makes data quality a first-class concern rather than an afterthought.

This kind of purpose-built tooling is one of the quieter ways we support the organizations we work with: not a new website, not a campaign, but infrastructure that makes the ongoing work more reliable.

Built for a community organization. See how we work with groups like this →