Deposits: 3/4 $ 1,200 3/11 1,700 Checks: 541 542 3/2 3/8 $5,900 3/18 4,400 543 3/12 500 2,300 3/25 3,100 Cash receipts: 3/26-3/31 2,000 $ 12,400 544 3/19 545 3/27 546 3/28 1,100 400 547 3/30 Balance on March 1 Receipts $ 5,700 12,400 900 1,200 $12,300 Disbursements (12,300) Balance on March 31 Help Save & Exit Subm $ 5,800 Information from March's bank statement and company records reveals the following additional information: a. The ending cash balance recorded in the bank statement is $7,756. b. Cash receipts of $2,000 from 3/26-3/31 are outstanding. c. Checks 545 and 547 are outstanding. d. The deposit on 3/11 included a customer's check for $410 that did not clear the bank (NSF check) e. Check 543 was written for $2,900 for office supplies in March. The bank properly recorded the check for this amount f. An automatic withdrawal for March rent was made on March 4 for $1,100. g. Madison's checking account earns interest based on the average daily balance. The amount of interest earned for March is $57. h. Last year, one of Madison's top executives borrowed $4,200 from Madison. On March 24, the executive paid $4,490 ($4,200 borrowed amount plus $290 interest) directly to the bank in payment for the borrowing. i. The bank charged the following service fees: $38 for NSF check, $16 for automatic withdrawal for rent payment, and $27 for collection of the loan amount from the executive. 1. Prepare a bank reconciliation for March 31. (Amounts to be deducted should be indicated with a minus sign.)