Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

create a template and complete bank reconciliation. Bank Statement Date Number D

ID: 2592468 • Letter: C

Question

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

Explanation / Answer

Bank reco. for month end nov 2014 Balance as per cash book         9,215 Ch. Issued but not year presented for payment Ch no 106 for graphic design             700 Ch no 107 for equipment supplies             375 ch no 109 for phone exp             180 ch no 110 for with drawal         1,500         2,755 Ch no 108 for for milage exp issued for 85 but wrongly entered for 185            100 Bank deposit was 1100 but only entered amount of 500 in cash book Short amount 600 in cash book            600 Bank Charges not entered into book             -45 Balance as per bank book      12,625 Cash Book Debit Credit Cash Deposit into bank        20,000 Ch no 100 for equipment         6,000 Cash Deposit into bank              500 Ch. No 101 for equipment             600 Ch. No 102 for insurance         1,200 Ch no 103 for supplies               90 Ch no 104 for equipment supplies             225 Ch no 105 for accounts payable             230 Ch no 106 for graphic design             700 Ch no 107 for equipment supplies             375 Ch no 108 for for milage exp             185 ch no 109 for phone exp             180 ch no 110 for with drawal         1,500 Total        20,500 Total       11,285 Cl Balance           9,215 Assumed all cash recived deposited into bank