Paying off a multi-year pledge early

Options
I have a donor who made a 3 year pledge then decided to pay off all three years now. This is wonderful but is causing reporting issues. I need to be able to report the total pledge and the total payment amounts as the result of fund raising activity undertaken this fiscal year. It works for accounting because they see the campaign year attached to each payment. However, I also need a simple report hat will show program staff that the gift is intended to be used over three years, so they won't think they have the whole amount available right now. Each year we change the Campaign and Appeal names but the Funds remain the same. I have entered three separate pledges, in the current and next 2 Annual Campaigns with due dates and with GL Post Dates based on the campaign years, but all with the current year's appeal. The payment, which was made using shares, was entered as a single gift, with the current year's appeal and current gift date and GL post date, and then applied to the 3 instalments. I pull my campaign reports using the Appeals Performance Analysis, so everything is showing up there as the result of this year's appeal. But I can't find a report that will show that part of the revenue is to be deferred to next year and the year after. Any suggestions?
Tagged:

Comments

  • JoAnn Strommen
    JoAnn Strommen ✭✭✭✭✭
    Ancient Membership Facilitator 4 Name Dropper Photogenic
    Jane Corbett:
    I have a donor who made a 3 year pledge then decided to pay off all three years now. This is wonderful but is causing reporting issues. I need to be able to report the total pledge and the total payment amounts as the result of fund raising activity undertaken this fiscal year. It works for accounting because they see the campaign year attached to each payment. However, I also need a simple report hat will show program staff that the gift is intended to be used over three years, so they won't think they have the whole amount available right now. Each year we change the Campaign and Appeal names but the Funds remain the same. I have entered three separate pledges, in the current and next 2 Annual Campaigns with due dates and with GL Post Dates based on the campaign years, but all with the current year's appeal. The payment, which was made using shares, was entered as a single gift, with the current year's appeal and current gift date and GL post date, and then applied to the 3 instalments. I pull my campaign reports using the Appeals Performance Analysis, so everything is showing up there as the result of this year's appeal. But I can't find a report that will show that part of the revenue is to be deferred to next year and the year after. Any suggestions?

    I don't believe you will find any such report showing deferred income as RE is not accounting software.  All I can think of to show your staff would be a campaign report of some type that shows you have already received $ for future campaign years.  Don't they get their reports of $ available from finance reports? 

Categories