Update logo, company name and tagline used across all pages.
Company Identity
Logo Image (optional — replaces initials)
🖼️
PNG, SVG, JPG — recommended 200×60 px or square
Choose File
✕ Remove logo image
Theme Colors
Customize the color palette used throughout the website.
Primary Colors
Live Preview
PrimaryDarkAccentAccent LtAmberAmber LtBG
Typography
Choose heading and body fonts loaded from Google Fonts.
Font Family
The quick brown fox
Serving Jharkhand since 2017. Your trusted solar partner.
Contact Information
Update phone, email, WhatsApp and address across all pages.
Contact Details
Director / Proprietor
Update the director's name, title and photo shown on the About and Home pages.
Director Information
Director Photo (shown on About & Home page)
📷
Recommended: square photo, at least 300×300 px
Choose Photo
✕ Remove photo
Favicon
Upload a custom favicon (browser tab icon).
Favicon Image
Recommended: 32×32 px or 64×64 px PNG/ICO file with transparent background.
⭐
PNG, ICO — 32×32 or 64×64 px
Choose Favicon
✕ Remove favicon
Team Members
Manage employees — add, edit and remove team records.
Employees
Name
Role
Phone
Email
Status
Actions
Loading…
Total Accounts
0
0 active · 0 closed
EMD Outstanding
₹ 0
Interest Outstanding
₹ 0
Total Outstanding
₹ 0
💎 Account Ledger
✕ Col Filters
All changes saved
💡 Click any cell to edit · Enter moves to next cell (Borrower → Lender → EMD Date → Total EMD Value → DD) · Shift+Enter goes back · Double-click date opens calendar · Auto-saves on blur · Use + Add Money to record receipts
#
Borrower Name ↕
Lender / Bank ↕
EMD Date ↕principal deposited
Expected Refund ↕agreed return date
Total EMD Value ↕EMD + DD (₹)
DD Amount ↕demand draft
Initial Interest (3-Mo) ↕10%·(D−E) + DD
Actual Refund ↕auto from transactions
Tenure ↕months
Extended Interest ↕(10%÷3)·(EMD−received)·months
Total Received ↕from borrower
EMD Recovered ↕principal received
Interest Recovered ↕interest received
EMD Outstanding ↕principal balance
Interest Outstanding ↕interest balance
Total Outstanding ↕balance due
Status ↕
Loading…
Lender Portfolio
Capital deployed, returns & risk — as of — · 💡 click any figure for account-level detail
Total Portfolio Value
₹ —
—
— %
Annualized Yield
Capital Invested
₹ —
Returns Earned
₹ —
Received
₹ —
Outstanding
₹ —
Full Metrics Matrix 10 dimensions — EMD, DD, interest & dues — click any figure for account detail
Account Status Breakdown classified by EMD receipt & interest health
Capital Status principal returned vs still deployed
Interest Income received vs pending
Returns Breakdown how your interest income is composed
Loading…
P&L Statement accrual income · cash realised · outstanding receivables
Break Even & Yield Analysis portfolio efficiency vs FD benchmark · capital recovery metrics
Outstanding Capital by Age older deployments carry higher recovery risk
Risk Snapshot portfolio safety indicators
Portfolio Holdings — all
Investment Calculator project the return on a new deal
Projected payouts for the next 4 months — based on current active accounts and interest accrual schedule.
CMC Report Generator
JREDA Annexure-IV — Monthly O&M & CMC reports. Enter the work-order details once; every monthly report (checklist + daily generation log) is generated automatically and exported as PDF or Word.
New Site
Letter & letterhead text — prefilled with the standard JREDA format (click to edit)
☀️
No CMC sites yet
Add your first site — enter the work-order details once and all monthly reports generate automatically.
📅 Report Plan
Month
Visit Date
Total kWh
Cumulative kWh
Day-wise
Actions
💡 Monthly totals are auto-estimated from plant capacity & Jharkhand season — edit any figure to fine-tune. Day-wise values always sum exactly to the monthly total and stay the same on every download until you press 🎲.
🛠 Maintenance Checklist Remarks (defaults printed in every month — click to expand)
Component
Activity
Description
Remark
The Infrared-inspection remark is set to N/A automatically for plants ≤ 50 kWp.
Security
Admin account: piyushkumar5061@gmail.com — change your password below.
Change Password
⚠️ Password is stored in your browser's localStorage. For production, use a proper backend authentication system.
Set / Change Admin PIN
4–6 digit numeric PIN for quick PIN login. Requires your current password to set.
Accounts
Account Due Breakup
Add Employee
Admin Panel Access (optional — leave blank if no panel access)
📊 Account Report
WhatsApp number:
📋 Change History —
Loading…
📝 Status Remarks
📊 Generate Report
A — Which Accounts to Include
B — Report Style
Status Change — Remarks Required
⚠ Please enter a reason — this field is required.
Lender Status Override — Notes Required
EMD interest stops accruing after this date. Defaults to today.
⚠ Please enter a reason — this field is required.
Account Journey
Add Remark to Selected
Adding to
Custom Journey PDF
Pick accounts + view → generate a combined multi-page PDF
Add Remark
Borrower Payments
➕ Add New Payment
📋 Payment History
Adjust Outstanding
⚠ Admin-only override — applies a manual correction to the computed outstanding. A clear reason is required for the audit trail.
Computed (auto)
₹ 0
Stored Delta
—
📥 Bulk Import Accounts — CSV / Excel
Upload a CSV or Excel file to create multiple EMD accounts at once
📂
Drop your CSV or Excel file here
or click to browse · .csv, .xlsx, .xls accepted
✓ SMART MODE
Paste your own export directly — all columns auto-detected. Required: Borrower Name, EMD Date, Total EMD Value ·
Optional: Lender, Expected Refund Date, DD Amount, Account Status, EMD Recovered, Interest Recovered, Remarks
⬛ 0 rows
✓ 0 valid
✕ 0 errors
Preparing…
Select a file to preview rows before importing.
Edit day-wise generation
Target total:0· Current sum:0
Day
Generation kWh
Grid outage (hh.mm)
Inverter down (hh.mm)
Remark
Tip: for an outage day, set the hours (e.g. 02.30) and change the remark (e.g. Grid outage). Everything else can stay as-is.