This query will return two rows. One shows the total payments entered into the system and the other shows the total distributed back to pledges. If all payments have been fully distributed, then these numbers will match.

select 'Total Payments Received', SUM(paymentamount)
from campayments
union
select 'Total Distributed', SUM(distributionamount)
from camdistributions