A. Prepare a bank reconciliation for March B. Prepare any journal entries that the company should make on 3/31 after reconciling the cash account. Bank Reconciliation Balance per Bank Balance per Company Acct. Titles Credit Debit ADD: Less: Write a ADD: short title for Beach item 4 you add or Less: 5 subtract 16 47 Put dollar 48 amounts in -49 yellow 50 section of 51 reconciliation Adjusted Balance 53 formulas/cell 54 references 55 52 using Adjusted Balance (No dates or explanations are required in these journal entry or entries.) Information from the Bank: Bank Statement ABC Bank XYZ Company Beginning Balance at 3/1/2019 Total Deposits and other credits Total checks and other debits Ending Balance at 3/31/2019 Acct# 40-1004 Date: 3/31/2019 $14,000.00 5,998.00 3,553.00 $16,445.00 Checks & Debits Check # Amount 1467 1165 Deposits and Credits Date Amount 1-Mar 900 1468 67 2-Mar 12-Mar 1430 2875 1 1469 472 17-Mar 75 23-Mar 218 Credit Memo 1 500 2 1470 98 23 1471 195 24 1473 1250 25 1475 75 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 31 CM#1 is for collection of accounts receivable 32 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 23-Mar 218 31-Mar 1100 98 Chk# 1470 195 Chk# 1471 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 Information 14000 900 Balance on 2/28 per bank Deposits in transit Outstanding Checks True Balance 1165 13735