BILLING & COLLECTION DASHBOARD

15-in-1 Analytics • Colourful Excel Report • BILLED & UNBILLED • UPPCL

← DataBabu.in Home
DASHBOARD CREATER Er. G. K. NISHAD | JE UPPCL
1️⃣ BILLED CSV
2️⃣ UNBILLED CSV
1️⃣DIVISION REPORT_____________________BILLING & REVENUE
DIVISION NAMETOTALUNBILLBILLEDTOTAL C.A (LACS)CA(EXC.LMV5) (LACS)BILL %TOTAL DUES (EXC.LMV5)(LACS)REVENUE (LACS)PAID NOCOLL EFF %TURNUP %HV COUNT
2️⃣ SDO_CODE (SUBDIVISION) WISE_____________________BILLING & REVENUE
SDO_CODE (SUBDIVISION)TOTALUNBILLBILLEDTOTAL C.A (LACS)CA(EXC.LMV5) (LACS)BILL %TOTAL DUES (EXC.LMV5)(LACS)REVENUE (LACS)PAID NOCOLL EFF %TURNUP %HV COUNT
Upload and Generate
3️⃣ SDO_CODE + SUBSTATION WISE_____________________BILLING & REVENUE
SDO_CODE (SUBDIVISION)SUBSTATION (Under SDO_CODE)TOTALUNBILLBILLEDTOTAL C.A (LACS)CA(EXC.LMV5) (LACS)BILL %TOTAL DUES (EXC.LMV5)(LACS)REVENUE (LACS)PAID NOCOLL EFF %TURNUP %HV COUNT
Upload and Generate
4️⃣ SUBSTATION WISE_____________________BILLING & REVENUE_____________________DIVISION
SUBSTATIONTOTALUNBILLBILLEDTOTAL C.A (LACS)CA(EXC.LMV5) (LACS)BILL %TOTAL DUES (EXC.LMV5)(LACS)REVENUE (LACS)PAID NOCOLL EFF %TURNUP %HV COUNT
5️⃣FEEDER WISE_____________________ DETAILS OF SUBSTATION
6️⃣ NON GOVT_____________________5 TO 9.99 KW_____________________(LMV 1,2,4B,6,11 & HV 1,2)
SDO_CODESUBSTATIONTOTALUNBILLEDBILLEDTOTAL C.A (LACS)DUES TOTAL OUTSTANDING (LACS)PAID CURR (NO)PAID AMT CURR (LAC)BILLED BUT NOT PAID (NO)
7️⃣ NON GOVT_____________________10 KW AND ABOVE_____________________(LMV 1,2,4B,6,11 & HV 1,2)
SDO_CODESUBSTATIONTOTALUNBILLEDBILLEDTOTAL C.A (LACS)DUES TOTAL OUTSTANDING (LACS)PAID CURR (NO)PAID AMT CURR (LAC)BILLED BUT NOT PAID (NO)
8️⃣ NON GOVT_____________________5 KW AND ABOVE_____________________(LMV 1,2,4B,6,11 & HV 1,2)
SDO_CODESUBSTATIONTOTALUNBILLEDBILLEDTOTAL C.A (LACS)DUES TOTAL OUTSTANDING (LACS)PAID CURR (NO)PAID AMT CURR (LAC)BILLED BUT NOT PAID (NO)
9️⃣ LMV1 REPORT_____________________(AS PER BILLED)
SDO_CODESUBSTATION NAME - LMV1TOTALUNBILLEDBILLEDTOTAL C.A (LACS)DUES TOTAL OUTSTANDING (LACS)PAID CURR (NO)PAID AMT CURR (LAC)BILLED BUT NOT PAID (NO)
🔟 LMV2 REPORT_____________________(AS PER BILLED)
SDO_CODESUBSTATION NAME - LMV2TOTALUNBILLEDBILLEDTOTAL C.A (LACS)DUES TOTAL OUTSTANDING (LACS)PAID CURR (NO)PAID AMT CURR (LAC)BILLED BUT NOT PAID (NO)
1️⃣1️⃣ LMV4 REPORT (SUPPLY_TYPE 46 & 47)_____________________(AS PER BILLED)
SDO_CODESUBSTATIONTOTALUNBILLEDBILLEDTOTAL C.A (LACS)DUES TOTAL OUTSTANDING (LACS)PAID CURR (NO)PAID AMT CURR (LAC)BILLED BUT NOT PAID (NO)
1️⃣2️⃣ LMV6 REPORT_____________________(AS PER BILLED)
SDO_CODESUBSTATIONTOTALUNBILLEDBILLEDTOTAL C.A (LACS)DUES TOTAL OUTSTANDING (LACS)PAID CURR (NO)PAID AMT CURR (LAC)BILLED BUT NOT PAID (NO)
1️⃣3️⃣ HV1 REPORT_____________________(AS PER BILLED)
SDO_CODESUBSTATIONTOTALUNBILLEDBILLEDTOTAL C.A (LACS)DUES TOTAL OUTSTANDING (LACS)PAID CURR (NO)PAID AMT CURR (LAC)BILLED BUT NOT PAID (NO)
1️⃣4️⃣ HV2 REPORT_____________________(AS PER BILLED)
SDO_CODESUBSTATIONTOTALUNBILLEDBILLEDTOTAL C.A (LACS)DUES TOTAL OUTSTANDING (LACS)PAID CURR (NO)PAID AMT CURR (LAC)BILLED BUT NOT PAID (NO)
1️⃣5️⃣ TARIFF WISE/CATEGORY WISE_____________________CONSUMER DETAILS____________(NO.)
SDO_CODESUBSTATIONTOTALHV2HV1LMV1LMV2LMV3LMV4LMV5LMV6LMV7LMV8LMV9LMV10LMV11