Deposit adjustments and investment realized losses

So, this is a pretty simple suggestion - I'd be surprised if no one has ever brought this up. My orgs have active managed equity portfolios, so we frequently have to book proceeds of investment sales, resulting in a realized gain or loss. 


I've found that the easiest, quickest way to do this is to simply go to the desired cash account in Treasury, and book a deposit adjustment. This works great when the month's investment sales result in a realized gain - we just credit equity securities for the cost basis and credit realized gain/loss for the gain.


Now when sales result in a realized loss, this doesn't work so well, since deposit adjustments do not allow us to book the debit we'd need to the realized gain/loss account to make that transaction work. So, we have to do it awkwardly, creating a deposit adjustment for the cost basis, then creating a "payment" adjustment for the loss. That's 2 steps for something that should only require 1, in my opinion. Could do a JE, sure, but I prefer to not have to fire off a bunch of JEs for ordinary ins and outs of cash every month. Could also go through Deposits, but then I have to create the deposit and then add the payment - another 2-step process.


Is there something in business rules/configuration I've missed that would allow me to book a debit for that realized loss against the total proceeds, in a single deposit adjustment? If not, I'd like to suggest it.

Comments

  • I'm am going to go out on a limb and say that there is no easy way.  My coworker is the one who handles our investments, it is a couple of day project to open all of the mail and then create the journal entry that books all of the adjustments and proceeds. The running joke is never start that on a Friday, lol.  She does use a recurring journal entry in the database, but the same can be done in FENXT with copying journal entries.  If you have a process of just doing everything once a month, that might be the best way to do it.
  • @Patrick Lunn
    Hello Patrick,

    Sorry, I'm late for your party. I just signed up for the BB community. I've handled investments for 2 large foundations and never use the deposit or reconcile function on Blackbaud. I would just create a roll forward spreadsheet to keep up with the transactions in totals. If you need additional info feel free to reach out.

Categories