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,000 Checks: 541 3/2

image text in transcribed

Madison Company's cash ledger reports the following for the month ending March 31.

DateAmountNo.DateAmount
Deposits:3/4$ 1,000 Checks: 5413/2$5,400
3/111,800 5423/8600
3/183,900 5433/122,600
3/253,900 5443/191,300
Cash receipts:3/26-3/312,700 5453/27600

5463/28500
$ 13,300 5473/301,400

Balance on March 1$ 6,200 $12,400
Receipts13,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.)

image text in transcribed

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

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

9th edition

1-119-49356-3, 1119493633, 1119493560, 978-1119493631

More Books

Students also viewed these Accounting questions