The bank portion of the bank reconciliation for Ivanhoe Company at October 31, 2017, is shown below. IVANHOE COMPANY Bank Reconciliation October 31, 2017 Cash balance per bank $12,497.90 Add: Deposits in transit 1,530.20 14,028.10 Less: Outstanding checks Check Number Check Amount 2451 $ 1,260.40 684.20 2470 2471 844.50 2472 435.75 2474 1,050.00 4,274.85 $9,753.25 Adjusted cash balance per bank The adjusted cash balance per bank agreed with the cash balance per books at October 31. The November bank statement showed the following checks and deposits. Bank Statement Checks Deposits Date 11-1 Amount $684.20 Date 11-1 Amount $1,530.20 11-2 844.50 11-4 1.211.60 1,050.00 11-8 990.10 Number 2470 2471 2474 2475 2476 2477 2479 2480 2481 2483 2486 11-5 11-4 11-8 11-10 11-15 11-18 11-27 11-30 11-29 2,575.00 1.472.70 2,945.00 1,640.70 2,830.00 600.00 1,720.00 1,330.00 695.40 575.50 11-13 11-18 11-21 11-25 11-28 11-30 Total 2,567.30 1,650.00 1,186.00 16,127.90 940.00 Total $12.910.30 The cash records per books for November showed the following. Cash Payments Journal Cash Receipts Journal Date Date 11-1 11-2 Amount $575.50 820.55 Amount $ 1.211.60 11-3 11-7 990.10 974.80 11-12 Number 2483 2484 2485 2486 2487 2488 11-2 11-4 2.575.00 Number 2475 2476 2477 2478 2479 2480 2481 Amount Date $1.640.70 11-20 2,830.00 11-22 600.00 11-23 538.20 11-24 1.702.00 11-29 1,330.00 11-30 695.40 Total 11-17 940.00 398.00 800.00 1,472.70 2.954.00 11-8 11-20 11-24 11-27 11-10 11-15 2,567.30 $14.457.15 1.650.00 11-18 2482 612.00 11-29 1.186.00 11-30 1,434.00 Total $16,040.70 The bank statement contained two bank memoranda: 1. Acredit of $2,357.00 for the collection for Ivanhoe Company of an electronic funds transfer. 2. A debit for the printing of additional company checks $93.95. At November 30, the cash balance per books was $11,336.80 and the cash balance per bank statement was $17.978.55. The bank did not make any errors, but Ivanhoe Company made two errors. Using the steps in the reconciliation procedure prepare a bank reconciliation at November 30, 2017. (List items that increase balance as per bank and books first.) IVANHOE COMPANY Bank Reconciliation November 30, 2017 Cash balance per bank statement $ 17978.55 Add : Deposits in transit 19412.55 Outstanding checks No. 2451 1260.40 1 No. 2472 435.75 1 No. 2478 538.20 i No.2482 612 1 No. 2484 820.55 1 No. 2485 974.80 1 No. 2487 398 1 No. 24887 800 D 5889.701 13572.25 Adjusted cash balance per bank $ 13572.85 Cash balance per books 11336.80 Add : Electronic funds transfer recelved 13693.80 Check printing charge 93.95 1 Error in recording check 18 1 Error in deposit 120.95 Adjusted cash balance per books 13572.85 Prepare the adjusting entries based on the reconciliation. (Note: The correction of any errors pertaining to recording checks should be made to Accounts Payable. The correction of any errors relating to recording cash receipts should be made to Accounts Receivable.) (Credit account titles are automatically indented when amount is entered. Do not indent manually.) Date Account Titles and Explanation Debit Credit Nov 30 (To record electronic funds transfer received by bank) Nov 30 (To record charge for printing company checks) Nov 30 (To correct error in recording check) Nov 30 (To correct error in deposit)