The bank portion of the bank reconciliation for Sandhill Co. at October 31, 2022, is shown below. SANDHILL CO. Bank Reconciliation October 31, 2022 Cash balance per bank Add: Deposits in transit $12,557.90 1.530.20 14,088.10 Less: Outstanding checks Check Number 2451 2470 2471 2472 2474 Adjusted cash balance per bank Check Amount $ 1.260.40 684.20 844.50 427.80 1,050.00 4,266.90 $9.821.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. Date 11-1 11-2 11-5 11-4 11-8 Checks Number 2470 2471 2474 2475 2476 2477 2479 2480 2481 SC Bank Statement Deposits Amount Date Amount $68420 11-1 $1,530,20 844.50 11-4 1,211.60 1,050.00 11-8 990.10 1.640.70 11-13 2.575.00 2,830,00 11-18 1.472.70 600.00 11.19 EFT 2,387.00 1.730.00 11-21 2,945.00 1,330.00 11-25 2,567.30 695.40 11-28 1,650.00 86.70 11-30 1.186.00 575.50 Total 18,514.90 11-10 11-15 11-18 11-27 11-28 11-30 2483 Date 11-1 11-2 11-5 11-4 11-8 11-10 11-15 11-18 11-27 11-28 Checks Number 2470 2471 2474 2475 2476 2477 2479 2480 2481 SC 2483 Bank Statement Deposits Amount Date Amount $684.20 11-1 $1,530.20 844.50 11-4 1,211.60 1,050.00 11-8 990.10 1.640.70 11-13 2.575.00 2,830.00 11-18 1.472.70 600.00 11-19 EFT 2,387.00 1.730.00 11-21 2.945.00 1,330.00 11-25 2,567.30 695.40 11-28 1.650.00 86.70 11-30 1,186.00 575.50 Total 18,514.90 940.00 $13,007.00 11-30 11-29 2486 Total The cash records per books for November showed the following Date Amount 11-1 Number 2475 2476 2477 11-2 11-2 11-4 Cash Payments Journal Amount Date Number $1.640.70 11-20 2483 2,830.00 11-22 2484 600.00 11-23 2485 538.20 11-24 2486 1.703.00 11-29 2487 1,330.00 11-30 2488 695.40 Total 612.00 $575.50 827.80 974.80 940.00 398.00 800.00 $14,465.40 2478 2479 2480 Cash Receipts Journal Date Amount 11-3 $1,211.60 11-7 990.10 11-12 2.575.00 11-17 1.472.70 11-20 2.954.00 11-24 2,567.30 11-27 1.650.00 11-29 1,186.00 11-30 1.494.00 11-8 11-10 11-15 2481 2482 11-18 Total 16.100.70 Bank Reconcidun November 30, 2022 $ 18.115.50 Cash balance per bank statement 1,494,00 Add Deposits in transit 19.609.50 Outstanding checks 1260,4 i No.2451 427.80 i No, 2472 5392 No. 2478 612 i No. 2482 8278 i No. 2484 974 No. 2485 No. 2485 9748 No. 2487 398 No. 2488 800 5,839.00 i Adjusted cash balance per bank $ 13,770.50 Cash balance per books $ 11,506 20 Add Electronic funds transfer received 2,387 13.893.20 Error in recording check Frenrin nacis > d Error in deposit 9 i Check printing charge 86.7 122.7 1 Adjusted cash balance per books $ 13.770.50 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. Round answers to 2 decimal places, eg. 5,275.50.) Debit Date Account Titles and Explanation Nov 30 Credit To record electronic funds transfer received by bank) I Nov 30 (To record charge for printing company checks) Nov 30 (To record charge for printing company checks) Nov 30 (To correct error in recording check) Nov 30 (To correct error in deposit) List of Accounts Assistance Used Accounts Payable Accounts Receivable Accumulated Depreciation Equipment Bank Charges Expense Cash Cash Over and Short Common Stock Cost of Goods Sold Depreciation Expense Entertainment Expense Equipment Freight-in Freight-Out Income Tax Expense Income Taxes Payable Insurance Expense Interest Receivable Interest Revenue Inventory Miscellaneous Exnence Miscellaneous Expense No Entry Notes Receivable Petty Cash Postage Expense Prepaid Insurance Retained Earnings Salaries and Wages Expense Sales Discounts Sales Revenue Servire Rouentin 5 Sales Discounts Sales Revenue Service Revenue Supplies Supplies Expense Travel Expense Utilities Expense
