The Amazing Contribution Report

TntConnect is a data-rich program. And the value of a support raising software is the way it can deliver data to you to help you…

  • Respond to donor activity (giving habits, gifts outside of their giving habits, missed gifts, milestones, etc.)
  • Plan future support development (categorize donors in priority order, determine amount to challenge, determine responsiveness to past campaigns, etc.)
  • Build relationships in general (keep in touch on a regular basis, remember milestone events in their lives, pray for them).

One of TntConnect’s most powerful financial components is the Contribution Report. This “13-Month Report” displays all gifts from all donors for the past 13 months (summarized by donor each month, not an individual gift list).

2017-10-13-ContrReport1

But that’s just scratching the surface of what this incredibly powerful and flexible report can do for you. In the upper left corner, for example, you can filter the displayed gifts based on the nature of the gift (include/exclude):

2017-10-13-ContrReport2

  • Gifts synced to the web (if your organization supports that)
  • Gifts you submitted to your organization which have not posted to the web (helpful to verify gifts you mailed in were correctly posted to your account)
  • Non-web gifts (to see those outside of the web posting)
  • Personal gifts (helpful if your organization limits the amount of personal gifts you can receive during the year)

You can also change the summary by adding/decreasing months (which I have done when I wanted to compare Decembers over a 5-10-15 year period), or switching to quarters or even years. I find it helpful to display by year, then increase the number displayed to all past years–that gives me a really helpful view long term:

(this screen shot cropped to simplify the display) Clark Kent has seen a lot of growth in since he joined ToonTown Ministries in 2007, but it looks like 2015 was a big year for some reason, or he has an alarming downward trend his director should be aware of, etc.!

2017-10-13-ContrReport3

Note in the above there are two boxes that may NOT appear on your Contribution Report:

  • The “All Designations” drop-down. For a database where many designations are included, and managed using TntConnect Pro, you can select any individual designation to display instead of all designations in the database.
  • The Currency drop-down box (displayed above as CAD Canadian dollar). The selected currency will show all gifts but only in the selected currency. Or you can check the box below (“Only show (CAD)“) to filter only for those donors who gave the selected currency. These boxes will only appear for those users who actually have more than one currency in their database.

A few extra things you should know about this profoundly helpful report:

  1. When you change any of the many filters at the top, you need to press the Update button to refresh the report (it does not update automatically).
  2. You can filter the displayed contacts to display only the Current Group (the Current Group that is selected in the Contacts View). This can be very helpful when you want to view the donations from a subset of your contacts.
  3. The Extra Fields button allows you to select any additional field(s) from the database to display in the report and then export. The report will remember your Extra Fields choices even after you exit the report and exit TntConnect.
  4. You can Sort by Last Gift Date (default and most common/most intuitive) or by Partner Last Name.
  5. You can Lookup the contacts who are displayed. Since your report only shows donors who meet your various selected criteria, there may be times when you want to then view only those contacts in the Contacts View.

Read the help topic about the Contribution Report
See the original help video
See the SmartStory short video

Advertisements

Manually Entering Gifts is a Breeze

Well over half of all TntConnect users serve with an organization that does not have a way to send gifts to TntConnect via the web or via a file. It may surprise you to learn that TntConnect was invented before the Gift Input feature was created. That is, all users had to enter gifts manually in the very beginning!

Because of this, TntConnect makes it super easy to enter gifts manually.

One option, of course, is simply to right-click in the Gifts box and “Add a Gift”—which you would do any time you add a single gift from a donor. But that is time consuming if you are entering dozens of them every month.

If you cannot download gifts at all, then your best bet is to use the Manual Gift Entry Form from the Tools menu.

Here is a blank Manual Gift Entry Form:

2016-07-06-ManualGiftEntry

If you are entering gifts multiple times per month (weekly, for example, as you view them on a web page), you will see that TNT displays all of the gifts so far this month:

2017-10-01-ManualGiftEntry2.jpg

This quick-entry form allows you to enter all of your gifts in just a few moments.

  • It displays every partner who has given a gift in the past 12 months.
  • You just enter the date and the amount.
  • You can lookup and add a New Partner to the form from your entire list of contacts (if the donor does not appear on the list).
  • You can press Another Gift if a partner has more than one gift in a month.
  • If you are working from a printed list or printed email (a little easier than toggling back and forth between TNT and your email or ministry web site), you can probably enter 25-50 donations in just a few minutes.
  • Also, if you receive gifts in more than one currency, you can enter all gifts from one currency at the same time. (If you do not have multi-currency turned on, the Currency box will not be shown.)
  • If you will not be linking to the web for gifts, be sure to uncheck the box New gifts on web so TNT will not be expecting you to download them (and match them) in the future.

The great news: No matter which of the 5 ways you enter gifts, TntConnect runs the same Automatic Actions for New Gifts features so you can take full advantage of TntConnect’s powerful analytics.

Read more about the Manual Gift Entry Form.

 

“Are you all okay?”

Two weeks ago I called a ministry partner in Houston. She’s an elderly woman who lives alone, and her daughter, I know, lives in Chicago. “I’m concerned about you,” I said. “Are you okay?”

She thanked me for calling and assured me she was fine. Her street was a river, but her front steps were dry. She felt very fortunate.

That was two weeks ago. Monday this week I texted my wife and asked her, “Are you all okay?”

I’m a pretty lousy husband. While my family was sleeping in the closet as Hurricane Irma blew over our house, I was on an international trip in Africa. Except for being without power for about 48 hours, and having a lot tree debris to cleanup, they were fine. She told me our neighborhood turned out like an anthill that was just kicked over–people we almost never out of doors emerged to see who lost a tree (or didn’t). Neighbors helping neighbors clean up. Won’t last long, but it’s great to see.

I appreciate that TntConnect helps me reach out to my partners and show compassion during a weather crisis like these–events that often affect a widespread area, and because of that I cannot know how my partners have fared unless I ask them. (Tornadoes, wildfires, earthquakes; sad we need a reason, but showing we care… shows we care.)

The best way to connect, of course, is just to call. Email or text is okay, I suppose. But a real phone call says a lot.

I use TNT to help me do this by using the Lookups to help me identify the contacts I could call. For example, last month I looked up all partners in Texas using Lookup | By State. Sometimes Lookup | By City works if that’s what I need.

One of my partners just moved to Texas a couple of months ago; I wasn’t sure where the town was, so I used the Google Maps button in TNT to discern that they lived outside Dallas, not Houston. But I contacted them anyway because a new address & new home were a good reason to call. And I started the call simply by asking, “Has Hurricane Harvey affected you at all?”

2016-09-15-mapslink

I don’t have ulterior motives with these calls. Every opportunity to reach out to a partner is a good one. Our partners love to hear from us, and most missionaries (like me) use the microphone portion of their smart”phone” far less than we should.

Speaking of that, How are you? If you were in an area impacted by Harvey or Irma–or wildfires in the West–I hope you have seen an outpouring of bonhomie from relatives, friends, neighbors, or even complete strangers.

Forwarding Order Expired

I just got a handful of my recent newsletters returned by the post office marked as “Undeliverable”. How do these things happen?

It turns out that I had not done a Tools | Update Donor Info recently. This connects to my organization and checks all addresses to see if the ministry has a more recent one. Several of my donors had moved (some I knew had moved but I did not have the correct address; others were a complete surprise).

After the sync, I had 35 contacts who had an address, phone, or email change. It is surprisingly common for a donor to alert the organization but forget to tell the missionary. (This is because the donor needs to change banking information or a receipt address.)

When a contact’s address/phone in TntConnect has an unresolved discrepancy with my organization’s address/phone, their address/phone will be bold and orange. There is a special Lookup just to find and resolve all these issues

After I did the donor info update, TNT offered to display the 35 discrepancies. But if I did not resolve them right away, I can still find them all later by going to:

Lookup | Unreviewed Account Info

If I see the organization’s address is one I know is an old address, I contact the office so they can update their address.

When I click on a bold orange address (or phone or email), TNT will display the Account Info box which shows me the donor information “from the organization’s view”.

2017-08-31-AddressInfo1

I can then click on the out-of-sync item and either Accept it (accept the organization’s version) or Ignore it (keep what I have already), if I think mine is more correct for me.

2017-08-31-AddressInfo2

In my experience, the organization’s address for my donor is usually more accurate. But the email or phone I have is usually more accurate than the ministry’s. This makes sense because donors change their email and phone #s a lot more frequently than their addresses, and they generally do not broadcast those little changes to businesses.

There are two very helpful topics in the Help Guides with a lot more detail about this subject:

View Organization Info (about the Organization details for this contact)

Update Donor Info (about the Tools menu link)

Oh, one more thing… even if the address is not Bold and Orange, you can easily get to the Organization Account Info either by selecting Contact | View [Org] Details, or just by clicking the Account number on the far right of the Name & Address Bar:

2017-08-31-AddressInfo3

“Please Pray for Me”

I put that title in quotes because I am not asking you readers to pray for me personally, but rather this blog post is about how to handle prayer requests from your donors.

One of the wonderful aspects of being a supported missionary is the opportunity we have to pray for our partners. Praying for our partners is a wonderful way to minister to them–to exercise partnership.

There are a few different ways to easily track prayer requests. Some users create a “To Do” task, and there are certainly benefits to that. It is possible to create it as a task and either not check it as “completed” until I stop praying for it; or, you can “complete” it and then having a recurring task re-create it perpetually.

I tried that once, but found that once I had two dozen or more prayer requests, my “actual” support-raising tasks (phone calls, appointments, and thank yous) were obscured. Of course I could filter calls and thank yous, but even so, the ‘urgent’ items I found were not as visible.

I personally do not view prayer as a “task”. I do not pray for someone and then check it off as “completed”.

What I have found that works well for me is actually logging the prayer request in TNT’s “jet engine”… the History Log.

I create a To Do history item (as if I had Done it). In the description I prefix the request with “PRAY:”, like this:

2017-08-28-PrayerReq2

Then I can go to the History View, select All as the time frame, and type PRAY: in the text filter, like this:

2017-08-28-PrayerReq3

When I am finished praying for this specific request, I can keep it in my history by editing the description. For example, I can change PRAY: to PRAY (DONE):

2017-08-28-PrayerReq4

By doing this, it will no longer appear in my prayer request filter in the History View.

See a video on this topic

Sweet Child of Mine

Over the years I have fielded many questions, thoughts, and suggestions on countless topics. But few have engendered as many differing opinions than how TntConnect handles “children”.

As most TNT users know, the Family Tab offers only one field for children information. While the yellow box is not particularly limited in length, practically it is limited to the 46 characters I can see on the screen. It does not do me much good to enter 500 characters of data if I cannot see it except by exporting.

2017-08-24-ChildrenField

TNT is a “data-lovers tool”, and this is one field where data-lovers would love a lot more.

For example, several users have asked me for a table where they can list every child, have a birthday for every child (which appears on the Birthday & Anniversary Report), list the spouse of every child, and have a memo field to write notes about the children, their hobbies, etc.

Others have asked for a bigger box, others for… whatever. Bottom line–lots of different ideas. I’m not the developer, so my answer is always to explain “How to do what you want to do with using what TNT already delivers”. 🙂

So the simple answer / simple solution to this situation is either:

  1. Just use the Children field as delivered, or
  2. Set up children as separate contacts in TntConnect.

In my own personal database, I have about five families where parents and children are separate contacts (and separate donors in many cases).

Once I set up the child as their own contact, then I can record everything in delicious detail: All of their bio data (birthday, church, hobbies, spouse, etc.), and any relationship activity (birthday cards, summer mission trip support, graduations, etc.).

It is sad to say Goodbye (Part 2)

Two weeks ago I shared the story of how one of our long-time partners went home to be with the Lord. In this blog post, I want to share some of the practical steps you take in TntConnect to record the passing of a contact.

Over 90% of our financial partners are married couples, two of whom are widows. There are two scenarios for managing deceased contacts:

  1. When the whole contact dies, typically a single person, and very rarely (never for me), when both die together such as in an accident.
  2. When one person in a couple dies, leaving a surviving spouse. This is the more common scenario for me personally at this stage of my life.

When a whole contact is deceased

When a contact dies, the simple step is to check the Deceased checkbox on the TNT Tab. As you have probably discovered, TNT “saves as you go”, but on the TNT Tab (and other tabs where you enter data), it does not save instantly as you move from field to field but rather when you switch tabs or switch contacts. So pressing the Deceased check-box will not “instantly” cause these actions to occur. But you can force them (see them happen) by pressing the Save button at the top.

Here is Elmer Fudd through the Mark Deceased process:

1. Before he is marked deceased

2017-08-16-Deceased1

2. When the checkbox is first clicked but not ‘saved’ or switched to another contact. Note that immediately (without the Save), the TNT Phase switches to “Never Ask” and the Send Newsletter box unchecks.

2017-08-16-Deceased2

3. After the Save, the Name & Address Bar looks like this, and

2017-08-16-Deceased3

4. The Address Tab changes to this:

2017-08-16-Deceased4

When only one spouse dies

This is the more common scenario when the donor is a couple. One spouse will pass away first. And in my personal experience with the 7 couples where both have passed away, in 6 the husband died before the wife but only 1 where the wife died first.

TNT is not ideal in this sense, because it does not track this type of relationship nuance. But given the relative rarity of this, it does not make sense to program a lot of complex features for how little they will be used.

Simple steps:

  1. Press the Edit Contact button. Manually remove the name of the spouse who has died.
  2. If it is the husband who has died, then move the wife’s name to the ‘primary’ side.
  3. On the phone and email boxes, delete the deceased spouse’s information and move the surviving spouse’s if necessary.
  4. On the Notes tab, type the name of the deceased spouse (to avoid a potentially embarrassing question in the future)

In pictures:

2017-08-16-Deceased52017-08-16-Deceased62017-08-16-Deceased72017-08-16-Deceased82017-08-16-Deceased9