Account dropped from financials

Heather Counter
Heather Counter
Name Dropper First Anniversary Facilitator 1 September 2024 Monthly Challenge
in Blackbaud Financial Edge NXT® General Discussions

Hi. We had an account that we no longer used that I closed by selecting “Prevent Data Entry from this Account” under ‘edit account settings’. Later, in running financials, I found my statement of financial position was out of balance historically. Diving in, I found that the account I'd thought I'd closed falls off of historical financials. Any idea why or how I can close an account to future posting without having it drop from financials? Thanks!

Comments

  • Kevin Brazell
    Kevin Brazell Blackbaud Employee
    Tenth Anniversary Kudos 5 First Reply Name Dropper

    @Heather Counter
    on the report usually there is a button to include inactive accounts. If this isn't marked , then any account marked inactive , like your account will be excluded. Double check the report settings and see if inactive accounts are not included. If they aren't, mark the box to include them and rerun the report(s)

  • Heather Counter
    Heather Counter
    Name Dropper First Anniversary Facilitator 1 September 2024 Monthly Challenge

    @Kevin Brazell Thanks. That did the trick to get the account to show up. Unfortunately, my FE balance sheet report remains out of balance. The difference stems back to FY22 and changes year over year. I can see the difference is in retained earnings. I've aligned freshly run reports against historicals and all other balances match. I'm perplexed. It's like FE is just adding in an extra amount to the report. I would have thought an entry was back dated, but past periods are closed and again, there have been no change to any other number - it seems to be report only with everything matching up except RE. Any thoughts as to what I could have done in the background to cause this to happen?

  • Roberta A. Gilbert
    Roberta A. Gilbert
    Eighth Anniversary Kudos 4 Name Dropper Facilitator 1

    @Heather Counter:

    @Kevin Brazell Thanks. That did the trick to get the account to show up. Unfortunately, my FE balance sheet report remains out of balance. The difference stems back to FY22 and changes year over year. I can see the difference is in retained earnings. I've aligned freshly run reports against historicals and all other balances match. I'm perplexed. It's like FE is just adding in an extra amount to the report. I would have thought an entry was back dated, but past periods are closed and again, there have been no change to any other number - it seems to be report only with everything matching up except RE. Any thoughts as to what I could have done in the background to cause this to happen?

    Out of curiosity, try running a Balance Sheet report, instead of a Statement of Financial Position, and compare the two. In theory, the numbers should be the same, but they're not pulled from the same data. The Bal Sheet pulls from Account Balances and the SFP pulls from Net Asset Classes. Our Bal Sheets report align with our Trial Balance and with our audited reports, but our SFP reports do not, and I have no way to historically fix them. I have had multiple Blackbaud support tickets on this, and nobody has been able to fix it or tell me how to prevent it. So I use the Balance Sheets exclusively now and change the title to SFP. But it still bugs me that FE (both database and NXT) allows these 2 reports to be out of sync with each other.

Categories