Welcome to Forums Sign in | Join | Help | Forums
in Search


Reconcile Cash Accounts without Modules

Last post 12-20-2005 4:56 PM by OBS315200707DUP Larry OBS315200707DUP Miles. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next
  • 12-07-2005 5:10 PM

    • Hillary Murphy
    • Top 100 Contributor
    • User Since: 1999
    • Posts 85
    • Organization: Phoebe Foundation
    • Products:  Accounting for Nonprofits, Blackbaud NetCommunity, The Financial Edge, The Raiser's Edge, The Researcher's Edge, Sphere

    Reconcile Cash Accounts without Modules

    We have FE but no other modules like AP, Bank Accounts, Cash Management, etc.... Can you suggest a way for us to easily reconcile our cash accounts without these modules? Hillary Murphy
    Financial Administrator
    Phoebe Foundation
    Hillary Murphy
    Phoebe Foundation
    Phoebe Putney Memorial Hospital
    Albany, Georgia
    www.supportphoebe.org
    www.youtube.com/phoebefoundation
    mailto:hmurphy@ppmh.org
  • 12-20-2005 1:48 PM In reply to

    Reconcile Cash Accounts without Modules

    I used to use the "proof of cash" method to reconcile bank accounts, back before I was using Blackbaud. This method is basically using a spreadsheet to show the detail of the items that appear on the general ledger, but not the bank statement, and visa versa. You start with your bank statement balance, and end with the general ledger. The details it provides shows you exactly what types of entries (if any) are needed to reconcile your account. It is also important to have an "outstanding checks" number. I get this by keeping a register (another spreadsheet) that has the first column "checks printed" or written, second column is "checks cleared", third column is "voided checks" the last is the balance, and the total of that will be what is left outstanding. This number will be needed to balance your bank account to the general ledger. I know this is confusing, but I hope it gives you some ideas where to start, and hopefully, someone else can explain this in better detail. SF
  • 12-20-2005 4:56 PM In reply to

    Reconcile Cash Accounts without Modules

    We also have abandoned Blackbauds bank reconciliation program for the same reason. We could never get the Blackbaud register used in the reconciliation program to egual the General Ledger. We also are using excel to reconcile thousands of credit card transactions a month books against bank. The book detail we export from Blackbaud which actually comes from Tessitura and the bank detail we export from the bank online.
Page 1 of 1 (3 items)