Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Madison Company's cash ledger reports the following for the month ending March 31. Date: Amount Number Date Amount Deposits: 3/4 $1,700 Checks: 541 3/2
Madison Company's cash ledger reports the following for the month ending March 31. Date: Amount Number Date Amount Deposits: 3/4 $1,700 Checks: 541 3/2 $5,900 3/11 1,300 542 3/8 900 3/18 4,100 543 3/12 2,400 3/25 3,600 544 3/19 1,600 Cash receipts: 3/26 to 3/31 2,400 545 3/27 500 $13,100 546 3/28 600 547 3/30 1,900 $13,800 Balance on March 1 Receipts Amount $5,900 13,100 Disbursements Balance on March 31 (13,800) $5,200 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,463. b. Cash receipts of $2,400 from 3/26 - 3/31 are outstanding. c. Checks 545 and 547 are outstanding. d. The deposit on 3/11 included an NSF check from a customer in the amount of $430 that did not clear the bank. e. Check 543 was written for $3,000 for office supplies in March. The bank properly recorded the check for this amount. f. An electronic funds transfer (EFT) for March rent was made on March 4 for $1,150. g. Madison's checking account earns interest based on the average daily balance. The amount of interest earned for March is $52. h. Last year, one of Madison's top executives borrowed $4,250 from Madison. On March 24, the executive paid $4,460 ($4,250 borrowed amount plus $210 interest) directly to the bank in payment for the borrowing. i. The bank charged the following service fees: $30 for NSF check, $18 for an electronic funds transfer (EFT) for rent payment, and $21 for collection of the loan amount from the ovecutive Complete this question by entering your answers in the tabs below. Required 1 Required 2 Prepare a bank reconciliation to calculate the correct balance of cash on March 31. (Amounts to be deducted should be indicated with a minus sign.) Bank's Cash Balance Per bank statement MADISON COMPANY Bank Reconciliation March 31 + Per general ledger Company's Cash Balance Bank balance per reconciliation Company balance per reconciliation
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started