When we do manual bank reconciliation, reports will bring GL total and outstanding transactions correctly. We can print test report before and reconciliation report after posting with correct totals.

But the problem is if We decided to activate bank auto reconciliation option under general ledger setup, this will use others bank reconciliation reports that did not balance with the GL bank account at the end of the month when we reconcile a bank statement. There is no cut off at the reconciliation date and the outstanding transactions included all transactions after the date to reconcile posted in the GL, that is not a reconciliation as well!

Also the test report, that doesn’t balance, needs to be print before posting the bank reconciliation. If not we can’t print a standard reconciliation report with bank balance minus plus outstanding cheques and deposits at the end of the month.

So, as a consultant I can’t suggest to my customer to use bank auto match because of the reports that need to be correct for accountants as usual in all accounting system. The only alternative is to link the bank to get transactions in a journal reconciliation, make map to text, create the journal entry, post it, and do manually bank reconciliation. The idea to link the bank transaction is to automatically match cheque’s and deposits not to do it manually.

This is a MUST to be correct in next update. Please vote.