ACC 213 Accounting Lab #5 for Chapter 6 Name Complete the Bank Reconciliation (Part A) and the Journal Entries (Part B) from the information provided. Part A: Information from the Bank: Information from the Company's accounting system: Bank Statement XYZ Company ABC Bank Cash Account with XYZ Bank #40-1004 XYZ Company Acct# 40-1004 Date: 3/31/2019 Cash Beginning Balance at 3/1/2019 $14,000.00 3/1 balance $13,735 Total Deposits and other credits 5,998.00 Total checks and other debits 3,553.00 2-Mar 1,430 67 Chk# 1468 Ending Balance at 3/31/2019 $16,445.00 12-Ma 2875 472 Chk# 146 17-Mar 75 98 Chk# 1470 Checks & Debits Deposits and Credits 23-Mar 218 95 Chk# 1471 Check # Amount Date Amount 31-Mar 1100 125 Chk# 1472 1467 $1,165 -Ma 90 1250 Chk# 1473 1468 67 -Ma 1430 155 Chk# 1474 1469 472 2-Mar 2875 57 Chk# 1475 1470 98 7-Mar 75 3/31 balance $17,014 1471 195 23-Mar 218 1473 1250 Credit Memo 1 500 147 75 Note: all checks paid by the bank were paid for the amounts written on the checks. Debit Memo 1 21 Check #1475 was for the utility bill Debit Memo 2 210 February Bank Reconciliation Information DM#1 is a bank service charge CM#1 is for collection of accounts DM#2 is for an NSF check receivable Balance on 2/28 per bank 13000 Deposits in transit 900 Outstanding Checks 1165 True Balance 12735 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 Debit Credit Write a ADD: ADD: short title for each item you add or Less: Less: subtract Put dollar amounts in yellow section of reconciliation using Adjusted Balance Adjusted Balance (No dates or explanations are required in these journal formulas/cell entry or entries.) references