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
Totals January February March April May June July August September October November December
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
Date Income Category Amount Description
01/01/14 Rent $2,100.00 January Rent
Total Income ###
Mileage Calculator
Expenses Allowable Rate: $0.555
Date Expense Category Amount Description Miles Driven Calculated
01/01/14 Commissions $2,100.00 Realtor Commission $0.00
01/30/14 Repairs $52.82 Replace Kitchen Faucet $0.00
01/30/14 Auto and Travel $7.14 Home Depot 14 $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
Date Income Category Amount Description
02/01/14 Rent $2,100.00 February Rent
Total Income ###
Mileage Calculator
Expenses Allowable Rate: $0.555
Date Expense Category Amount Description Miles Driven Calculated
02/17/14 Repairs $135.66 Repair Rear Screen Door $0.00
02/17/14 Auto and Travel $5.10 Home Depot 14 $7.77
02/19/14 Repairs $60.09 Replace Blinds in Bedroom 1 $0.00
02/19/14 Auto and Travel $5.10 Home Depot 14 $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
Date Income Category Amount Description
03/01/14 Rent $2,100.00 March Rent
Total Income ###
Mileage Calculator
Expenses Allowable Rate: $0.555
Date Expense Category Amount Description Miles Driven Calculated
$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
Date Income Category Amount Description
04/01/14 Rent $2,100.00 April Rent
Total Income $2,100.00
Mileage Calculator
Expenses Allowable Rate: $0.555
Date Expense Category Amount Description Miles Driven Calculated
04/22/14 Repairs $248.00 Plumber 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
Date Income Category Amount Description
05/01/14 Rent $2,100.00 May Rent
Total Income $2,100.00
Mileage Calculator
Expenses Allowable Rate: $0.555
Date Expense Category Amount Description Miles Driven Calculated
05/03/14
Legal and Other Professional F
$200.00 Renew Rental License $0.00
05/03/14 Auto and Travel $19.38 Renew Rental License - City Hall 38 $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
Date Income Category Amount Description
06/01/14 Rent $2,100.00 June Rent
Total Income $2,100.00
Mileage Calculator
Expenses Allowable Rate: $0.555
Date Expense Category Amount Description Miles Driven Calculated
06/17/14 Insurance $548.11 Home 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
Date Income Category Amount Description
07/01/14 Rent $2,100.00 July Rent
Total Income $2,100.00
Mileage Calculator
Expenses Allowable Rate: $0.555
Date Expense Category Amount Description Miles Driven Calculated
07/03/14 Repairs $700.00 Roof, 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
Date Income Category Amount Description
08/01/14 Rent $2,100.00 August Rent
Total Income $2,100.00
Mileage Calculator
Expenses Allowable Rate: $0.555
Date Expense Category Amount Description Miles Driven Calculated
08/09/14 Repairs $14.16 Door Latch Replacement $0.00
08/09/14 Auto and Travel $7.77 Home Depot 14 $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
Date Income Category Amount Description
09/01/14 Rent $2,100.00 September Rent
Total Income $2,100.00
Mileage Calculator
Expenses Allowable Rate: $0.555
Date Expense Category Amount Description Miles Driven Calculated
$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
Date Income Category Amount Description
10/01/14 Rent $2,100.00 October Rent
Total Income $2,100.00
Mileage Calculator
Expenses Allowable Rate: $0.555
Date Expense Category Amount Description Miles Driven Calculated
$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