Property Management

Commercial Property & Lease Management System

A custom MS Access system replacing spreadsheets for a commercial property manager — unit tracking, CAM/tax billing, and automated invoicing.

Central dashboard for properties, tenants, and invoicing
INDUSTRY
Property Management
BUILT_WITH
Microsoft Access, VBA
ENGAGEMENT
Full System Build
STATUS
Delivered

The project

A commercial property management company was running a growing portfolio of buildings and units through a patchwork of spreadsheets — one for leases, another for CAM (common area maintenance) charges, another for owner statements. Nothing talked to anything else, and every month-end invoicing run meant reconciling numbers by hand across all three.

We built a single MS Access system around their actual workflow: a centralized dashboard for quick access to properties, tenants, leases, invoicing, payments, and reports; full property and unit records (square footage, status, CAM rates, property taxes); and complete owner and tenant profiles with notes and attachments. The core of the system automatically generates monthly rent, CAM, and property tax invoices with accurate totals pulled straight from the lease terms — no more manually recalculating a CAM share every time a unit changes hands.

Payments and tenant ledgers are tracked in the same system, and built-in operational and financial reports export straight to Excel and PDF for owners who still want a familiar spreadsheet view. The result: far less manual reconciliation, fewer billing mistakes, and a clear, centralized view across the whole property portfolio instead of three disconnected files.

Inside the system

SCREEN 01 / 05

Central dashboard for properties, tenants, and invoicing
Central dashboard for properties, tenants, and invoicing

What's in the system

What the finished database does, feature by feature.

  • Centralized dashboard for properties, tenants, leases, invoicing, and payments
  • Property & unit management with CAM rates and property tax tracking
  • Owner and tenant profiles with notes and attachments
  • Automated monthly rent, CAM, and property tax invoicing
  • Payment tracking with clear tenant ledgers
  • Rent increase notices and tenant communication support
  • Built-in reports with Excel and PDF export

Want something like this for your business?

Tell us what you're trying to solve. We'll give you a straight answer on scope and cost.