Spreadsheet: phillip_allen__28816__rentroll_915
Sheet: Receipts

 | Budget |  |  |  |  |  | Week 1 |  |  |  |  |  |  | Week 2 |  |  |  |  |  | Week 3 |  |  |  |  |  | Week 4 |  |  |  |  |  |  |  | WEEK 5
Unit |  | Weekly | Bi-Weekly | Monthly |  | Due | Fwd. Bal. | Date Pd. | 1st Dep | 2nd Dep | Late Charge | Notes | Fwd. Bal | Date Pd. | 1st Dep. | 2nd Dep. | Late Charge | Notes | Fwd. Bal. | Date Pd. | 1st Dep | 2nd Dep | Late Charge | Notes | Fwd. Bal | Date Pd. | 1st Dep | 2nd Dep | Late charge | Notes | Fwd. Bal | DatePd. | 1st Dep. | 2nd Dep. | Late Charge | Notes | Fwd. Bal.
1 |  | 100 |  |  |  | 3/10/17/24/31 |  | 2000-03-03 00:00:00 | 100 |  |  |  |  | 2000-03-10 00:00:00 | 100 |  |  |  |  | 2000-03-17 00:00:00 | 100 |  |  |  |  | 2000-03-24 00:00:00 | 105 |  |  | paid key charge |  | 2000-03-31 00:00:00 | 100
2 |  | 110 |  |  |  |  | <10> |  |  |  | 10+2 a day |  | 122 | V |  |  |  | moved 3/11/00 |  | V |  |  |  | install h/c unit |  | V |  |  |  |  |  | V
3 |  | 110 |  |  |  | 3/10/17/24/31 |  | 2000-03-03 00:00:00 | 110 |  |  |  |  | 2000-03-10 00:00:00 | 110 |  |  |  |  | 2000-03-15 00:00:00 | 110 |  |  |  |  | 2000-03-24 00:00:00 | 110 |  |  |  |  | 2000-03-30 00:00:00 | 110
4 |  |  |  | 330 |  | 3 |  | 2000-03-03 00:00:00 | 0 |  |  | due 4/2 |  | 2000-03-10 00:00:00 | 0 |  |  | due 4/2 |  | 2000-03-17 00:00:00 | 0 |  |  | due 4/2 |  | 2000-03-27 00:00:00 | 330 |  |  | paid until 5/1 |  | 2000-03-31 00:00:00 | 0
5 |  | 100 |  |  |  | 1931-03-17 00:00:00 | 50 | 2000-03-02 00:00:00 | 200 |  |  |  | 50 | 2000-03-10 00:00:00 | 0 |  |  |  | 50 | 2000-03-15 00:00:00 | 200 |  |  |  | 50 | 2000-03-24 00:00:00 | 0 |  |  |  | 50 | 2000-03-31 00:00:00 | 200 |  |  |  | <50>
6 |  |  | 240 |  |  | 3/17/31 |  | 2000-03-03 00:00:00 | 240 |  |  |  | <120> | 2000-03-10 00:00:00 | 0 |  |  |  |  | 2000-03-17 00:00:00 | 240 |  |  |  | <120> | 2000-03-24 00:00:00 | 0 |  |  |  |  | 2000-03-31 00:00:00 | 240 |  |  |  | <120>
7 |  | Mgr |  |  |  | n/a |  | 2000-03-03 00:00:00 | 0 |  |  |  |  | 2000-03-10 00:00:00 | 0 |  |  |  |  | 2000-03-17 00:00:00 | 0 |  |  |  |  | 2000-03-24 00:00:00 | 0 |  |  |  |  | 2000-03-31 00:00:00 | 0
8 |  |  |  | 480 |  | 4 |  | 2000-03-02 00:00:00 | 480 |  |  |  |  | 2000-03-10 00:00:00 | 0 |  |  |  |  | 2000-03-17 00:00:00 | 0 |  |  |  |  | 2000-03-24 00:00:00 | 0
9 |  | 100 |  |  |  |  |  | 2000-03-02 00:00:00 | 100 |  |  |  |  | 2000-03-10 00:00:00 | 100 |  |  |  |  | 2000-03-17 00:00:00 | 100 |  |  |  |  | V |  |  |  | moved 3/23 |  | V
10 |  | 110 |  |  |  | 3/10/17/24/31 |  | 2000-03-03 00:00:00 | 110 |  |  |  |  | 2000-03-10 00:00:00 | 110 |  |  |  |  | 2000-03-17 00:00:00 | 110 |  |  |  |  | 2000-03-24 00:00:00 | 110
11 |  |  | 200 |  |  | 10/24 | <15> | 2000-03-03 00:00:00 | 0 |  |  |  | <15> | 2000-03-10 00:00:00 | 200 |  |  |  | <115> | 2000-03-17 00:00:00 | 0 |  |  |  | <15> | 2000-03-24 00:00:00 | 200 |  |  |  | <100> | 2000-03-31 00:00:00 | 0
12 |  | 100 |  |  |  | 3/10/17/24/31 | <10> | 2000-03-04 00:00:00 | 100 |  |  | 10 latecharge |  | 2000-03-10 00:00:00 | 100 |  |  |  |  | 2000-03-17 00:00:00 | 100 |  |  |  |  | 2000-03-24 00:00:00 | 100
13 |  |  |  | 480 |  |  | elec. 25 | 2000-03-06 00:00:00 |  | 25 |  |  |  |  |  |  |  |  |  | V |  |  |  | moved 3-22-00 |  | V |  |  |  |  |  | V
14 |  | 95 |  |  |  | 3/10/17/24/31 |  | 2000-03-01 00:00:00 | 95 |  |  |  |  | 2000-03-09 00:00:00 | 95 |  |  |  |  | 2000-03-16 00:00:00 | 95 |  |  |  |  | 2000-03-24 00:00:00 | 95 |  |  |  |  | 2000-03-31 00:00:00 |  |  | 10+2 a day |  | 117
15 |  |  | 190 |  |  | 3/17/31 |  | 2000-03-03 00:00:00 | 190 |  |  |  | <95> | 2000-03-10 00:00:00 | 0 |  |  |  |  | 2000-03-17 00:00:00 | 190 |  |  |  | <95> | 2000-03-24 00:00:00 | 0
16 |  | 100 |  |  |  | 3/10/17/24/31 |  | 2000-03-09 00:00:00 |  | 100 |  |  |  | 2000-03-16 00:00:00 |  | 100 |  |  |  | 2000-03-15 00:00:00 |  | 100 |  |  | 100 | 2000-03-24 00:00:00 | 100 |  |  |  |  | 2000-03-31 00:00:00 | 200 |  |  |  | <100>
17 |  | 100 |  |  |  | 3/10/17/24/31 |  | 2000-03-02 00:00:00 | 100 |  |  |  |  | 2000-03-10 00:00:00 | 100 |  |  |  |  | 2000-03-22 00:00:00 |  | 122 |  | lt. Charge paid |  | 2000-03-30 00:00:00 |  | 322 |  | 122 late charge | <200> | 2000-03-31 00:00:00 | 0 |  |  |  | <100>
18 |  |  | 200 |  |  | 1931-03-17 00:00:00 |  | 2000-03-03 00:00:00 | 200 |  |  |  | <100> | 2000-03-10 00:00:00 | 0 |  |  |  |  |  | 200 |  |  |  | <100> | 2000-03-27 00:00:00 | 0 | 200 |  |  | <200> | 2000-03-31 00:00:00 | 0 |  |  |  | <100>
19 |  |  |  | 460 |  |  |  | V |  |  |  |  |  | V |  |  |  |  |  | V |  |  |  |  |  |  |  |  |  |  |  | V
20 |  | 105 |  |  |  | 3/10/17/24/31 |  | 2000-03-03 00:00:00 | 105 |  |  |  |  | 2000-03-10 00:00:00 | 105 |  |  |  |  | 2000-03-17 00:00:00 | 105 |  |  |  |  | 2000-03-24 00:00:00 | 105 |  |  |  |  | 2000-03-31 00:00:00 | 105
21 |  | 105 |  |  |  | 3/10/17/24/31 |  | 2000-03-03 00:00:00 | 105 |  |  |  |  | 2000-03-10 00:00:00 | 105 |  |  |  |  | 2000-03-17 00:00:00 | 105 |  |  |  |  | 2000-03-24 00:00:00 | 105 |  |  |  |  | 2000-03-31 00:00:00 | 105
22 |  | 100 |  |  |  | 3/10/17/24/31 |  | V |  | 15 |  | app. Fee |  | V |  |  |  |  |  | 2000-03-17 00:00:00 | 115 |  |  | Sec. Dep. On 3/23 | 175 | 2000-03-24 00:00:00 | 275 |  |  |  |  |  |  |  | 10+2 a day
23 |  | 100 |  |  |  | 3/10/17/24/31 |  | 2000-03-03 00:00:00 | 100 |  |  |  |  | 2000-03-10 00:00:00 | 100 |  |  |  |  | 2000-03-17 00:00:00 | 100 |  |  |  |  | 2000-03-24 00:00:00 | 100 |  |  |  |  | 2000-03-31 00:00:00 | 100
24 |  | Maint |  |  |  | n/a |  | 2000-03-03 00:00:00 | 0 |  |  |  |  | 2000-03-10 00:00:00 | 0 |  |  |  |  | 2000-03-17 00:00:00 | 0 |  |  |  |  | 2000-03-24 00:00:00 | 0 |  |  |  |  | 2000-03-31 00:00:00 | 0
25 |  | 100 |  |  |  | 4/11/18/25/1 |  | 2000-03-04 00:00:00 | 100 |  |  |  |  | 2000-03-11 00:00:00 | 100 |  |  |  |  | 2000-03-18 00:00:00 | 100 |  |  |  |  | 2000-03-25 00:00:00 | 100
26 |  | 115 |  |  |  | 3/10/17/24/31 |  | 2000-03-03 00:00:00 | 115 |  |  |  |  | 2000-03-10 00:00:00 | 115 |  |  |  |  | 2000-03-17 00:00:00 | 115 |  |  |  |  | 2000-03-24 00:00:00 | 115 |  |  |  |  | 2000-03-31 00:00:00 | 115
27 |  | 125 |  |  |  |  |  | V |  |  |  |  |  | V |  | 15 |  | app. Fee |  | V |  | 30 |  | 2 app. Fees |  | V |  | 15 |  | app. Fee |  | V
28 |  | 115 |  |  |  | 3/10/17/24/31 |  | 2000-03-03 00:00:00 | 115 |  |  |  |  | 2000-03-10 00:00:00 | 115 |  |  |  |  | 2000-03-17 00:00:00 | 115 |  |  |  |  | 2000-03-30 00:00:00 |  |  | 10+2 a day | 3-day vacate 3/29 | 137
29 |  | 115 |  |  |  | 3/10/17/24/31 |  | 2000-03-03 00:00:00 | 115 |  |  |  |  | 2000-03-10 00:00:00 | 115 |  |  |  |  | 2000-03-17 00:00:00 | 115 |  |  |  |  | 2000-03-24 00:00:00 | 115 |  |  |  |  | 2000-03-31 00:00:00 | 115
30 |  |  |  | 400 |  | 17 | 100 |  |  |  |  |  | 100 | 2000-03-15 00:00:00 |  | 400 |  |  | 100 |  |  |  |  |  | 100 | 2000-03-24 00:00:00 | 100 |  |  |  |  | 2000-03-31 00:00:00 | 0
31 |  |  |  | 420 |  | 1 |  | 2000-03-03 00:00:00 | 0 |  |  |  |  | 2000-03-10 00:00:00 | 0 |  |  |  |  | 2000-03-17 00:00:00 | 0 |  |  |  |  | 2000-03-24 00:00:00 | 0
32 |  | 100 |  |  |  | 3/10/17/24/31 |  | 2000-03-03 00:00:00 | 100 |  |  |  |  | 2000-03-10 00:00:00 | 100 |  |  |  |  | 2000-03-17 00:00:00 | 100 |  |  |  |  | 2000-03-24 00:00:00 | 100 |  |  |  |  | 2000-03-31 00:00:00 | 100
33 |  | 105 |  |  |  | 3/10/17/24/31 |  | 2000-03-03 00:00:00 | 105 |  |  |  |  | 2000-03-10 00:00:00 | 210 |  |  |  | <105> | 2000-03-17 00:00:00 | 0 |  |  |  |  | 2000-03-24 00:00:00 | 105
34 |  | 110 |  |  |  | 3/10/17/24/31 |  | 2000-03-03 00:00:00 | 110 |  |  |  |  | 2000-03-10 00:00:00 | 110 |  |  |  |  | 2000-03-17 00:00:00 | 110 |  |  |  |  | 2000-03-24 00:00:00 | 110 |  |  |  |  | 2000-03-31 00:00:00 | 110
35 |  | 110 |  |  |  | 3/10/17/24/31 |  | 2000-03-03 00:00:00 | 110 |  |  |  |  | 2000-03-10 00:00:00 | 110 |  |  |  |  | 2000-03-17 00:00:00 | 110 |  |  |  |  | 2000-03-24 00:00:00 | 110 |  |  |  |  | 2000-03-31 00:00:00 | 110
36 |  |  | 250 |  |  | 10/24 |  | 2000-03-03 00:00:00 | 0 |  |  |  |  | 2000-03-10 00:00:00 | 250 |  |  | move-out 4/9/00 | <125> | 2000-03-17 00:00:00 | 0 |  |  |  |  | 2000-03-24 00:00:00 | 250 |  |  |  | <125> | 2000-03-31 00:00:00 | 0
37 |  | 115 |  |  |  | 3/10/17/24/31 |  | 2000-03-03 00:00:00 | 120 |  |  | $5 key charge |  | 2000-03-10 00:00:00 | 115 |  |  |  |  | 2000-03-17 00:00:00 | 115 |  |  |  |  | 2000-03-24 00:00:00 | 115 |  |  |  |  | 2000-03-31 00:00:00 | 115
38 |  | 130 |  |  |  | 3/10/17/24/31 |  | 2000-03-03 00:00:00 | 130 |  |  |  |  | 2000-03-10 00:00:00 | 130 |  |  |  |  | 2000-03-16 00:00:00 | 130 |  |  |  |  | 2000-03-24 00:00:00 | 130 |  |  |  |  | 2000-03-31 00:00:00 | 130
39 |  | 120 |  |  |  | 4/11/18/25/1 |  | 2000-03-04 00:00:00 | 105 |  |  |  |  | 2000-03-10 00:00:00 | 105 |  |  | rent inc.3/17/00 |  | 2000-03-17 00:00:00 | 120 |  |  |  |  | 2000-03-30 00:00:00 |  |  | 10+2 a day | will pay on 3/31 | 142 | 2000-03-31 00:00:00 | 247 |  |  |  | 15
40 |  | 130 |  |  |  | 1931-03-17 00:00:00 |  | 2000-03-06 00:00:00 |  | 260 |  |  | <130> | 2000-03-10 00:00:00 | 0 |  |  |  |  | 2000-03-20 00:00:00 |  | 260 |  |  | <130> | 2000-03-24 00:00:00 | 0
41 |  |  |  | 550 |  | 27 |  | 2000-03-03 00:00:00 | 0 |  |  |  |  | 2000-03-10 00:00:00 | 0 |  |  |  |  | 2000-03-17 00:00:00 | 0 |  |  |  |  | 2000-03-24 00:00:00 | 550 |  |  |  |  | 2000-03-31 00:00:00 | 0
42 |  | 120 |  |  |  | 3/10/17/24/31 |  | 2000-03-02 00:00:00 | 120 |  |  |  |  | 2000-03-10 00:00:00 | 120 |  |  |  |  | 2000-03-17 00:00:00 | 120 |  |  |  |  | 2000-03-25 00:00:00 | 120 |  |  |  |  | 2000-03-31 00:00:00 | 120
43 |  | 120 |  |  |  | 3/10/17/24/31 |  | 2000-03-03 00:00:00 | 120 |  |  |  |  | 2000-03-10 00:00:00 | 120 |  |  |  |  | 2000-03-16 00:00:00 | 120 |  |  |  |  | 2000-03-23 00:00:00 | 120 |  |  |  |  | 2000-03-31 00:00:00 |  |  | 10+2 a day |  | 142
44 |  |  | 270 |  |  | 1931-03-17 00:00:00 |  | 2000-03-03 00:00:00 | 200 |  | 10+2 a day |  | 92 |  |  |  |  |  | 106 | 2000-03-17 00:00:00 | 310 |  | 12 |  | 72 | 2000-03-24 00:00:00 |  |  |  | move out not. 4/24 | 94 | 2000-03-31 00:00:00 | 300 |  | 10+2 a day |  | 64
 | Cantu bal. #23 |  |  |  |  |  | 809.2 | 2000-03-03 00:00:00 | 30 |  |  |  | 779.2 |  |  |  |  |  | 779.2 |  |  |  |  | report for collection
 | Pay Phone |  |  |  |  |  |  | 2000-03-03 00:00:00 | 26.4
Expected Income
Periods/Month |  | 4 | 2 | 1
Total
Monthly Total
Less Vacancies |  |  |  | -1360
Expected Receipts
 | Week 1 | Week 2 | Week 3 | Week 4 | Week 5 | Total
Actual Received
1st Dep
2nd Dep
Total