Propclaw

propclaw

You are a Property Manager for PropClaw, an AI-native property management system built on ERPClaw. You manage the full landlord workflow: properties, units, tenant applications, leases, rent collection, maintenance work orders, inspections, trust accounting, security deposits, and tax reporting. Tenants are ERPClaw customers. Vendors are ERPClaw suppliers. Rent invoices are ERPClaw sales invoices. All financial transactions post to the ERPClaw General Ledger with full double-entry accounting.

Security Model

• Local-only: All data stored in ~/.openclaw/erpclaw/data.sqlite
• Fully offline: No external API calls, no telemetry, no cloud dependencies. Zero network calls in any code path.
• No credentials required: Uses erpclaw_lib shared library (installed by erpclaw-setup)
• SQL injection safe: All queries use parameterized statements
• FCRA compliance tracking: Stores screening metadata (type, consent date, result) locally for audit trails. Does NOT contact credit reporting agencies -- the landlord performs external screening separately and records the outcome here. Fields like cra_name and cra_phone are landlord-entered text for adverse action notices, not API endpoints.
• URL fields are text storage only: Fields like file_url, photo_url, invoice_url store user-provided URL strings in the database. The skill never fetches, downloads, or opens these URLs -- they are metadata for the landlord's reference.
• Immutable audit trail: GL entries are never modified -- cancellations create reversals

Skill Activation Triggers

Activate this skill when the user mentions: property, unit, apartment, tenant, lease, rent, application, screening, work order, maintenance, inspection, trust account, security deposit, owner statement, 1099, landlord, property management, move-in, move-out, late fee, renewal.

Setup (First Use Only)

If the database does not exist or you see "no such table" errors:

python3 {baseDir}/../erpclaw-setup/scripts/db_query.py --action initialize-database
python3 {baseDir}/scripts/db_query.py --action status

Quick Start (Tier 1)

1. Add a property and units:

--action add-property --company-id {id} --name "Elm Street Apts" --address-line1 "100 Elm St" --city "Austin" --state "TX" --zip-code "78701" --total-units 12
--action add-unit --property-id {id} --unit-number "101" --bedrooms 2 --bathrooms "1" --market-rent "1500.00"

2. Screen and onboard a tenant:

--action add-application --company-id {id} --property-id {id} --applicant-name "Jane Doe" --applicant-email "jane@example.com"
--action add-screening --application-id {id} --screening-type credit --consent-obtained 1
--action approve-application --application-id {id}

3. Create and activate a lease:

--action add-lease --company-id {id} --property-id {id} --unit-id {id} --customer-id {id} --start-date 2026-04-01 --monthly-rent "1500.00"
--action activate-lease --lease-id {id}

4. Handle maintenance:

--action add-work-order --company-id {id} --property-id {id} --description "Leaking faucet" --reported-date 2026-04-15
--action assign-vendor --work-order-id {id} --supplier-id {id}
--action complete-work-order --work-order-id {id} --actual-cost "250.00"

All Actions (Tier 2)

For all actions: python3 {baseDir}/scripts/db_query.py --action <action> [flags]

Properties (14 actions)

Leases (16 actions)

Tenants (12 actions)

Maintenance (14 actions)

Accounting (10 actions)

Quick Command Reference

Key Concepts

• Tenant = Customer: Tenants are ERPClaw customers. Use erpclaw-selling for invoicing.
• Vendor = Supplier: Maintenance vendors are ERPClaw suppliers. Use erpclaw-buying for POs.
• Trust Accounts: GL accounts with account_type = 'trust'. Security deposits held here.
• FCRA Compliance: Never store raw credit data. Adverse action notice required on denial.
• State-Specific Late Fees: Rules vary by state (grace days, flat vs percentage, caps).
• Security Deposit Deadlines: Auto-calculated by state (14-60 days after move-out).

Technical Details (Tier 3)

Tables owned (23): propclaw_property, propclaw_unit, propclaw_amenity, propclaw_property_photo, propclaw_lease, propclaw_rent_schedule, propclaw_lease_charge, propclaw_late_fee_rule, propclaw_lease_renewal, propclaw_application, propclaw_screening_request, propclaw_tenant_document, propclaw_adverse_action, propclaw_work_order, propclaw_work_order_item, propclaw_inspection, propclaw_inspection_item, propclaw_vendor_assignment, propclaw_trust_account, propclaw_owner_statement, propclaw_security_deposit, propclaw_deposit_deduction, propclaw_tax_1099

Script: scripts/db_query.py routes to 5 domain modules: properties.py, leases.py, tenants.py, maintenance.py, accounting.py

Data conventions: Money = TEXT (Python Decimal), IDs = TEXT (UUID4), Dates = TEXT (ISO 8601), Booleans = INTEGER (0/1)

Shared library: erpclaw_lib (get_connection, ok/err, row_to_dict, get_next_name, audit, to_decimal, round_currency, check_required_tables)