Generally, Bank Reconciliation is done to ensure reconciliation between the Balance of Ledger to the Balance of Bank and difference arising could be referred as Unpresented, Uncleared and Unrecorded Transactions which are identified, categorized and accounted for accordingly.
It requires major human intervention to reconcile the difference to Zero.
I have made a model which almost minimized human intervention and whole categorization of it is done automatically. It only requires to copy and paste the Ledger of Unreconciling items to a specified area.
It also identifies payments which are "Post Dated" or which are "Staled" and adjust it from the Ledger Balance.
And last, it categorized all Unreconciled Payments to its aging so that it could be considered and accounted for accordingly while projecting Cashflow Position.