PROBLEM 7-4A BANK RECONCILIATION PROBLEM BANK RECONCILIATION AS OF 10/31/22 (BANK SIDE) Balance per Bank @ October 31, 2022 12,367.90 Additions Needed October 31 Deposit in Transit Subtractions Needed Check #2451 Check #2470 Check #2471 Check #2472 Check #2474 TOTALS 1,530.20 (1,260.40) (684.20) (844.50) (426.80) (1,050.00) 9,632.20 INFORMATION PER COMPANY BOOKS (CURRENT MONTH - NOVEMBER) INFORMATION PER BANK STATEMENT - NOVEMBER Beginning of month cash balance 9,632.20 Beginning Balance per Bank 12,367.90 Cash receipts for the month Checks written during the month: CHECKS AND OTHER DEBITS DEPOSITS AND CREDITS Date Amount Check # Date Written Amount Check # Date Amount Date Amount 11/3 1,211.60 2475 11/1 1,640.70 2470 11/1 684.20 11/1 1,530.20 11/7 990.10 2476 11/2 2,830.00 2471 11/2 844.50 11/4 1,211.60 11/12 2,575.00 2477 11/2 600.00 2474 11/8 1,050.00 11/8 990.10 11/17 1,472.70 2478 11/4 538.20 2475 11/4 1,640.70 11/13 2,575.00 11/20 2,954.00 2479 11/8 1,705.00 2476 11/8 2,830.00 11/18 1,472.70 11/24 2,567.30 2480 11/10 1,330.00 2477 11/10 600.00 11/19 2,242.00 11/27 1,650.00 2481 11/15 695.40 2479 11/15 1,750.00 11/21 2,945.00 11/29 1,186.00 2482 11/18 612.00 2480 11/18 1,330.00 11/25 2,567.30 11/30 1,304.00 2483 11/20 575.50 2481 11/27 695.40 11/28 1,650.00 2484 11/22 829.50 2483 11/30 575.50 11/30 1,186.00 2485 11/23 974.80 2486 11/29 940.00 2486 11/24 940.00 DEBIT CARD (NEW CHECKS) 11/30 85.00 2487 11/29 398.00 2488 11/30 800.00 Total Deposits 15,910.70 Total Checks Ending balance per books NOTE: If a discrepency, let's assume bank is always right. COMPANY SIDE (OUR SIDE OF THINGS) Balance per Books Additons Needed Subtractions Needed 14,469.10 Total Checks and Debits 11,073.80 Ending Balance 11,073.80 BANK SIDE OF THINGS Balance per Bank Additional Needed Subtractions Needed TOTALS TOTALS NOTE CHECK FIGURE: $13,176.80 13,025.30 Total Deposits 18,369.90 17,712.50 17,712.50