I thought I had the bank rec module figured out, but my friendly auditors have pointed out that I may have missed something.  When I run a General Ledger for a single account (the account we created to track a cash account at the bank), the ending balance is X at 6/30/09.  Pretty simple, I thought.

 When I did the reconciliation report (several months ago, and now I can not re-create that report) the page that shows "Reconciliation of Cash Account to Statement" (NOT to Register) shows a different ending balance labeled "Cash account ending balance 6/30/09".  I can not figure out for the life of me where the system is pulling that number from, or why it would be different from the balance on my general ledger and trial balance reports? 

Any bright ideas would be greatly appreciated - thanks so much!

Hi Marianne,

The most common reasons that I can think of that could cause the General Ledger report to not match a Reconciliation report is you are including Not Yet Posted transactions on the General Ledger Report (Reconciliation Reports do not include Not Yet Posted transactions), there have been postings to the cash account since you last ran the reconciliation report with a post date prior to 06/30/09 or your bank uses multiple cash accounts and you are only running the General Ledger report for one of those cash accounts.

I hope this information helps you.

William