Importing Pledges with other Installment Schedules (includes sample data file)

When importing Pledges with an Installment schedule that is other than a Monthly schedule, the setup depends on the frequency and other options selected for the installment schedule.
How do I import Pledges with Semi-Monthly, Bi-Monthly, Specific Day installment schedules?
How do I import Pledges with an irregular schedule?
See the sample data file below.
Note: The final column in this file is not intended to be mapped in the import.  This is provided as a description of how the Pledge schedule will be in the final results.

See How to import pledges and recurring gifts with installment schedules (includes sample data file) for more detailed instructions on importing Pledges and Installment schedule.

Importing Pledges with an Irregular Schedule requires 3 separate imports.

Import 1 will import the Pledge with nothing populated in the Frequency fields of the import.  This will default it to Single Installment.  Automatically Add Installments option should NOT be selected.The Gift Import ID must be assigned so it can be used in the subsequent imports.

Import 2 will import the Installments.  Each line in the import File will be a separate Installment.  The Gift Link will be the Gift Import ID from Import 1.

Amount>GFInsAmt
Date>GFInsDate
Gift Link>GFLink (This is the Import ID of the original Pledge)
Installment Import ID> GFInsImpID (leave this blank, the system will populate it)

Import 3 will be an import to update the existing Pledge to change the Single Installment on the schedule to Irregular.  
 
Pledge Payments Irregular

Was this article helpful?


Thanks for your feedback! Did this solve your issue?

Comments (optional):


Thanks for your feedback!
We're glad it was helpful but sorry it didn’t solve your issue. If you need assistance, click Chat with Support below.
We’re sorry to hear that. Please tell us why.

 I don't like how this works.

 The answer is confusing.

 The answer didn't match what I was searching for.

Additional Comments (optional):


Thanks for your feedback! If you need assistance, click Chat with Support below.
Thanks for your feedback. Help us make our products even better by sharing details in our Idea Banks or our online Community.
Thanks for letting us know. We'll work on clarifying the information in the article. If you need assistance, click Chat with Support below.
Thanks for letting us know. We'll work on updating the search engine to return more relevant results.