BBMS transactions in RE and FE

Alissa Booth

Hello! We have recently converted from eTapestry to RENXT and then integrated with Financial Edge. I have a few questions about BBMS fees I am hoping someone can offer insight about.

When I receive the gift batches in RE, I had been approving them as they come in so I could acknowledge the gift. Then when I received the BBMS disbursement report, I would run a query to account for the gifts on the disbursement report and post that to the GL with a Summary (Cash/AR only) report. But the staff accountant says that creates too many cash lines that she has to adjust because it creates one for each gift batch. I can hold off approving installment batches because they get a year-end statement, but is there a workaround for one-time gifts?

Also, how do you handle BBMS fees for donations where the donor does not pay the fee? When I post the transactions from RE to FE, it posts the gross, not the net amount.

I hope I made this clear. I appreciate any help. Thanks!

Michael Heneghan

@Alissa Booth
Alissa,

Exactly my issues as well. I did not see a reply from you earlier.

Is there anyone out there who solved this issue?

Susan Trippe

@Alissa Booth
I am the FE accountant for our school, and I can tell you that I have to post the BBMS fees with a manual journal entry every month. The person in our office who posts the BBMS gifts in RE creates a batch that comes over to FE, but her batch does record the gross amount of the gifts. I am able to review the batch in FE before I post it. Our batches that come over from RE are very detailed…basically each gift has its own journal entry, but I like it that way. It's much easier for me to analyze and track down any issues in the future.

Alissa Booth

@Susan Trippe Thank you!

Roberta A. Gilbert

@Susan Trippe
I pull in gift info from RE to FE regularly. I use the partially consolidated setting in RE so that the portion that is disbursed to our bank shows the total disbursed (easier for bank recs) but the revenue side shows all the gift detail. Because the JEs come over to FE unposted, I can edit them by lowering the amount received in cash by the amount of the fees, and then adding another line to debit the fees to a different GL account. This allows my cash detail to align with the receipts at our bank.

Wendy Fraser

What helps us is a report in Merchant Services: go to Reports/Disbursement/click the 3 dots/select "Detailed PDF." This gives all of the charges for a specific date.

We use these figures to break down the disbursements into the batches we have on a spreadsheet to help with the bank rec.