flowchart TD
    subgraph Data Layer [ERP Data Ingestion]
        PO[Purchase Orders CSV] --> DB[(SQLite / Postgres DB)]
        GRN[Goods Received Notes CSV] --> DB
        INV[Vendor Invoices CSV] --> DB
    end

    subgraph SQL Engine [Analytics & Reconciliation Pipeline]
        DB --> CTE[3-Way Matching SQL CTEs & Window Functions]
        CTE --> DISC[Discrepancy Matrix & Risk Scoring]
        DISC --> DB_TABLES[Populate Discrepancies & Audit Logs]
    end

    subgraph Agentic Layer [Model Context Protocol & Ops AI Agent]
        DB_TABLES <--> MCP[FastMCP Server]
        MCP <--> AGENT[Ops AI Agent Resolution Engine]
        AGENT --> POLICY[Corporate Financial Policy Rules]
        POLICY --> ACTIONS[Auto-Approve / Hold / Credit Note Request]
    end

    subgraph Executive Layer [UI & Observability]
        DB_TABLES --> DASHBOARD[Streamlit Executive & Ops Workbench]
        ACTIONS --> DASHBOARD
    end

git clone https://github.com/your-username/FinOps-Agentic-Reconciliation.git
cd FinOps-Agentic-Reconciliation

# Create virtual environment
python -m venv venv
source venv/bin/activate  # On Windows: venv\Scripts\activate

# Install dependencies
pip install -r requirements.txt

# Generate 1,000+ realistic transaction records and run ETL pipeline
make etl

# Or run directly via Python:
python -m src.pipeline.etl_reconciliation

make test

make dashboard

FinOps-Agentic-Reconciliation/
├── README.md                      # Technical documentation & architecture
├── pyproject.toml                 # Package configuration
├── requirements.txt               # Pinned dependencies
├── Makefile                       # Developer CLI shortcuts
├── config/
│   └── settings.yaml              # Financial thresholds & tolerance settings
├── data/
│   ├── raw_pos.csv                # Sample PO transactions
│   ├── raw_grns.csv               # Sample GRN receipts
│   └── raw_invoices.csv           # Sample Vendor Invoices
├── sql/
│   ├── 01_schema_init.sql         # Relational DDL & performance indexes
│   ├── 02_three_way_matching.sql  # 3-Way matching CTEs & window functions
│   └── 03_vendor_aging_kpis.sql   # AP aging aggregation queries
├── src/
│   ├── pipeline/
│   │   ├── generate_synthetic_data.py # ERP synthetic transaction generator
│   │   └── etl_reconciliation.py  # Main ETL reconciliation engine
│   ├── mcp_server/
│   │   └── ops_mcp_server.py      # FastMCP JSON-RPC server implementation
│   ├── agent/
│   │   ├── ops_agent.py           # FinOps AI Agent batch execution engine
│   │   └── discrepancy_rules.py   # Deterministic financial policies
│   └── dashboard/
│       └── app.py                 # Streamlit Executive Ops Workbench
└── tests/
    ├── test_reconciliation.py     # Discrepancy rule unit tests
    └── test_mcp_server.py         # MCP tool integration tests