Madison Company's cash ledger reports the following for the month ending March 31 Depositat Date 3/2 Date 3/4 3/11 3/18 3/25 3/26- 3/31 Amount $ 1,600 1,900 4,400 1,700 2,500 $ 14,100 No. Checksi 541 542 563 544 545 3/12 3/19 3/27 Amount $ 6,000 500 2,500 1,600 400 Cash receipto: 5&6 3/20 3/30 547 600 1,200 $12,800 Balance on March 1 Receipts Disbursements Balance on March 31 $ 5.500 14,100 (12.800) $ 6,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 $8,233. b. Cash receipts of $2,500 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 $490 that did not clear the bank (NSF check). e. Check 543 was written for $3,100 for office supplies in March. The bank properly recorded the check for this amount 1. An automatic withdrawal for March rent was made on March 4 for $1,000 9. Madison's checking account earns interest based on the average daily balance. The amount of interest earned for March is $58. h. Last year, one of Madison's top executives borrowed $4150 from Madison On March 24, the executive paid $4.440 (54,150 The bank charged the following service fees: 832 for NSF check, 518 for automatic withdrawal for rent payment, and $25 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 sitn.) 1. Prepare a bank reconciliation for March 31. (Amounts to be deducted should be indicated with a minus sign.) MADISON COMPANY Bank Reconciliation March 31 Company's Cash Balance Before reconciliation Bank's Cash Balance Before reconciliation 5:12 After reconciliation $ O After reconciliation $ 0 2. Record the necessary cash adjustments.(If no entry is required for a transaction/event, select "No Journal Entry Required in the first account field.) View transaction list Journal entry worksheet