BBMS transactions in RE and FE

Alissa Booth
Alissa Booth
First Anniversary Kudos 1 Name Dropper Participant
in Blackbaud Financial Edge NXT® General Discussions

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!

Comments

  • Michael Heneghan
    Michael Heneghan
    Facilitator 1

    @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
    Susan Trippe
    Kudos 4 Fourth Anniversary Name Dropper Participant

    @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
    Alissa Booth
    First Anniversary Kudos 1 Name Dropper Participant

    @Susan Trippe Thank you!

  • Roberta A. Gilbert
    Roberta A. Gilbert
    Eighth Anniversary Kudos 4 Name Dropper Facilitator 1

    @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
    Wendy Fraser
    Facilitator 1

    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.

Categories