Year-End Pledge Receivables

Options

Our finance department just came to us looking for a pledge report that should have been produced in June that would give outstanding pledge balances that are due for FY14 and then those that are due for FY15, etc. Is there a way to take a snapshot of what those balances looked like back in June without backing out 6 months worth of pledge payments? I do not need constituent detail, just summary numbers. Of course our previous Database manager left on bad terms and there is no path to follow on how this was previously done.

Tagged:

Comments

  • Marcus Brown:

    Our finance department just came to us looking for a pledge report that should have been produced in June that would give outstanding pledge balances that are due for FY14 and then those that are due for FY15, etc. Is there a way to take a snapshot of what those balances looked like back in June without backing out 6 months worth of pledge payments? I do not need constituent detail, just summary numbers. Of course our previous Database manager left on bad terms and there is no path to follow on how this was previously done.

    If I'm remembering correctly, there's not a way. 

    Not sure what you mean by "backing out 6 months worth of pledge payments".  Hopefully it's not deleting them and re-entering. Do you have constituents that pay off payments way ahead?  Just wondering how much scrutiny you'll need to give payments.   If you don't need constituent detail you should be able to look at your current figures and run a query or report of pledge payments made since 6/30.  Start with adjusting by that amount and look for any early payments.

    Do you have your cash flow reports from previous year that you could check against payments made for someone that had say $5000 due in FY14 but now has $0 due because of early payment?  There are several reports that might be beneficial under Reports > Pledge and Recurring Gift Reports like Activity, Cash Flow, Journal, Pledge Status - can do payments during specific time period.

    Even with FY equal to calendar year, we ran into this in January once when some reports not done when all entry for December completed.

    Only other thought is do you happen to have back-up of your database from that time period that you could load and run info and then re-load current info?

    Just some thoughts

  • Marcus Brown:

    Our finance department just came to us looking for a pledge report that should have been produced in June that would give outstanding pledge balances that are due for FY14 and then those that are due for FY15, etc. Is there a way to take a snapshot of what those balances looked like back in June without backing out 6 months worth of pledge payments? I do not need constituent detail, just summary numbers. Of course our previous Database manager left on bad terms and there is no path to follow on how this was previously done.

    Only way, I believe, is to get a backup of your database as of 6/30/13 (or the date you had all entries in for the end of the year).  You could then get a valid report as of that date.
  • Marcus Brown:

    Our finance department just came to us looking for a pledge report that should have been produced in June that would give outstanding pledge balances that are due for FY14 and then those that are due for FY15, etc. Is there a way to take a snapshot of what those balances looked like back in June without backing out 6 months worth of pledge payments? I do not need constituent detail, just summary numbers. Of course our previous Database manager left on bad terms and there is no path to follow on how this was previously done.

     Thank you everyone for the suggestions. Apparently the solution is to run a pledge status report on the last FY and create a gift query of those pledges to limit a cash flow report summary. Blackbaud customer service took the time to walk me through it this morning. They seriously have the best customer support of any company I've ever dealt with.

Categories