Madison Company's cash ledger reports the following for the month ending March 31. Deposits: Date 3/4 3/11 3/18 3/25 3/26 - 3/31 Amount $ 1,200 1,600 3,800 3,100 2,700 $ 12,400 No. Date Amount Checks: 541 3/2 $ 5,900 542 3/8 500 543 3/12 2,600 544 3/19 1,400 545 3/27 40e Cash receipts: 546 3/28 3/30 547 800 1,500 $13,100 Balance on March 1 Receipts Disbursements Balance on March 31 $ 5,200 12,400 (13, 100) $ 4,500 Information from March's bank statement and company records reveals the following additional Information: The ending cash balance recorded in the bank statement is $5.923 b. Cash receipts of $2.700 from 3126-3/31 are outstanding Checks 545 and 547 are outstanding d The deposit on 31 included a customer's check for 5420 that did not clear the bank (NSF check) e Check 543 was written for $3.200 for office supplies in March. The bank properly recorded the check for this amount . An automatic withdrawal for March rent was made on March 4 for $1.250. g. Madison's checking account earns interest based on the average daily balance. The amount of interest earned for March is $55. h. Last year, one of Madison's top executives borrowed $4.300 from Madison. On March 24,the executive paid $4,510 (54,300 borrowed amount plus $210 interest) directly to the bank in payment for the borrowing The bank charged the following service fees $38 for NSF check $14 for automatic withdrawal for rent payment and $20 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.) MADISON COMPANY Bank Reconciliation March 31 Bank's Cash Balance Company's Cash Balance Before reconciliation Before reconciliation 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 Record the entries that increase cash Note: Enter debits before credits General Journal Debit Credit Transaction 1