create a template and complete bank reconciliation.

Bank Statement Date Number Description Withdrawals Deposits Balance $20,000.00 November 1, 2014 November 5, 2014 101 Deposit I Check $20,000.00 600.00 6,000.00 1,200.00 90.00 19,400.00 13,400.00 12,200.00 12,110.00 Check Check November 5, 2014 100 November 6, 2014 102 November 11, 103 2014 November 12, 104 2014 November 15, 2014 November 21, Check 11,885.00 Check Deposit 2 Check Check Bank Service 225.00 1,100.00 12,985.00 230.00 12,755.00 2014 November 29, 2014 12,670.00 12,625.00 $12,625.00 108 85.00 November 30, 2014 November 30, 2014 45.00 Charge Ending Balance Previous