Works with the AI Agents you already use

    Claude CodeClaude CodeCursorCursorCodex CLICodex CLIDeepSeekDeepSeekMuseMuse+22 more

    rent roll reconciliation

    1

    Reconciles tenant payment records against lease contracts. Classifies variances as matched, overpayment, underpayment, delinquent, or missing payment. Flags exceptions for review. Decision support only.

    $1.99

    Secure checkout via Stripe

    Money-back guarantee

    Converts to your local currency at checkout

    Security scanned
    rent roll reconciliation

    rent roll reconciliation

    Example session with this skill installed

    Reconcile the Jan 2024 rent for Riverside Apts. I have attached the tenant ledger and three lease contracts for units 101, 102, and 103. The reporting currency is USD.

    • Read your context and instructions
    • Compiled the rent roll reconciliation

    The rent roll reconciliation for Riverside Apts for the period of January 2024 is complete. The analysis compares the provided tenant ledger against the three active lease contracts.

    Rent Roll Reconciliation — Riverside Apts, January 2024

    1. Scope, sources and assumptions

    • Sources: Tenant Ledger (E1), Lease Contracts (E2)
    • Period: 2024-01-01 to 2024-01-31
    • Currency: USD
    • Thresholds: Tolerance 1%, Material Threshold 10%

    2. Reconciliation summary

    • Total Expected: $6,500.00
    • Total Received: $5,850.00
    • Net Variance: -$650.00
    • Variance Rate: -10.0%

    3. Discrepancy summary

    • Matched: 1
    • Overpayment: 0
    • Underpayment: 1
    • Delinquent: 1
    • Missing: 0
    • No Lease Found: 0

    4. Exception register

    Tenant IDUnitStatusVarianceNote
    T-002102Underpayment-$150.00Partial payment received
    T-003103Delinquent-$500.00No payment recorded for period

    5. Warnings and items for human review

    • Management decision required: Unit 102 underpayment of $150.00 needs a billing adjustment or follow-up notice.

    Management decision required: Unit 103 shows zero payment; verify if check is in transit or if eviction proceedings are active.

    Next steps

    1. Review the exception register for Units 102 and 103.
    2. Confirm if any off-ledger payments were received for Tenant T-003.
    3. Approve the $150.00 billing adjustment for Unit 102.

    Connects securely to your tools. The creator never sees your data.

    About this skill

    Manual rent roll audits are prone to calculation errors and missed variances. This skill automates the comparison of tenant payment ledgers against lease contract terms to identify discrepancies. It uses a deterministic script to compute variances, ensuring mathematical accuracy across hundreds of records.

    What it does

    • Discrepancy classification Categorizes variances into matched, overpayment, underpayment, delinquent, or missing payment statuses.
    • Exception flagging Identifies payments received without an active lease or payments tied to expired contracts.
    • Financial calculation Computes total expected rent versus actual collections, net variance, and variance rates for a specific period.
    • Data validation Detects information gaps in tenant records or lease terms and requests missing data to complete the audit.
    • Reporting Generates structured summaries including exception registers and management review warnings.

    How it works

    1. Supply the lease contracts and tenant payment ledgers for the target property and period.
    2. The agent builds a request.json file following a strict schema to map your raw data.
    3. A self-contained Python script executes the reconciliation logic using defined tolerance thresholds.
    4. The agent presents a structured report including a reconciliation summary and exception register.

    Frameworks & tools

    The skill relies on a Python-based execution environment to run the scripts/run.py utility. It uses standard JSON schemas for input validation and data mapping.

    Why this beats prompting it yourself

    LLMs frequently hallucinate arithmetic when reconciling long lists of payments. This skill offloads the math to a deterministic script while using the agent to handle unstructured data mapping and contextual explanations.

    Use cases

    • Audit monthly rent collections to identify underpayments or missed transfers.
    • Reconcile large tenant ledgers against active lease agreements during property acquisitions.
    • Detect delinquent tenants and payments made under expired lease terms.
    • Generate variance reports for property managers to approve billing adjustments.

    Known limitations

    Does not support property operating budgets, lease abstracting, or security deposit reconciliations. Multi-property portfolio reconciliation is currently out of scope.

    Find more skills like this on the Claude Skills Marketplace, the Codex Skills Marketplace and the Gemini Skills Marketplace, or browse All Claude Skills.

    Does not handle CAM reconciliations, security deposits, or multi-property portfolios. Requires Python environment for the calculation script. Decision support only, no automated billing updates.

    How to use

    1. 1

      Connect your agent to the Agensi MCP

      Copy the prompt and paste it into Claude, ChatGPT, Cursor or any agent that supports MCP. It sets up the connection for you. Manual setup

    2. 2

      Sign in to Agensi

      Your agent shows a sign-in link. Sign in and click Allow.

    3. 3

      Ask for what you need

      Your agent loads this skill and uses it on your task. It always asks before buying a skill.

    Reviews

    No reviews yet

    Be one of the first to try it. Every listed skill goes through the trust checks below.

    Security scanned

    Checked by our 8-point scan before listing

    Fresh listing

    Recently published to Agensi

    Money-back guarantee

    Doesn't do what its page promises? You get your money back.

    Trust & safety

    Security scan

    Security scan passed today

    Permissions

    Terminal / Shell
    Read Files
    Write Files
    Environment Variables
    Listedtoday

    What's inside

    Frequently Asked Questions

    While LLMs often struggle with large-scale arithmetic, this skill uses a deterministic Python script to handle the math, ensuring 100% accuracy in variance calculations across hundreds of records.

    You will receive the core reconciliation agent, the `scripts/run.py` execution utility, the required JSON schemas for data mapping, and documentation on how to format your lease and ledger inputs.

    Yes, the skill is designed to handle unstructured data by using the agent to map your raw tenant ledgers and lease contracts into the required JSON schema before running the audit.

    This skill is currently focused on individual property audits and does not support multi-property portfolio reconciliation or security deposit tracking.

    This skill requires a Python-based execution environment to run the reconciliation script and is compatible with AI agents that support code execution and file system access.