Stay Organized. Never Miss a Lease Deadline. Track Every Dollar You Pay.

Managing a commercial lease involves much more than paying monthly rent. CAM (Common Area Maintenance) charges, taxes, insurance, maintenance expenses, lease renewals, rent increases, certificates of insurance, and landlord payments can quickly become overwhelming—especially if you manage multiple locations.

The Commercial Tenant CAM & Lease Expense Tracker gives you one centralized system to organize every expense related to your commercial properties, monitor what you owe, and keep important lease dates from slipping through the cracks.

Whether you lease office space, warehouses, retail locations, medical offices, or other commercial properties, this spreadsheet helps you stay on top of your financial obligations while providing a complete overview of your portfolio.

Perfect For

• Commercial tenants
• Office tenants
• Warehouse businesses
• Retail stores
• Medical and professional offices
• Multi-location businesses
• Franchise owners
• Property and facilities managers

Track Up to 34 Commercial Properties

Manage multiple leased properties from a single workbook.

Each property has its own dedicated worksheet where you can record:

• CAM (Common Area Maintenance) expenses charged by your landlord
• Non-CAM operating expenses you pay directly
• Rent payments
• CAM payments
• Additional landlord fees
• Vendor information
• Payment history
• Outstanding balances

Need more than 34 properties? Custom versions are available.

Record Both CAM and Non-CAM Expenses

Keep a complete record of every expense associated with each leased property.

Examples include:

CAM (Common Area Maintenance) Expenses

• Landscaping
• Parking lot maintenance
• Snow removal
• Security
• Common area utilities
• Building maintenance
• Property management fees
• Common area repairs

Non-CAM Expenses

• Electricity
• Internet
• Telephone
• Office supplies
• Equipment
• Interior repairs
• Cleaning services
• Any custom expense category you choose

All expense categories are fully customizable.

Track Every Payment Made to Your Landlord

Record:

• Monthly rent
• CAM payments
• Late fees
• Other landlord charges
• Payment dates
• Amounts due
• Amounts paid
• Outstanding balances

Instantly see which properties still have balances due.

Automatic Portfolio Dashboard

As you enter information, everything updates automatically.

View your entire portfolio at a glance with:

• Monthly expenses
• Year-to-date expenses
• Total landlord payments
• Monthly payment summaries
• Expense breakdowns by property
• CAM vs Non-CAM expense summaries
• Rent vs CAM vs Other payment summaries
• Property comparison charts
• Year-to-date expense graphs

No manual calculations required.

Automatic Monthly Expense Statements

Generate a monthly summary of expenses for every property automatically.

Quickly review:

• Total monthly expenses
• Expense categories
• Property-by-property totals
• Company-wide expense summaries

Perfect for budgeting, internal reporting, and accounting.

CAM Reconciliation Made Easy

Monitor your CAM (Common Area Maintenance) charges throughout the year.

Compare:

• Budgeted CAM
• Actual CAM paid
• Variances
• True-up adjustments
• Prior-year comparisons

This makes annual CAM reconciliation much easier and helps identify unexpected increases.

Never Miss Important Lease Dates

Built-in color-coded reminders automatically alert you when important lease events are approaching.

Track:

• Lease start dates
• Lease renewal dates
• Rent increase dates
• Certificate of Insurance (COI) renewal dates

Color coding automatically changes:

• Yellow – Upcoming deadline
• Red – Past due

No more forgotten renewals or missed lease milestones.

Automatic Rent Increase Calculator

Simply enter:

• Next rent increase date
• Increase percentage

The spreadsheet automatically calculates:

• New monthly rent
• Increase amount
• Updated payment amount

Perfect for leases with scheduled annual rent increases.

Track Deposits and Lease Information

Store important lease information for every property, including:

• Property address
• Landlord contact information
• Security deposits
• Lease dates
• CAM budgets
• Rent details
• Renewal information

Everything stays organized in one place.

Vendor Management

Maintain a complete vendor directory with:

• Company name
• Contact person
• Phone number
• Email
• Address
• Services provided
• Notes

Vendor names automatically become dropdown lists throughout the spreadsheet for faster data entry.

Taxes Due Tracker

Never miss another tax deadline.

Automatically track:

• Tax due dates
• Tax amounts
• Payments made
• Remaining balances
• Days until due
• Days overdue

Built-in color coding highlights upcoming and overdue tax payments.

Insurance Due Tracker

Stay on top of insurance renewals for every location.

Track:

• Insurance due dates
• Premium amounts
• Payments made
• Outstanding balances
• Days remaining until renewal

Automatic alerts help ensure your policies stay current.

Maintenance Schedule

Keep preventive maintenance organized for every property.

Track recurring maintenance by:

• Quarterly
• Semi-Annual
• Annual

Customize maintenance items to match your business needs.

Maintenance Request Tracker

Manage repair requests from start to finish.

Track:

• Property
• Request date
• Requestor
• Issue description
• Priority level
• Assigned vendor
• Completion date
• Pending work
• Notes

A convenient way to stay on top of repairs across all locations.

Fully Customizable

Customize the spreadsheet to fit your business.

Modify:

• Expense categories
• Payment categories
• Vendor lists
• Maintenance items
• Property information

Need additional properties? We can customize the spreadsheet for your portfolio.

Features

• Supports up to 34 commercial properties
• Automatic dashboard
• CAM reconciliation
• Monthly expense statements
• Balance due tracker
• Lease renewal tracker
• Rent increase tracker
• Certificate of Insurance tracker
• Tax due tracker
• Insurance due tracker
• Vendor management
• Maintenance schedule
• Maintenance request log
• Automatic calculations
• Color-coded reminders
• Fully customizable
• Available for Microsoft Excel and Google Sheets

Why You'll Love It

Instead of juggling multiple spreadsheets, calendars, invoices, and lease documents, you'll have one organized system that tracks your lease obligations, landlord payments, CAM expenses, and important deadlines automatically.

Spend less time searching for information, avoid missed renewals and unexpected charges, and gain a clear picture of what each commercial property is costing your business.

Whether you lease one commercial space or dozens, this spreadsheet helps you stay organized, informed, and in control.

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 Tenant Expense Tracker 

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.