Prepare a Bank Reconciliation JUSTQUESTIONANSWERONLY

p4-47a.xls

Sheet1

Problem 4-47A					Name
					Section
A	B	C	D	E	F	G	H
5	Sharp Company
6	Bank Reconciliation
7	May 31
8	Bank:
9	Balance, May 31						Amount
10	Add:
11	Deposit in transit						Amount
12							$ - 0
13
14	Less:
15	Total outstanding checks						Amount
16	Correct (adjusted) bank balance, May 31						$ - 0
17
18	Books:
19	Balance, May 31						Amount
20	Add:
21	Title						Amount
22	Title						Amount
23	Deduct:
24	Title						Amount
25	Title						Amount
26	Title						Amount
27	Correct (adjusted) book balance, May 31						$ - 0
28
29	Assets =		Liabilities +		Shareholders' Equity
30					Contributed capital	+ Retained earnings
31	(100.00)	cash				(100.00)	bank fees
32
33
34
35
36
37
38
39
40
	End of Problem

&LReimers, Financial Accounting 3e

CyberCoach: This amount must equal the Adjusted book balance in cell H27. Otherwise, you have not reconciled.

CyberCoach: This amount must equal the Adjusted bank balance in cell H16. Otherwise, you have not reconciled.

CyberCoach: Enter amounts as a positive number in cells H24, H25, and H26 .