Excel format please

AA15 JX A B D E F G H K L O S T M N Q R V 1 On March 31, 20X1, Home Decorating Pavilion received a bank statement showing a balance of $9,840. The balance in the firm's checkbook and Cash account on the same date was $9,994. 2 The difference between the two balances is caused by the items listed below. 3 4 5 a. A $2,965 deposit made on March 30 does not appear on the bank statement. 7 b. Check 358 for $530 issued on March 29 and Check 359 for $1,740 issued on March 30 have not yet been paid by the bank. 9 c. A credit memorandum shows that the bank has collected a $1,500 note receivable and interest of $150 for the firm. 11 d. A service charge of $34 appears on the bank statement. 13 e. A debit memorandum shows an NSF check for $570. (The check was issued by Dane Jaris, a credit customer.) 15 f. The firm's records indicate that Check 341 of March 1 was issued for $900 to pay the month's rent. 16 However, the canceled check and the listing on the bank statement show that the actual amount of the check was $800. 18 g. The bank made an error by deducting a check for $605 issued by another business from the balance of Home Decorating Pavilion's account. 19 20 21 Required: 22 1. Prepare a bank reconciliation statement for the firm as of March 31, 20X1. 23 2. Record entries for any items on the bank reconciliation statement that must be journalized. 24 25