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: 5 6 7 8 9 10 11 16 17 18 19 22232 20 Bank statement data 21 EFT rent collection Service charge NSF checks Charge for printed checks Ending balance 12 13 In reviewing his cash records, Patrick identifies the following: 14 15 315 10 100 11 $ 710 Deposit in transit Outstanding checks Balance, March 31 Salary check sssss S Cash records data $ 1,775 $ 615 $ 1,865 Recorded Actual amount amount $ 21 S 210 24 Use the blue shaded areas on the ENTERANSWERS tab for inputs. Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the 25 Instructions tab you will be marked wrong.
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: 5 6 7 8 9 10 11 16 17 18 19 22232 20 Bank statement data 21 EFT rent collection Service charge NSF checks Charge for printed checks Ending balance 12 13 In reviewing his cash records, Patrick identifies the following: 14 15 315 10 100 11 $ 710 Deposit in transit Outstanding checks Balance, March 31 Salary check sssss S Cash records data $ 1,775 $ 615 $ 1,865 Recorded Actual amount amount $ 21 S 210 24 Use the blue shaded areas on the ENTERANSWERS tab for inputs. Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the 25 Instructions tab you will be marked wrong.
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
Related questions
Question
Question is attached in the screenshot
greatly appreciate the help
thank you
uye
reye

Transcribed Image Text:E
G
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
2 calculations, if applicable.)
NM4 in 6000
5
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
1775
615
H
I
K
L
M
N
0
P

Transcribed Image Text:A B
1 Internal Control and Cash
2 Use a bank reconciliation
6
7
с
Bank statement data
EFT rent collection
3
4 Skatetown USA's manager Jim Patrick received monthly bank statement at March 31, which shows the following:
5
Service charge
NSF checks
Charge for printed checks
Ending balance
D
ԱԴ ԱԴ ԱԴ
Deposit in transit
Outstanding checks
Balance, March 31
Salary check
$ 315
8
9
10
11
12
13 In reviewing his cash records, Patrick identifies the following:
14
15
16
17
18
19
$
10
$ 100
11
$
$ 710
E
Cash records data
$ 1,775
$ 615
$ 1,865
F
Recorded Actual
amount amount
$ 21 $ 210
G
H
20
21
22
23
24 Use the blue shaded areas on the ENTERANSWERS tab for inputs.
Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the
25 Instructions tab you will be marked wrong.
26
K
L
M
N
Expert Solution

This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 2 images

Knowledge Booster
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


Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,

Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,


Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,

Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,

Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON

Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education

Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education