Question
Bank reconciliation The accounting records for Springsteen, Inc. show the following information for February 28, 2015: Date Amount Number Date Amount Balance Feb. 1 $
Bank reconciliation
The accounting records for Springsteen, Inc. show the following information for February 28, 2015:
| Date | Amount |
| Number | Date | Amount |
Balance | Feb. 1 | $ 8,510 | Checks: | 343 | Feb. 2 | 4,100 |
Receipts |
| 10,600 |
| 344 | Feb. 4 | 1,800 |
Payments |
| (11,300) |
| 345 | Feb. 11 | 2,100 |
Balance | Feb. 28 | 7,810 |
| 346 | Feb. 12 | 1,200 |
|
|
|
| 347 | Feb. 18 | 300 |
|
|
|
| 348 | Feb. 26 | 400 |
Deposits: | Feb. 4 | $ 1,200 |
| 349 | Feb. 28 | 1,400 |
| Feb. 11 | 1,200 |
|
|
| $11,300 |
| Feb. 18 | 2,700 |
|
|
|
|
| Feb. 25 | 3,400 |
|
|
|
|
| Feb. 26 | 700 |
|
|
|
|
| Feb. 27 | 200 |
|
|
|
|
| Feb. 28 | 1,200 |
|
|
|
|
|
| $10,600 |
|
|
|
|
Additional information pertaining to this checking account was obtained by comparing the monthly bank statement with the company's records. The following was revealed:
1. | The ending cash balance per the bank statement was $7,960. |
2. | Total deposits of $2,100 from February 26-28 are in transit. |
3. | Checks 347 and 349 are outstanding. |
4. | An $100 NSF check from a customer did not clear the bank. This NSF check was included in the February 25th deposit. |
5. | Check #343 was prepared correctly as a $1,400 payment on account. This check was properly recorded by the bank, but was erroneously included on the company's records in the amount of $4,100. |
6. | A debit memo for $2,000 was shown on the bank statement as notice that the company's rent was automatically paid from the checking account on February 1st. |
7. | A credit memo for $15 was shown on the bank statement as notice that the company had earned interest on its average daily balance in this checking account. |
8. | The bank's fees for the month totaled $65. |
Prepare a bank reconciliation to calculate the adjusted cash balance for Springsteen's checking account at February 28, 2015.
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