Bank+Reconciliation+in+Excel

Many people dislike the chore of balancing their check book on a monthly basis. I have made a template in Excel that will make this chore a little easier for all! Starting with your check book balance, add deposits and subtracting checks written. The ending balance line has a formula that adds these 3 lines for you. Then you fill in the ending Bank statement balance, add any outstanding deposits, and subtract outstanding checks. Once again the Adjusted ending balance line has a formula to add these 3 lines for you. Notice also that the list of outstanding checks total amount will be copied to the correct line in the bank reconciliation. Hopefully this will make balancing a check book a little easier.
 * ||  |||||||||| ** BANK RECONCILIATION ** || ||
 * || |||||||||| September 30, 2009 || ||
 * |||| CHECKBOOK - GENERAL LEDGER: || || || || || ||
 * || |||| BEGINNING BOOK BALANCE || || $ 400.00 || || ||
 * || || CASH RECEIPTS || || || 300.00 || || ||
 * || |||| LESS: CASH DISBURSEMENTS || || __ (200.00) __ || || ||
 * || || ENDING BALANCE || || || || __ $ 500.00 __ || ||
 * |||| BANK STATEMENT || || || || || ||
 * || |||| ENDING BANK BALANCE || || $ 600.00 || || ||
 * || |||| PLUS: OUTSTANDING DEPOSITS || || -  || || ||
 * || |||| LESS: OUTSTANDING CHECKS || || __ (100.00) __ || || ||
 * || |||| ADJUSTED ENDING BALANCE || || || __ $ 500.00 __ || ||
 * || |||||||||| OUTSTANDING CHECK LIST || ||
 * || || CK# || DATE || AMOUNT || || || ||
 * || || 120 || 9/5/2009 || 50.00 || || || ||
 * || || 124 || 9/15/2008 || 50.00 || || || ||
 * || |||| TOTAL OUTSTANDING CHECKS || $ 100.00 ||   ||   ||   ||
 * || |||| ENDING BANK BALANCE || || $ 600.00 || || ||
 * || |||| PLUS: OUTSTANDING DEPOSITS || || -  || || ||
 * || |||| LESS: OUTSTANDING CHECKS || || __ (100.00) __ || || ||
 * || |||| ADJUSTED ENDING BALANCE || || || __ $ 500.00 __ || ||
 * || |||||||||| OUTSTANDING CHECK LIST || ||
 * || || CK# || DATE || AMOUNT || || || ||
 * || || 120 || 9/5/2009 || 50.00 || || || ||
 * || || 124 || 9/15/2008 || 50.00 || || || ||
 * || |||| TOTAL OUTSTANDING CHECKS || $ 100.00 ||   ||   ||   ||
 * || |||||||||| OUTSTANDING CHECK LIST || ||
 * || || CK# || DATE || AMOUNT || || || ||
 * || || 120 || 9/5/2009 || 50.00 || || || ||
 * || || 124 || 9/15/2008 || 50.00 || || || ||
 * || |||| TOTAL OUTSTANDING CHECKS || $ 100.00 ||   ||   ||   ||
 * || || 120 || 9/5/2009 || 50.00 || || || ||
 * || || 124 || 9/15/2008 || 50.00 || || || ||
 * || |||| TOTAL OUTSTANDING CHECKS || $ 100.00 ||   ||   ||   ||
 * || |||| TOTAL OUTSTANDING CHECKS || $ 100.00 ||   ||   ||   ||
 * || |||| TOTAL OUTSTANDING CHECKS || $ 100.00 ||   ||   ||   ||