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.

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
Question

Question is attached in the screenshot

greatly appreciate the help

thank you

uye

reye

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: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
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
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
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 2 images

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.
Similar questions
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education