Commercial Property Management Spreadsheet with Automatic CAM Distribution, Excel & Google Sheets

Automatic CAM Distribution • Tenant Statements • Reconciliation

This easy-to-use Commercial Property Management Spreadsheet is built specifically for Commercial Property Managers and Landlords who want accurate bookkeeping, transparent CAM billing, and professional reporting—without expensive software or a steep learning curve.

Designed to manage multiple offices within a commercial building, this spreadsheet automatically calculates CAM charges based on tenant square footage, supports both fixed and variable CAM, and generates clear tenant statements so everyone knows exactly what’s due—every month.

Compatible with Microsoft Excel and Google Sheets, this tool lets you get started immediately.

What’s Included

• Set up for 20 offices / tenants in one commercial building

• Customization available based on your property configuration
  (Nominal customization fee depending on number of properties)

Key Features

Simple Setup & Ease of Use

• No learning curve

• No complicated chart of accounts

• Start recording income and expenses immediately

Tenant & Property Management

• Separate tab for each office / tenant

• Property tab to store rent, lease dates, renewals, deposits, rent increases, COI, and notes

• Automatic Rent Roll with all key rental details

• Security deposit tracking

• Automatic balance-due tracking per tenant

• Automatic rent increases by percentage or flat amount

• Rent increases triggered automatically on dates you set

• Rent receipt included

CAM & Expense Management

• Automatic CAM Distribution based on tenant square footage

• Supports CAM, NNN, and non-CAM expenses (clearly separated)

• Monthly & Quarterly Tenant CAM Statements

• Automatic CAM Reconciliation showing Budget vs Actual variance

• Easy income & expense tracking

• 10 income categories & 20 expense categories (fully customizable)

Dashboards & Reporting

• Main Dashboard summarizing and comparing Income & Expenses

  • By month (all properties)

  • By individual property

  • Drill-down by categories

• Visual graphs for quick insights

• Automatic Owner Reports

• Automatic Property & Tenant Reports

• Owner payout tracking

Vendors, Compliance & Operations

• Vendor list with up to 50 vendors (auto drop-down in expense entry)

• Store vendor contact details in one place

• Automatic Certificate of Insurance (COI) tracking per tenant

• Taxes Due dashboard with automatic color-coded alerts

• Insurance Due dashboard with automatic color-coded alerts

• Maintenance request tracking

• Maintenance schedule checklist for all properties

FREE BONUS

Rent Due Date Tracker — included at no additional cost

Instant Download & Support

• Download instantly and start using right away

• Includes:

  • Excel version

  • Google Sheets version

  • Step-by-step PDF instructions

  • Sample Excel file with example data

• Google Sheets requires only a free Google account

• Friendly support available if you have questions

VIDEO of the Commercial Property Manager's Spreadsheet

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.