Homework Help is Here – Start Your Trial Now!
Business
Accounting
E G H 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 NM+I67 3 4 5 BANK: Balance, March 31 B 7 8 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 I J K

E G H 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 NM+I67 3 4 5 BANK: Balance, March 31 B 7 8 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 I J K

Intermediate Accounting: Reporting And Analysis
Intermediate Accounting: Reporting And Analysis
3rd Edition
ISBN:9781337788281
Author:James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher:James M. Wahlen, Jefferson P. Jones, Donald Pagach
Chapter6: Cash And Receivables
Section: Chapter Questions
Problem 11MC
See similar textbooks
icon
Related questions
Question

Questions attachedi n the screenshot below

thanks for the help

aprpeciated

dedwefwe

fwefwf

!!

A B с 1 Internal 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: 456700 2499799 8 9 10 11 14 15 16 17 18 19 Bank statement data 20 21 22 23 EFT rent collection Service charge NSF checks Charge for printed checks Ending balance $ 12 13 In reviewing his cash records, Patrick identifies the following: Deposit in transit Outstanding checks Balance, March 31 Salary check sssss $ $ $ D 315 10 100 11 $ 710 Cash records data $ $ 615 1,775 $ 1,865 E Recorded Actual amount amount 210 $ 21 $ F G H J K
Transcribed Image Text:A B с 1 Internal 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: 456700 2499799 8 9 10 11 14 15 16 17 18 19 Bank statement data 20 21 22 23 EFT rent collection Service charge NSF checks Charge for printed checks Ending balance $ 12 13 In reviewing his cash records, Patrick identifies the following: Deposit in transit Outstanding checks Balance, March 31 Salary check sssss $ $ $ D 315 10 100 11 $ 710 Cash records data $ $ 615 1,775 $ 1,865 E Recorded Actual amount amount 210 $ 21 $ F G H J K
D E F G H 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.) NM 20001 5 6 7 BANK: 8 Balance, March 31 9 Add: 10 Subtotal B 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 I J K
Transcribed Image Text:D E F G H 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.) NM 20001 5 6 7 BANK: 8 Balance, March 31 9 Add: 10 Subtotal B 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 I J K
Expert Solution
steps

Step by step

Solved in 3 steps with 2 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Bank reconciliation statement
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Recommended textbooks for you
Intermediate Accounting: Reporting And Analysis
Intermediate Accounting: Reporting And Analysis
Accounting
ISBN:
9781337788281
Author:
James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher:
Cengage Learning
Cornerstones of Financial Accounting
Cornerstones of Financial Accounting
Accounting
ISBN:
9781337690881
Author:
Jay Rich, Jeff Jones
Publisher:
Cengage Learning
Survey of Accounting (Accounting I)
Survey of Accounting (Accounting I)
Accounting
ISBN:
9781305961883
Author:
Carl Warren
Publisher:
Cengage Learning
Century 21 Accounting Multicolumn Journal
Century 21 Accounting Multicolumn Journal
Accounting
ISBN:
9781337679503
Author:
Gilbertson
Publisher:
Cengage
Century 21 Accounting General Journal
Century 21 Accounting General Journal
Accounting
ISBN:
9781337680059
Author:
Gilbertson
Publisher:
Cengage
Financial Accounting: The Impact on Decision Make…
Financial Accounting: The Impact on Decision Make…
Accounting
ISBN:
9781305654174
Author:
Gary A. Porter, Curtis L. Norton
Publisher:
Cengage Learning
SEE MORE TEXTBOOKS