Question
The cash balance per books for Sunland Company on November 30, 2022, is $10,451.12. The following checks and receipts were recorded for the month of
The cash balance per books for Sunland Company on November 30, 2022, is $10,451.12. The following checks and receipts were recorded for the month of December 2022:
Checks | Receipts | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
No. | Amount | No. | Amount | Amount | Date | ||||||
17 | $377.58 | 22 | $598.03 | $863.05 | 12/5 | ||||||
18 | 580.81 | 23 | 1,706.69 | 960.73 | 12/21 | ||||||
19 | 176.00 | 24 | 940.49 | 827.77 | 12/27 | ||||||
20 | 606.69 | 25 | 265.22 | 1,386.00 | 12/31 | ||||||
21 | 253.34 |
In addition, the bank statement for the month of December is presented below:
Balance | Deposits and Credits | Checks and Debits | Balance | |||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Last Statement | No. | Total Amount | No. | Total Amount | This Statements | |||||||||||||||||||||
$5,424.03 | 5 | $9,597.55 | 10 | $3,651.38 | $11,370.20 | |||||||||||||||||||||
Checks and other debits | Deposits | Date | Balance | |||||||||||||||||||||||
No | Amount | No | Amount | No | Amount | |||||||||||||||||||||
14 | 167.48 | 17 | 377.58 | 22 | 598.03 | 5,503.57 | 12/1 | $9,894.32 | ||||||||||||||||||
18 | 508.81 | 24 | 940.49 | 863.05 | 12/8 | $9,238.22 | ||||||||||||||||||||
19 | 176.00 | 25 | 265.22 | 960.73 | 12/23 | $9,560.77 | ||||||||||||||||||||
21 | 253.34 | 34.00 | SC | 827.77 | 12/29 | $10,120.20 | ||||||||||||||||||||
269.00 | NSF | 1,690.00 | CM | 12/31 | $11,370.20 | |||||||||||||||||||||
Symbols: NSF (Not sufficient funds) SC (Service charge) CM (Credit Memo) |
Check No. 18 was incorrectly written for $580.81 for a payment on account. Check No. 14 was the only outstanding check at the end of November. There was also one deposit in transit at the end of November. The NSF check was from S. Lewis, a customer, in settlement of an account receivable. An entry has not been made for the NSF check. The credit memo is for the collection of a note receivable including interest of $79.00 that has not been accrued. The bank service charge is $34.00.
(a) Prepare a bank reconciliation at December 31. (Enter answers to 2 decimal places, e.g. 25.20.)
(b) Prepare the adjusting journal entries required by the bank reconciliation. (Credit account titles are automatically indented when the amount is entered. Do not indent manually. Enter answers to 2 decimal places, e.g. 25.20.)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started