Bank reconcilations are very important on the year end check list. While doing a bank reconciliation you must take into account the outstanding checks or any checks in transit also. Using Excel to do a reconciliation is simple and quick. Once the formula's are set then one just has to enter data and all is set. Please visit www.samplewords.com/personal-bank-reconciliation.html.