I have a supporter who has pledged to provide $xxx dollars if we raise 10 times that amount. The donor will not provide the gift unless we meet this number several years out into the future.
For millennium purpose I have this entered as a conditional pledge.
My accounting department would like millennim to recognize the revenue as we earn a portion of it each month. We will not have any money to apply to reduce the pledge and we do not want to write down the pledge amount. I suggested using a campaign amount field on our gift screen, but this would need to be manually updated each week.
The problem is with our reporting structure I do not know that could look back at past dates to get the amount earned on a certain date. Can anyone provide me with any guidance?