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

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

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

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
  • SEE MORE 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