With the proper template (and there is one for nonprofits included with Access), it's not too difficult for someone with a modicum of computer savvy to put together a program to handle the basics of fundraising using either Excel or Access. However, remember that the fundraising world is not static, and neither should be your fundraising program—continuing maintenance could become a drain on your time and resources.
In our opinion, there are two situations in which using Access or Excel (or similar products) might make sense.
so new that the people involved aren't sure just where it's going or how long it will exist.
In that case, all that is really needed is a basic mailing list to keep contact information on everyone who shows an interest in the group or who contributes something (money, time, services) to the organization.
Two bits of advice for people in this situation:
Excel is a popular spreadsheet program that comes with most versions of Microsoft® Office. A spreadsheet provides a simple, but limited, way to set up basic record-keeping. Its main drawback is that, as more data is added, and more categories of data are needed, spreadsheets tend to become unwieldy and ultimately unusable.
Access is included with the Professional edition of MS-Office, and is actually a programming language and database manager that can be used to create a fundraising program. Think of it as SAR ("some assembly required") furniture: a box containing a collection of parts, tools, and obscure instructions that you hope to assemble into a useful object.
such as tracking school attendance and tuition payments, box-office theatre sales and ticketing, cabin rentals, or pet adoptions.
If this is you, then you have three options:
If you can't find one that fits your special needs, then you might consider a custom or homegrown program for that one, but do your homework first, as this choice will inevitably be costly. Unless you are lucky enough to find two programs that talk to each other (share data back and forth, a rarity), you will find yourself doing some double-entry of data most commonly when you update someone’s address, e-mail, or phone number.
It’s not a perfect solution, but you avoid all the double-entry of data.
You may start out with something that works wonderfully, but it will need constant maintenance and probably be outgrown eventually. You're very likely to end up spending huge amounts of money and time – you’ll be amazed at how much! At least look seriously at what software is available. Chances are good that somebody has already written a program to do what you need and you can save your resources to put toward your mission.
To see if FundRaiser Software might work for your organization
Watch this 5 minute video overview