Isn't there a basic bank rec report that will spell out the bank reconciliation?
I have run 1-5-0-21, but the "account current balance" at the bottom of the report is very misleading, as it reflects today's GL balance instead of the GL balance at the end of the reconciliation period (obvioulsy the GL has moved on since the bank statement balance date. How could that ever be relevant?).
No-where are the 3 critical values displayed all in one place:
GL Balance (as of the end of the reconciliation period)
less Uncleared/open transactions (as of the end of the reconciliation period)
= Bank Stmt Ending Balance (end of the reconciliation period)
Advice?