We have donors who make pledges that are payable over multiple years/payments. EX. $25,000 pledge to be paid over 5 years ($5,000/yr.). We set up those pledges using the recurring tab, which then creates multiple charges that reflect the payment schedule. This seems to result in inaccurate data, because if I query by a charge, it is looking at each individual charge ($,5,000), rather than the full pledge amount ($25,000). Should I be querying for a different field? Are there special reports that I am supposed to be running?
With software that I have used in the past, there is one CHARGE that represents the full pledge amount ($25,000), which has a PAYMENT schedule of multiple future payments attached to it ($5,000 x 5). That is far more accurate since in reality, that is what is going on. The donor made ONE large pledge, and he is PAYING it over many payments. If it worked that way, then every time, I am querying a charge, or looking at a charge on a report, I am looking at the actual, full pledge amount, which will give me the most accurate information.
Is there already a way to do what I am describing? If not, can it be created? I assume this is a major issue for other mosdos as well......