Using Google Sheets to share Triple Net (NNN) Expenses

Google Sheets provides an accessible platform for sharing triple net (NNN) expense details with tenants. Transparent expense communication reduces disputes and strengthens landlord-tenant relationships through clear documentation.

#Creating Your Expense Spreadsheet

Start Simple:

1. Open Google Sheets
2. Create new spreadsheet
3. Title it clearly: "Triple Net Expenses for [Property Name]"

Organize Columns:

• Expense Category (property taxes, insurance, CAM, utilities, etc.)
• Amount
• Due Date
• Notes or Documentation Reference

Structure for Clarity: Separate different expense categories into different sheets within the same spreadsheet. Group related expenses together for easy reference.

#Adding Expense Data

Input All Shared Expenses:

• Property taxes (with assessment details)
• Insurance premiums (policy years and coverage types)
• Common area maintenance (CAM) costs
• Utilities and services
• Other shared operating expenses

Include Critical Information:

• Exact amount due per tenant
• Payment due date
• Prior year comparisons (where relevant)
• Allocated basis (percentage share, square footage, etc.)

#Sharing Your Spreadsheet

Grant Access:

1. Click Share button (top right)
2. Enter tenant email addresses
3. Select viewing or editing permissions as appropriate
4. Add optional message explaining the spreadsheet purpose and any payment instructions

Permission Levels:

• View Only: Tenants see expense details without editing capability (recommended)
• Editing: Tenants can add notes or questions directly in the sheet

Professional Communication: Include a brief message explaining the shared document purpose, payment procedures, and how tenants should address questions or disputes.

#Best Practices for Expense Sharing

Update Regularly: Refresh expense data quarterly or annually to maintain current information and demonstrate transparency.

Document Sources: Link expense documentation or include references where tenants can verify amounts (tax assessments, insurance declarations, etc.).

Establish Clear Terms: Include in your NNN lease which expenses are tenant-paid and your method for calculating individual tenant shares.

Address Questions Promptly: Monitor shared spreadsheet comments and respond quickly to tenant inquiries about expense allocations.

Archive Historical Records: Keep prior years' expense sheets accessible for audit and reference purposes.

#Bottom Line

Transparent NNN expense sharing via Google Sheets reduces friction and disputes. Clear documentation strengthens tenant confidence in expense allocation and demonstrates professional financial management. Simple, accessible expense sharing supports positive tenant relationships.