Hi,

I need help with a bank reconciliation question. I am attaching the question image. Images are numbered from 1 to 5.

Learning Plan 6 - BF001 - Book X VitalSource Bookshelf: Basic Bo X Post learning requirement - Lea O https://online.vitalsource.com/#/books/9780176798765/cfi/6/32!/4/234/2@0:0 Q. Search A & III OD Most Visited Renalyn @ Login National Student Loan... Robertson College On... @ Gmail - Email from Go... A Internet Banking for A... Canada Revenue Agen... Internet reporting serv... * Textbook Solutions & ... PRACTICE EXERCISE 9 From the following information, prepare a bank reconciliation statement for the Asian Book Store on February 28. 20-. Follow these steps carefully: Compare the outstanding deposit and the outstanding cheques shown on the January 31 reconciliation statement (Figure 9.20a) with the deposits and cheques listed on the February bank statement (Figure 9.20b). If these items now appear on the bank statement, they are no longer outstanding Therefore, you should put a check mark beside each of these amounts on the bank statement. Figure 9.20a Bank Reconciliation for January Asian Book Store Bank Reconciliation January 31, 20- Bank Statement Balance $1 5 8 4 00 Outstanding Deposit 3 2 5 0 00 4 8 3 4 OO less: Outstanding Cheques #231 $1 6 6 0 00 #232 1 9 4 0 00 3 6 0 0 00 Adjusted Balance $1 2 3 4 00 Figure 9.20b Bank Statement for February Bank Statement (February) Date Cheques Deposits Balance We've updated our read aloud feature! Give it a try here 163 n - AaLearning Plan 6 - BFQ01 - Book! X VitalSource Bookshelf: Basic Bo X * Post learning requirement - Lee O https://online.vitalsource.com/#/books/9780176798765/cti/6/32!/4/242/4/2@0:0.318 ... Q Search = Most Visited Renalyn @ Login National Student Loan.. . Robertson College On.. G Gmail - Email from Go... A Internet Banking for A... * Canada Revenue Agen... Internet reporting serv... * Textbook Solutions & ... Bank Statement (February) Date Cheques Deposits Balance Feb. 1 S W N N - O V V V WW N NN 1,584 3,250 4,834 1,940 2,894 1,660 1,234 1,580 2,814 926 1,888 4,560 6,448 3,500 2,948 89 2,859 91 2,768 123 2,645 3,300 5,945 84 5,861 155 5,706 7,500 22 13,206 3,000 16,206 22 361 15,845 22 2,750 13,095 23 MTG 2,500 10,595 26 4,250 14,845 27 3,910 10,935 28 667 10,268 We've updated our read aloud feature! 28 S/C 23 10,245 Give it a try here. 164 AaLearning Plan 6 - BF001 - Bookl X VitalSource Bookshelf: Basic Bo > * Post learning requirement - Lea > https://online.vitalsource.com/#/books/9780176798765/cfi/6/32!/4/242/4/2@0:66.0 ... Y Q Search E Most Visited Renalyn @ Login National Student Loan.. Robertson College On... G Gmail - Email from GO.. A Internet Banking for A. Canada Revenue Agen.. Internet reporting serv. *Textbook Solutions & . > > ooo's 0,200 A 22 361 15,845 22 2,750 13,095 23 MTG 2,500 10,595 26 4,250 14,845 27 3,910 10,935 28 667 10,268 28 S/C 23 10,245 28 NSF 250 9,995 Figure 9.20c Cash Receipts Journal Cash Receipts Journal Date Deposits Feb. 3 1,580 7 4,560 12 3,300 17 7,500 22 3,000 26 4,250 28 3,550 27,740 We've updated our read aloud feature! Give it a try here 164 Aa )Learning Plan 6 - BF001 - Book X VitalSource Bookshelf: Basic Bo X Post learning requirement - Lea X -CA https://online.vitalsource.com/#/books/9780176798765/cfi/6/321/4/244/4/2@0:80.1 Q Search ELINO Most Visited Renalyn @ Login + National Student Loan.. Robertson College On... G Gmail - Email from Go.. A Internet Banking for A.. Canada Revenue Agen... Internet reporting serv.. Textbook Solutions & . > > A 27,740 Figure 9.20d Cash Payments Journal Q Cash Payments Journal Date Cha# Amount Feb. 2 VIVIN 233 926 234 89 235 3,500 6 236 91 7 237 123 11 238 84 11 239 155 17 240 2,750 20 241 361 23 242 3,910 23 243 667 23 Mortgage 2,500 27 244 1,740 27 245 1,000 28 246 2,050 19,946 We've updated our read aloud feature! Give it a try here. 165 Aa )Learning Plan 6 - BF001 - Book! X VitalSource Bookshelf: Basic Bo X Post learning requirement - Lea X X -> O https://online.vitalsource.com/#/books/9780176798765/cfi/6/32!/4/246/4/2@0:17.3 ... Search Most Visited Renalyn @Login National Student Loan... . Robertson College On... G Gmail - Email from Go.. A Internet Banking for A. Canada Revenue Agen.. Internet reporting serv. Textbook Solutions & ... Feb. 2 233 926 A UI 234 89 235 3,500 236 91 7 237 123 11 238 84 11 239 155 17 240 2,750 20 241 361 23 242 3,910 23 243 667 23 Mortgage 2,500 27 244 1,740 27 245 1,000 28 246 2,050 19,946 Check the February deposits in the Cash Receipts Journal (Figure 9.20c) against the deposits listed on the bank statement. Write "O/S" beside any deposit in the journal that does not appear on the bank statement. These are the outstanding deposits that will be shown on this month's bank reconciliation. Check the February entries in the Cash Payments Journal (Figure 9.20d) against the cheques listed on the bank statement. Write "O/S" beside any payment in the journal that does not have a corresponding amount on the bank statement. These are the outstanding cheques to be shown on this month's bank reconciliation. The balance in the Bank account on the books at the end of January was $1,234. Use this amount and the totals of the Cash Receipts and Cash Payments Journals to calculate the balance in the Bank account at the end of February. The following items were noted on the bank statement at the end of February but have not yet been recorded on the books: (a) monthly bank charges, $23. (b) NSF cheque from H. Potter, $250. Finally, record the General Journal entries for the items not yet recorded on the books. We've updated our read aloud feature! Give it a try here. PRACTICE EXERCISE 10 165 Aa