Automating BBMS Disbursement Reconciliation to GL

Question

Hi everyone, I’m looking for advice on streamlining our gift posting process. Currently, I’m manually updating each gift record by cross-referencing the BBMS Disbursement Transaction Report. It’s incredibly time-consuming to do this gift-by-gift.

Does anyone have a workflow or tool to automate the posting of these gifts to the General Ledger? I am looking to move away from manual lookups and reconciliation. Any tips on built-in integrations or third-party tools would be greatly appreciated!

Roberta A. Gilbert · Answer

https://community.blackbaud.com/discussion/comment/313429#Comment_313429

It should be available in both.  I still use Database view to pull gifts into FE, and if I set the Post area to "Pre-Post" the report I get is a Validation report, which I can inspect without posting anything.  If it looks good, I run it again in Post mode, which posts it to RE and sends it to FE as an Open Journal Entry.  If anything is missing or doesn't add up to what we received, I forward it to our Development Dept and they check the gift info in RE.

Michelle Fenske · Answer

@Roberta A. Gilbert the Validation Report you mentioned - is that something available in Database view, Web view, or both?

Roberta A. Gilbert · Answer

One other thing occurred to me, @Valdez Roman .  Do you have FE and RE integrated so that you can pull gifts directly from RE to FE?  I was assuming you did, but perhaps not.  Integrating the two databases allows you to open RE and post directly to the GL in FE, without having to even touch individual gift records.  It's basically 2 steps:  Step 1 produces a Validation report from RE which you can view and compare to what you expected to see from BBMS or any other gift processor.  If they match, then Step 2 actually posts the gifts in RE, and copies them to the designated revenue account(s) in an FE JE, which you can then post manually or edit (e.g. I might add processing fees, if any) before posting.