Touchpoint Software Documentation | Contribution Statements

Contribution Statements

Posting Contributions

Contributions must be posted on the donors’ records before statements can be generated. Be sure to close the bundles before running all statements.

Administrative Setup

Before you generate statements for the first time, your TouchPoint Administrator will need to customize the header and notice for your statements.

You will want to make sure that you have your donors’ Contribution Statement Types set up correctly. This will ensure that they receive the appropriate type of statement, either Individual or Joint.

Mailing Contribution Statements
Contribution Statements in TouchPoint are designed so that you can use #9 window envelopes. You can choose either the one window envelopes to display just the mailing address, or the two window envelopes to display your return address as well. If you prefer to print labels instead of using window envelopes see Export Contributors Only below.
Frequency of Statements
Some churches choose to generate quarterly statements, while others generate them only at the end of the year. Because you control the date range, you can generate them whenever you like.

Options for Generating PDF Statements

Individual or Family Statement
  • Go to the person’s record.
  • Click Giving > Statements.
  • Click the year for which you want a statement.
  • Use the Print function from your browser to print the statement.
  • After printing, you can use your browser’s back arrow to return to the person’s record.
Donor-Generated Statement

Anyone who has a user account, including those with MyData and OrgLeadersOnly accounts, can print their own statements as follows:

  • Log on to your TouchPoint database.
  • If you are a MyData user, as soon as you log on you will be on your record. If you are an OrgLeadersOnly or Staff user, select your name from under People in the main menu (it will be the last in the list).
  • Select Giving > Statements.
  • Click the year for which you want a statement.
  • Print using your browser’s print function.

See Exclude Electronic Only section below.

All Statements
  • Go to Administration > Contributions > Statements (Create All).
  • Select the Start Date and End Date.
  • Select the Sort - either Name or Zip.

Note

See further options below. You may choose to run a sub-set as a test by using the Starts With option.

  • Click Run.
  • You will see the date / time you started the process, the Total Contributors (this number will build until it finds all who fit the criteria), the status, which will indicate ‘running…`, the current number of records the system is working on, and the Set #. Set #0 will be the set with everyone included; set #1 will be the one-page statements. You will have sets for each group based on the number of pages in the family’s statements.

Important

Once the process has begun, you can leave the page and continue to work elsewhere in the system. Or you can even close your browser. The statements will continue to run on the server.

When you want to check the progress, return to Administration > Contributions > Statements (Create All). Select the button Previously Run Sets. This will take you to the page indicating the progress. The page will refresh every 5 seconds, which will indicate to you that it is still working.

Once all statements have been generated, you will see a link for All Households (PDF). This will be all statements. If the status still indicates Running…, then it is working on the paged sets of statements. Again, you can leave and return at any point. Just be sure to select Previously run Sets.

Completed Statements

When the statements have totally finished, you will have two or more PDF files.

  • All Households - all the statements in one PDF file
  • Set 1 - one-page statements per family
  • Set 2 - two-page statements per family
  • Set 3 - three-page statements per family
  • You will have more sets if there are families with more than three pages.

This little 2-minute video will show you what to expect.

Further Options

Exclude Electronic Only

Check this box if you do not want to print statements for those who have opted for Electronic Only statements. These My Data users will log on and generate their own statements from the Giving > Statements tab.

Tip

You may want to exclude these donors for the first 3 quarterly statements, but include them for the yearly statement.

In Search Builder, run a search to find those who have opted for Electronic Only, and send them an email letting them know when each quarter’s contributions have been posted, so they will know they can log on and print their statement. The Condition Wants Electronic Statement is on the Contributions tab and should be Equals True.

Sort
  • Leave as (not specified) to sort by Family ID
  • Select name to sort by last name
  • Select zip to sort by zip code
Select Tag
  • If you need statements for just a those in a specific tag, select it from the drop-down.
Starts with
  • Leave blank for all statements
  • Enter a letter of the alphabet to print statements only for those whose last name begins with that letter
  • Enter a range such as A-M or Aa-Ab

Caution

Families will be grouped together and the statements will have page numbers (page ? of ?). This is so you can mail all of the family’s statements in the same envelope if you choose. Just be sure to notice the page numbers at the bottom of each page to know when you are at the end of that family’s set of statements.

Also, if an individual’s statement runs more than one page, each page will have his people ID (PID#) in the bottom left corner beside the page number. This will help you keep the statement pages together.

Export Contributors Only

This will give you an Excel spreadsheet of everyone that will receive a statement. One use for this is to generate mail merge labels (see use cases below) if you do not want to use window envelopes. It will contain the following columns: Name, Address, People ID, Family ID, Spouse ID, Deceased Date, HOHIND (HOH=1, Spouse=2, Other=3), Family Position ID, Age, Joint (True or False), Campus ID.

We recommend that, if you want the export, you run it first (entering the date range you want), and then remove the check mark for the export and run the statements.

Use Cases for Export Contributors Only

Use case 1: Use the export to create mailing labels for the statements if you do not use window envelopes.

Use case 2: Use the export to find those that should have a statement, but for whom a statement did not generate. The reasons someone might not get a statement are: 1) Do Not Mail Flag is set; 2) The person has no address; 3) The person’s Statement Option is set to None.

To find those that did not get a statement (for use case 2) follow these steps after generating the export:

  • Select and copy the entire column labeled PeopleId.
  • Go to Administration > Batch Actions > Tag People Ids. This batch process must be done by the Admin user.
  • Paste the column into the text field, name the Tag, and press Submit.
  • Create a new search using these Conditions:
    • Has My Tag - selecting the Tag you just created - set to False.
    • Contribution Amount History - enter the date range matching that of the statements and Greater Than / Equal To the amount used as the minimum amount for the statements.
  • The results will be anyone that had donations, but for whom a statement did not print. You can then look at the people records and decide if you need to try to contact the donors and update their records.

Contribution Options in the Settings

There are other options that your TouchPoint Administrator can create in Administration > Setup > Settings

Check Numbers and/or Notes
The default for contribution statements is not to print check numbers or notes on the statements. However, if your church chooses to print either or both of these on the statements, add the settings/s RequireCheckNoOnStatement (to print the check numbers) or RequireNotesOnStatement (to print the notes).
Donors without Addresses
When you generate All Statements, people without an address on their record will, by default, not have a statement generated. However, some churches ask the members to pick up their statements at the church, and they want to print statements even though there is not a street address on the person’s record. To change the default so that these statements will generate, add the setting RequireAddressOnStatement and set it to false.
Electronic Statements
Some churches prefer that everyone generate their own statements. Therefore, they want all new people records to have the Electronic Statements option set to true. If you want that option, add the setting ElectronicStatementDefault and se the value to true. Then every new people record will have that box checked by default.
Envelope Numbers instead of People ID #

If you have envelope numbers as Extra Values and want those to print on the statement instead of the people ID# (which is the default) you can add the setting PrintEnvelopeNumberOnStatement with the value set as true.

Minimum Contribution Amount

The setting named MinContributionAmount allows you to set the minimum contribution amount required for a statement to generate.

This is a minimum for a person’s total contributions during the date range you select when generating statements. It is not a minimum for a single contribution.

You can enter the amount you want for the minimum as a whole number (ex. 200).

Your starter database may have this setting and you just need to adjust the amount to fit your requirements.

Tip

At our church, we sent the minimum to $250 for the first 3 quarters (we send statements each quarter), and change it to $5 for the year-end statements.

Names for Joint Donors
By default, joint statements will read Mr. and Mrs. John Smith for a married couple giving jointly. However, if you prefer for both names to be listed, add the setting NoTitlesOnStatements for the following format for couples receiving joint statements: John Smith and Mary Smith; or Frank Jones and Janet Williams-Jones.
Non-Tax Deductible Contributions
If you want these to display on the contribution statements (they display in a separate section, add the setting DisplayNonTaxOnStatement and set it to true.
Pledges
If your church tracks Pledges, you have the option to display the pledge or not to display it once the pledge has been met. The default is to not show the Pledge if the person has fulfilled his Pledge and the Fund is still Open. Add the setting ShowPledgeIfMet and set the value to true if you want to show the Pledge until you close the Fund.
Printed Date
By default, the date you actually generate statements will display in the top right corner as the Printed Date. If you do not want this to display on statements, add the setting NoPrintDateOnStatement and set it to true.

Extra Values Relating to Statements

There are 2 Standard Family Extra Values that can be added to a family, that relate not only to mailing labels, but also to the name and address that display on Contribution Statements. See the help article referenced below for complete instructions.

Mailing Address
Add the Family Extra Value of MailingAddress if you want the statement (and all mailings) to be sent to an address (such as PO Box) that is different from the one on the family’s record.
Couple Name
Add the Family Extra Value of CoupleName if the couple prefers to be addressed differently than the standard naming convention when you combine couples.

Custom Statements for Ministries

If your church has separate ministries and you receive donations for those ministries in your church’s TouchPoint database, you have the option of creating Custom Statements for them. This means that you can have one statement for the standard church’s funds, and different statements for any ministries that you have. When you use this option, each statement for a ministry will have the ministry name in the header instead of the church’s name. This is based on the Funds that you use for those ministries. You will identify which funds should report with which ministry in a Text File. See the document listed below for step by step instructions.

Troubleshooting

If you print statements and the statement itself says No Data instead of the normal information included on a giving statement, there are several things you should look for in order to make the necessary corrections.

  1. Does the family have an address? Because our statements are designed to be mailed, statements, by default, will not generate for anyone without a mailing address. Exception: See the setting above for Donors without Addresses.
  2. Is the person’s Contribution Option set to Joint? If so, make sure that they have a Marital Status of Married, that they have a Gender set, and that they have a Position of Primary Adult.
  3. Be sure to check the Marital Status, Gender, and Position of the person’s spouse (see question above), if they are married.

© 2018 TouchPoint Software, LLC.  All rights reserved.