A map of what you keep track of, on paper, first.
Members, dues, events, sponsors, invoices, contacts — written down with how each one connects to the others. You read it and sign off on it before a single record moves anywhere.
One list everybody trusts, instead of six that disagree.
Members, customers, events, invoices and contacts kept in one place and updated once. Change somebody’s email in the morning and it is right everywhere by the afternoon — no retyping it into four systems and hoping you caught them all.
Diagnosis
One place where each member, customer, event, invoice and contact exists exactly once. One entry, one record, one place to look it up. Everything else you use — the accounting, the email tool, the website, the registrations — reads from it or writes back to it. We are not selling you another spreadsheet template.
The people who hire us for this are usually one spreadsheet away from a genuinely bad week. Six tabs of master lists. Somebody exporting a file every Monday morning. One staffer keeping a private copy because the shared one was wrong back in March and nobody trusted it again. Nobody lied. They were each forced to keep their own version because nothing else held. We collapse the versions into one. Common signs:
What you get
Members, dues, events, sponsors, invoices, contacts — written down with how each one connects to the others. You read it and sign off on it before a single record moves anywhere.
Out of the spreadsheets, the old system, the vendor sites and the tab named “old don’t use.” Duplicates merged, blanks flagged, and every record carrying a note of where it came from, so you can prove it later.
Set up on your account and your card, so you own it outright. If we disappeared tomorrow you would still have the login, the records and someone else’s ability to pick it up.
Your accounting, your email tool, your registration and ticketing: connected, so a change made once shows up in all of them. One update, everywhere. Nobody retypes anything.
Whoever chases dues sees dues. Whoever runs the event sees the event. Finance sees the money. All of them looking at the same records, none of them able to break it for anyone else by sorting a column.
Every field explained and every rule written down in language a new hire can follow on their first week, without calling us and without guessing what somebody meant.
Architecture
Picture a wheel. In the middle is the one set of records. The spokes are the tools you already use — the member list, the accounting, the email tool, the reports you hand the board. Each one reads from the middle and writes back to it. The middle is the truth. The rest are just windows onto it.
The rules live with the records, not in a spreadsheet formula somebody can wipe out by dragging a cell. If something goes in wrong, you hear about it the moment it is typed, not the week the board asks for the numbers.
Process
We track down every place your information currently lives — spreadsheets, the old system, the vendor sites, that one Notion page. You get one picture of the sprawl and one of what would replace it.
We write down what gets tracked and how it connects, walk your staff through it, and lock it. Nobody touches a record until you have signed off on that page.
We pull from the old places, merge the duplicates and load it into the new one, with every record noting where it came from. At week three we sit down with whoever handles the money and check the numbers line up.
We connect it to what you already pay for — accounting, email, registrations — so a change made once shows up everywhere. Both directions where that makes sense, one direction where it doesn’t.
Your staff moves off the old spreadsheets. The old ones stay readable but locked for 30 days, so nothing is lost while everyone finds their footing. We are on the phone daily that week.
Optional. We keep the connections running, adjust as you grow and add new tools as you take them on. Or we hand over the written guide and disappear.
FAQ
Engagement
A fixed price, set after the first week. Five to twelve scattered places pulled into one.
Agreed on paper in week one, everybody switched over by week six. We don’t do 18-month projects.
We keep the connections running, adjust as you grow and add new tools as you take them on.
Enormous old systems are a different animal. We’ll refer you.
Bring the messiest one — the merged cells, the color coding nobody wrote down, the tab named “old don’t use.” Thirty minutes, no deck, no pitch. We’ll tell you what it would take to have one place instead of twelve, and if we’re not the right fit, we’ll tell you who is.