Commercial Property Manager Spreadsheet Income Expenses CAM NNN Rent Due Taxes Insurance Maintenance Multiple Offices

Commercial property managers will find this spreadsheet extremely useful and easy to use. Ideal for managing multiple commercial properties that are being rented. It is great for bookkeeping and also tracking various due dates.

You can easily record and track Rental Income & Expenses, CAM, NNN, Owner Payouts, Rent Due date, Taxes, Insurance, Vendors and Property Maintenance for all your commercial properties / offices through this spreadsheet.

Extremely easy to use Spreadsheet with very powerful Property Management features. Available in Excel and Google Sheets

This Spreadsheet includes

20 Offices in 1 building

I can customize this for you as per your property configuration. I will request a nominal customization fee depending on the number of properties.

FEATURES

1. Separate tabs for each office / tenant

2. Main Dashboard which summarizes and compares Income & Expenses
- For all properties by month
- For each property
- Summarization & Drill Down by Categories
- Dashboard has CAM and NNN expenses separated
- Graphs

3. 10 Income Categories & 20 Expense Categories that can be fully customized by you.

4. Automatic Balance due tracking for each tenant

5. Automatic Rent Due Date Tracking with color alerts

6. Automatic CAM Calculation and Reconciliation

7. Automatic Rent Increase calculations based on % or amount set by you.

8. A Property Tab where you can record all pertinent information for each of your properties including Rent, Start Date, Renewal Date, Deposit, Rent Increases, COI and notes

9. Automatic Rent Roll

10. A Vendor List with 50 Vendors which becomes an automatic drop down menu in the Expenses Tab.
You can also record all vendor details like contact information etc.

11. Automatic Certificate of Insurance tracking for each tenant

12. A Taxes Due tab which shows with automatic color grading how soon taxes are due for each property.

13. A Insurance Due Tab which shows when Insurance payments are due with automatic color grading.

14. Maintenance Requests tracking

15. A Maintenance Schedule checklist for all properties

16. Track Owner Payouts

17. Automatic Owner Reports that can be sent to Owners.

18. Rent Receipt

VIDEO of the Commercial Property Manager's Spreadsheet

I will be happy to provide support and answer any questions.

You will get both the Google Sheets and Excel versions along with a PDF file with step-by-step instructions.
There will also be an Excel file with sample data as an example.

For Google Sheets, you will only need a free Google account to use it.

Download Instantly and use
This is copyrighted to MoneyUsage.com and is for your own personal use. It cannot be sold, shared or otherwise redistributed.