Rental Income and Expense Worksheet
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
ABCDEFGHIJKLMNOPQRS
1
2
Year:2019Gross Income:$5,105.00Total Expenses:$4,125.00Net Income:$980.00Deposits:$2,150.00
3
4
Property CodeProperty Address/Unit #Rent Amt.Tenant NamePhoneMove-In DateRenewal date
5
A123 Oak Street, #123$1,500John Doe(555) 555-55551/1/192/1/20
6
B567 Street Road$1,250Bob Roberts(555) 555-55551/18/192/18/20
7
C890 Lake Blvd. E, #456$1,780Jennifer Jane(555) 555-55551/29/197/29/19
8
D555 Road Ave. NW$1,400Sarah Lee(555) 555-55552/11/1912/11/19
9
E000 Zero St. S, #000$1,950Mark Marcus(555) 555-55552/19/195/19/19
10
11
12
Security DepositsABCDETotal
13
DateAmountDateAmountDateAmountDateAmountDateAmount
14
Deposit Received1/1/19$500.001/18/19$200.001/29/19$500.002/11/19$500.002/19/19$300.00$2,000.00
15
Pet Deposit1/1/19$50.002/11/19$100.00$150.00
16
Other:$0.00
17
Total:$550.00$200.00$500.00$600.00$300.00$2,150.00
18
19
20
Rental IncomeABCDETotal
21
DateAmountLate FeeDateAmountLate FeeDateAmountLate FeeDateAmountLate FeeDateAmountLate Fee
22
Jan.2/4/19$1,500.00$50.002/1/19$1,250.00$0.002/2/19$1,780.00$0.00$4,580.00
23
Feb.$0.00
24
Mar.$0.00
25
Apr.$0.00
26
May$0.00
27
Jun.$0.00
28
Jul.$0.00
29
Aug.$0.00
30
Sept.$0.00
31
Oct.$0.00
32
Nov.$0.00
33
Dec.$0.00
34
Total:$1,500.00$50.00$1,250.00$0.00$1,780.00$0.00$0.00$0.00$0.00$0.00$4,580.00
35
36
37
Other IncomeABCDETotal
38
DateAmountDateAmountDateAmountDateAmountDateAmount
39
Laundry2/4/19$5.002/2/19$10.00$15.00
40
Storage2/4/19$10.002/1/19$50.00$60.00
41
Fees (application, etc.)2/1/19$100.00$100.00
42
Parking2/4/19$100.002/2/19$250.00$350.00
43
Other:$0.00
44
$0.00
45
Total:$115.00$150.00$260.00$0.00$0.00$525.00
46
47
48
Monthly ExpensesJan.Feb.Mar.Apr.MayJun.Jul.Aug.Sept.Oct.Nov.Dec.Total
49
Cleaning/Maintenace$20.00$20.00
50
Yard/Snow removal$20.00$20.00
51
Garbage$10.00$10.00
52
Gas$0.00
53
Electricity$0.00
54
Water/Sewer$0.00
55
HOA Dues$200.00$200.00
56
Other:$0.00
57
$0.00
58
Total:$250.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$250.00
59
60
61
Operating ExpensesJan.Feb.Mar.Apr.MayJun.Jul.Aug.Sept.Oct.Nov.Dec.Total
62
Advertising$100.00$100.00
63
Technology Licenses$50.00$50.00
64
Management Fees$100.00$100.00
65
Auto Travel$0.00
66
Telephone$50.00$50.00
67
Professional Services$250.00$250.00
68
Office Supplies$25.00$25.00
69
Wages and Salaries$2,500.00$2,500.00
70
Insurance$400.00$400.00
71
Taxes$100.00$100.00
72
Licenses$300.00$300.00
73
Total:$3,875.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$3,875.00
74
75
76
Other ExpensesABCDETotal
77
DateAmountDescriptionDateAmountDescriptionDateAmountDescriptionDateAmountDescriptionDateAmountDescription
78
Real Estate Taxes$0.00
79
Other taxes: (Specify)$0.00
80
Mortgage Interest$0.00
81
Other Interest$0.00
82
Pest Control$0.00
83
Equipment Purchased$0.00
84
Repairs:$0.00
85
Painting$0.00
86
Plumbing$0.00
87
Electrical$0.00
88
Appliances$0.00
89
Outside Contractors$0.00
90
Other:$0.00
91
$0.00
92
$0.00
93
$0.00
94
Total:$0.00$0.00$0.00$0.00$0.00$0.00
95
Loading...