Assessment: Bank Reconciliation and Adjusting Entries Attempt #1 Note: This exercise is in two steps. Each subsequent step moves to the right on this spreadsheet. The following information pertains to Kelker Corp. Cash balance per bank, December 31, $8,394. The bank service charge for the month is $20. Cash balance per books, December 31, $7,947. The bank erroneously deposited a check for $150 in Kelker's account. The deposit should have gone in a different account. Deposits in transit, December 31, $1,265. Outstanding checks, December 31, $985. The bank collected a $600 note for Kelker Corp. plus $12 interest less $15 fees. Instructions: Step 1. Please prepare a bank reconciliation in proper format based on the above information. Step 2. Prepare the adjusting entries required as a result of the bank reconciliation. Date each entry December 31. Assessment: Bank Reconciliation and Adjusting Entries Attempt #1 Note: This exercise is in two steps. Each subsequent step moves to the right on this spreadsheet. The following information pertains to Kelker Corp. 1. Cash balance per bank, December 31, $8,394. 2. The bank service charge for the month is $20. 3. Cash balance per books, December 31, $7,947. 4. The bank erroneously deposited a check for $150 in Kelker's account. The deposit should have gone in a different account. 5. Deposits in transit, December 31, $1,265. 6. Outstanding checks, December 31, $985. 7. The bank collected a $600 note for Kelker Corp. plus $12 interest less $15 fees. Instructions: Step 1. Please prepare a bank reconciliation in proper format based on the above information. Step 2. Prepare the adjusting entries required as a result of the bank reconciliation. Date each entry December 31. Date General Journal Account Title and Explanation Ref. Debit Credit
Assessment: Bank Reconciliation and Adjusting Entries Attempt #1 Note: This exercise is in two steps. Each subsequent step moves to the right on this spreadsheet. The following information pertains to Kelker Corp. Cash balance per bank, December 31, $8,394. The bank service charge for the month is $20. Cash balance per books, December 31, $7,947. The bank erroneously deposited a check for $150 in Kelker's account. The deposit should have gone in a different account. Deposits in transit, December 31, $1,265. Outstanding checks, December 31, $985. The bank collected a $600 note for Kelker Corp. plus $12 interest less $15 fees. Instructions: Step 1. Please prepare a bank reconciliation in proper format based on the above information. Step 2. Prepare the adjusting entries required as a result of the bank reconciliation. Date each entry December 31. Assessment: Bank Reconciliation and Adjusting Entries Attempt #1 Note: This exercise is in two steps. Each subsequent step moves to the right on this spreadsheet. The following information pertains to Kelker Corp. 1. Cash balance per bank, December 31, $8,394. 2. The bank service charge for the month is $20. 3. Cash balance per books, December 31, $7,947. 4. The bank erroneously deposited a check for $150 in Kelker's account. The deposit should have gone in a different account. 5. Deposits in transit, December 31, $1,265. 6. Outstanding checks, December 31, $985. 7. The bank collected a $600 note for Kelker Corp. plus $12 interest less $15 fees. Instructions: Step 1. Please prepare a bank reconciliation in proper format based on the above information. Step 2. Prepare the adjusting entries required as a result of the bank reconciliation. Date each entry December 31. Date General Journal Account Title and Explanation Ref. Debit Credit
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
Related questions
Question
not use ai please

Transcribed Image Text:Assessment: Bank Reconciliation and Adjusting Entries
Attempt #1
Note: This exercise is in two steps. Each subsequent step moves to the right on this spreadsheet.
The following information pertains to Kelker Corp.
Cash balance per bank, December 31, $8,394.
The bank service charge for the month is $20.
Cash balance per books, December 31, $7,947.
The bank erroneously deposited a check for $150 in Kelker's account. The deposit should have gone in a different
account.
Deposits in transit, December 31, $1,265.
Outstanding checks, December 31, $985.
The bank collected a $600 note for Kelker Corp. plus $12 interest less $15 fees.
Instructions: Step 1. Please prepare a bank reconciliation in proper format based on the above information.
Step 2. Prepare the adjusting entries required as a result of the bank reconciliation.
Date each entry December 31.

Transcribed Image Text:Assessment: Bank Reconciliation and Adjusting Entries
Attempt #1
Note: This exercise is in two steps. Each subsequent step moves to the right on this spreadsheet.
The following information pertains to Kelker Corp.
1. Cash balance per bank, December 31, $8,394.
2.
The bank service charge for the month is $20.
3.
Cash balance per books, December 31, $7,947.
4.
The bank erroneously deposited a check for $150 in Kelker's account. The deposit should have gone in a different account.
5.
Deposits in transit, December 31, $1,265.
6.
Outstanding checks, December 31, $985.
7.
The bank collected a $600 note for Kelker Corp. plus $12 interest less $15 fees.
Instructions: Step 1. Please prepare a bank reconciliation in proper format based on the above information.
Step 2. Prepare the adjusting entries required as a result of the bank reconciliation.
Date each entry December 31.
Date
General Journal
Account Title and Explanation
Ref.
Debit
Credit
Expert Solution

This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps

Recommended textbooks for you


Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,

Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,


Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,

Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,

Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON

Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education

Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education