Contents

• Introduction
• Step 1: Download and edit the template, or choose your provider
  • Import using the ChMeetings Excel File
  • Import using one of the available providers
• Step 2: Upload the Data File
• Step 3: Complete the import

Introduction

You can easily import contribution transactions into ChMeetings by simply downloading a template, adding the data to it, then reuploading it. Alternatively, you can use the data file generated by your previous system. Before you import, please go to Settings > Account Settings and make sure that you have configured the account’s Country and State/City. 

Please note that if there are two or more people with identical names, the import tool will also consider the email address and mobile number to ensure that contributions are assigned to the right person.

Please also keep in mind that the import tool has a limit of 500 records per file. If you need to import more, please split your data into separate files, of maximum 500 records each.

Step 1: Download and edit the template, or choose your provider

Please start by going to Tools > Import Giving, Here is where you will be able to choose how to import your data:.

Import using the ChMeetings Excel File

This import method involves downloading our template, populating it with data, and uploading it in the next step. Click the Download Template File button, to get the file that you will need to populate with data.

The template will be an Excel spreadsheet with a few columns to fill out.

Please populate at least the First Name, Last Name, Email or Mobile Phone, Fund, Amount, Date, and Batch Number to have contributions associated with the right member, fund, payment method, etc. The tool allows you to import without the First & Last Name, Email, or Mobile Phone fields, but the contribution will be recorded as anonymous. 

Here are the available fields within the import template (those mandatory for a non-anonymous record are marked with an asterisk):

• First Name
• Last Name
• Email
• Mobile Phone
• Fund*
• Gross* - The gross amount donated, including fees.
• Fee - The amount paid as processing fees for online giving transactions.
• Payment Method*
• Date*
• Deposit Date - If the contribution has been deposited to accounting, this column lists the date when this was done.
• Batch Name
• Batch Number
• Check Number
• Notes

You can enter an existing fund or batch number, or add a new one. They will be automatically created when importing. 

You can also add an Address column, which will be considered when adding non-member contacts.

Additionally, please select whether your source data contains people’s names in one or multiple columns.

1. Single Name Column - People’s full name must be entered in the “Name” column. The following order is mandatory: “First Name Last Name”.
2. Multiple Name Columns - Each of the people’s names must be entered in their dedicated columns. There are separate columns for the First Name and Last Name.

When you are done editing your file, please click Next to proceed to the following step.

Import using one of the available providers

To import data from a provider, all you need to do is have your exported data file ready to upload in the next step. The supported app files are: CashApp, Givelify, Overflow, Paypal, Planning Center, Pushpay, Subsplash, Tithely, and Vanco.

To proceed with the import: 

• Select the provider from the list, 

• Optionally choose the Batch to which you want to import the contributions, 

Click Next to go to the next step where you’ll be able to upload your data.

Step 2: Upload the Data File

You are now ready to upload your data file for import. No matter which import method you chose in Step 1, simply click Select File, then browse your computer for the file you just edited. Depending on the size of your file, the upload might take a few moments. When it is successful, you will see this on-screen.

Click Next to go to the last step of the import.

Step 3: Complete the import

Now you can review the results of your import. You will be shown the total contributions, and amount, total anonymous contributions and their amount, as well as any new funds added via the import.

If this looks correct, please click Import. If not, please refresh the page to start over. Please check your uploaded file and correct any issues you might notice here.

When your import is successful, you will be notified and taken to your main dashboard. 

You will find your newly imported transactions by going to Contributions > All Contributions.