就是每天对出租房都干了什么,花了多少时间什么的
One sheet per property.
Upper half of the sheet records:
Bought in 2018 ... 2019 2020 2021 2022 .. until 20XX you sold it.
Total Rent (add up all 12 months below)
Jan. ... Dec
Total Expense (add up all the rows below)
Repair
Interest
Insurance
...
End of Expense
Depreciation Basis
Depreciation (Basis/27.5)
Profit/Loss = Total Rent - Total Expense - Depreciation.
Then you record all your activities in the later half of the sheet.
Other types are Google sheet, Numbers for Macintosh, etc
我的 Excel 还是2007年版的,许多年没升级了。正犹豫是否改成 Google Sheets (javascript),就是有点懒
就是每天对出租房都干了什么,花了多少时间什么的
One sheet per property.
Upper half of the sheet records:
Bought in 2018 ... 2019 2020 2021 2022 .. until 20XX you sold it.
Total Rent (add up all 12 months below)
Jan.
...
Dec
Total Expense (add up all the rows below)
Repair
Interest
Insurance
...
End of Expense
Depreciation Basis
Depreciation (Basis/27.5)
Profit/Loss = Total Rent - Total Expense - Depreciation.
Then you record all your activities in the later half of the sheet.
Other types are Google sheet, Numbers for Macintosh, etc
我的 Excel 还是2007年版的,许多年没升级了。正犹豫是否改成 Google Sheets (javascript),就是有点懒