Menu
  • Home
  • Services
    • Implementation Services
    • Support Services
    • Salesforce Support Services on Tap
    • Customization Services
    • Integration Services
    • Consulting Services
    • Product Development with Salesforce
  • Focus Areas
    • Buyer Journey Management
    • Supporting Nonprofits
    • Salesforce Integration Orchestration
    • Employee Management
  • Case Studies
  • Blog
  • Internship
  • Contact
  • COVID 19 & beyond

Pledge and Payment Adjustment management for non profits

CategoriesBlog / Nonprofit

Admin

April 15, 2019

Pledge and Payment Adjustment in Salesforce® NPSP

This article provides the details on how users can leverage power of NPSP to manage pledge adjustments and payment adjustments.

There are chances of errors in entering pledges or payment in the system, thus there should be a way to correct the errors without affecting the accounting system. Usually every non-profit organization uses an accounting system to keep the track and audit of the money coming in and going out from the organization and uses some accounting system software’s like SAGE for fulfil this requirement.

Salesforce instance need to keep sending data to Accounting system like SAGE everyday to keep the debit and credit for both the systems in sync.

No in case if someone enters the wrong data for ex. Enters a pledge amount as 1000 instead of 100, and this wrong data flows to the accounting system. Later some point of time the user realizes their mistakes then at that point of time he/she can not alter the amount on the original pledge record from 1000 to 100 as this correction will make both the system in conflict. To resolve this issue, we can easily do some customizations on top of Salesforce NPSP and can achieve the adjustments in such a way that both Salesforce and SAGE accounting systems will remain in sync.

Pledge Adjustments

Pledge adjustments are made against a pledge record and can be categorized separately than pledge, thus we can use a new record type on opportunity called “pledge adjustments” which will separate the pledge and pledge adjustments data. Now as pledge adjustments are always related to a pledge, we can relate pledge adjustments with the pledge so that user can view the pledge adjustments as child records on the main pledge record.

In order to do adjustments against the original pledge, we need to perform some customization on top of Salesforce NPSP as mentioned below:

  • Create a new record type called “Pledge Adjustment: on opportunity object.
  • Create a lookup relationship on Opportunity say, “Original Pledge”. This field will be used on pledge adjustment records to link all related pledge adjustments to the original pledge against which user is doing adjustments.
  • Create a quick action on Opportunity Object of type record create for Opportunity of type “Pledge Adjustments” and this quick action on Opportunity detailed page.
  • This quick action will provide a way to create adjustments directly from the pledge record.
  • We can create workflow rule to modify the amount on the original pledge when a pledge adjustment record gets created, keeping the original amount as-is on the pledge record, thus there will be two fields on the pledge Amount and original amount where amount will be updated amount after the adjustment and original amount would be the main amount without any adjustments.

Payment Adjustments

NPSP has also introduced a new Payment object which can be used to track payments against a pledge. A Payment is tightly coupled with pledge in the system, thus using Opportunity for pledges and a separate Payment object to track the related payments for the pledges, NPSP has made a clear segregation between tracking pledges and payments.

In NPSP, Payments cannot exist without a pledge, making ease for the user to track the payments per pledge.

Payment can also be entered wrongly in the system may be my human error etc. and these can be adjusted by maintaining payment adjustment record type on Payment object.

Normal Payment would be tracked with the Payment record type on the Payment object however payment adjustments can be tracked using “Payment Adjustments” record type.

If someone creates a payment record of 1000 instead of 100 by mistake, then this can be adjusted simply by creating a new payment record of record type payment adjustment of amount -900. Thus, the total would remain 100 as the main payment amount i.e. 1000+(-900) = 100. Both the records i.e. Payment and Payment Adjustments should be linked to the same pledge so that NPSP can roll-up the received payment amounts correctly on the pledge record.

NPSP automatically rolls up the payment received amount on the pledge record based on the payments attached to the pledge record.

 

Recent Posts

  • Grant Sourcing, Management and Impact Reporting
  • How do you get your alumni to get involved with you on your initiatives?
  • What Information do I need to capture and maintain with respect to my Alumni?
  • What information do I need to capture about my volunteer and why?
  • What information do nonprofits need to capture and maintain of their donors and the donations they give?

Categories

  • Blog
  • Communities
  • Finance
  • General
  • Nonprofit
  • Sales
  • Salesforce Technology
  • Services

Archives

  • February 2022
  • January 2021
  • October 2020
  • September 2020
  • August 2020
  • March 2020
  • February 2020
  • September 2019
  • April 2019
  • February 2019
  • November 2018
  • September 2018
  • August 2018
  • June 2018
  • April 2018
  • March 2018
  • February 2018
  • January 2018
  • December 2017
  • November 2017
  • October 2017
  • September 2017
  • July 2017
  • November 2016
  • October 2016
  • September 2016
  • August 2016
  • July 2016
  • June 2016
  • May 2016
  • April 2016
  • March 2016
Thinqloud was founded with the vision of helping business grow using Salesforce®.

We do this by driving automation and process management using Salesforce® Technology thereby improving and implementing integrated CRM ,Sales and Marketing processes. Our mature team comprises of IT professionals (Technology and DevOps), Business process consultants and Salesforce® enthusiasts.

Email : sales@thinqloud.com

Services

  • Solution Development Services
  • Salesforce Implementation Services
  • Salesforce Support Services
  • Salesforce Customization Services
  • Salesforce Integration Services
  • Classic to Lightning Migration
  • Salesforce Consulting Services

Site Links

  • Home
  • Blog
  • Case Studies
  • Contact
  • Internship

© 2022 Thinqloud, All Rights Reserved.

  • Privacy