GL Post Report Settings

Madeleine Holdsworth

Hoping someone with more day-to-day FE posting experience can advise here.  Our client is just starting out with posting from RE to FE.  All the GL distribution info is set up.  They are using BBMS for their donation form, and they've selected the "4 times a month" disbursement schedule.  

So that means that 4 times a month, they get a single deposit that combines a week-ish worth of daily batches from BBMS - each day that there is transaction activity, they get either 1 or 2 batches - one for credit cards, one for EFTs.  So over the course of the period covered by the disbursement, that could be 10-12 batches.

They want to post to FE on that same schedule, so that the posted gifts include everything included in the disbursement.  The assumption is that there are settings available that will create ONE consolidated bank deposit debit line, and then as many credit lines as needed to cover all the different types of revenue.

The problem we're having is that we can't figure out the settings for the GL Post Report in RE to get the bank account/debit lines to consolidate across batches - has anyone done this successfully?  I could have sworn there was a way so that there was just one bank line, which will then match to the deposit amount of the disbursement,  minus the fees.  Am I crazy?

They do have the "bank adjustment" box checked in FE, which is what BB support told me was needed on the journal entry, but that doesn't seem to have an impact on the number of bank lines.  Post Report attached

Sample Posting Report - Need Bank Consolidation.jpg

- trying to get the two lines outlined in red consolidated into one.  Identifying details blurred out.

Thanks for any help or guidance out there! I will also post this message to the FE Community too.

Carlene Johnson

I can't speak to all the details about FE, but what I can share is that I typically make the GL Post Date match the disbursement date and then use a query where GL Post Date = Disbursement Date and then use that query to post all those gifts as one group to FE.

One complication is that EFTs take more time to process so when they happen close to the disbursement date it is sometimes tricky to know which date to use for the GL Post Date as it might fall into the next disbursement.

Madeleine Holdsworth

That is what we did, but the post report doesn't roll them up into one group.