Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Spicy Potato Company's cash T-account shows the following information: Date Cash Description Amount Date 01-Dec Balance 180,000 05-Dec Deposit 9,000 16-Dec Deposit 15,000 31-Dec Deposit

image text in transcribed
image text in transcribed
Spicy Potato Company's cash T-account shows the following information: Date Cash Description Amount Date 01-Dec Balance 180,000 05-Dec Deposit 9,000 16-Dec Deposit 15,000 31-Dec Deposit 20,000 Description 02-Dec Cheque #910 06-Dec Cheque #905 14-Dec Cheque #917 15-Dec Cheque #911 29-Dec Cheque #920 30-Dec Cheque #921 31-Dec Cheque #922 Amount 16,000 2,000 12,000 9,000 8,000 35,000 14,500 31-Dec 127,500 The following information comes from the company's bank statement: Deposits Balance Date Description (Withdrawals) le. Running Total 01-Dec Opening balance $ 180,000 $ 180,000 02-Dec Cheque #910 16,000 164,000 05-Dec Deposit 9,000 173,000 06-Dec NSF cheque 5,000 168,000 06-Dec Cheque #905 20,000 148,000 14-Dec Cheque 1917 12.000 136,000 15-Dec Chegue 911 9 000 127.000 The following information comes from the company's bank statement: Deposits Balance Date Description (Withdrawals) ie. Running Total 01-Dec Opening balance $ 180,000 $ 180,000 02-Dec Cheque #910 16,000 164,000 05-Dec Deposit 9,000 173,000 06-Dec NSF cheque 5,000 168,000 06-Dec Cheque #905 20,000 148,000 14-Dec Cheque #917 12,000 136,000 15-Dec Cheque #911 9,000 127,000 15-Dec EFT Collection 25,000 152,000 16-Dec EFT Payment 1,200 150,800 16-Dec Deposit 15,000 165,800 29-Dec Cheque #920 8,000 157,800 31-Dec Bank charges 10 157,790 31-Dec Interest 157,795 31-Dec Ending balance S 157,795 - Additional information: a. The correct amount of Cheque #905, a payment on account was $20,000. The company's bookkeeper made an error b. The EFT payment was for monthly maintenance costs. The EFT collection was for consulting work the company previously billed. d. The NSF cheque was from a client named A. Hamilton REQUIRED: Based on the information above, prepare a bank reconciliation NO LOURNAL ENTRICS ARE REQUIRED

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

Accounting and auditing research tools and strategies

Authors: Thomas Weirich, Thomas Pearson, Natalie Tatiana

8th edition

9781118806487, 1118027078, 1118806484, 978-1118027073

More Books

Students also viewed these Accounting questions