Madison Company's cash ledger reports the following for the month ending March 31 -1 Deposits: Date 3/4 3/11 3/11 3/25 3/26-3/31 Amount $ 1,800 1,300 4,180 3,400 2,200 $ 12,800 NO Checks: 541 542 543 504 545 Date 3/2 3/8 3/12 3/19 3/27 3/28 3/30 Annount $ 5,400 700 2,400 1,500 200 Cash receipts 0.19 49 546 5.42 1700 $12.600 Balance on March 1 Recepts Disbonents Balance on March 31 $ 5,900 12,800 (12,500) $ 6,100 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,959. b Cash receipts of $2,200 from 3/263/31 are outstanding Checks 545 and 547 are outstanding, d. The deposit on 3/11 included a customer's check for $470 that did not clear the bank (NSF check) e. Check 543 was written for $3,000 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 $1150 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 $4150 from Madison, on March 24. the executive paid $4,400 ($4150 borrowed amount plus $250 interest) directly to the bank in payment for the borrowing, 1. The bank charged the following service fees: $36 for NSF check. $18 for automatic withdrawal for rent payment, and 522 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 21 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.) 8 00:10.21 View transaction ist Journal entry worksheet Record the entries that increase ish. Net Ente det before cred Debit Credit Transaction General Journal View general Journal Clear entry Record entry