The bank portion of the bank reconciliation for Crane Company at October 31, 2022, is shown below. CRANE COMPANY Bank Reconciliation October 31, 2022 Cash balance per bank Add: Deposits in transit $12,587.90 1,530.20 14.118.10 Less: Outstanding checks Check Number Check Amount $1,260.40 2451 2470 684.20 2471 844.50 2472 427.80 2474 1,050.00 4,266.90 Adjusted cash balance per bank $9,851.20 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 Number Amount Date Amount 11-1 2470 $ 684.20 11-1 $1,530.20 11-2 2471 844.50 11-4 1,211.60 990.10 11-5 2474 1,050.00 11-8 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,402.00 11-15 2479 1,720.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 87.65 11-30 1.186.00 Bank Statement Checks Deposits Date Number Amount Date Amount 11-1 2470 $ 684.20 11-1 11-2 2471 844.50 11-4 $1,530.20 1,211.60 990.10 2.575.00 11-5 2474 1,050.00 11-8 11-4 2475 1,640.70 11-13 11-8 2476 2,830.00 11-18 1.472.70 11-10 2477 600.00 11-19 EFT 2,402.00 11-15 2479 1,720.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 87.65 11-30 1.186.00 11-30 2483 575.50 Total 18.529.90 11-29 2486 940.00 Total $12.997.95 The cash records per books for November showed the following. Cash Receipts Journal Date Number Amount Date Amount Cash Payments Journal Amount Date Number $1,640.70 11-20 2483 2,830.00 11-22 2484 11-1 2475 $575.50 11-3 $1,211.60 11-2 2476 826.85 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,702.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,463.45 11-27 1,650.00 11-18 2482 612.00 11-29 1.186.00 11-30 1.524.00 Total 16,130.70 The bank statement contained two bank memoranda: 1. A credit of $2,402.00 for the collection from a customer for Crane Company of an electronic funds transfer. A debit for the printing of additional company checks $87.65. 2. At November 30, the cash balance per books was $11,584.00 and the cash balance per bank statement was $18,185.40. The bank did not make any errors, but Crane Company made two errors. (a) 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.) CRANE COMPANY Bank Reconciliation Cash balance per bank statement $ Add Deposits in transit Less V Outstanding checks No. 2451 $ No. 2472 Adjusted cash balance per books ZA Add : Deposits in transit Adjusted cash balance per bank $ Adjusted cash balance per books $ Add Cash balance per books Error in deposit Outstanding checks Adjusted cash balance per books Electronic funds transfer received Deposits in transit Check printing charge Error in recording check $ $
