• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar

Icon Systems

Simple to use. Power to grow.

  • (800) 596-4266
  • Free Trial
  • Blog
  • Features
  • Bookkeeping
  • Order
  • Pricing
  • Resources
  • Login

July 29, 2014 by Icon Systems Leave a Comment

This post was last updated on February 14th, 2024 at 09:54 am.

If there’s one thing churches want to eliminate when it comes to receiving donations, it’s the Summer Slump. It’s that time of year when folks are taking vacations, attending graduations and weddings or spending weekends at the lake. The change in routine all too often causes a disconnect in regular giving, even though the light bill, salaries and other typical monthly expenses incurred by the church still need to be paid. While tools such as automatic electronic fund transfers and online giving pages can help lessen the blow, maintaining contact with those who need a little extra encouragement in order to be consistent with their giving can be beneficial for both the church and the giver. In IconCMO, you can use Donations: Statements to identify and generate mailing labels for individuals who have not made a financial donation during a certain period of time.

From the IconCMO menu, go to Donations: Statements.

The Contribution Statements window showing the outlay of the screens
Fig. 1 – The Donation Statements window

Let’s take a look at a particular scenario. To do this, we’ll make a few assumptions:

  • All donations that have come in so far for June and July have been posted.
  • Giving has been consistent and on-target from January through the end of May, but began to slump in June and continued to run behind in July as well.
  • We are primarily concerned with consistent giving on the part of our active members and active non-members.
  • We want to make contact with individuals who have not made a donation in either June or July. We’d like to send out a letter in August to encourage them in their giving, so we’ll need to produce some mailing labels. The setup parameters should look similar to what is shown below.
The Contribution Statements setup screen.
Fig 2. – The Donation Statements setup screen.

Several important parameters have been highlighted in yellow. Notice that the People Who Have option has been changed to Not Given, so that we only print labels for folks who have not given a gift. We have set a date range which covers June and July, specified that we want people with a Household Status of either Active or Active NonMbr, and set our Reporting Options choice to Labels (All) so we get mailing labels instead of statements. Setting the correct Label Type and clicking the Show Report button will generate output to a PDF document from which mailing labels can be printed.

It’s possible you may want to produce your letter by employing a mail-merge technique, as this will allow you to automatically insert first names in the salutation of the letter. You may also want to print the member’s address on the letter itself. To do this, go to Donations: Reports and click on Pledges & Donations For Assigned Donor #’s – All Funds Include Contact Information to access the report.

The contribution giving reports menu and report options.
Fig. 3 – The Donation Giving Reports Menu

This report can generate output for the same group of people we printed labels for from Donation Statements. The setup for the report should look similar to what is shown below.

The setup parameters for the Pledges and Contributions with Contact Info report.
Fig. 4 – Setup parameters for the “Pledges and Donation with Contact Info” report.

Notice we have set a Date Range which covers June and July, specified that we want people with a Status of either Active or Active NonMbr, set our Pledge Range so that it doesn’t matter whether they made a pledge or not, and set our Giving Range to zero so we only find those folks who have not made a donation in either June or July. Additionally, our output will be in Excel Report format, so we can mail-merge the data. Clicking the Show Report button will generate output that looks similar to what is shown below.

Output from the Pledges and Contributions with Contact Info report shown in Excel format.
Fig. 5 – Output from the “Pledges and Donation with Contact Info” report shown in Excel format.

You will notice that the Name column is not in the ideal format for a mail-merge letter. There are options in Excel that can be used to put first names in one column and last names in another. In this example, we’ll use some formulas to do this. In the next two screen shots, you’ll see that we’ve inserted two new columns, First Name and Last Name. By entering (and then replicating) a formula in these columns, we can separate the first names and last names for our mail merge. The formula for extracting the First Name from Column A into Column B is shown in Figure 6, while the formula for extracting the Last Name from Column A into Column C is shown in Figure 7. The result yields some name columns with a data format that is suitable for use in a mail-merge letter.

Excel spreadsheet showing Excel formula for extracting the first name from column A.
Fig. 6 – Excel formula for extracting the first name from column A.
Excel spreadsheet showing Excel formula for extracting the last name from column A.
Fig. 7 – Excel formula for extracting the last name from column A.

Now that you have the tools needed to reconnect with your lapsed givers, might this be a good time to write that letter?

Featured Photo by Emilio Takas on Unsplash

Filed Under: Contributions Tagged With: church accounting software, church management software, church reports, contribution statements, donations

Avatar for Icon Systems.

About Icon Systems

Icon Systems, Inc. has been a leader in church management software since 1992. We develop high quality software for religious organizations, from church plants to denominational offices. Always improving, we’re committed to continually enhancing our cloud-based church management solutions so we can meet churches’ ongoing needs for efficient administration, effective communication and accurate FASB accounting.

Reader Interactions

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Primary Sidebar

several dollar bills some flat some folded
Top Rated
Church Accounting Software

Search blog posts…

Popular Posts

  • Debits and Credits – Does Debit Mean Minus and Credit Mean Plus?
  • Church Finance - Renting Space And Its Cost
  • Fund Transfers and Account Transfers, part 1 of 2
  • Church Software Mobile Apps - IconCMO Set Up
  • Training Videos - IconCMO Church Management System
  • Bolster Your Outreach With QR Codes
  • Easy Church Fund Accounting Example!
Blog Home

Subscribe to Our Blog!

Sign Up Now
We respect your privacy and you can unsubscribe at any time.
  • The Facebook icon button link
  • The Instagram icon button link
  • The X icon button link
  • The LinkedIn icon button link
  • The YouTube icon button link
  • The Wordpress icon button link
Icon Systems, Inc.
3330 Fiechtner Drive S Suite 204
Fargo, ND 58103
Hours: Mon-Thu 8-5, Fri 8-4 CT
About Us — Privacy — Support — Careers — Sitemap
Recent Blog Posts
  • Is an All-In-One Church Software the Best Option?
  • Church Donation Software - Do you Need It?
  • Text Messaging for Church Software!
  • Is Church Software Online A Better Solution?
  • The Best Church Software Is Compliant & User Friendly!
Sales
800-596-4266
sales@iconcmo.com
Tech Support
218-236-1899
support@iconcmo.com
Fax: 218-236-0235
© 1992 – 2025 Icon Systems, Inc.