Fillable Printable Rental Income and Expenses Spreadsheet
Fillable Printable Rental Income and Expenses Spreadsheet
Rental Income and Expenses Spreadsheet
www.FastBusinessPlans.com
Rental Property Statement
Tax Year:2014
Physical Address (Street, City, State, Zip):1201 Main St., Topeka, KS 66601
Property Type:1 Single Family Residence
TotalsJanuaryFebruaryMarchAprilMayJuneJulyAugustSeptemberOctoberNovemberDecember
Income$25,200.00$2,100.00$2,100.00$2,100.00$2,100.00$2,100.00$2,100.00$2,100.00$2,100.00$2,100.00$2,100.00$2,100.00$2,100.00
Expenses
Advertising$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Auto and Travel$60.03$7.14$10.20$0.00$0.00$19.38$0.00$0.00$7.77$0.00$0.00$15.54$0.00
Cleaning and Maintenance$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Commissions$2,100.00$2,100.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Insurance$548.11$0.00$0.00$0.00$0.00$0.00$548.11$0.00$0.00$0.00$0.00$0.00$0.00
Legal and Other Professional Fees$200.00$0.00$0.00$0.00$0.00$200.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Management Fees$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Mortgage Interest$9,915.96$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$9,915.96
Other Interest$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Repairs$1,623.11$52.82$195.75$0.00$248.00$0.00$0.00$700.00$14.16$0.00$0.00$412.38$0.00
Supplies$20.07$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$20.07$0.00
Taxes$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Utilities$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Depreciation Expense or Depletion$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Other$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Total Expenses$14,467.28$2,159.96$205.95$0.00$248.00$219.38$548.11$700.00$21.93$0.00$0.00$447.99$9,915.96
Net Income$10,732.72-$59.96$1,894.05$2,100.00$1,852.00$1,880.62$1,551.89$1,400.00$2,078.07$2,100.00$2,100.00$1,652.01-$7,815.96
January Rental Income and Expenses
www.FastBusinessPlans.com
Income
DateIncome CategoryAmountDescription
01/01/14Rent$2,100.00January Rent
Total Income###
Mileage Calculator
ExpensesAllowable Rate:$0.555
DateExpense CategoryAmountDescriptionMiles DrivenCalculated
01/01/14Commissions$2,100.00Realtor Commission$0.00
01/30/14Repairs$52.82Replace Kitchen Faucet$0.00
01/30/14Auto and Travel$7.14Home Depot14$7.77
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
Total Expenses###
February Rental Income and Expenses
www.FastBusinessPlans.com
Income
DateIncome CategoryAmountDescription
02/01/14Rent$2,100.00February Rent
Total Income###
Mileage Calculator
ExpensesAllowable Rate:$0.555
DateExpense CategoryAmountDescriptionMiles DrivenCalculated
02/17/14Repairs$135.66Repair Rear Screen Door$0.00
02/17/14Auto and Travel$5.10Home Depot14$7.77
02/19/14Repairs$60.09Replace Blinds in Bedroom 1$0.00
02/19/14Auto and Travel$5.10Home Depot14$7.77
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
Total Expenses$205.95
March Rental Income and Expenses
www.FastBusinessPlans.com
Income
DateIncome CategoryAmountDescription
03/01/14Rent$2,100.00March Rent
Total Income###
Mileage Calculator
ExpensesAllowable Rate:$0.555
DateExpense CategoryAmountDescriptionMiles DrivenCalculated
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
Total Expenses$0.00
April Rental Income and Expenses
www.FastBusinessPlans.com
Income
DateIncome CategoryAmountDescription
04/01/14Rent$2,100.00April Rent
Total Income$2,100.00
Mileage Calculator
ExpensesAllowable Rate:$0.555
DateExpense CategoryAmountDescriptionMiles DrivenCalculated
04/22/14Repairs$248.00Plumber for Bath Drain Backup$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
Total Expenses$248.00
May Rental Income and Expenses
www.FastBusinessPlans.com
Income
DateIncome CategoryAmountDescription
05/01/14Rent$2,100.00May Rent
Total Income$2,100.00
Mileage Calculator
ExpensesAllowable Rate:$0.555
DateExpense CategoryAmountDescriptionMiles DrivenCalculated
05/03/14
Legal and Other Professional F
$200.00Renew Rental License$0.00
05/03/14Auto and Travel$19.38Renew Rental License - City Hall38$21.09
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
Total Expenses$219.38
June Rental Income and Expenses
www.FastBusinessPlans.com
Income
DateIncome CategoryAmountDescription
06/01/14Rent$2,100.00June Rent
Total Income$2,100.00
Mileage Calculator
ExpensesAllowable Rate:$0.555
DateExpense CategoryAmountDescriptionMiles DrivenCalculated
06/17/14Insurance$548.11Home Insurance$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
Total Expenses$548.11
July Rental Income and Expenses
www.FastBusinessPlans.com
Income
DateIncome CategoryAmountDescription
07/01/14Rent$2,100.00July Rent
Total Income$2,100.00
Mileage Calculator
ExpensesAllowable Rate:$0.555
DateExpense CategoryAmountDescriptionMiles DrivenCalculated
07/03/14Repairs$700.00Roof, Gutter, Etc.$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
Total Expenses$700.00
August Rental Income and Expenses
www.FastBusinessPlans.com
Income
DateIncome CategoryAmountDescription
08/01/14Rent$2,100.00August Rent
Total Income$2,100.00
Mileage Calculator
ExpensesAllowable Rate:$0.555
DateExpense CategoryAmountDescriptionMiles DrivenCalculated
08/09/14Repairs$14.16Door Latch Replacement$0.00
08/09/14Auto and Travel$7.77Home Depot14$7.77
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
Total Expenses$21.93
September Rental Income and Expenses
www.FastBusinessPlans.com
Income
DateIncome CategoryAmountDescription
09/01/14Rent$2,100.00September Rent
Total Income$2,100.00
Mileage Calculator
ExpensesAllowable Rate:$0.555
DateExpense CategoryAmountDescriptionMiles DrivenCalculated
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
Total Expenses$0.00
October Rental Income and Expenses
www.FastBusinessPlans.com
Income
DateIncome CategoryAmountDescription
10/01/14Rent$2,100.00October Rent
Total Income$2,100.00
Mileage Calculator
ExpensesAllowable Rate:$0.555
DateExpense CategoryAmountDescriptionMiles DrivenCalculated
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
Total Expenses$0.00
