Kite MCP Server

# Quick Start: Find Your Duplicate Ledger Entries ## Your Specific Issue You have these duplicate entries in account=1: ``` 31 Dec 2025 N/A Book Voucher ₹659.94 - ₹170.54 31 Dec 2025 N/A Book Voucher ₹659.94 - ₹170.54 ``` ## How to Find and Fix (3 Steps) ### Step 1: Open Conflicts Page Go to: `http://localhost:3000/conflicts` ### Step 2: Scan for Duplicates Look for the "Scan Database for Duplicates" section at the top: 1. **Account dropdown:** Select your account (the one with ID=1) 2. **Type dropdown:** Select "Ledger" 3. Click **"Scan for Duplicates"** button You should see: "✅ Scan complete. Found X duplicate(s)" ### Step 3: Delete the Duplicate Scroll down and you'll see your duplicate entry displayed: ``` ┌────────────────────────────────────────────────────┐ │ 🔵 Ledger Conflict │ │ Type: Exact Duplicate (Already in DB) │ ├────────────────────────────────────────────────────┤ │ Date: 31 Dec 2025 │ │ Particular: N/A │ │ Debit: ₹659.94 │ │ (shown twice, side by side) │ └────────────────────────────────────────────────────┘ ``` Click the red **"Delete Duplicate"** button. Done! ✅ Your duplicate is now removed from the database. --- ## Why Wasn't It Showing Before? The conflict detection previously only worked **during import** (when you upload a CSV). It would compare CSV data against the database. But your duplicates were **already in the database** (both entries), so there was nothing to compare against during import. The new **Scanner** feature now looks **inside your database** to find entries that are duplicated, which is exactly what you needed! --- ## Test It Now 1. Start your development server if not running: ```bash cd equity npm run dev ``` 2. Open: `http://localhost:3000/conflicts` 3. Use the scanner as described above 4. You should see your duplicate entries! --- ## If You Want to Test on Other Accounts Repeat the process for each account: - Select different account from dropdown - Select "Tradebook" to find duplicate trades - Select "Ledger" to find duplicate ledger entries --- ## Need More Help? See the detailed guide: `HOW_TO_FIND_EXISTING_DUPLICATES.md`