Bank Reconciliations (20 Points) Account enquines 132 032 Westpac Bank 24 hrs a day Customer Number 90876752 Details of your account For the period from 31 Jul 2007 to 31 Aug 2007 Date Description of transaction Debit Credit Balance 2007 STATEMENT OPENING BALANCE 6,713.37 1-Aug CASH DEPOSIT 235.15 6.949.02 1-Aug STATE GOVT TAX ON WITHDRAWALS 200 6.749.02 9-Aug WITHDRAWAL CHEQUE 301099 855.10 5.893.92 9-Aug NOTE NO 5556 COLLECTION 2.800 8.693.92 12-Aug WITHDRAWAL CHEQUE 301100 566.60 8,127.32 12-Aug WITHDRAWAL CHEQUE 301097 141.80 7.985.52 12 Aug WITHDRAWAL CHEQUE 301098 253.80 7.731.72 13 Aug CASH DEPOSIT 656 20 8.387.92 16-Aug WITHDRAWAL CHEQUE 300903 362.50 8,025.42 18-Aug WITHDRAWAL CHEQUE 300902 90.40 7.935.02 13-AugCheck printing fees 100.00 7.835.02 18-Aug WITHDRAWAL CHEQUE 300906 83.30 6,951.72 15-Aug CASH DEPOSIT 369.25 7.320.97 25-Aug CASH DEPOSIT 240.00 7.560.97 25-Aug Returned Check NSF (Customer A) $450 7.110.97 28-Aug SERVICE CHARGES 535 7,075.97 28-Aug MAINTENANCE FEES 569 7.006.97 31-AugCLOSING BALANCE 7,006,97 Books of XYZ Company Date Description of transaction Debit Credit Balance Balance 6,613.87 Issued to Supplier (Check NO 300906 $583330 3773037 Aug. 1 Issued to Supplier (Check NO 301097) 338877 Aug. 1 Bank deposit $235.15 5,623.92 Aug 5 Issued to Supplier Check NO 301098) $253.80 5,370.12 Aug 5 Issued to Supplier (Check NO 301099) $855.10 4,515.02 Aug 8 Bank deposit $636.20 5.171.22 Aug & Issued to Supplier (Check NO 301100) $566.60 4.604.62 Aug. 12 Issued to Supplier (Check NO 300902) $90.40 4,514.22 Aug 15 $369.25 4,883747 Aug 13 Issued to Supplies Check NO 300903 $36250 4520.97 Aug 20 Issued to Supplier (Check NO 300904) $100.00 4,420.97 Aug 24 Bank deposit $240.00 4.660 97 Ang 9 Customer Check NO 402001 sent to the bank $3.000 7.660.97 Aug. 29 Customer Check NO 402002 sent to the bank $2.500 10.160.97 Aug 29 Payroll Salaries Check NO 300905 $4.000 6.160.97 Aug 30 Bank deposit $5,000 11.160.97 Aug 30 Customer Check NO 402003 sent to the bank $800 11 960.97 Aug 31 CLOSING BALANCE 11,960.97 Aug. 1 Aug 1 Bank deposit Check NO 301097 issued by company to a supplier in January 1, the check issued at amount of $141.80 and the bank correctly cleared the check But the company clerk made a mistakejoumalizing the check in amount of $441.8 You have a copy of general ledger as maintained by a company and a copy ofledger as maintained by bank. Prepare bank reconciliations as of August 31 for XYZ co. And record the adjusting entries for the company