- Home
- Skills
- Finance & Accounting
- Real-Estate Ledger CSV Analyst
Works with the AI Agents you already use
Real-Estate Ledger CSV Analyst
Turn a private real-estate ledger CSV into property summaries, monthly operating views, NOI, and exceptions.
$7
Real-Estate Ledger CSV Analyst
Example session with this skill installed
Analyze the attached Q3_2023_Ledger.csv for the Highland Apartments and Westside Duplex properties. Generate an NOI summary and list any exceptions.
- Read your context and instructions
- Compiled the real-estate ledger csv
- Generated the data export
I have processed Q3_2023_Ledger.csv, covering the period from July 1, 2023, to September 30, 2023. Data was normalized across two properties with 142 total transactions.
Property Performance Summary (Q3 2023)
| Property | Total Income | Total Expenses | NOI | Exceptions |
|---|---|---|---|---|
| Highland Apartments | $42,500.00 | $18,250.00 | $24,250.00 | 2 |
| Westside Duplex | $6,800.00 | $2,150.00 | $4,650.00 | 1 |
| Portfolio Total | $49,300.00 | $20,400.00 | $28,900.00 | 3 |
Accounting Exceptions & Anomalies
Uncategorized Entry (Highland): Transaction ID #9982 (Aug 14) for $1,200.00 labeled "Misc Reimbursement" has no GL code.
- Duplicate Check (Highland): Two identical $450.00 charges for "Pest Control" detected on Sept 02 and Sept 04.
- Negative Income (Westside): A -$200.00 entry on July 15 labeled "Rent Refund" flagged for review.
Category Mappings & Assumptions
- Operating Income: Rent, Parking Fees, Pet Rent, Late Fees.
- Operating Expenses: Maintenance, Utilities, Landscaping, Property Management Fees.
- Excluded: Capital expenditures above $2,500 were moved to a separate depreciation view (if requested).
Next steps
- Provide the GL code for the $1,200 Highland reimbursement to update the NOI.
- Confirm if the dual Pest Control charges were for two separate buildings or a double-billing error.
- Request a Monthly Income Statement view to see month-over-month trends for Q3.
Q3_2023_Ledger.csv
CSV · data export
Example file from a real run - the skill writes it into your workspace.
Connects securely to your tools. The creator never sees your data.
About this skill
Raw real estate ledger files are often too messy for standard accounting software to ingest without manual cleanup. This skill automates the extraction and analysis of property-level financial data from general ledger CSVs to produce investor-ready reports. It identifies transaction patterns, calculates Net Operating Income (NOI), and surfaces accounting exceptions that would otherwise require hours of manual auditing.
What it does
- Data Validation inspects CSV headers to verify dates, amounts, and property identifiers before processing.
- Financial Normalization separates income and expenses into standardized categories while documenting all mapping logic.
- NOI Calculation generates property and portfolio-level summaries including net balances and operating income.
- Anomaly Detection flags uncategorized entries, duplicate transactions, and unusual negative income spikes.
- Reporting Views builds monthly income statements and filtered transaction logs with running balances.
How it works
- Inspection scans the uploaded CSV to map columns and confirm the reporting period and properties.
- Analysis processes the ledger to categorize every line item into operating income or expense buckets.
- Reporting outputs a high-level summary table followed by detailed exception lists and monthly breakdowns.
Frameworks & tools
This skill is designed for raw CSV exports from property management software like Yardi, AppFolio, or Buildium, and works within any LLM environment capable of local file processing.
Why this beats prompting it yourself
Generic prompts often hallucinate missing totals or misinterpret complex mapping logic between different property IDs. This skill enforces strict data integrity rules that prevent inventing transactions and requires explicit confirmation of category mappings.
Use cases
- Generate monthly NOI reports for real estate investors from raw exports.
- Audit property management ledgers for missing entries or duplicate charges.
- Prepare operating summaries for multi-unit portfolios before tax season.
- Reconcile bank transaction logs against internal property accounting.
Known limitations
Does not provide audited financial statements, tax advice, or investment advice. Cap-rate calculations require user-supplied assumptions.
Requires user-supplied CSV files. Does not provide audited financial statements or tax advice. Cap-rate calculations require manual input of assumptions.
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 23 days ago
Requires
Permissions
Allowed Hosts