Works with the AI Agents you already use

    Claude CodeClaude CodeCursorCursorCodex CLICodex CLIMuseMuseDotsDots+21 more

    Real-Estate Ledger CSV Analyst

    1

    Turn a private real-estate ledger CSV into property summaries, monthly operating views, NOI, and exceptions.

    $7

    Secure checkout via Stripe

    Money-back guarantee

    Converts to your local currency at checkout

    Security scanned
    Real-Estate Ledger CSV Analyst

    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)

    PropertyTotal IncomeTotal ExpensesNOIExceptions
    Highland Apartments$42,500.00$18,250.00$24,250.002
    Westside Duplex$6,800.00$2,150.00$4,650.001
    Portfolio Total$49,300.00$20,400.00$28,900.003

    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

    Generated

    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

    1. Inspection scans the uploaded CSV to map columns and confirm the reporting period and properties.
    2. Analysis processes the ledger to categorize every line item into operating income or expense buckets.
    3. 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. 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 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

    Cloudflare
    Jsdelivr

    Permissions

    Network Access
    Read Files
    Write Files

    Allowed Hosts

    cdn.jsdelivr.net
    cdnjs.cloudflare.com
    Listed23 days ago

    What's inside

    Frequently Asked Questions

    The skill is optimized for raw CSV exports from major property management platforms like Yardi, AppFolio, and Buildium, as well as standard bank transaction logs containing property-related data.

    Unlike standard prompts, this skill uses a specialized validation layer to prevent hallucinations, ensuring that every NOI calculation and balance is derived strictly from your uploaded data without 'inventing' transactions.

    Yes, the skill is designed to handle multi-unit portfolios, mapping different property IDs and identifiers to create consolidated reports or individual monthly statements as needed.

    You will receive the proprietary skill configuration and logic required to run the analysis within your chosen AI agent environment, along with a guide on how to format your CSVs for optimal results.

    The skill automatically flags accounting exceptions, such as duplicate transaction entries, uncategorized expenses, and unusual negative income spikes, saving you hours of manual auditing.

    New in Finance & Accounting