Welcome to the Assistant Secretary Database program (AS). The AS is a computer program for the lodge secretary, treasure, and other members (District Deputies, etc.) to keep track of membership, visitors, widows, multiple lodges, financials, dues, inventory, send letters, lodge minutes, events, and much more. You can implement the AS to replace or augment your current paper-based membership tracking.
We include a help manual, along with help videos so you will never feel lost. If you do happen to head North, we offer top-quality free support.
A detailed description of the features in the Assistant Secretary are listed below
Please read the manual or quick start guide before starting work in the Assistant Secretary. The Assistant Secretary does require initial setup before you add members.
To access the database once you download:
Install on Windows 8, 7, Vista, and XP. If you download the ZIP file, please click on "setup.exe" to install the database. If you don't know which one to download, we highly recommend you download the .exe since it is much easier to install.
|Assistant Secretary 5.0||196 MB||Installer (EXE)|
|Assistant Secretary 5.0||196 MB||ZIP|
|Quick Start Guide||1 MB||DOCX|
|Help Manual||1 MB||DOCX|
|All "Help Manuals"||1 MB||ZIP|
|Blank database (restore)||1 MB||MDB|
|Import file||1 MB||CSV|
|Lodge Handouts||1 MB||XLSX|
|Upgrade Ver 4 to Ver 5||1 MB||EXE|
|All "Files"||1 MB||ZIP|
|All "Videos"||195 MB||ZIP|
Here are the test files we used to produce the videos. You can use these files to learn more about the database and to test the different functions.
|Test Database (test version)||20 MB||MDB|
|Import File (test version)||1 MB||CSV|
|Finished Letter (from letter video)||1 MB||RTF|
|Dues Boiler (from letter video)||1 MB||DOCX|
|All "Test Files"||1 MB||ZIP|
The Assistant Secretary Masonic Database is packed with the features you need. As a matter of fact, many of the features were requested by Brothers just like you.
Keep track of members, visitors, widows, and non-members/vendors. Specifically for members, you can input their contact information, lodge information (seat/office, membership status, etc.), petition information, affiliations, dates and degrees, committees, and much more.
Keep track of all money flowing into and out of the lodge. We have a very handy dues feature that allows you to assign dues to large groups in a matter of minutes. In addition, at the end of the year, the program will automatically calculate arrears and assign dues for the coming year. You can add bank accounts or "cash" accounts.
The Letters feature allows you to create letters for members, visitors, widows, and non members. This might be one member or all members in a group or an entire lodge. You can create dues letters (will automatically show the arrears, current dues, and balance) and other important letters. You can export the letters to PDF or Microsoft Word. You can also save letters as boilers so you can use them in the future.
You can also use the letters feature to create boilers for your minutes.
Standard Reports: We created several reports that you can run very quickly. Our standard reports allow you to report on all items in the database. In addition, it provides several features, including: birthday lists, label printing, profit and loss for the lodge, dues amounts, etc.
Report Designer: Our report designer is a great tool for you to build reports in a short period of time. If you wanted to quickly lists all lodge members and their email addresses, you can do that in about two minutes (and export into Excel).
The inventory module allows Brothers to provide a checkout system for the lodge (lodge library) or help keep track of items in the lodge. In addition, it can help keep track of the cost of items when new, and the purchase date.
The Lodge Handout is used by the Secretary to input members into the database. The Secretary can print the Lodge Handout and provide to members or email (Lodge Handout is in Microsoft Excel). If emailed, the Lodge members can return to the Secretary so the Secretary can easily import the members into the database. It is definitely crucial when you first start working with the database (can save countless time since no items must be retyped).
Adobe Acrobat Reader