Page 1 of 5
Customer Identity
Basic identification · OTP-verified contact · Service selection
Personal Identification
As per KYC documents
Contact Verification
Mobile and email verified via OTP before consultation proceeds
+91
4-digit code sent to customer's email
Employment Type *
✓
💼SalariedEmployed✓
🏢BusinessSelf-employed✓
👨⚕️ProfessionalCA/Doctor/Lawyer✓
✈️NRINon-residentService Required *
What has the customer come for today?
✓
🏠Home LoanPurchase/Construct/Renovate✓
🔄Balance TransferReduce EMI burden✓
🔧Loan RestructuringEMI reduction strategy✓
🏗Mortgage / LAPLoan against property✓
💼Business LoanExpansion / working capital✓
📊CIBIL AnalysisCredit review & strategy✓
🛡InsuranceTerm / health / loan protection✓
📈Mutual FundsSIP / goal-based investment💼 Consultation Fee
Confirm before proceeding
₹
⚠
Advisory success fee of 1% of sanctioned loan amount is payable upon issuance of sanction letter. This must be communicated to the customer before proceeding.
Page 2 of 5
Financial Profile
Income, liabilities, CIBIL — live FOIR calculated as you type
Live Eligibility Assessment
—
FOIR %
—
Max New EMI
—
Approx Eligible
—
DSCR
—
LTV %
—
App Score
FOIR threshold: 40–50% · DSCR > 1.2 preferred · LTV: max 80% residential, 60% commercial
Income Details
₹
₹
₹
₹
Existing Liabilities
₹
Sum of all current loan EMIs
₹
CIBIL & Credit Profile
Page 3 of 5
Loan & Service Details
Specific loan requirement — BT, restructuring, new loan
New Loan Requirement
₹
₹
🔄 Balance Transfer / Restructuring Details
Current loan being transferred or restructured
₹
₹
Additional Requirements
₹
Page 4 of 5
Document Checklist
Mark each document — collected, missing or waived. Auto-saved to Sheets.
✅ 0 Collected
❌ 0 Missing
— 0 Waived
ℹ
Tap ✅ Collected / ❌ Missing / — Waive on each document. Automatically updates the AI analysis and Google Sheets. The report will show exact missing document list.
🪪 KYC Documents (All Services)
💰 Income Documents
🏠 Property / Collateral Documents
📋 Additional Documents
Document Collection Notes
Page 5 of 7
Financial Projections
AI-generated P&L, Balance Sheet, Cash Flow — 3-year projection · Legally compliant · Printable PDF
🤖
Claude AI generates complete financial projection documents based on the income and loan data collected. These are advisory projections with mandatory legal disclaimers. Every document is printable as a standalone PDF page.
Projection Parameters
₹
₹
₹
Page 6 of 7
Payment Collection
Consultation fee · 1% advisory success fee · Razorpay QR · Payment link
Fee Summary — This Consultation
₹—
Consultation Fee
₹—
1% Success Fee
⏳ Pending
Status
Razorpay QR / UPI Pay
LIVE
Scan with any UPI app · GPay · PhonePe · Paytm · BHIM
KG FINVEST
Scan & Pay with any UPI App
₹
Powered by Razorpay · Live Key: rzp_live_SzjjRlt…
💳 Razorpay Checkout
Open payment modal or generate link for WhatsApp/SMS
₹
Razorpay Key ID: rzp_live_SzjjRltWDwbKYa
Keys managed in GAS Script Properties
Keys managed in GAS Script Properties
💰 Payment Log
No payments recorded yet
🔑 API Key Status
Claude API Key
Checking…
AI analysis & projections
Razorpay Key ID
Checking…
rzp_live_SzjjRltWDwb…
Razorpay Secret
Checking…
Payment verification
GAS Web App
Checking…
All backend functions
📌 To update any key: Apps Script Editor → Project Settings → Script Properties
Keys: CLAUDE_API_KEY · RAZORPAY_KEY_ID · RAZORPAY_SECRET
Keys: CLAUDE_API_KEY · RAZORPAY_KEY_ID · RAZORPAY_SECRET
Page 7 of 7 — Final Report
AI Analysis Report
Full Claude AI credit assessment · Lender recommendations · Advisor sign-off
🤖
Ready to generate AI analysis — Claude will analyse all 4 pages of data: financial profile, FOIR, CIBIL, loan details, document status, and generate a complete advisory report with lender recommendations.