GL Post report and consolidation of bank account/debit lines

Madeleine Holdsworth · August 25

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 - 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 RE Community too.

Sample Posting Report - Need Bank Consolidation.jpg

Amanda Bowman · September 4

I never could find if there was a setting for this, so I would push the RE batch over to FE; then in FE, open the batch, change the debit to the deposit balance and delete all the other debit lines

Roberta A. Gilbert · September 15

I do the same as Amanda. If I can't import the data in the format I want it, I open the unposted JE after bringing the data over from RE, make the necessary changes, and then post it. (This was an issue in the Database also, btw.)

Madeleine Holdsworth · September 15

Thanks. I didn't know if we were missing a setting or it couldn't be done.

Roberta A. Gilbert · September 15

It's because RE separates gifts by date, and BBMS (Merchant Services) separates gifts by date AND by transaction type (credit card, bank ACH, etc). So by the time the funds are disbursed, that separation has already happened. BBMS reports with multiple pages mean each page is a different transaction type, yet gift dates may or may not be duplicated from page to page.

Not only that, FE doesn't even read the gift dates from RE - FE only reads the GL Post dates which are set up in RE specifically for this import function. If you're trying to tie out your bank statement, the only date that matters is the BBMS Disbursement date. It should match the date the funds arrived in your bank account. That's the date which has to be used for the GL Post date in RE, and it's the only date FE sees or records.

.

Madeleine Holdsworth · September 15

Thanks. That is what we're doing; using the GL Post Date to match the BBMS Disbursement Date. But I wasn't aware that FE does read gift dates; that's good to know!

GL Post report and consolidation of bank account/debit lines

Answers

Categories