Import Contributions for Online Giving Transactions

This article provides steps to import contributions for online giving transactions.

Regardless of what the online giving system is, transactions can be imported into the directory. 

Here are the steps to import contributions:

Prepare the Export File

Before the online giving donations are imported, ensure all givers have assigned envelope numbers in your Online Giving System that are the same as the envelope number you’ve assigned them in Directory.

1. To import Online Giving Transactions the file should have the following headers. They do not need to be in any particular order.

- FundNumber
- EnvelopeNumber
- Amount
- Date
- PaymentMethod  (Optional)
- OnlineGivingContributionID  (Optional)

Template:

Contributions_Import_Summary3.csv

Example:



To Import the File

2. Save the CSV or Excel file from the current Online Giving provider.
3. Ensure the file is converted to a CSV file if it is an Excel file.
4. From Giving go to File Import in the main Giving menu.



5. Click on load New Contribution File.
6. Select the saved CSV file from your computer.

7. Click on Import File.

The file imports and, confirms the number of transactions imported.  The number of accounts in the file that were skipped are those that had been previously recorded.

Transactions can be excluded for a variety of reasons:

  1. The fund numbers do not match what you have set up in Directory.
  2. The donor’s envelope number doesn’t exist in the system.
  3. The transaction appears to be a duplicate because of date, amount, fund, and envelope # existing for a different transaction.

These items are able to be viewed on the File Import History.

Necessary adjustments can be made in the system to add the family, update an envelope number, and reimport. Adjustments can also be made to your CSV file and then reimport. Any duplicates are avoided.

Note* Visual steps are best viewed at full screen. Click Esc on your keyboard when finished viewing.






Was this article helpful?