Answered step by step
Verified Expert Solution
Question
1 Approved Answer
The bank portion of the bank reconciliation for Crane Company at October 31, 2021, was as follows: CRANE COMPANY Bank Reconciliation October 31, 2021 Cash
The bank portion of the bank reconciliation for Crane Company at October 31, 2021, was as follows:
CRANE COMPANY Bank Reconciliation October 31, 2021 | ||||
Cash balance per bank | $11,365 | |||
Add: Deposits in transit | 1,510 | |||
12,875 | ||||
Less: Outstanding cheques | ||||
#2451 | $1,200 | |||
#2470 | 980 | |||
#2471 | 901 | |||
#2472 | 511 | |||
#2474 | 1,090 | 4,682 | ||
Adjusted cash balance per bank | $8,193 |
The adjusted cash balance per bank agreed with the cash balance per books at October 31. The November bank statement showed the following:
CRANE COMPANY Bank Statement November 30, 2021 | ||||||||||||
Cheques and Other Debits | ||||||||||||
Date | Number | Amount | Deposits | Amount | ||||||||
Oct. 31 | $11,365 | |||||||||||
Nov. 3 | 2470 | $980 | $1,510 | 11,895 | ||||||||
4 | 2471 | 901 | 10,994 | |||||||||
5 | 2475 | 1,641 | 1,217 | 10,570 | ||||||||
6 | 2474 | 1,090 | 9,480 | |||||||||
7 | 2476 | 2,910 | 990 | 7,560 | ||||||||
10 | 2477 | 600 | 6,960 | |||||||||
13 | 2,575 | 9,535 | ||||||||||
14 | 2479 | 1,750 | 7,785 | |||||||||
18 | 2480 | 1,330 | 1,518 | 7,973 | ||||||||
21 | 1,722 | 9,695 | ||||||||||
25 | NSF | 230 | 2,567 | 12,032 | ||||||||
26 | 2481 | 695 | 11,337 | |||||||||
27 | 1,650 | 12,987 | ||||||||||
28 | 2486 | 900 | EFT 2,520 | 14,607 | ||||||||
28 | 2483 | 517 | 1,186 | 15,276 | ||||||||
30 | LN | 2,220 | 13,056 |
Additional information from the bank statement:
1. | The EFT of $2,520 is an electronic transfer from a customer in payment of its account. The amount includes $90 of interest that Crane Company had not previously accrued. | |
2. | The NSF for $230 is a $215 cheque from a customer, Pendray Holdings, in payment of its account, plus a $15 processing fee. The companys policy is to pass on all NSF service charges to the customer. | |
3. | The LN is a payment of a note payable with the bank and consists of $220 interest and $2,000 principal. | |
4. | At November 30, the cash balance per books was $8,858. The bank did not make any errors. |
The cash records per books for November follow. Two errors were made by Crane Company.
Cash Payments | |||||||||||||||
Date | Number | Amount | Date | Number | Amount | ||||||||||
Nov. 3 | 2475 | $1,641 | Nov. 18 | 2482 | $624 | ||||||||||
3 | 2476 | 2,190 | 20 | 2483 | 517 | ||||||||||
4 | 2477 | 600 | 21 | 2484 | 847 | ||||||||||
6 | 2478 | 509 | 24 | 2485 | 991 | ||||||||||
8 | 2479 | 1,750 | 26 | 2486 | 900 | ||||||||||
10 | 2480 | 1,330 | 28 | 2487 | 1,100 | ||||||||||
14 | 2481 | 695 | Total | $13,694 |
Cash Receipts | |||
Date | Amount | ||
Nov. 3 | $1,217 | ||
7 | 990 | ||
12 | 2,575 | ||
17 | 1,518 | ||
20 | 1,277 | ||
24 | 2,567 | ||
27 | 1,650 | ||
28 | 1,186 | ||
30 | 1,379 | ||
Total | $14,359 |
|
Prepare a bank reconciliation at November 30. (List items that increase balance as per bank & books first.)
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