Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The adjusted cash balance per bank agreed with the cash balance per books at October 31. The November bank statement showed the following: WILDHORSE COMPANY

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed
The adjusted cash balance per bank agreed with the cash balance per books at October 31. The November bank statement showed the following: WILDHORSE COMPANY Bank Statement November 30, 2021 Cheques and Other Debits Date Number Amount Deposits Amount Oct. 31 $11,945 Nov. 3 2470 $980 $1,530 12,495 4 2471 907 11,588 5 2475 1,641 1,215 11,162 6 2474 1,010 10,152 7 2476 2,910 990 8,232 10 2477 600 7,632 13 2,575 10,207 14 2479 1,750 8,457 18 2480 1,330 1,440 8,567 21 1,833 10,400 25 NSF 260 2,567 12,707 26 2481 695 12,012 27 1,650 13,662 28 2486 900 EFT 2,490 15,252 28 2483 575 1,186 15,863 30 LN 2,250 13,613 Additional information from the bank statement:Additional information from the bank statement: 1. The EFT of $2,490 is an electronic transfer from a customer in payment of its account. The amount includes $60 of interest that Wildhorse Company had not previously accrued. 2. The NSF for $260 is a $245 cheque from a customer, Pendray Holdings, in payment of its account, plus a $15 processing fee. The company's 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 $250 interest and $2,000 principal. 4. At November 30, the cash balance per books was $9,257. The bank did not make any errors. The cash records per books for November follow. Two errors were made by Wildhorse Company. Cash Payments Date Number Amount Date Number Amount Nov. 3 2475 $1,641 Nov. 18 2482 $608 3 2476 2,190 20 2483 575 4 2477 600 21 2484 841 6 2478 556 24 2485 1,027 8 2479 1,750 26 2486 900 10 2480 1,330 28 2487 1,130 14 2481 695 Total $13,843Cash Receipts Date Amount Nov. 3 $1,215 7 990 12 2,575 17 1,440 20 1,388 24 2,567 27 1,650 28 1,186 30 1,377 Total $14,388 Prepare a bank reconciliation at November 30. (List items that increase balance as per bank & books first.) WILDHORSE COMPANY Bank Reconciliation November 30, 2021 V\fPrepare the necessary adjusting entries at November 30. (Note: The correction of any errors in the recording of cheques should be made to Accounts Payable. The correction of any errors in the recording of cash receipts should be made to Accounts Receivable.) (Credit account titles are automatically indented when the amount is entered. Do not indent manually. If no entry is required, select "No Entry" for the account titles and enter O for the amounts.) Date Account Titles and Explanation Debit Credit Nov. 30 (To record receipt from customer & interest earned & to correct error) Nov. 30 V (To record NSF cheque and other cash payments)The bank portion of the bank reconciliation for Wildhorse Company at October 31, 2021, was as follows: WILDHORSE COMPANY Bank Reconciliation October 31, 2021 Cash balance per bank $11,945 Add: Deposits in transit 1,530 13,475 Less: Outstanding cheques #2451 $1,400 #2470 980 #2471 907 #2472 466 #2474 1,010 4,763 Adjusted cash balance per bank $8,712 The adjusted cash balance per bank agreed with the cash balance per books at October 31. The November bank statement showed the following

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Financial Numbers Game

Authors: Charles W Mulford, Eugene E Comiskey

1st Edition

0471770736, 9780471770732

More Books

Students also viewed these Accounting questions

Question

Subjective norms, i.e. the norms of the target group

Answered: 1 week ago