Question
Madison Company's cash ledger reports the following for the month ending March 31. Date Amount No. Date Amount Deposits: 3/4 $ 1,800 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,800 | Checks: | 541 | 3/2 | $ 5,900 |
3/11 | 1,600 | 542 | 3/8 | 700 | ||
3/18 | 4,400 | 543 | 3/12 | 2,000 | ||
3/25 | 3,400 | 544 | 3/19 | 2,000 | ||
Cash receipts: | 3/26-3/31 | 2,200 | 545 | 3/27 | 400 | |
546 | 3/28 | 900 | ||||
$ 13,400 | 547 | 3/30 | 1,900 | |||
Balance on March 1 | $ 6,200 | $13,800 | ||||
Receipts | 13,400 | |||||
Disbursements | (13,800) | |||||
Balance on March 31 | $ 5,800 | |||||
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,525. |
b. | Cash receipts of $2,200 from 3/26-3/31 are outstanding. |
c. | Checks 545 and 547 are outstanding. |
d. | The deposit on 3/11 includes a customer's check for $470 that did not clear the bank (NSF check). |
e. | Check 543 was written for $2,600 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,000. |
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,450 from Madison. On March 24, the executive paid $4,720 ($4,450 borrowed amount plus $270 interest) directly to the bank in payment for the borrowing. |
i. | The bank charged the following service fees: $32 for NSF check, $17 for automatic withdrawal for rent payment, and $28 for collection of the loan amount from the executive. |
. | Prepare a bank reconciliation for March 31. Record the necessary cash adjustments |
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