A national professional association with a few thousand members ran renewals the way most associations do: a spreadsheet exported from the membership database, a mail merge, and a fortnight of phone calls from the office. Lapsed members were discovered when they complained about losing access. Meanwhile the same office inbox handled member queries, event bookings, branch enquiries and supplier invoices with no separation between them, and nobody could say how many were open.
The difficulty
The association’s problem was that its three systems did not know about each other: the membership database held people, the accounting system held money, and the inbox held everything else. Reconciling who had paid for what involved exporting two lists and comparing them in a spreadsheet each month. The renewal season concentrated an entire year’s administrative load into six weeks, which made the office’s capacity problem feel like a staffing problem when it was a structure problem.
Project snapshot
- SectorMembership Association
- Modules deployedInsight Care, Insight Ledger, Insight Portal add-on
- Duration7 weeks, timed to finish before the renewal season
- Written up withClient permission; identifying detail removed
Numbers quoted in this study were measured by the client before and after the change — they are not our estimates. Where a figure could not be measured cleanly, it has been left out rather than rounded flatteringly.
What we changed
We made Insight Ledger the system of record for who has paid, and left the membership database to hold who the members are — a decision taken explicitly in the first workshop and written down, which is what made the rest straightforward. Renewal invoices now generate from the ledger on a schedule and are chased automatically on the association’s own timing. Member queries moved to Insight Care with the Insight Portal in front of it: one form per category, routing to the staff member who handles that work, with SLA timers the office published to its branches. The monthly reconciliation became a report rather than a comparison exercise.
The results
- Renewal chasing automated on the association’s own schedule.
- Lapsed members identified before they lose access, rather than when they complain.
- Member queries tracked, owned and visible; the branch walk-up path has declined.
- Monthly payment reconciliation produced as a report instead of assembled by hand.
Money lives in the ledger and people in the membership database. That decision removed the reconciliation problem.
If your organisation looks like this one
If three systems do not share data, decide which owns which record before connecting them: money in the ledger, people in the membership database. Automate chasing on your own timing. Put a portal in front of the queue so members can see the status of their enquiry.
To see how a project like this would run against your own calendar and numbers, ask us for a written quote — Association work is quoted per renewal cycle, so the change lands in the quiet months before your season.