Using the transaction details and templates provided below complete Bank Reconciliation for the following financial records for Charlies Coffee Lounge.

Recreate the Bank Reconciliation in Excel.

Enter all required information.

Balance at the bottom of reconciliation.

Un-presented Cheque Details Payment Type (eg. cheque no, cash direct debit) Date 08-Jan-09 Kays Cleaning 15-Jan-09 Office Essentials 27-Jan-09 Rid Pest Control Details Amount Chq. No. 1009 Chq. No. 1010 Chq. No. 1011 $225.00 $33.00 $425.00 Outstanding Deposits Total Amount Received Date Details Invoice/Receipt No. NIA NIA 28-Jan-09 Sale of Coffee Beans 200.00 29-Jan-09 Sales of Fixtures and Fittings 1,200.00 Bank Balance 31 January 2009 $10,250.00