Works with the AI Agents you already use
rent roll reconciliation
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
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 ID | Unit | Status | Variance | Note |
|---|---|---|---|---|
| T-002 | 102 | Underpayment | -$150.00 | Partial payment received |
| T-003 | 103 | Delinquent | -$500.00 | No 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
- Review the exception register for Units 102 and 103.
- Confirm if any off-ledger payments were received for Tenant T-003.
- 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
- Supply the lease contracts and tenant payment ledgers for the target property and period.
- The agent builds a
request.jsonfile following a strict schema to map your raw data. - A self-contained Python script executes the reconciliation logic using defined tolerance thresholds.
- 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.
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
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
Sign in to Agensi
Your agent shows a sign-in link. Sign in and click Allow.
- 3
Ask for what you need
Your agent loads this skill and uses it on your task. It always asks before any payment.
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