Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Prepare the bank reconciliation on excel at September 30th. The information below relates to the Cash account in the ledger of Redding Company (16 points)

Prepare the bank reconciliation on excel at September 30th.
image text in transcribed
The information below relates to the Cash account in the ledger of Redding Company (16 points) Balance September 1-$35,725; Cash deposited$86,000. Balance September 30-$32,225; Checks written-$89,500. The September bank statement shows a balance of $35,375 on September 30 and the following memoranda Credits Collection of $5,250 note plus interest $50 Interest earned on checking account $5,300 $80 Debits NSF check: J. E. Hoover Safety deposit box rent $935 $175 At September 30, deposits in transit were $5,695, and outstanding checks totaled $4,575. Instructions Prepare the bank reconciliation at September 30

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

Consolidated Financial Reporting

Authors: Paul Taylor

1st Edition

1853962503, 9781853962509

More Books

Students also viewed these Accounting questions

Question

=+What category does this metric represent?

Answered: 1 week ago