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 October 3q. The November bank statement showed the following checks and deposits.

image text in transcribed

The adjusted cash balance per bank agreed with the cash balance per books October 3q. The November bank statement showed the following checks and deposits.

image text in transcribed

The cash record per books for November showed the following

image text in transcribed

At November 30, the cash balance per books was $11,833.40 and the cash balance per bank statement was $18,364.10. The bank did not make any errors, but Wildhorse Co. made two errors.

Using the steps in the reconciliation procedure, prepare a bank reconciliation at November 30, 2022. (List items that increase balance as per bank and books first. Round answers to 2 decimal places, e.g. 5,275. 50.)

image text in transcribed

image text in transcribed

The bank portion of the bank reconciliation for Wildhorse Co. at October 31, 2022, is shown below. WILDHORSE CO. Bank Reconciliation October 31, 2022 Cash balance per bank $12,677.90 Add: Deposits in transit 1,530.20 14,208.10 Less: Outstanding checks Check Number Check Amount 2451 $ 1,260.40 2470 684.20 2471 844.50 2472 427.80 2474 1,050.00 4,266.90 Adjusted cash balance per bank $9,941.20 Bank Statement Checks Deposits Date Number Amount Date Amount 11-1 2470 $ 684.20 11-1 $1,530,20 11-2 2471 844.50 11-4 1,211.60 11-5 2474 1,050.00 11-8 990.10 11-4 2475 1,640.70 11-13 2,575.00 11-8 2476 2,830.00 11-18 1,472.70 11-10 2477 600.00 11-19 EFT 2,447.00 11-15 2479 1,740.00 11-21 2,945.00 11-18 2480 1,330.00 11-25 2,567.30 11-27 2481 695.40 11-28 1,650.00 11-28 SC 91.50 11-30 1,186.00 11-30 2483 575.50 Total 18,574.90 11-29 2486 940.00 Total $13,021.80 Cash Payments Journal Cash Receipts Journal Date Number Amount Date Number Amount Date Amount 11-1 2475 $1,640.70 11-20 2483 $ 575.50 11-3 $1,211.60 11-2 2476 2,830.00 11-22 2484 823.00 11-7 990.10 11-2 2477 600.00 11-23 2485 974.80 11-12 2,575.00 11-4 2478 538.20 11-24 2486 940.00 11-17 1,472.70 11-8 2479 1,704.00 -11-29 2487 398.00 11-20 2,954.00 11-10 2480 1,330.00 11-30 2488 800.00 11-24 2,567.30 11-15 2481 695.40 Total $14,461.60 11-27 1,650.00 11-18 2482 612.00 11-29 1.186.00 11-30 1,614.00 Total 16,220.70 The bank statement contained two bank memoranda: 1. Acredit of $2,447.00 for the collection from a customer for Wildhorse Co. of an electronic funds transfer. 2 A debit for the printing of additional company checks $91.50, WILDHORSE CO. Bank Reconciliation $ $ > > 0/- $ ta $ GA 4 > > > > > >

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_2

Step: 3

blur-text-image_3

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 New Yellow Book Government Auditing Standards

Authors: Rebecca A. Meyer

1st Edition

1119784638, 978-1119784630

More Books

Students also viewed these Accounting questions