Question
The December cash records of Buffy Insurance follow: Data table Cash Receipts Cash Payments Date Cash Debit Check No. Cash Credit Dec. 4 $4,200 1416
The December cash records of Buffy Insurance follow:
Data table
Cash Receipts | Cash Payments | ||
Date | Cash Debit | Check No. | Cash Credit |
Dec. 4 | $4,200 | 1416 | $790 |
9 | 450 | 1417 | 150 |
14 | 510 | 1418 | 710 |
17 | 2,000 | 1419 | 1,190 |
31 | 1,880 | 1420 | 1,460 |
|
| 1421 | 1,300 |
|
| 1422 | 580 |
Buffy's Cash account shows a balance of $16,760 at December 31. On December 31,Buffy Insurance received the following bank statement:
Data table
Bank Statement for December | ||||||
Beginning Balance |
|
| $13,900 | |||
Deposits and other Credits: |
|
|
| |||
| Dec. | 1 |
| EFT | $500 |
|
| Dec. | 5 |
|
| 4,200 |
|
| Dec. | 10 |
|
| 450 |
|
| Dec. | 15 |
|
| 510 |
|
| Dec. | 18 |
|
| 2,000 |
|
| Dec. | 22 |
| BC | 1,800 | 9,460 |
Checks and other Debits: |
|
|
| |||
| Dec. | 8 | NSF | 500 |
| |
| Dec. | 11 | (check no. 1416) | 790 |
| |
| Dec. | 19 |
| EFT | 930 |
|
| Dec. | 22 | (check no. 1417) | 150 |
| |
| Dec. | 29 | (check no. 1418) | 710 |
| |
| Dec. | 31 | (check no. 1419) |
| 1,910 |
|
| Dec. | 31 |
| SC | 10 | (5,000) |
Ending Balance |
|
| $18,360 | |||
Explanations: BC-bank collection; EFT-electronic funds transfer; | ||||||
NSF-nonsufficient funds checks; SC-service charge |
December bank statement.)
Additional data for the bank reconciliation follow:
More info
a. | The EFT credit was a receipt of rent. The EFT debit was an insurance payment. |
b. | The NSF check was received from a customer. |
c. | The $1,800 bank collection was for a note receivable. |
d. | The correct amount of check no. 1419, for rent expense, is $1,910. Buffy's controller mistakenly recorded the check for $1,190. |
Part 1
Requirement 1. Prepare the bank reconciliation of Buffy Insurance at December 31, 2024. Prepare the bank portion of the reconciliation, followed by the book portion of the reconciliation.
Buffy Insurance | |||||
Bank Reconciliation | |||||
December 31, 2024 | |||||
Bank: |
|
| |||
Balance, December 31, 2024 |
| 16,760 | |||
ADD: |
|
|
| ||
|
|
|
| ||
LESS: |
|
|
| ||
|
|
|
| ||
|
|
|
| ||
|
|
|
| ||
|
|
|
Part 2
Books: |
|
| |
|
|
| |
ADD: |
|
|
|
|
|
|
|
|
|
|
|
LESS: |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Part 3
Requirement 2. Journalize any required entries from the bank reconciliation. (Record debits first, then credits. Select the explanation on the last line of the journal entry table.)
Begin with the EFT collection.
Date | Accounts and Explanation | Debit | Credit | ||
Dec. 31 |
|
|
| ||
|
|
|
| ||
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Part 4
Journalize the collection of the note.
Date | Accounts and Explanation | Debit | Credit | ||
Dec. 31 |
|
|
| ||
|
|
|
| ||
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Part 5
Journalize the NSF check.
Date | Accounts and Explanation | Debit | Credit | ||
Dec. 31 |
|
|
| ||
|
|
|
| ||
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Part 6
Journalize the EFT payment.
Date | Accounts and Explanation | Debit | Credit | ||
Dec. 31 |
|
|
| ||
|
|
|
| ||
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Part 7
Journalize the service charge.
Date | Accounts and Explanation | Debit | Credit | ||
Dec. 31 |
|
|
| ||
|
|
|
| ||
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Part 8
Journalize the entry to correct the error.
Date | Accounts and Explanation | Debit | Credit | ||
Dec. 31 |
|
|
| ||
|
|
|
| ||
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
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