Screenshot / mockup placeholder
Replace with actual project screenshots
The Challenge
A Grand Lodge jurisdiction was managing membership data for hundreds of constituent Lodges through a patchwork of spreadsheets, Access databases, and paper forms. Annual returns from Lodges arrived in inconsistent formats. Per capita calculations were done manually, leading to errors and disputes. There was no centralized view of membership trends across the jurisdiction, and the Grand Secretary's office spent weeks each year reconciling data. No commercial membership software understood the unique Masonic concepts of dual membership, plural membership, demits, and the distinction between Entered Apprentices, Fellow Crafts, and Master Masons.
The Solution
I built a custom web application designed from the ground up for Masonic membership management. The system models the full Masonic membership lifecycle: petition, investigation, ballot, degrees, affiliation, dual membership, demit, suspension, and restoration. Lodge Secretaries enter data through a clean web interface, and the Grand Secretary has real-time visibility across the entire jurisdiction. Per capita is calculated automatically based on configurable rules. Annual returns are generated with one click. A reporting dashboard shows membership trends, degree activity, and Lodge health metrics. Role-based access ensures each Lodge sees only its own data, while Grand Lodge officers see the full picture.
Outcome & Impact
Annual return processing time dropped from weeks to days. Per capita calculation errors were eliminated. The Grand Secretary's office now has real-time jurisdiction-wide membership analytics for the first time. Lodge Secretaries report that the new system is dramatically simpler than the previous process, and data quality has improved across the board.