Question

How do we solve this?

Workshop 3 Problems Student Q Search Sheet Home Insert , Xcut Copy Page Layout Formulas Data Review Calibri (Body) - 12 - A- A = = BI U DA = View = der Σ AutoSum' ΑΘ, Ep Wrap Text General $ % Paste = Format Merge & Center ) 0 .00 Conditional Format Formatting as Table Cell Styles Insert Delete Format Clear Sort & Filter G24 K L M N O P Q R S T U V W X fx | A B C D E FE H I J 1 3.6 Perform a Bank Reconciliation Points: 12 items @ 2 pts. Each = 24 points. 2 Directions: Complete the bank reconciliation bellow based on the following information 3 NSF Checks returned were $5,200, outstanding checks were $25,820.52, Service charges were $31.13 Customer note collection was $53,101.11, deposit in transit was $9,245.89 and interest earnings were $3,953.00 Ending balance per bank statement $ 144,223.99 Add: Deduct True Cash Balance $ 144,223.99 Ending company balance per company records $75,826.38 Add: 0.00 Deduct: True Cash Balance $75,826.38 Helpful Resources Bank Recon Video 1 Bank Recon Video 2 Bank Recon Video 3 Problem 3.1 Problem 3.2 Problem 3.3 Problem 3.4 Problem 3.5 Problem 3.6 + Ready @ - - - + 100%

Answer 1

ending balance per bank statement - $ 104,223.99 9, 245.89 25,820 57 Addi Deposit in transit 153,469.88 25,820.52 les: - outstanding checks. Adjusted balance as per Bank 127,649.36 Ending balance as per company records. - $75,826.38 Addi customee note collection - $53,101.11 Interest earnings - 3,953.00 57,054.11 132,880.49 Deduct NSF checks returned service charges 31.13 Adjusted balances per Books $5,200 $231-13 127,649.36

If you have any doubts please comment on the answer