Real Estate Spreadsheet Template - Free Download
4.1,
2689
votes
Please vote for this template if it helps you.
REAL ESTATE INCOME & EXPENSE WORKSHEET !!!!!!!!!!!!!
YEAR _________________
NAME________________________________________________________________________________________ Federal ID #____________________________
NAME OF BROKER _____________________________________________________________________________________________________________________
ADDRESS OF BUSINESS_____________________________________________________________________________________________________________
How many months was this business in operation during the year 12 Months
❏
OR
From _____ To_____
How many hours during the year did you and/or your spouse devote to this business FULL TIME
❏
OR
# of hours ________
Is any portion of your investment in this business
not
subject to payback by you YES
❏
NO
❏
BUSINESS INCOME
COMMISSIONS
1099 – MISC.
Bring in ALL 1099s received. Include
Non-Employee Amount in Gross Sales.
REFERRAL FEES
Do your records agree YES
❏
with the amount reported NO
❏
RETURNS/REFUNDS
Did you receive $10,000.00 in actual cash from any
OTHER INCOME
individual at any one time—
or in accumulated
amounts—
during this tax year
Sales of Equipment, Machinery, Land, Buildings Held for Business Use
Kind of Property
Date Acquired
Date Sold
Gross Sales Price
Expenses of Sale
Original Cost
CAR and TRUCK EXPENSES
VEHICLE 1
VEHICLE 2
✓ BUSINESS MILES
Year and Make of Vehicle
____
Bank trips
Date Purchased (month, date and year)◊
____
Client meetings
Ending Odometer Reading (December 31)
____
Continuing education
Beginning Odometer Reading (January 1)
–
–
____
Excrow & loan office
Total Miles Driven (End Odo – Begin Odo)
____
Professional meetings
Total Business Miles (do you have another vehicle)
____
Showing property
Total Commuting Miles
____
Viewing property
Parking Fees and Tolls
____
Other
License Plates
Interest
Continue only if you take actual expense (must use actual expense if you lease)
Gas, oil, lube, repairs, tires, batteries, insurance, supplies, wash, wax, etc.
Commuting Miles (to Office)
Lease Costs
