please help answer the last two (A&B) using the first two pics information provided.
A C D E 1 ACC 213 Accounting Lab #5 for Chapter 6 3 Complete the Bank Reconciliation (Part A) and the Journal Entries (Part B) from the information provided. 4 Part A: 6 Information from the Bank: 7 8 Bank Statement ank 9 10 XYZ Company Acct# 40-1004 Date: 3/31/2019 11 12 Beginning Balance at 3/1/2019 13 Total Deposits and other credits 14 Total checks and other debits 15 Ending Balance at 3/31/2019 $14,000.00 5,998.00 3,553.00 $16,445.00 16 Deposits and Credits 17 Checks & Debits 18 Check # Amount Date Amount 1-Mar 900 19 1467 1165 2-Mar 1430 20 1468 67 1469 12-Mar 2875 21 472 17-Mar 75 22 98 1470 23 195 23-Mar 218 1471 Credit Memo 1 500 24 1250 1473 25 75 1475 26 Debit Memo 1 21 27 Debit Memo 2 210 28 29 DM#1 is a bank service charge 30 DM#2 is for an NSF check CM#1 is for collection of accounts receivable 31 32 Sheet1 + OCT (A G H M Information from the Company's accounting system: XYZ Company Cash Account with XYZ Bank #40-1004 Cash 3/1 balance $13,735 2-Mar 1,430 67 Chk # 1468 12-Mar 2875 472 Chk# 1469 17-Mar 75 98 Chk # 1470 23-Mar 218 195 Chk# 1471 31-Mar 1100 125 Chk # 1472 1250 Chk # 1473 155 Chk# 1474 57 Chk# 1475 3/31 balance $17,014 Note: all checks paid by the bank were paid for the amounts written on the checks Check #1475 was for the utility bill. February Bank Reconciliation Inforrmation Balance on 2/28 per bank 14000 900 Deposits in transit 1165 Outstanding Checks 13735 True Balance B. Prepare any journal entries that the company sho on 3/31 after reconciling the cash account. omnan Dahit Acct Titlec AutoSave OFF ACC213 Chap Home Insert Draw Page Layout Formulas Data Review View A A Calibri 12 General E Paste A $ % 9 fx C5 A B C D E F G H 29 DM#1 is a bank service charge DM 2 is for an NSF check CM#1 is for collection of acccounts 30 receivable Ba 31 De 32 Ou 33 Tru 34 35 A. Prepare a bank reconciliation for March 36 37 Bank Reconciliation 38 Balance per Bank Balance per Company 39 40 Write a ADD: ADD: 41 short 42 title for 43 each item 44 you add or Less: Less: 45 subtract 46 47 Put dollar 48 amounts in 49 yellow 50 section of 51 reconciliation 52 using 53 formulas/cell 54 references Adjusted Balance Adjusted Balance 55 56 57 58 59 60 Sheet1 + OCT (A ACC213 Chapter 6 Instructionand Template w Insert v Conditional Formatting General 5 Delete Format as Table Sort & Filter X 00 Cell Styles Format L M N K H J February Bank Reconciliation Inforrmation Balance on 2/28 per bank 14000 900 Deposits in transit 1165 Outstanding Checks 13735 True Balance B. Prepare any journal entries that the company should make on 3/31 after reconciling the cash account. Credit Debit Acct. Titles (No dates or explanations are required in these journal entry or entries.)
