ment e Sind Help Save & Exit Submit Deposits: Date 3/4 3/11 3/18 3/25 3/26-3/31 Amount $ 1,100 1, Jee 4,200 3,900 2,600 $ 13,100 No Checks: 541 542 543 Cash receipts: 544 Date 3/2 3/8 3/12 3/19 3/27 3/28 3/30 545 546 547 Amount $ 5,980 See 2,600 1,000 800 700 1,200 $12,700 Balance on March 1 Receipts Disbursements Balance on March 31 $5,3ee 13,100 (12,700 $ 5,700 Information from March's bank statement and compahy records reveals the following additional information: a. The ending cash balance recorded in the bank statement is $7,317, b. Cash receipts of $2,600 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 $460 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 1. An automatic withdrawal for March rent was made on March 4 for $1,350 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,400 from Madison. On March 24, the executive paid $4,660 ($4.400 borrowed amount plus $260 interest) directly to the bank in payment for the borrowing. 1. The bank charged the following service fees: $39 for NSF check, $19 for automatic withdrawal for rent payment, and $30 for collection of the loan amount from the executive, ch 40 essment Saved Help Save 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 After reconciliation After reconciliation ch C 40 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 O search 40