Question
Madison Company's cash ledger reports the following for the month ending March 31. Date Amount No. Date Amount Deposits: 3/4 $ 1,000 Checks: 541 3/2
Madison Company's cash ledger reports the following for the month ending March 31.
Date | Amount | No. | Date | Amount | ||
Deposits: | 3/4 | $ 1,000 | Checks: | 541 | 3/2 | $5,400 |
3/11 | 1,800 | 542 | 3/8 | 600 | ||
3/18 | 3,900 | 543 | 3/12 | 2,600 | ||
3/25 | 3,900 | 544 | 3/19 | 1,300 | ||
Cash receipts: | 3/26-3/31 | 2,700 | 545 | 3/27 | 600 | |
546 | 3/28 | 500 | ||||
$ 13,300 | 547 | 3/30 | 1,400 | |||
Balance on March 1 | $ 6,200 | $12,400 | ||||
Receipts | 13,300 | |||||
Disbursements | (12,400) | |||||
Balance on March 31 | $ 7,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 $8,529. b. Cash receipts of $2,700 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 $420 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. f. An automatic withdrawal for March rent was made on March 4 for $1,450. g. Madison's checking account earns interest based on the average daily balance. The amount of interest earned for March is $57. h. Last year, one of Madison's top executives borrowed $4,350 from Madison. On March 24, the executive paid $4,610 ($4,350 borrowed amount plus $260 interest) directly to the bank in payment for the borrowing. i. The bank charged the following service fees: $32 for NSF check, $13 for automatic withdrawal for rent payment, and $23 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.)
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