I created budgets for HOA so funds are available to replace or repair commonly owned property, like tennis courts, roofs, pools, private streets, etc.
When I go to a community, I currently use an excel form that I use to record measurements and quantities, and which provides calculated results. This data is manually copied and pasted into a proprietary Access-based software. It is a bit clunky, hard to see all the information and it's easy to lose data.
Additionally, I would like to use this same form to keep track of several databases. I could possibly keep using excel and have a number of tweaks, but I think Access or another database program would work best. I would also like to be able to export the data onto a website.
I want all functions broken down into very simple jobs for flexibility and ability to understand what is going on. I will also need very good documentation.