Profit & Loss Calculator for Rental Property

Описание: Use this Excel & Google Sheets to calculate a Profit & Loss Statement and Balance Sheet for the year and easily file your Schedule-E for your rental property. This tool is free when you become a client.

Instructions to use the calculator in 4 easy steps:

Step 1: If you will use Google Sheets, the link is provided within the file. To begin using the calculator make a copy of the Google Sheets. Go to File-Make a copy.

Step 2: Go to the month of financial activity you want to record.

Step 3: In column B, enter type of payment, for most it will be “Check” $ goes out or “Deposit” $ goes in.

Step 4: In columns C-F, enter the date, description, account = income or expense account name from the “Total” tab, and most importantly the amount - enter as negative for expenses.

Do not edit the cells in the “Total” tab. Those are all formulas