FundRaiser Blog

The FundRaiser Software Blog is an excellent resource for nonprofit organizations looking to learn more about fundraising, donor management, membership management, and much more.

Producing End of Year Tax Summary Letters in FundRaiser

Producing End of Year Tax Summary Letters in FundRaiser

It's time to produce Tax Summary letters (also called End of Year letters) again. They are usually sent in January after the last donation for the year is in. To help you breeze through this process, here's a coherent plan of attack for FundRaiser users.

Step One

First, start by deciding how you want to list the donations in your letter. Two merge functions found in the FundRaiser word processor are used specifically for this type of letter.

  • GiftList function
  • GiftTotal function

You may decide to use either or both of these merge fields in your letter.

The difference between these two functions is the level of detail they give. GiftList provides a list of donations. GiftTotal provides a single total amount.

GiftList Function

      The GiftList is a mini report-- it shows a list of individual gifts.

In FundRaiser Spark, Select and Professional, you can choose which columns will be displayed, like Mode (check, charge) or Benefit (if the donor received any goods or services from you in return for their donation). With Benefit, you can display the amount and description of the benefit, and GiftList will subtract the benefit total from the total given and show the actual tax deductible amount.

Gift Totals Function
The GiftTotal function simply calculates the total dollar amount for a date range that you specify when entering the function. Usually you use this merge field in the body of the letter, where you would say something like "Thank you for donating a generous total of [GiftTotal] this year."

Other Merge Functions You Might Use in your Letter
In FundRaiser Sparl. Select and Professional, you can configure the GiftTotal merge function to show the "net amount" (total given minus any benefits). You could then, for example, add that function to the end of the sample line above, like: "of which %[GiftTotal] is tax deductible".
Another merge function in Select and Professional is GiftCount, which allows you to say how many donations the donor gave. You could say, for example, "Thank you for your 7 gifts totaling a generous $500, of which $375 is tax deductible."

Step Two

After you've decided how to list donations, get your letter template ready. There is a sample letter called EndOfYear that comes with FundRaiser. Click on the WP (Word Processor) button in FundRaiser to open up the built-in word processor. Edit the message to suit your organization's mission and change the year for the GiftList merge function by deleting the function, then re-inserting it. If you've decide to use the GiftTotal function in addition to (or instead of) GiftList, then make that change to the template also.

If you already have a letter that you used successfully last year, then all you need to do is reset the GiftList and/or GiftTotal functions in your letter template, so that you can change the date range from to the correct year. To reset these functions, just double-click on them to bring up the criteria window.

Step Three

Before you print your letters, and now that you've gotten all the details of the letter done, double-check that you have all of your gifts from the year entered into the system. It sounds like an obvious matter, but it will be much easier to print letters for all donors, rather than having to go back and print letters one-at-a-time for those that were somehow overlooked. Maybe while you've been getting the letter details ready one last check has surfaced.

Step Four

Now, create a Grouping of everyone who donated last year, or you can simply use the Advanced section of the Mass Mailings to select those who have given gifts during the past year.  Whichever way you decide to do it is fine, but the Grouping is more permanent, in that the instructions you give FundRaiser to create the grouping are saved in a file, and the grouping can then be used at any time in the future, too.

When creating the grouping, you might save a little money by selecting only those who gave more than $20 or so during last year, but we recommend that you send a letter to everyone who gave, regardless of amount. Why? Because this is the perfect time to re-establish your relationship with all your donors. Even if someone gave only $5, you may be able to convince them to give more or to give more often. You can be pretty certain that they will not give even the $5 if you do not maintain your relationship with them.

Step Five

To print letters, click on the Print menu, then on Mass Mailings.  In the Specifics tab, choose Letter, making sure you also select the letter you want from the letter dropdown in the center of that page.  Also remember to set your print choices, especially if you have some folks who prefer email.  In the Who page, select your Grouping.  You may want to Exclude those marked Deceased, but not necessarily those who are Inactive, Anonymous, or Exclude from General Mailings.Click on the Print button, then preview your letters to make sure they look okay (this assumes you’ve got the Specifics tab set to preview first), and then click on the printer button in the upper left of the preview window to print.

To print labels or envelopes, return to the Mass Mailing window, and on the Specifics tab, choose Labels or Envelopes. Check the Who page again, making sure the same Grouping is chosen, with the same settings, and then choose to print.  You’ll get another window where you can choose the defaults for your particular Labels or Envelopes.  Unless you changed settings on the Specifics page, the labels or envelopes will be printed in the same order as the letters.

To learn more about how FundRaiser can help with keeping in great contact with your donors 

Take a look at some of the basic features of FundRaiser donor management programs

Reach More Donors with NCOA Processing
An Open Letter from FundRaiser CEO, Autumn Shirley...

Related Posts

Wait a minute, while we are rendering the calendar
GoFundMe project volunteering upgrading donors development director customer service targeted mailings grassroots campaign NCOA processing Thanksgiving Tickles password protection adding personal notes to letters salutation relationship tracking donor engagement online donations updates ticketsales custom page ticket sales mailing pledges transparency technical support board members monthly giving donor relations annual campaign new leadership correspondence backing up data Crowdfunding Campaign operating systems accounting software Personalizing advanced tab brick campaign donor source giving levels recurring gifts donor preferences banquet gift notes field office thank you letters motivation code tech tip donor retention rate phoning donors Network for Good New Year gift entry budget Reminders moves management donor attrition rate data entry increasing giving amounts auction personalizing letters tax summary letters mode code operational costs donor advised funds the Ask #GivingTuesday anonymous donors merge fields donor recognition reports membersip benefits letter membership benefits how to handle auction gifts holiday direct mail announcements GivingTuesday letter templates how-to videos volunteers arts publicity materials holiday giving spreadsheets Snow Birds alumni corporate sponsors texting donors lapsed donor mission driven LYBUNTS community broadcasting appeal nonprofit fundraising PayPal Constant Contact SYBUNTS customer portal donor slip In-Kind gifts giving history donor prospects user interface annual maintenance plan planned giving holiday letters animal rescue look and feel government grants membership programs support welcome packet Reporting to IRS pictures Groupings fundraising letters Importing Data solicitors donor contact information social media overview data conversion communications donor targeting flash sales charity golf tournaments large donations motivation ROI entering auction gifts user spotlights capital campaign spare fields memorial giving campaign management foundations upgrade follow up Company culture training fundraising Codes FundRaiser Spark building donor relationships role of nonprofits raffle case study new nonprofit in honor of donations happiness donor profile event management on site training grants community arts nonprofits product news small donations major donors online donations premiums passwords importing csv new version Resiliency Task List appeal letters Alternative Addresses disaster relief campaign donor loyalty planning correspondance donor retention add ons Congratulations security segmenting donors legacy giving major gift prospects donation history Facebook campaign community supported gardens general Donor Portal vacation endowment campaign donor National Change of Address prospects data analysis change of address updating Thank You features Volunteer module email repeat donors new donors FundRaiser Basic understanding giving trends Excel End of Year Letters training tip Cloud word processor tribute gifts Facebook new features merge notes donor attrition gift acceptance policy FundRaiser Hosted

Connect With Us

  800-880-3454 ext 3
  Email Us
  Request More Information
  Monday-Friday
      8:30AM-5:30PM CST

Customer Portal Login Form

   

The customer portal is unavailable. If you need support please reach out to support@fundraisersoftware.com Thank you.

 

  User Name:
  Password:

If you are not sure about your Customer User Name, please call 800-543-4131 and we will be able to help you.

Or you have lost your password, Request Password