Hi David,
I had the same situation for invoices and received payments. The logic should be similar for your case.
In your case, I would suggest the following:
Have 2 distinct tables, one for pledges and one table for payments.
In the payments table, ...