Tenant Rent Ledger Template.xlsx

	A	B	C	D	E	F	G
1	Tenant Rent Ledger
2	Rental Address	123 Main Street, Los Angeles		Account	123
3	Tenant Name	Edna Jones		Phone	123-456-7890
4	Owner Name	Dan Brown		Type	WF debit card
5	Lease Date	4/1/2022		Card nº	xxxxxxxxxxxxxxxx
6	Expiration Date	3/31/2023		Year	2023
7	Security deposit held	$2,000.00		Name	Edna Jones
8
9	Date rent / Other fees collected from Tenant	Rent due from Tenant	Late fees / Other due from Tenant	Total amount due	Total bank deposits to management trust account	Payment method	Balance due from Tenant
10	Date rent / Other fees collected from Tenant	$	$	$	$		$
11
12	4/1/2022	$1,500	$50	$1,550	$ 1,500.00	Debit card	$ 50.00
13							$ -
14							$ -
15							$ -
16							$ -
17							$ -
18							$ -
19							$ -
20							$ -
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
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100