The December bank statement and cash T-account for Stewart Company follow:   BANK STATEMENT Date Checks Deposits Other Balance Dec. 1               $ 45,600 6 $ 7,600             38,000 11   530 $ 27,000         64,470 17   12,900             51,570 23       35,000         86,570 26   530             86,040 30   17,800   18,000 NSF* $ 280   85,960 31         Interest earned   60   86,020 31         Service charge   130   85,890   * NSF check from J. Left, a customer.   Cash (A) Dec. 1 Balance 45,600           Deposits     Checks written during December: Dec. 11   27,000     7,600     23   35,000     530     30   18,000     12,900     31   12,000     530               130               17,800               4,500     Dec. 31 Balance 93,610              There were no deposits in transit or outstanding checks at November 30.   How would i enter this data in the bank reconcilliation table

Question

The December bank statement and cash T-account for Stewart Company follow:

 

BANK STATEMENT

Date Checks Deposits Other Balance
Dec. 1               $ 45,600
6 $ 7,600             38,000
11   530 $ 27,000         64,470
17   12,900             51,570
23       35,000         86,570
26   530             86,040
30   17,800   18,000 NSF* $ 280   85,960
31         Interest earned   60   86,020
31         Service charge   130   85,890
 

* NSF check from J. Left, a customer.

 

Cash (A)
Dec. 1 Balance 45,600          
Deposits     Checks written during December:
Dec. 11   27,000     7,600    
23   35,000     530    
30   18,000     12,900    
31   12,000     530    
          130    
          17,800    
          4,500    
Dec. 31 Balance 93,610          

  

There were no deposits in transit or outstanding checks at November 30.

 

How would i enter this data in the bank reconcilliation table

Expert Answer

Want to see the step-by-step answer?

Check out a sample Q&A here.

Want to see this answer and more?

Experts are waiting 24/7 to provide step-by-step solutions in as fast as 30 minutes!*

*Response times vary by subject and question complexity. Median response time is 34 minutes and may be longer for new subjects.

Related Accounting Q&A

Find answers to questions asked by student like you

Q: Hi, I'm not sure which values to use because I assumed it would be the difference between the two va...

A: Trading investments: Trading investments refer to the short term investments bought by the company i...

Q: shown is the information needed to prepare a bank reconciliation for Warren Electric at December 31....

A: Bank Reconciliation Statement: Bank statement is prepared by bank. The company maintains its own rec...

Q: At zero direct labor hours in a flexible budget graph, the total budgeted cost line intersects the v...

A: Fixed costs: Fixed costs are those costs which remain unchanged even there is a change in the produc...

Q: If I have a machine that I purchased for $50,000. I'be recorded depreciation of $28,000. I sell the ...

A: Book value of an asset is the Purchase price of the asset less accumulated depreciation. when the ma...

Q: On January 1, 2019, Roosevelt Company purchased 12% bonds having a maturityvalue of $500,000 for $53...

A: Prepare amortization schedule.

Q: Which of the following is not a condition that must be satisfied before interest capitalization can ...

A: Capitalized Interest: Interest is usually paid on the amount borrowed and it is shown as an expense ...

Q: At the beginning of 2018, Thompson Service, Inc., showed the following amounts in the stock-holders'...

A: Prepare journal entry for the given transactions (from January 3 to May 9).

Q: Savallas Company is highly automated and uses computers to control manufacturing operations. The com...

A: Click to see the answer

Q: Miller Toy Company manufactures a plastic swimming pool at its Westwood Plant. The plant has been ex...

A: 1.Material price variance = (budgeted price-actual price)* actual quantity consumed=(5-4.95)*49,200=...