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, Deposits: Amount 55,600 Date 3/4 3/11 3/18 3/25 3/26-3/31 Amount $ 1,800

image text in transcribed
Madison Company's cash ledger reports the following for the month ending March 31, Deposits: Amount 55,600 Date 3/4 3/11 3/18 3/25 3/26-3/31 Amount $ 1,800 1,169 4,469 3,500 2,869 $ 13,600 Cash receipts: No. Date Checks: 541 3/2 542 3/8 543 3/12 544 3/19 545 3/27 3/28 5473/30 2,00 1,500 400 969 1,400 $12,400 $ Balance on March 1 Receipts Disbursements Balance on March 31 6,200 13,600 (12,400) 7,400 $ 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,603 b. Cash receipts of $2,800 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 $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.450. g. Madison's checking account earns interest based on the average daily balance. The amount of interest earned for March is $59. h. Last year, one of Madison's top executives borrowed $4,450 from Madison. On March 24, the executive paid $4,740 ($4.450 borrowed amount plus $290 interest) directly to the bank in payment for the borrowing. 1. The bank charged the following service fees: $38 for NSF check, $10 for automatic withdrawal for rent payment, and $28 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.)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

Advanced Accounting

Authors: Joe Hoyle, Thomas Schaefer, Timothy Doupnik

10th edition

0-07-794127-6, 978-0-07-79412, 978-0077431808

Students also viewed these Accounting questions