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

  1. The ending cash balance recorded in the bank statement is $8,296.
  2. Cash receipts of $2,100 from 3/263/31 are outstanding.
  3. Checks 545 and 547 are outstanding.
  4. The deposit on 3/11 included a customer's check for $430 that did not clear the bank (NSF check).
  5. Check 543 was written for $2,700 for office supplies in March. The bank properly recorded the check for this amount.
  6. An automatic withdrawal for March rent was made on March 4 for $1,000.
  7. Madison's checking account earns interest based on the average daily balance. The amount of interest earned for March is $51.
  8. 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.
  9. 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

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_2

Step: 3

blur-text-image_3

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 For Decision Makers

Authors: Mark DeFond

2nd Edition

1618533142, 9781618533142

More Books

Students also viewed these Accounting questions

Question

How does technology play a role in manufacturing?

Answered: 1 week ago