Login

Fillable Printable Rental Income and Expenses Spreadsheet

Fillable Printable Rental Income and Expenses Spreadsheet

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
Login to HandyPDF
Tips: Editig or filling the file you need via PC is much more easier!
By logging in, you indicate that you have read and agree our Terms and Privacy Policy.