De А B С D E F G H n 1 Interhal Control and Cash 2 Use a bank reconciliation 3 4 Skatetown USA's manager Jim Patrick received monthly bank statement at March 31, which shows the following: 5 Bank statement data 7 EFT rent collection $ 315 8 Service charge $ 10 D 9 NSF checks $ 100 Charge for printed checks 11 11 es Ending balance $ 710 12 6 0 0 re: 10 Oo ha 13 In reviewing his cash records, Patrick identifies the following: 14 15 16 17 18 19 Deposit in transit Outstanding checks Balance, March 31 Cash records data $ $ $ 1,775 615 1,865 20 21 22 Salary check Recorded Actual amount amount S 21 $ 210 23
1 Using a bank reconciliation, determine how much cash Patrick actually has at March 31, 2021. (Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instructions tab you will be marked wrong. Use cell references from prior calculations, if applicable.) 2 3 4 Skatetown USA 5 Bank Reconciliation 6 March 31, 2021 7 BANK: 8 Balance, March 31 9 Add: 10 Subtotal 11 Less: 12 Adjusted bank balance 13 14 BOOKS: 15 Balance, March 31 16 Add: 17 Subtotal 18 Less: 19 20 21 22 23 24 Adjusted book balance 25 26 Patrick's actual cash balance 27 28
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!