Software Solutions/Strategy Advice - Non Profit

Hello,

We are a non-profit housing association with a team of 12. Over the years, our office IT network and software solutions have met our relatively non-complex IT needs. However, we're growing in the data and information managed, as well as complexity of business processes. We are basically using MS Office suite of products, and are managing much of our data on Excel spreadsheets. We have three kinds of data managed related to housing societies, buildings, and contacts (people). We are set up on a basic LAN with 12 workstations, a couple of shared printers and some shared folders for documents and such, but overall, our data and information management is department versus organization focused. This is starting to become very challenging to manage, as we don't have any data consolidation/centralization tools or processes, nor ways to analyze data beyond basic Excel functionality. Since our data is growing, our need to access the data and "slice and dice" it is becoming more relevant (e.g., "show me all buildings in this region with this number of units using this type of heating, but where the building is newer than 2000. And show me their property manager's contact information".). Right now, it's just too cumbersome and time consuming in Excel.

The other key piece of data is our extensive contact list, but each department manages its own list and email addresses, in Excel spreadsheet or Outlook (not Enterprise version so contacts not shared between departments). We are also using one MS Access Database as our official organizational contact list but this list has become membership centric and other departments have strayed from using it. We are constantly at odds as to who has the most recent information, and duplication not only of contact lists but housing related data is a growing problem. Briefly, our main departments are made up of:

• Membership (membership renewals, member services, etc.)
• Research (manage extensive housing society and building related data)
• Education (manage website, manage education programs e.g., workshops, training)
• Energy Management (manage extensive building related data related to energy management)

Our main priority is to consolidate and centralize our data (get things out of Excel and into an actual database). But we need software solutions that can manage our access to the data in a way that suits the needs of each department. As an example, membership wants to know when they became a member but education wants to know what workshops the member has attended in 2011. Reseach wants to know if an individual is part of a society and energy wants to know if that society's buildings qualify for a grant based on its demographics. But maybe energy shouldn't or doesn't need to see all the membership information. Right now, each department tracks this person/society/building data separately in their own way.

Just at a high-level, we likely need a CRM solution that can manage both customers/contacts as well as membership specific information (we are a member centric organization). We also need a solution for managing and analyzing data (i.e., accessing, updating and manipulating housing related data quite easily and quickly as we can do in Excel). By the way, the energy and research departments are constantly adding new rows and columns of data to their spreadsheets so the new solution will have to be flexible to allow for this.

Any advice on software and hardware solutions that may meet our needs? We are looking for something that is more sophisticated than what we have of course, but with an understanding that we are a non-profit with limited dollars. Something off-the-shelf and easy to maintain, with minimal recurring license fees is highly desireable. Nothing complicated...just an easier way to manage data/information so we're all on the same page. Thanks kindly in advance for your feedback. Please feel free to ask clarifying questions.