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 No. Date Amount Deposits: 3/4 $ 1,400 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,400 | Checks: | 541 | 3/2 | $ | 5,500 | |||
3/11 | 1,300 | 542 | 3/8 | 500 | |||||||
3/18 | 4,100 | 543 | 3/12 | 2,100 | |||||||
3/25 | 3,700 | 544 | 3/19 | 1,700 | |||||||
Cash receipts: | 3/26-3/31 | 2,100 | 545 | 3/27 | 500 | ||||||
$ | 12,600 | 546 | 3/28 | 800 | |||||||
547 | 3/30 | 1,500 | |||||||||
Balance on March 1 | $ | 5,800 | $ | 12,600 | |||||||
Receipts | 12,600 | ||||||||||
Disbursements | (12,600 | ) | |||||||||
Balance on March 31 | $ | 5,800 | |||||||||
Information from March's bank statement and company records reveals the following additional information:
- The ending cash balance recorded in the bank statement is $8,296.
- Cash receipts of $2,100 from 3/263/31 are outstanding.
- Checks 545 and 547 are outstanding.
- The deposit on 3/11 included a customer's check for $430 that did not clear the bank (NSF check).
- Check 543 was written for $2,700 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,000.
- Madison's checking account earns interest based on the average daily balance. The amount of interest earned for March is $51.
- Last year, one of Madison's top executives borrowed $4,400 from Madison. On March 24, the executive paid $4,650 ($4,400 borrowed amount plus $250 interest) directly to the bank in payment for the borrowing.
- The bank charged the following service fees: $36 for NSF check, $15 for automatic withdrawal for rent payment, and $24 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.)
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.)
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