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).	2020 2021 2022 2023 2024 2025 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
4		Accounts Receivable, beginning of year
5		Allowance for Doubtful Accounts, 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 2024 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