FundRaiser Blog

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.

Although custom-written software can be next to impossible to maintain, support, and upgrade over the long term, it's nice to have a few features that you can "mold" to suit your organization's particular needs.  Here are a few that are found (as noted) in FundRaiser Spark, Select, and/or Professional:

Found in all three versions, Spare Fields are created in the Options section, and are used to hold information that a) needs to be isolated, b) has no other designated field, and c) will commonly be available for all name records.  Spares can hold text, numbers, dates, or consist of a logical yes/no checkbox, or even a dropdown containing codes of your own making.  Isolating data in spare fields allows it to be more easily merged into correspondence, exported to other programs, and (in Select/Pro) used as columns in User-Defined Reports.

When entering a gift in FundRaiser, the Mode Code is used to differentiate not only between methods of payment (cash, check, charge, etc.) but also between monetary or in-kind donations.  When you create a Mode Code you must specify whether that code will be monetary or in-kind.  A Mode Code is always one or the other, and each gift requires a Mode Code.  You may have multiple codes, as is usual in FundRaiser, which allows for specific types of in-kind donations.  For instance, one of our users is a diaper bank, and, while they accept many infant-related types of in-kind donations, they need to keep diaper donations separated from others.  The easiest way was to have, simply, a "diaper" Mode Code.  When running various reports, you can specify to include monetary, or in-kind, or both types of donations.  Use these codes to your advantage.  And check out the Coding & Spare Fields training video in the Customer Portal section of our website.

On each gift record is a "Letter Notes for Merging" section.  It is primarily used for notes that will then be merged into thank you letter templates.  And for monetary gifts, these are usually personal greetings, of sorts, like "Gee, it was great to see you", or "Glad to see you've recovered from surgery", or something else to more personalize the thank you letter.  For In-Kind donations, this is a great place to put a description of the items (or services) that were donated.  It makes a permanent record as well as an easy way to pull that description in to a thank you letter.  More information on entering gifts is available in both the FundRaiser Overview and Recurring Gifts training videos available in the Customer Portal section of our website.

One of the biggest time savers, no matter the task, is to have a plan of attack, and to stick to that plan.  While you may have to make adjustments when circumstances warrant, having a basic plan for inputting data and outputting results will give you consistently better results than a slapdash approach.  In FundRaiser, the normal flow is to 1) enter gifts, 2) check your entries, usually by running the Automated Correspondence for Gift Thank You's report, and, finally, 3) print (or email) your gift thank you letters.  The job of recording a gift isn't complete until all three steps are complete.

I've mentioned in other blogs that it's easy to do more than necessary when entering data, by coding people with giving-related attributes, for instance, or storing the same information in multiple ways.  If you have a plan (see #1 above), it should include what codes you want to use for people, and what codes you want to use for gifts.  Understanding the various codes in FundRaiser, and how they relate to creating Groupings and Reports, is fundamental in having a smooth working relationship with the software.  Don't try to record every little detail, unless that detail is critical to understanding your donors or their giving, or unless that detail gives you another avenue for requesting future contributions or participation.

1. People codes vs. Gift codes

The most important code usage tip (in my opinion) is to make certain that the assignment or attribute fits.  In FundRaiser there are codes that attach to name records (what I call "people" codes), and codes that attach to gift records (hence "gift" codes).  For the most effective assignment of codes, think of codes as "unique identifiers" that attach to either a person or a gift.  In other words, does the code have to do with the person, defining that person in some way?  Or does it have to do more with a gift, defining the gift in some way?  An example of people codes are the Category codes in FundRaiser.  Category codes, unlimited in the number that can be created and/or assigned, give us information about people such as life situations (parents, grandparents, students, seniors, occupation, hobbies, interests, relationship to our organization or another, etc.).  Gift codes, on the other hand, tell us about the gift, such as why the gift was given (Motivation code), or how that money is to be spent (Purpose code, for describing restricted/designated use gifts).  Make a list of all the things you need to know about a gift.  Make a separate list of all the things you need/want to know about your people.  Keep the lists handy, and, when in doubt, refer to them when wanting to assign a code.

Note from Sasha: I have worked with Robert L. Weiner at the TechSoup forums where we have both been volunteer forum moderators in the database and software section for many years. Come visit us there sometime! Over the years, I've come to respect his depth of knowledge and skill at sharing about best practices for using donor databases. This article by him is one of my favorites. Robert is an independent technological consultant to non-profits and is not affiliated with FundRaiser Software. I'm sharing the article because I believe it is one of the most concisely helpful resources written on the subject of donor database best practices, and that FundRaiser users will benefit from reading it.

After people, data is your most important asset.-- John Kenyon

Here in southern Arizona (location of the FundRaiser training office), they are affectionately called "snowbirds".  They leave their main homes and "fly" south when the weather becomes cold and bitter, and tend to return in the spring, at least until retirement.  When I lived in Florida, vacationing Canadians were given the same nickname.  The populace of the United States is a very mobile one, and keeping up with any one person can be difficult.  FundRaiser Select and Professional have a feature that will help you keep up with your "migratory" donors and prospects, and it's called Alternate Addresses.  If you have FundRaiser Spark, or Basic, you may want to check into moving up to Select or Professional here.

Many folks have permanenet vacation addresses.  Many don't.  For those who don't, try to get email addresses and you'll still be able to reach them no matter where they are.  For those who DO have permanent alternate residences, simply enter them in the Alt Add tab in the Name Details section of their name record.  One thing to note is that there are two (2) different ways to tell FundRaiser which address should be used at any given time.  When you enter an alternate address, you have the option of assigning a code to the address, which can be handy for different "types" of addresses, like work vs. home, or current vs. previous, but you also have the option of assigning a date range to show when the alternate address will be occupied.  This is a much better solution , in my opinion, for vacationers, when you have a good idea what that date range will be.  You might want to store previous addresses, and, when someone moves, you'll be able to "save" the old address as an "inactive" alternate address, too.  You can pull an alternate address into the primary address page just as easily, from the Alt Add tab.

What happens when you begin to have more than one person working simultaneously in your donor database? For one thing, new situations arise that weren't there when only a single user was accessing the database. There may be questions about data integrity, work flow, or coordinatiing usage of the program.

This article will shed some light on these common questions and concerns about coordinating more than one user working in FundRaiser. I'll suggest ways to make FundRaiser even more helpful in keeping your information secure and accessible.

Okay, so we're not going to travel back in time to keep tabs on Ulysses, here, but in tracking grant proposal progress, it is important to make sure that each step of the process is done in a timely manner. There are usually deadlines that must be met to be considered for grant monies, so it is imperative that we have some method of reminding ourselves when those deadlines are coming near.

In FundRaiser Professional and FundRaiser Select, the "Tickler" system fills this need. Tickles are date-sensitive reminders that can be associated directly with a name record, such as a Foundation from which we are seeking a grant. There is a Tickle tab for each and every name record. In this tabbed page, we can keep multiple tickles, with "Do Dates", notes, and more. In the case of a grant application, you would set up separate tickles for each stage of the application process, and later for the reporting deadlines. If different staff members need to be involved, you can assign tickles to the responsible staff members to accomplish. Once they have completed their portion of a tickle, they can pass the tickle along to the next staff member, or when completed, can give it back to you.

The Ozarks have put on a truly breathtaking show this Fall.  I have never seen colors so vivid.  The trees stand boldly clad in crimson and gold.  Ruby vines twine around trunks and gently swing from branches like expensive jewelry.  Even when clouds darken the sky, the colors continue to glow as if lit from within.

Color is such an important part of our lives.  Naming colors is one of the first things we learn as children.  Since color is a near universal language, stemming from somewhere deep in our primeval history, we can use color to communicate many things without words.  Red usually means stop or danger, yellow inspires caution or attention, and green suggests going ahead.  Like most people, I suspect, I don’t even have to think about these impressions, they are just there.

What is the question?  What should we code or not code?  And why?  In FundRaiser we have the option to use a lot of different types of codes, and sometimes, in a well-meaning effort to document as many aspects of our donors as possible, we end up duplicating our efforts and making things more confusing by creating unnecessary codes.  And what, exactly, ARE “unnecessary” codes?? 

I have a lovely south facing window next to my desk at the FundRaiser office. Early this spring I replaced the sinuous vines that had been growing on the windowsill next to my desk. They had been slyly trailing beneath my desk, giving me the impression that they were ready to wrap around my feet and drag me under the moment I wasn’t paying attention.

I decided that sweet, innocent strawberry plants would be a lovely replacement. After all, there could be nothing sinister about the fresh green, rounded leaves and delicate white blossoms with their cheery yellow centers. The vines went into the compost pile and five small strawberry plants took their place in fresh new soil. The plants seemed very happy in their new home and the June bearing variety quickly produced blooms followed by small tart berries. Then the runners spouted.  It began with a single, innocent shoot. Now the longest one is relentlessly reaching for me across the top of my desk.  Time to find the pruning shears.... A coding scheme in your donor management software can be very much like these vines.

It's scorching hot here in the Southwest (training office is in Arizona), and the monsoon rains just haven't been as heavy or as often as we'd like to cool things down or build the water table up.  This is the time of the year when many of us become lethargic and just don't want to do much more than sit and think.  And I was thinking of the impending deadline most all of our users have in the near future.  It's just around the corner:  the deadline for getting the best upgrade pricing for Client / Server.  And some folks may be wondering how much change this will make in their use of the program.  Most of us are used to routines in entering data, creating reports, sending thank you letters, and so on, and ANY change can be a bit intimidating.

How much will you need to re-learn once you've upgraded to the Client / Server version?NOTHING.

My morning cup of tea on the back deck was especially nice today. A cool breeze swirled though the leaves of the trees and brought the first spicy hint of autumn to my nose. Grass, newly green from recent rains, has quickly pushed dangling seed heads toward the sky.  Crickets piped their sad tunes from the hedge. Even the placid doves seem livelier with the advent of cooler weather.

While I sat, a steaming cup of mint tea cradled in my hands, I watched a small grey rabbit dine on a patch of clover left uncut by the corner of the house. His ears flicked back and forth and his bright black eyes scanned his surroundings as he daintily pulled velvet green leaves from their stems. One can hardly blame him; a rabbit, being the natural prey of pretty much anything with pointed teeth, must always be ready to run.  The slightest hint of trouble will send him bounding away.Donors can be very much like rabbits when it comes to their information with nearly as many “virtual predators” as a rabbit has physical ones.

Mother Nature is mistress of the art of timing. When left to her own devices, everything happens when it should.  Seeds sprout when the soil warms enough to nurture them properly.  Delicate green leaves unfurl when the days are long and warm enough to feed the tree.  Blooms burst forth just in time for the bees and other insects to pollinate them, while birds hatch their hungry families to feed on this bounty.

I, on the other, do not have Mother Nature’s patience.  I am always trying to bend the rules.  I want those super early tomatoes, flowers in the winter, and cucumbers in December.  These preferences have nothing to do with what is best, just what I want.  The funny thing is that when I do get my way with these things they are often less than satisfactory.  Those early tomatoes are small and bitter from lack of sun; the flowers quickly marred by insects, and the cucumbers bland and tasteless.  Truly timing is everything.Just as with gardening, timing is vital when creating your FundRaiser backups. 

When it comes to using codes in FundRaiser, MaineShare (this month's Case Study organization) has as good a handle on the process as any user, and better than most.  And they are using codes to their advantage in a rather intricate pattern of donations to keep everything straight in their records and aboveboard in their dealings with donors.

The whole idea of codes is that we can uniquely identify things with codes, and each code can represent something a lot larger than itself.  There are codes that are applied to the donor record and codes that are applied to each gift record.  So this means that we can uniquely identify both gifts and donors through codes.  The number of gift codes are limited, and many of them are pretty limited in their application, such as the gift Mode code, which represents a method of payment (cash, charge, check, inkind, etc.).  There isn't a lot of leeway in the use of this particular code field.  But then there is the Motivation code, to tell us WHY a person gave, the Fund code to tell us WHERE we put that money, and the Purpose code, to say HOW we are going to use that money (restricted or designated funds).  With Professional, there are a couple of extra gift codes, for even more ways to break out gift reports.

I love weeds. That may seem very odd to hear from someone who enjoys gardening, but perhaps I am not a typical gardener. I must confess I’m terribly fickle when it comes to my garden. Each spring I succumb to the passion of lush, green spring and gaily plant far more than I can ever take care of. Inevitably the oppressive heat of summer squelches my enthusiasm and only those plants that survive the minimal tending I care to give them live to benefit from my renewed vigor with autumn’s chill.Despite these serious flaws in my gardening technique, I’m never without green in my life. For intrepid weeds soften my failures. Perhaps my favorite is the wild morning glory. Its rich green leaves cover a vine as tough and tenacious as barbed wire. These tendrils coil from dry, barren ground and climb to the sun upon anything they can reach. Yet from this ruthless creeper spring delicate ivory blossoms that sing to the sun for only one day. It is truly heartening to see beauty spring from what seems to be nothing.

Nonprofit organizations often have the same issue with hardware and software. You spring out of what seems to be nothing, pulling resources from volunteers and donations from the community you serve. Purchasing up to date computers and hiring someone to set up and maintain them is frequently out of your reach, financially, although I’ve seen some pretty amazing things done with the bare minimum.

For those of you who haven’t spent much time on the phone with me while unraveling one of the many mysteries FundRaiser may present us, I’m an old-fashioned girl. I cook most everything from scratch, make cheese, and sew some of my own clothes. Don’t get me wrong, I like electricity and indoor plumbing as much as the next girl, but I feel strongly that technology should be a helper, not the sole reason for doing something.

This month is the celebration of independence for the USA, and it seems appropriate to try revolutionizing your thinking about creating segments of your database, or Groupings, and, hopefully, turn an otherwise onerous task into one that gives you more freedom and choice. Groupings help you to pull out a sampling of people (or organizations) from your full database in order to treat them as a separate group. Why would you even want to do that? Well, the most common answer is to “target” an audience with a specific message from your organization, whether for an appeal letter, an invitation to an event, or a special “thank you” newsletter at the end of a particularly successful campaign.

Sometimes you may just want to see how many people fit certain criteria (how many people gave this year? Last year? How many gave more than X dollars all time? During the previous 24 months?). You may not even need to look at the records individually, but just need the number of records involved. You may want to take one of those groupings, and use the records in a report so that you can see their individual giving, or to list out their contact information, and so forth.

I think the key attraction of owning our home for me is the fact that I can do whatever I want with it. If I want purple and green walls I can have them (well if I can talk my husband into it, that is). One of the first things we did after buying the house was remove the door between the kitchen and the bathroom as it made the kitchen basically a hallway to the bathroom. One must walk through the bedroom to get to the bath now, but I felt that is more than made up for by the increased counter space I will be able to add.