Bank accounts have never been reconciled in BB

I assumed a new position a week ago, and I just found out that the bank reconciliations have never been done in BB. The organization switched to BB three years ago, and all the bank reconciliations have been done in excel.

What would be an easy way to get caught-up on those reconciliations in BB?

Comments

  • Kevin Brazell
    Kevin Brazell Blackbaud Employee
    Tenth Anniversary Kudos 5 First Reply Name Dropper

    @Eva Madren
    Bit of a loaded question as there won't really be an “easy” way to catch up. There are a number of variables that will dictate how much work it would be. Things to consider :

    • Was cash management always unlocked and making adjustments from JE's to the bank register
    • What is the amount of time for the banks and database
    • The bank will start from the beginning of it's creation, similar to the above, so amount of time you're making up will be important.

    That's just a few things to consider. Regardless of the time frame, you've got to decide , the cadence of doing the bank recs. Do you try to recreate the history and go period by period ? If you're covering large gaps of time, do you do 1 for a year, or one big one up until a more current year or time.

    It could be a daunting task, and you may want to explore consulting options to have outside help you plan and brainstorm the process.