Software to Manage Architectural Review Committee

Hello everyone, I have reviewed previous discussion topics here and see you all mentioning software to manage an entire association.

What I am specifically looking for is a software that our ARC can use to manage lots here in our association. the problem we have is that our ARC committee members change every few years and all records are currently hand written making it tough for ARC members to know prior history. We want to database all ARC history so its available via a web based software.

Can anyone suggest a software that will manage ARC actions and homeowner lot history?

thanks in advance.

Joel

Check your accounting software manufacturer. Our software has an add-on module that allows us to add all ARC information for each lot. The info is scanned from the plot plan forward with any changes through the years. The homeowner has the ability to view all this info on-line and submit applications for changes. It really simplifies the paper work for all involved.

CAMPRO has the software for the administrative side of management, which includes the ARC issues. Don't know anything specific about it, but here's the link to their site:

http://www.campro.us/product.html

and a number of the software companies listed in this directory have ARC modules, but I just don't know if they will stand alone:

http://www.communityassociations.net/national_directory.html

To be honest, you could probably find a local programmer to design a simple database to keep the information, the input forms, reports, and an interface with Word to send out letters.

Joe

Joel:

Excel is great and you can create a spreadsheet to meet your needs. We use Excel for our Master ARC listing and it works well for our communities.

Joel:

For the sake of spacing here it is in a smaller format, but Excel allows you to insert comments and you can create the spreadsheet to meet your communities needs. Project numbering assists you with tracking the ARC process. We stamp every ARC that comes in with the date received, date that it is scanned and emailed to the board and all of this information is placed into this database, so we can track the process at any given time.

Name: Address: Project#: Description: Approv/denial: Comments:
Smith 123 AB St GC101 10x12 Shed Pending Revd 11-14-07
scan/email 11/14

If you email me privately at [email protected] I can send you the template. But that should give you the idea.

Hi Joel, Paul

Ok, here are the costs.

Quick Google search "Autosketch"
Amazon. com New and used from $ 47.00
Student version Studica $ 74.00
Amazon.com New full box version CDS and Manual $ 123.00
Autocad/Autosketch $ 149.00 Shipped box version
$ 122.00 Download version
Take your pick, depending on your computer expertise.

Our provider has his own program and draws site plans in Autosketch for his livlihood.
Our Agreement on signing the contract was that we, our HOA, owned the drawings and all rights to them. ie we own the copyright.
Then we bought the program and can view whatever we like, update files ourselves, add new items on each layer, create new layers for any class of entity. He will be glad to do the work for us and get paid for it.

We could not find original plans of our association (50 years, deaths,changes in BOD, Management Co, etc etc) Our provider came on site and measured our site, 650ft x 860ft - 136 units, checked against a county copy of the survey and registration, aligned the buildings and roadway/walkways and then entered each item we asked him to plot.
So we now have a tree inventory and location, security lights, water heaters, floor plans of units, irrigation controllers and sprinklers.

We want to add All underground services, sewers, plumbing, electrical etc, and all above ground maintenance items.
Each item is linked to an inventory table for those items, and all the record keeping details go in a box/file page for that specific item.
(eg electricity meter # xxx ,location, sevicing security gate, checked date, replaced date) Ditto water heaters with cost and contractor name ind invoice #.

LAYERS ARE IMPORTANT. Start with your plat survey, go down for underground services, up for above ground. separate entities.
eg Irrigation, valves, lines controllers sprinklers each on a separate layer. You can then view them together or work on only that type of entity. Much less confusion.

Together with an Excel spreadsheet you can then get a very comprehensive record of requests, approvals, violations actions and compliances.

Email me for a copy of our Excel spreadsheet. We requested our Man Co to give us 2 pages of spreadsheet instead of 3-50 letters at our meetings.

ALL, repeat All requests, complaints violations, work undertaken should go on your spreadsheet. You will soon build a valuable database for your HOA.

Your ARC committee can have their own spreadsheet and you add it to the master as reuired.

AdrianC

Its the best and it costs you nothing the MC pays for it. Its free to the HOA.

What if you don't have an MC?