Applying a BluePay Recurring Plan to an Existing iMIS Pledge

If you have an existing iMIS pledge open, and you want to tie it to a BluePay recurring ("rebilling") plan so that future payments will pay down the pledge, follow these instructions.

Keep in mind the following:

  • This article only applies if you are on Donate Now - Premium 2.9.1 or higher, and have an existing open pledge that was not created via Donate Now - Premium initially.
  • Older versions of Donate Now - Premium do not have the capability to pay down pledge installments.
  • If you have an existing rebilling plan you'd like to use within BluePay, navigate to the rebill admin screen which lists the details of the rebilling plan, and skip Step 2.

Step 1: Obtain the original pledge transaction number

Do the following to obtain the original pledge transaction number:

  1. In iMIS Desktop, go to Customers and load the donor's record.
  2. In the bottom row of tabs, clickΒ FundraisingΒ > Donor History, and only showΒ Pledges.
  3. Click Refresh.
  4. Find the pledge you'd like to use with BluePay, and double click the record to select it. The pledge detail report opens.
  5. From this detail window, note the following pieces of information which you will need later:
    • Trans. Number
    • Number of remaining payments
    • Payment amount

Step 2: Set up the BluePay rebilling plan

Do the following to set up the BluePay rebilling plan:

  1. Sign in to theΒ BluePay Secure Portal with the same account that is used for Donate Now - Premium BluePay payments. For multiple accounts (fraternity/foundation/housing/etc), the account must match.
  2. Go toΒ Processing > Virtual Terminal.
  3. Fill out the followingΒ standard fields with the billing information:
    • Transaction Mode:Β Live
    • Transaction Type:Β Credit Card (Or, selectΒ Check if you are processing ACH and have enabled ACH on your BluePay account)
    • All Contact Information: (First, Last, Address, Phone, Email)
    • Credit Card Number
    • CVV2 Code
    • Expiration Date
  4. Additionally, fill out the followingΒ non-standard fields:
    • Transaction Type:Β AUTH
    • Amount: $0 (The pledge amount will be entered below.)
  5. Under theΒ Recurring Billing section, fill out the following fields:
    • Enable:Β Yes
    • Start date:Β The first date you would like to start payments on
    • Rebilling Frequency:Β Must match the pledge frequency, use one of the following examples:
      • Monthly: 1 MONTH
      • Quarterly: 3 MONTH
      • Semi-Annually: 6 MONTH
      • Annually: 1 YEAR
    • Number of Cycles:Β The number of pledge installments remaining.
    • Rebill Amount:Β The amount to pay towards each installment.
  6. When finished, clickΒ Process.
πŸ“˜

Note

If you do not have all of the necessary credit card information (Card #, CVV2, and Expiration), you will need to obtain this information from the donor.

πŸ“˜

Note

It is not currently possible to pay a different amount towards the last pledge installment, if it differs due to rounding.

Step 3: Note the BluePay recurring plan information

If successful, BluePay will respond withΒ APPROVED: INFORMATION STORED. This is a successful message which tells you the credit card information was stored for later processing (the Start Date above), but was not charged today.

Do the following to note the BluePay recurring plan information:

  1. On this screen, click View Receipt
  2. On the Receipt screen, click Return to Details. This will take you to the transaction details screen.
  1. Click Rebilling ID to go to the Rebill Admin screen.
  2. On the Rebill Admin screen, make note of the following fields:
    • Rebilling ID
    • Cycles Remaining
    • Rebilling Amount
    • Rebilling Period

Step 4: Determine the Donate Now - Premium financial account ID

A Donate Now - Premium Financial Account profile is where Donate Now - Premium stores its BluePay settings, as well as settings for batch and cash account settings.

🚧

Warning

If you have multiple Financial Account profiles in Donate Now - Premium and/or multiple BluePay accounts (e.g. for Foundation vs Housing), then the BluePay account you use to set up the rebilling plan above in Step 3 must match the Donate Now - Premium Financial Account profile's BluePay information.

To find out which Financial Account ID to use, do the following:

  1. Sign in to the Donate Now - Premium Admin site, and click Financial Accounts.
  2. Click theΒ Edit icon next to the one you would like to use.
  3. Verify that the Account ID and User ID fields in Donate Now - Premium match the Account ID and User ID fields on theΒ Transaction Details screen in BluePay (see screenshot above).
  4. On the Edit screen, in the upper-right corner, take note of the Financial Account IDΒ as we will use it in the next step.

Step 5: Insert the Demo_Recurring_Gift record

Do the following to insert the Demo_Recurring_Gift record for the Staff site and iMIS Desktop:

Staff Site

Do th following in the Staff site:

  1. Go to the Recurring Gifts panel located on the user's record. This can be on their Member Profile or Donor Profile, just depends on how your system is set up.
  1. You are required to enter all of the following fields except those which are locked/grayed out in the screenshot below:

iMIS Desktop

Do the following in iMIS Desktop:

  1. In iMIS Desktop, go toΒ Customers and look up the donor's record
  2. Open the Demo_Recurring_Gift tab window.
  3. Scroll to the bottom of the table and click the new row to insert a new record.

Your fields may be in a different order or have a different label depending on your demo table setup. If you are not sure which fields are which, refer to your demo table setup to confirm the database fields.

  1. Enter the following fields:
Field nameGet fromValue to enter
Unique IDBluePay12-digit Rebill ID
Initial Gift DateN/ACurrent Date
FrequencyBluePayRebilling Period
OccurrencesBluePayCycles Remaining
Recurring AmountBluePayRebilling Amount
Total Amount ExpectedBluePayShould match the total pledge amount sum.
Number of Gifts GivenN/AEnter the amount of pledge installments that have already been paid by the donor, prior to setting up BluePay. This can also be 0 if this is a future scheduling with no installments paid yet.
Total Amount GivenN/AEnter the amount that has been given so far. This should equate to (Recurring Amount * Number of Gifts Given).
DistributioniMISEnter a distribution code value that exists in the Donate Now - Premium gen table IDONATE_DISTRIBUTIONS, such as "GEN" or "AF".
FundiMISEnter the fund code that the distribution is configured to use in iMIS.
Campaign CodeiMISOptional. This value is an override only. Enter a valid iMIS campaign code that should be applied to gifts that are written using this recurring plan. If not set, will use the distribution's default code.
Appeal CodeiMISOptional. This value is an override only. Enter a valid iMIS appeal code that should be applied to gifts that are written using this recurring plan. If not set, will use the distribution's default code.
CC Expiration (Month)BluePayEnter the card expiration month (1 or 2 digits). Set to "0" for ACH transactions.
CC Expiration (Year)BluePayEnter the card expiration year (2 digits, e.g. "19" or "23"). Set to "0" for ACH transactions.
Last Response ReceivedN/ALeave blank. This value is auto-filled when an automatic recurring payment notification is received from BluePay.
Third-party Confirmation NumBluePay12-digit Rebill ID (Same as "Unique ID")
Donate Now - Premium Financial Account IDDonate Now - PremiumNumeric Financial Account ID obtained from Step 4 above.Β Β MUST NOT BE "0".
Last Recurring StatusN/ALeave blank. This value is auto-filled when an automatic recurring payment notification is received from BluePay.
Pledge Trans NumberiMISThe Pledge Trans number obtained from Step 1 above. (Ignore any automatic commas that appear in this field.)
Pledge Last StatusN/ALeave blank. This value is auto-filled when an automatic recurring payment notification is received from BluePay.
Is ActiveN/AMust be checked. (If not checked, automatic recurring gifts from BluePay will not be entered into iMIS.)
Warning FlagN/ALeave unchecked. This value is auto-filled when an automatic recurring payment notification encounters an error.
  1. ClickΒ OK.
  2. Click Save.

Your recurring pledge is now set up in BluePay and iMIS.


Did this page help you?