ABCDEFGHIJKLMNOPQRSTUVWXY
1
Instructions to make a copy
2
3
Click File of the Google sheets (not the browser). If it is hidden, click the down arrow (v) to bring it up.
4
Select "Make a copy".
5
Remove "Copy of " from "Name".
6
Select "Folder" to be our shared folder. Click "<" and choose "Shared with me".
7
8
address123 Main Street, Fairfax, VA 22030
9
10
First day you rented or were ready to rent your home in 202501/01/2025
11
Last day you rented your home in 202512/31/2025365
12
First day you own your home in 202501/01/2025
13
Last day you own your home in 202512/31/2025365
14
Percentage of time your home was rented ("Time ratio")1If you rented your home the entire year, it is 100%.
15
16
Exclusively rented area (do not count the shared common area)1000
17
Toral living area1000
18
Percentage of space rented ("Space ratio")1If you rented your entire home, it is 100%.
19
20
Number of tenants who pay rent3
21
Total number of people (tenants and non-tenants) living in the home3
22
Internet / Utilities share ratio ("Use ratio")1If all people living in the home are tenants, it is 100%.
23
24
"Date Place in service" needed when it is an improvement exceeding $2,500
25
26
DELETE ALL SAMPLE DATA LEAVING ONLY YOUR ACTUAL DATA!
27
28
CategoryDescription AmountIs improvement?DateExpense exclusive for rental?Time ratioSpace orRentalPersonal
29
When needed(Increase value)Placed in serviceTime and Space wiseuse ratio
30
Rent received11,111NY1.00001.000011,111
31
Advertising111NY1.00001.0000111
32
Home Owner Association (HOA) fees2,222NY1.00001.00002,222
33
Cleaning and maintence444NY1.00001.0000444
34
Commisions0NY1.00001.00000
35
Gardening556NY1.00001.0000556
36
Home Insurance (it is okay if insurance covers part of next year)1,111NY1.00001.00001,111
37
Private Mortgage Insurance (PMI)NY1.00001.00000
38
Legal and other professional feesNY1.00001.00000
39
Licenses and permitsNY1.00001.00000
40
Management feesNY1.00001.00000
41
Mortgage interest paid to banks11,111NY1.00001.000011,1110
42
Mortgage loan balance (average)For personal/rental mixed only1,234,567NY1.00001.00001,234,5670
43
Other interestsNY1.00001.00000
44
Painting and decorating222NY1.00001.0000222
45
Pest control1,000NY1.00001.00001,000
46
Plumbing and electrical667NY1.00001.0000667
47
Repairs333NY1.00001.0000333
48
Supplies / Appliaces / FurnitureDishwasher556Y10/15/2025Y1.00001.0000556
49
Property Tax6,667NY1.00001.00006,6670
50
Telephone and internetNY1.00001.00000
51
Utilities (if you paid it, not the tenants)778NY1.00001.0000778
52
Wages and salariesNY1.00001.00000
53
Other expense 1Roof5,556Y11/15/2025Y1.00001.00005,556
54
Other expense 2NY1.00001.00000
55
Other expense 3NY1.00001.00000
56
Other expense 4NY1.00001.00000
57
Other expense 5NY1.00001.00000
58
Depreciation (we will calculate, please provide closing doc for first time rental)
Calculated value
59
Amortization (we will calculate, please provide closing doc for first time rental)
Calculated value
60
61
Auto exepenses used for rentalSample
62
Description of vehicle (year, make, model)2013 Nissan Altima
63
Date placed in service01/01/2021
64
Total mileage used in 2025 (personal and business)888
65
Business mileage (Over 50% risks losing county tax relief)111
66
Parking fees and tolls (business portion only)$44
67
Car loan interest$333
68
Personal property tax$222
69
Busines ratio12.50%
70
Business Rate (dollar per mlie)$0.70
71
Mileage deduction$77.70
72
Interest expense (business portion)$42
73
Taxes and licenses (business portion)$28
74
Total car expenses (we will calculate based on the information provided above)
Calculated value$192
75
Personal property taxes (Schedule A)$194
76
77
Net rental income-$20,414
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100