Question

Thank you alot in advance. ??

Problem 7-05A a-b (Part Level Submission) (Video) The bank portion of the bank reconciliation for Cullumber Company at October 31, 2020, is shown below. Cullumber Company Bank Reconciliation October 31, 2020 Cash balance per bank Add: Deposits in transit $12,167.90 1,330.20 13,498.10 13,43 Less: Outstanding checks Check Number 245 2470 2471 2472 2451 Check Amount $ 1,060.40 484.20 644.50 226.80 1,050.00 2474 3,465.90 $10,032.20 Adjusted cash balance per bank

Answer 1

BC $ 18,082.50 $ 2,104.00 $ 20,186.50 А Cullumber Company Bank Reconciliation November 30, 2020 4 Cash balance per bank statement 5 Add: Deposit in transit 6 7 Less: outstanding checks 8 Check no:2451 Check no:2472 Check no:2478 Check no:2482 Check no:2484 Check no:2485 14 Check no:2487 15 Check no:2488 16 17 Adjusted cash balance per bank 18 19 Cash balance as per books 20 Add: 21 Electric fund transfer received 22 23 Less: 24 Check printing charge 25 Error in recording check no: 2479 ($1,550-$1,505) 26 Error in Deposit ($2,854-$2,845) $ 1,060.40 $ 226.80 $ 488.20 $ 562.00 $ 779.50 $ 924.80 $ 348.00 $ 750.00 $ 5,139.70 $ 15,046.80 $ 12,973.80 $ 2,192.00 $ 15,165.80 $ $ $ 65.00 45.00 9.00 27 $ 119.00 $ 15,046.80 28 Adjusted cash balance as per books

B Cullumber Company Bank Reconciliation 3 November 30, 2020 4 Cash balance per bank statement 5 Add: Deposit in transit 18082.5 2104 =+C4+C5 7 Less: outstanding checks Check no:2451 Check no:2472 Check no:2478 Check no:2482 Check no:2484 Check no:2485 Check no:2487 15 Check no:2488 1060.4 226.8 488.2 562 779.5 924.8 348 750 =SUMB8:B15) =+C6-C16 17 Adjusted cash balance per bank 12973.8 2192 =+C19+C21 19 Cash balance as per books 20 Add: 21 Electric fund transfer received 22 23 Less: 24 Check printing charge 25 Error in recording check no: 2479 ($1,550-$1,505) 26 Error in Deposit ($2,854-$2,845) 27 28 Adjusted cash balance as per books 65 =1550-1505 =2854-2845 =SUM(B24:B26) =+C22-C27