Answered step by step
Verified Expert Solution
Link Copied!

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,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

3.40 Rating (156 Votes )

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Accounting Tools for business decision making

Authors: Paul D. Kimmel, Jerry J. Weygandt, Donald E. Kieso

6th Edition

978-1119191674, 047053477X, 111919167X, 978-0470534779

More Books

Students also viewed these Accounting questions

Question

9. What are the main requirements of work cells?

Answered: 1 week ago

Question

Question 2 For an n x n matrix A = form) via (aij)

Answered: 1 week ago