A	B	C	D	E	F
1		INSTRUCTIONS: enter your own data in the gold-shaded cells and then click Recalculate on the toolbar above.
2		Company name
3		Year (the accounting year-end is December 31).	2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 2039 2040 2041 2042 2043 2044 2045 2046 2047 2048 2049 2050 2051 2052 2053 2054 2055 2056
4		Accounts Receivable, beginning of year
5		Allowance for Credit Losses, beginning of year
6		The following transactions took place during the year:
7
8		2) Reinstatement of previously written off accounts receivable. There were no reinstated amounts in the Accounts Receivable at the beginning of the year.
9
10
11
12
13		The allowance method is used. An aging analysis estimates the following amount of the year-end accounts receivable is uncollectible/impaired:
14
15
16		REQUIRED
17
18		Part [2] Prepare a reconciliation for 2027 of (a) the income statement's Sales Revenue less Bad Debts Expense to (b) the Cash Received from Customers.
19
20		© Brian Conheady.	Prepared for educational use.
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55