How can I set up a Pledge Table to track pledges, formulate a payment schedule, and track payments TO that Pledge?

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

My idea began as a Pledges table and a Transactions table.

A Pledge record would be created for the individual's, and include the full amount, a start and end date, a frequency (monthly, quarterly, etc.). Then it could list the schedule to fulfill that pledge on time. 

Then, a Transaction record would be created for the individuals actual donation towards the pledge, and this could update the Pledge record showing that the remaining balance is the [Total] - [Transaction Amount].

With the schedule, could it also be possible to be able to note when the balance is in arrears when a transaction hasn't been added in time to meet the set schedule.

Help?

Photo of Travis Bruno

Travis Bruno

  • 0 Points

Posted 3 years ago

  • 0
  • 1
Photo of Blake Harrison - DataBlender

Blake Harrison - DataBlender, Champion

  • 100 Points 100 badge 2x thumb
You can use the Recurring Record Wizard to at least help to create multiple Pledge records at regular intervals, but I suspect that it won't work exactly the way that you're wanting it to.

If I were to build something like this, I would probably create a many to many relationship between Pledge and Donations. For the sake of example, we'll call it Expected Donations. So, these table relationships would look like this:

Pledges < Expected Donations > Donations

The Expected Donations table would have Expected Amount (lookup from Pledge), Expected Date, and then Lookups from Donations for Donation Amount and Donation Date.

Using this setup, you would be able to identify the most recent Donation (summary from Expected Donations), Amount in Arrears (Summary from Expected Donations), etc.
Photo of Travis Bruno

Travis Bruno

  • 0 Points
This may be the right direction... I'm going to see if I can figure something out with your suggestions. I didn't know about the Recurring Record Wizard. Thank you!