BILLING & COLLECTION DASHBOARDS

🏠
DATABABU.IN
1️⃣ BILLED DATA IN CSV
2️⃣ UNBILLED DATA IN CSV
3️⃣ LAST YEAR SAME MONTH IN EXCEL (ONLY PAID CONSUMERS) (40MB)

MUST HAVE CONTAIN DIV_CODE , SDO_CODE,SUBSTATION,FEDER, PAY_AMT,PAY_DATE, TOTAL_PAY_AMT
📅 CURRENT MAX LAST_PAY_DATE (Auto)
📅 LAST YEAR CUTOFF DATE (Manual Change it)
CHANGE THE DATE AND CLICK ON APPLY DATE THEN GENERATE.
Actions
1️⃣ DIVISION----------- BILLING & COLLECTION----
DIVISION TOTAL(NO.) UNBILLED(NO.) BILLED(NO.) BILLING(%) TOTAL C.A(LACS) CA (EXC. LMV5)(LACS) TOTAL DUES(LACS) REVENUE TODAY(LACS) TOTAL PAID(NO.) REVENUE TILL TODAY(LACS) LY REVENUE TILL TODAY(LACS) AMT LEAD / LAG(LACS) LEAD / LAG(%) LAST YEAR FULL MONTH(LACS) TURNUP(%) COLL EFF(%)
2️⃣ SDO_CODE WISE----------- BILLING & COLLECTION----
SDO_CODE TOTAL(NO.) UNBILLED(NO.) BILLED(NO.) BILLING(%) TOTAL C.A(LACS) CA (EXC. LMV5)(LACS) TOTAL DUES(LACS) REVENUE TODAY(LACS) TOTAL PAID(NO.) REVENUE TILL TODAY(LACS) LY REVENUE TILL TODAY(LACS) AMT LEAD / LAG(LACS) LEAD / LAG(%) LAST YEAR FULL MONTH(LACS) TURNUP(%) COLL EFF(%)
Upload and Generate
3️⃣ SUBSTATION WISE ----------- BILLING & COLLECTION----
SUBSTATION TOTAL(NO.) UNBILLED(NO.) BILLED(NO.) BILLING(%) TOTAL C.A(LACS) CA (EXC. LMV5)(LACS) TOTAL DUES(LACS) REVENUE TODAY(LACS) TOTAL PAID(NO.) REVENUE TILL TODAY(LACS) LY REVENUE TILL TODAY(LACS) AMT LEAD / LAG(LACS) LEAD / LAG(%) LAST YEAR FULL MONTH(LACS) TURNUP(%) COLL EFF(%)
8️⃣ FEEDER WISE----------- BILLING & COLLECTION----
4️⃣ REVENUE------SUBSTATION & CATEGORY WISE ------ON DATE (TODAY)--
SUBSTATION ON DATE(NO.) ON DATE AMT(LACS) HV2(NO.)HV2(LACS) HV1(NO.)HV1(LACS) LMV1(NO.)LMV1(LACS) LMV2(NO.)LMV2(LACS) LMV3(NO.)LMV3(LACS) LMV4(NO.)LMV4(LACS) LMV5(NO.)LMV5(LACS) LMV6(NO.)LMV6(LACS) LMV7(NO.)LMV7(LACS) LMV8(NO.)LMV8(LACS) LMV9(NO.)LMV9(LACS) LMV10(NO.)LMV10(LACS) LMV11(NO.)LMV11(LACS)
Upload and Generate
5️⃣ REVENUE-----SDO CODE & CATEGORY WISE-----ON DATE (TODAY)--
SDO_CODE ON DATE(NO.) ON DATE AMT(LACS) HV2(NO.)HV2(LACS) HV1(NO.)HV1(LACS) LMV1(NO.)LMV1(LACS) LMV2(NO.)LMV2(LACS) LMV3(NO.)LMV3(LACS) LMV4(NO.)LMV4(LACS) LMV5(NO.)LMV5(LACS) LMV6(NO.)LMV6(LACS) LMV7(NO.)LMV7(LACS) LMV8(NO.)LMV8(LACS) LMV9(NO.)LMV9(LACS) LMV10(NO.)LMV10(LACS) LMV11(NO.)LMV11(LACS)
Upload and Generate
6️⃣ REVENUE ------SUBSTATION & CATEGORY WISE------CURRENT MONTH TOTAL--
SUBSTATION TILL TOTAL(NO.) ON DATE AMT(LACS) HV2(NO.)HV2(LACS) HV1(NO.)HV1(LACS) LMV1(NO.)LMV1(LACS) LMV2(NO.)LMV2(LACS) LMV3(NO.)LMV3(LACS) LMV4(NO.)LMV4(LACS) LMV5(NO.)LMV5(LACS) LMV6(NO.)LMV6(LACS) LMV7(NO.)LMV7(LACS) LMV8(NO.)LMV8(LACS) LMV9(NO.)LMV9(LACS) LMV10(NO.)LMV10(LACS) LMV11(NO.)LMV11(LACS)
Upload and Generate
7️⃣ REVENUE-----SDO & CATEGORY WISE-----CURRENT MONTH TOTAL--
SDO_CODE TILL TOTAL(NO.) ON DATE AMT(LACS) HV2(NO.)HV2(LACS) HV1(NO.)HV1(LACS) LMV1(NO.)LMV1(LACS) LMV2(NO.)LMV2(LACS) LMV3(NO.)LMV3(LACS) LMV4(NO.)LMV4(LACS) LMV5(NO.)LMV5(LACS) LMV6(NO.)LMV6(LACS) LMV7(NO.)LMV7(LACS) LMV8(NO.)LMV8(LACS) LMV9(NO.)LMV9(LACS) LMV10(NO.)LMV10(LACS) LMV11(NO.)LMV11(LACS)
Upload and Generate