How do you get Projects to balance on the balance sheet?

We utilize Projects to track Endowment, capital funds, and gift funds. Our batch postings from Raiser's edge are hitting our projects both in the Revenue accounts, cash accounts, and AR accounts (for pledges), but our accounts payable through the Payables module only hits the project in the Expense account, not the AP or Cash accounts. This is causing the cash balances in all of our projects to be wrong. Does anyone have recommendations to fix this?

Comments

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

    @Josh Smith you'll want to look at your Fund's Transaction Requirements to see if projects are A, required on any account types. This affects whether project id's are copied over to all the fields in AP workflows vs just the expense side. IF it's not set to require on all accounts, it's not going to copy it all over. To update that is now a data service and you'd need to connect with your AE to go over the desired outcome for the fund and look at the billable service to update that and also get the unpost data service as enforcing it at the fund level after go live in the fund usually overwrites the posted history, and the unpost service is needed so you can unpost all your activity in that fund(s), export the data out first, make the change, then correct the data.

Categories