The cash data of Dunlap Automotive for March 2020 follow (Click the icon to view the chequebook.) Dunlap received the following bank statement on March 31, 2020 Click the icon to view the bank statement.) (Click the icon to view the additional data for the bank reconciliation.) Requirement Prepare the Dunlap Automotive bank reconciliation at March 31, 2020 Prepare the Dunlap Automotive bank reconciliation at March 31, 2020. (Leave unused cells blank.) Dunlap Automotive Bank Reconciliation March 31, 2020 BANK Add: Less Cheque No. Less Cheque No. Chequebook Cash Date Item Jrnl. Ref Debit Credit Balance March 1 Balance 7,250 31 CR6 9.821 31 CP 11 Cash Receipts (CR) 17,071 6,211 Date Cash Debit elds an March 2$ 3,047 8 589 10,860 Cash Payments (CP) Cheque No. Cash Credit 3113 $ 1,038 3114 1,848 3115 1,930 3116 559 3117 902 3118 10 1.186 1.665 16 22 1.230 29 1.064 561 Chequebook Cash Receipts (CR) Cash Payments (CP) Date Cash Debit Cheque No. Cash Credit March 2$ 3,047 3113 $ 1,038 8 589 3114 1,848 10 1,186 3115 1,930 16 1,665 3116 559 22 1,230 3117 902 29 3118 561 1,064 1,040 3119 506 30 Total $ 9,821 3120 977 3121 169 2.370 3122 Bank Statement for March 2020 $ 7,250 Beginning balance Deposits and other additions: March 1 $ 650 EFT 4 3,047 9 12 589 1,186 17 1,665 22 23 1,450 BC 1,230 9.817 Cheques and other deductions: March 7 S 1,038 13 1,390 1,230 23 9,817 Cheques and other deductions: March 7 $ 1,038 13 1,390 14 409 US 15 1.848 18 559 21 26 351 EFT 902 30 561 30 15 SC (7.073) Ending balance $ 9.994 Explanation EFT-electronic funds transfer, BC-bank collection, USunauthorized signature SC-service charge