Received funds split between development (RE) & Tuition (Billing Mgmt) - separate transactions in FE?

Daniel Wallach
Daniel Wallach
Sixth Anniversary Kudos 2 Name Dropper Facilitator 1
in Blackbaud Financial Edge NXT® General Discussions

Hi everyone,

We're users of RE and K-12, in the middle of bringing in FE and Billing Management. We have a common issue where we receive cheques from parents meant to be allocated partially to tuition and partially to donations. Ultimately this has meant one sum hits the bank after a cheque is deposited and we have to record separate transactions in RE and our current tuition software, with info in the comments of these entries noting their relation to the sum hitting the bank, so our bookkeeper can reconcile, which is ultimately a bandaid and a headache.

With FE and Billing Management, our understanding is that it would still have to work this way, with transactions feeding from RE & BM in FE, ultimately still showing as 2 transactions, so reconciliation still becomes a pain.

We could be missing something, but does anyone know if there's a way to have one sum recording in FE that will tie into the separate RE and BM transactions easily?

Comments

  • Elizabeth Perron
    Elizabeth Perron
    Eighth Anniversary Kudos 5 Name Dropper Participant

    @Daniel Wallach
    You may want to attend the Blackbaud Field of Users event happening later in January. It’s run by @Karen Tuecke and discusses many products by members of this community. Go to Products>Organizational Best Practices > Events

    Or reach out to support.

    In harmony,

    Elizabeth

    Blackbaud Community Team

  • Anthony Block
    Anthony Block
    Tenth Anniversary Kudos 2 Name Dropper Facilitator 1

    @Daniel Wallach

    Hi Daniel,

    The only way around this that I know of is to post a charge to the student account for whatever the advancement revenue is, then apply the whole check to the student account. That way the check is accounted for in one transaction so it matches the bank deposit. Downside is that there no way to match to any batch report coming out of RE (where advancement would have recorded the donation/pledge payment). Best practice would be to have families write separate checks, but that can be difficult.

    Tony Block

  • susan correa
    susan correa
    Fifth Anniversary Name Dropper Facilitator 1

    @Daniel Wallach
    Depends on how you map payments from RE & BM into FE.

    To “split a payment” into two sub-ledger. Enter the FE donation and map it to A/R instead of Bank Acct GL for that type of transaction. Same with the Tuition side. Then a Journal Entry into A/R and Bank accounts once deposited. So in FE, it will show one sum in CASH GL easier for Bank Recons.

    Hope that helps.

Categories