Wednesday, 31 December 2014

CO-ORDINATION SECTION

CO-ORDINATION SECTION


            Co-ordination section is the most important section of Data Control.  It provides co-ordination among all other sections of Data Control. Following important jobs are controlled through this section:-

-                                              Industrial billing.
-                                              Processing of Dead Defaulter’s billing.
-                                              Processing of WAPDA Employees Departmental billing.
-                                              Processing of All Monthly Reports relating to billing.
-                                              Processing of Feeder Wise Line Losses Reports CP-22.
-                                              Processing of MIS Reports prepared at regional level.
-                                              Processing of Monthly Payroll of Employees of WAPDA Offices.
-                                              Processing, printing and checking of all other reports demanded by the authority from time to time.











INDUSTRIAL BILLING

A separate master file has been introduced for the billing of industrial connections having peak load more than 5 KW.  Following types of connection are billed under this procedure:-

-          Industrial connections having peak load above 20 KW.
-                      Domestic connections above 20 KW.
-                      Domestic connections above 5 KW having TOU metering tariff.
-                      Commercial connections above 20 KW.
-                      Commercial connections above 5 KW having TOU metering tariff.
-                      Bulk supply connections.
-                      Tube-well connections (Scarp + Agriculture) above 20 KW.
-                      Tube-well connections (Scarp + Agriculture) above 5 KW having TOU metering tariff.
-                      Street light connections.
-                      Residential colonies attached to industrial premises
-                      Railway tractions.
-                      Co-Generations.

This billing is also called as MDI Billing (i.e. maximum demand indicated).  A separate procedure is adopted for the processing and checking of MDI bills. Following in puts forms are used for this purpose:-

-           CP-137   Master Data Addition/ Change form (connections above 20 KW).
-           CP-140.  Street Light Addition/ Removal/ Replacement form.
-           CP-142   Advice of Transfer between MDI & General Batches.
-           CP-052   Bill adjustment inputs form.
-           CP-138   Meter data change form.
-           CP-139   Un-identified cash/debtor’s adjustment form.
-           GSTNO  “NTN” & “GST” Number addition/ updation File.
-           Zero GST Data Addition/updation.
            Meter reading lists and allied data of MDI batch is received in the Computer Centre through Commercial Superintendent of the Assistant Manager’s (C.S) Office. As for as nature of job is concerned, MDI billing is very important. Following measures are adopted for accurate receiving of data:-

-                      Writing should be legible and there must be no cutting/overwriting on inputs forms. If due to some reasons cutting/ over-writing is accepted, it must be signed and stamped be the Assistant Manager (CS) concerned.
-                      Each page of the data must be signed and stamped by the competent authority.
-                      Dispatch number and date must be written on the top of each page.
-                      Names and addresses must be recorded in capital letters and within the limits of the fields.
-                      Number of pages and entries must be in accordance with CP-80.

            Inputs data of CP-052, CP-138 and CP-139 is common in MDI billing and General billing. The “filling criteria” is same in MDI billing as in General billing. However, the details of other inputs are as below.

CP-137 MASTER DATA ADDITION/CHANGE FORM (CONNECTIONS ABOVE 40 KWs):-

This input form is used for addition of new consumers on master file as well as for any change, which may be required in this information at some later stage. Two types of transactions are involved in this input form:-

“1”                   For addition of new record.
“2”                   For change in existing informations.

            The relevant transaction type must be encircled/ticked. Following checks are implemented to ensure accuracy:-

-                      In case of addition there must be a valid reference number ( i.e. batch number, Sub Division code and account No.) keeping the check digit column blank.  In case of change, a complete reference number ( i.e. Batch number, Sub division code, Account number and check digit) is must. The reference number entered must be a valid one existing on computer master file.
-                      Two digits valid tariff code must be entered as per purpose of connection. It means nature of business/industry, for which connection is required.
-                      Application number must be written in seven digits. First character is alphabetic. (i-e A,B,C……)
-                     Data of application must be as DD – MM – CCYY.
-                      There must be a valid security amount according to the rate by taking into consideration tariff code, sanctioned load, rural/urban code and seasonal code. It is ensured that:-

Security Amount (Rounded in Rs.)   =   Sanctioned Load  X  Rate per KW.

-         Enter a valid security date and connection date as DD-MM-CCYY. The dates must be written as:-

 Date of application  <  Date of security  <  Date of connection.

-                      Enter sanctioned load with two decimal points. The sanctioned load must be entered within the limits of tariff requirement.
-                      The capacity of installed transformer must be recorded in the relevant column. It is essential in case of B-3 connections only.
-                      Enter ‘R’ for rural connection and ‘U’ for urban connection in the respective column.
-                      Enter ‘0’ for permanent connections and ‘1’ for seasonal connections as seasonal supply code.
-                      Electricity duty must be entered as per procedure given below: -

Private connections exempted from ED coded as ‘0’.
Private connections paying ED coded as ‘1’.
Govt. connections exempted from ED coded as ‘5’.
Govt. connections paying ED coded as ‘6’.

-           A five digits Government department code must be entered in the column of Government code for all Government connections having ED code as ‘5 or ‘6’. This must be a valid code existing in Government Department Code Table.
-           Standard classification code is introduced to identify the various types of connections. This is a five digits code. This code must be a valid one existing in Standard Classification Code Table.
-           There are some categories of commercial or industrial consumers that are exempted from GST & With-holding Income Tax as per Gazette Notification. For this exemption income tax code is introduced. Income Tax code must be entered as:-

                        “0”                   No exemption.
                        “1”                   Income Tax exempted and GST not exempted.
                        “2”                   Income Tax not exempted and GST exempted.
                        “3”                   GST and Income Tax both exempted. 
“4”                   Income Tax not exempted and GST exempted for large tax payers.
                        “5”                   GST and Income Tax both exempted for large tax payers.

-           Enter the number of sets installed in the premises in the respective column. Maximum four sets may be installed in the premises. To record meter information of 2nd, 3rd and 4th set, a separate CP-137 form is used for each set keeping all other columns blank except meter information columns
-           Total number of supply points must be recorded in the respective column.
-           Enter total number of ACs installed in the premises in the respective column.
-           Meter rent/service rent must be recorded in the respective columns with two decimal points.
-           Enter the National Identity card number of the consumer in the respective column.
-           Five digits transformer code is introduced to each transformer indicating the capacity and serial number. First two digits of the transformer code are indicating the capacity as:-
                                    CODE                             TRANSFORMER CAPACITY   
                        ‘01’                                          10 KV transformer.
                        ‘02’                                          15 KV transformer.
                        ‘03’                                          25 KV transformer.
                        ‘04’                                          50 KV transformer.
                        ‘05’                                          75 KV transformer.
                        ‘06’                                          100 KV transformer.
                        ‘07’                                          150 KV transformer.
                             ‘08’                                          200 KV transformer.
                                    ‘09’                                          400 KV transformer.
                                    ‘10’                                          630 KV transformer.
                                    ‘11’                                          Above 630 KV transformer.

Last three digits are introduced for serial number in each category of the transformer. Serial number must be in odd numbers. (i.e. 001, 003, 005, 007………).
For example 3rd transformer having 75 kv capacity is coded as ‘05005’.
-           Category and line length columns are used only for street light consumers installed under tariff code ‘72’ for the calculation of service rent as:-

 Service rent = line length x line rate.

-           Category indicates the line rate to be charged. Four types of line rate are under operation:-

Under category ‘1’ the rate applicable is Rs.253/- per KM.
Under category ‘2’ the rate applicable is Rs.23/- per KM.
Under category ‘3’ the rate applicable is Rs.158/- per KM.
Under category ‘4’ the rate applicable is Rs.33/- per KM.
                       
Line length is entered in kilometers with two decimal points.
-                      Name, Father’s Name, Address line-1 and address line-II must be written in capital letters and within the limits of 30 columns each.
-                      Meters are identified as “1” for KWH meters, “2” for KVARH meters and “3” for MDI meters.  Meter ID must be entered accordingly.
-                      Enter the number of set for which the information is recorded.
-                      The main/ sub-set code indicates that either meter is main or a sub-set of main meter.  Enter “0” for main meter and “1” for sub-set of main meter.
-                      A valid six digits feeder code must be entered in the feeder code column. The feeder code must be available in the feeder code table under same sub division.
-                      Enter the meter number of the meter installed in 10 digits in the relevant fields.
-                      Location code indicates the location of installed meter.  It must be “O” for outside, “P” for on pole and “I” for inside.
-                      Enter two digits manufacturing code, which indicates the name of the company who has manufactured the installed meter in the respective column.  This code must be from 01 to 33 as per manufacturing code table.
-                      A six digits meter code must be entered in the meter code column. First two digits identify the function of the meter and remaining four digits identify base, volts, phase and wire.
-                      Multiplying factor for KWH and KVARH meters must be entered with two decimal points.  Multiplying factor of MDI meter must be entered with three decimal points.
-                      Enter maximum range of KWH and KVARH meters from “4” to “9” in the respective column.
-                      The reading at the time of installation of KWH and KVARH meters must be recorded as initial reading.
-                      Enter one digit KVARH / KVAH code in the relevant columns as:-

            “1”                   for KVAH meter       
 “2”                  for KVARH meter

-                      Enter re-set number and cumulative MDI reading at which meter is installed. Cumulative MDI reading is recorded with two decimal points.
-                      There is a facility to record 12 months history of current MDI recorded. Enter month as MM-CCYY.  It must always be in descending order.
-                      If transaction type “2” is ticked/ encircled, it means that change in existing information is required. Only that information is filled which is required to be changed.
-                      In change of reference case, new reference number having a valid batch, sub division code and account number must be entered keeping the check digit column blank.
BASIC DATA ADDITION FOR TOD (TIME OF DAY)TARIFFS:-

The Authority has provided the facility of TOD tariff to industrial consumers. Under this tariff two sets are installed in the premises and two different rates are applicable.  From “24” hours of the day, “20” hours are considered as off-peak hours and “04” hours are considered as peak hours.  The energy consumed during off-peak hours is recorded on off-peak meter and energy consumed during peak hours is recorded on peak meter. A lower rate is applied to the units recorded on off-peak meter and a higher rate is applied to the units recorded on peak meter as compared to normal industrial tariff.  The following timings shall be observed as peak and off-peak hours.

SEASON                    PEAK TIMING                    OFF-PEAK TIMING
Dec. to Feb.                   5 PM to  9 PM                         Remaining 20 hours
Mar. to May.                  6 PM to 10 PM                        ----------do-----------
Jun. to Aug.                   7 PM to 11 PM                        ----------do-----------
Sep. to Nov.                   6 PM to 10 PM                        ----------do-----------

Following procedure is adopted for addition of such consumers:-

-                      Tariff code must be entered as:-

 “12”                for B-2 TOD
“14”                 for B-3 TOD
“17”                 for B-4 TOD

-                      Total number of meter sets and supply point must be entered as “2”.  First set is considered as off-peak meter and second set is considered as peak meter.
-                      Meter numbers of KWH, KVARH and MDI meters of both sets are same.
-                      Meter codes of KWH, KVARH and MDI meters must be entered as “50504” in case of off peak set and “50604” in case of peak set.
-                      Multiplying Factor of all the meters (i-e KWH, KVARH and MDI) will be entered with two decimal points.
-                      Present reading of KWH and KVARH meters will be entered with two decimal points, while current MDI reading and Cumulative MDI reading will be recorded with three decimal points.
-                      A separate form of CP-137 will be used to record the information of peak set.
-                      In case of second set (i-e Peak set) meter codes and initial readings are only recorded, while remaining information is considered same as in off-peak set.

CP-140 STREETLIGHT ADDITION/REMOVAL/REPLACEMENT FORM:-

This form is used at the time of addition of a streetlight connection along with CP-137 to record the number of ordinary lamps, tubes, mercury lamps and total wattage information. This form is also used for removal/ replacement of existing streetlights. Following checks are applied to ensure accuracy.

-           The reference number must be same as entered in CP-137 form including check digit.
-           Enter type as “A” for addition of streetlights, “D” for removal of existing streetlights and “R” for replacement of existing streetlights.
-           Wattage must be entered as per following table:-

                        “40”                                                                for tube light
                        “40, 60, 100, 120, 200 and 500”                    for ordinary lamp.
                        “125, 150, 160, 250, 400, 500 and 1000”      for mercury lamp.

-           Enter total number of tubes, ordinary lamps or mercury lamps as installed at the site of connection.
-           Enter total wattage as the sum of wattage of each category. Wattage of each category is calculated by applying following formulae:-

                        Total Wattage  =  Wattage           X            Total number of tubes/
                                                      category                         ordinary lamps/ mercury/ lamps



CP-142 ADVICE OF TRANSFER BETWEEN MDI & GENERAL BATCHES:-

This form is used for transfer of reference numbers from General Master File to Industrial Master File and vice versa as a result of extension/ reduction of load. Following procedure is adopted for filling of data:-

-           Enter a valid reference number (i-e batch number, sub division code, account number and check digit) existing on master file, which is required to be changed.
-           Enter new reference number (i-e new batch number, new sub division code, and new account number) keeping the check digit column blank.
-           Enter a valid tariff code as per nature of connection and sanctioned load.
-           Enter sanctioned load with two decimal points in the respective column.
-           Meter rent/ service rent must be entered with two decimal points in the relevant fields.
-           Installed transformer capacity must be filled in “B-3” connections only.
-           Meter information is recorded as per procedure discussed in the instructions of CP-137 Master Data Addition/ Change Form.
-           For change from General Batches to MDI Batch, fill in complete information of KWH, KVARH and MDI meters.
-           For change from MDI Batch to General Batches, fill in the information of KWH meter only, if it is replaced otherwise leave these columns blank.

 

CP-138 METER DATA CHANGE FORM:-


While filling CP-138 Meter Data Change Form for Replacement, Reconnection, Temporary Disconnection and Permanent Disconnection, following points must be strictly considered:-

-           In case of replacement of single meter of a set (i-e KWH meter, KVARH meter or MDI meter), removed and installed information of that meter must be filled in, which is actually replaced and not for the complete set.
-           In case of reconnection of TDISC consumers installed meter information is not required and all columns after RCO Execution Date must be left blank however in case of reconnection of PDISC consumers, installed meter information of complete set (i-e KWH, KVARH, and MDI meters) is required to be entered.
-           In case of Temporary/ Permanent Disconnection, removed meter information of complete set    (i-e KWH, KVARH and MDI meters) must be entered.

The remaining “filling criteria” for CP-138 of Industrial Consumers is same as in General Consumers.
                     

NTN & GST NUMBER ADDITION/ UPDATION FORM:-


NTN & GST numbers are allotted by the Taxation Department to all the individuals existing on the Tax Net for the purpose of General Sales Tax and Income Tax. At the end of financial year, the amount of General Sales Tax paid through Electricity Bills is required to be adjusted from payable General Sales Tax amount. For this purpose “Allotted General Sales Tax number” printed on the Electricity Bill. A “NTN” & “GST” number file is prepared and used parallel in billing of General & MDI batches. A special input form is used for addition of consumers in this file. Following filling criteria is required to be observed:-

-                      Enter a complete reference number having a valid Batch, Sub Division Code, Account Number and Check Digit.
-                     Name, Father’s/ Husband’s name, Address Line-I and Address Line-II is required to be entered same as on Master File.
-                      National Tax Number and General Sales Tax Number as allotted must be entered in the relevant columns.

All the inputs forms received for this purpose are arranged in the order of sub division and are bundled with the help of tags. Current date is allocated as “Main Date”. After entry of a main date the proof list is obtained from the machine room. This list is edited 100 % from the source data. Corrections/ errors (if any) are got corrected through manual entry. When it is ensured that entered data is 100 % correct as per source data the posting is requested. Two copies of posting report are got printed. 1st copy is retained in the Computer Centre as office record and 2nd copy is sent to field offices. So in this way a consumer is added in the “NTN” & “GST” number file.
ZERO GST DATA ADDITION/ UPDATION:-

There are some Industrial Consumers that falls in the category of “Large Tax Payers”.  These consumers are exempted from GST in electricity bills. The Income Tax Code of such consumers is required to be updated as “4”. This code is entered, listed and posted through a special command file i-e GSTPOST.com. The entry of Batch, Sub Division and Reference number is required. Check digit will be created automatically. GST number in 13 digits is to be entered. The entered GST number is compared with the GST number of GSTNO file. The posting step is executed. If entered GST number and GSTNO file GST number is same, the Income Tax Code will automatically be updated as “4 “.
     
SUPPLY OF PRE-PRINTED METER READING LISTS (INDUSTRIAL) CP-34C TO FIELD OFFICES THROUGH ASSISTANT MANAGERS (CS):-

Two types of pre-printed Meter Reading Lists (CP-34 c) are prepared in the Computer Centres as:

-          For the consumers having sanctioned load up to 500 kw.
-          For the consumers having sanctioned load above 500 kw.

These meter reading lists are supplied to Assistant Managers (Operation) of all sub divisions through Assistant Managers (CS) at least seven days prior to the date of reading or as per Billing Schedule circulated by the Manager Commercial. After recording the meter readings, CP-34 C is received in the Computer Centre through Commercial Superintendents of Assistant Manager’s (C.S) Office. Following checks are performed in the Computer Centre:-

-           A.M. (CS) memo number and date is written on first page of CP-34 C and CP-80.
-           Number of pages/ entries recorded on CP-80 is in accordance with meter reading list CP-34 C.
-           There must be the signature and stamp of A.M. (CS), A.M. (Operation) and Dy: Manager (operation) on each page of CP-34 C.
-           It must be ensured that readings are properly filled in and are legible. There must be no cutting/ overwriting on CP-34 C. If, due to some reasons cutting/ overwriting is accepted, it must be signed by the A.M. (CS)/ A.M. (Operation) concerned.

RECORDING OF READINGS ON METER READING LIST CP-34 C:-

Present reading of KWH/ KVARH meters must be recorded in accordance with their respective ranges. Current MDI reading and Present Cumulative MDI readings are recorded with two decimal points. In case of TOD Tariff, KWH and KVARH readings are recorded with two decimal points while current MDI reading and present Cumulative MDI readings are recorded with three decimal points. Present reading recorded must always be greater than previous reading except in case of replacement, round completion or updation of previous reading through CP-52. Re-set number is must in case where MDI meter is installed. Re-set number recorded must be the next higher to the re-set number of previous month where current MDI reading is recorded. In case where Present Cumulative reading is recorded same as per previous, re-set number of previous month is entered. In new defective cases, the remarks “defective” must be written in the remarks column along with signature and stamp of the A.M. (Operation) concerned. Similarly remarks “OK” must be written against meters erroneously declared as defective along with signatures and stamp of A.M. (Operation) concerned. In all the cases where any one of the KWH or KVARH meter has completed its round, the remarks “Round Complete” must be written in the remarks column. Similarly remarks “ MCO/RCO/TDC/PDC” must be written in the remarks column accordingly against the consumers for which Replacement/Reconnection/Temporary Disconnection/Permanent Disconnection is attached. 

PROCESSING OF CP-34 C & MISCELLANEOUS DATA IN COMPUTER CENTRE:-

            After receipt of MDI reading lists (CP-34 C) and other inputs data from all divisions, the data is entered in the inputs register. The miscellaneous data is arranged transaction type wise at first stage and then in the order of sub division in each transaction. Main date and number of pages are written on the first page of each input.

            Following status codes are entered in red ink in the status code’s columns on MDI Meter Reading List (CP-34 c):-

                        “4”                   for defective meters case.
                        “5”                   for round completion cases.
                        “6”                   for meter replacement cases.
“7”                   for replacement of MDI meters where multiplying factor is  updated and load is charged according to new multiplying factor.
“8”                   for previous defective meters declared as OK.

The MDI meter reading lists (CP-34 C) and miscellaneous data is submitted to data entry section through data movement register.

            After completion of data entry of MDI miscellaneous, proof lists are requested in the machine room. These lists are edited/checked from the source data. Error messages are got cleared. Errors are marked in red ink. All missing entries are also added in the proof lists. Then proof lists are sent to data entry section for correction purpose. After rectification of errors through data entry section, fresh proof lists are obtained from the machine room. This practice is repeated again and again upto 100 % correctness. When it is ensured that all the corrections and missing entries have been entered, the posting of miscellaneous data is requested in the machine room. Two copies of each posting report are got printed. Posting statistics are verified from the source data as well as final and history page of each output. First copy is retained in the office as office record and second copy is separated for dispatch to Assistant Manager’s (C.S) Office s.

METER READING LIST ENTRY & PROOF LISTS:-

            When Meter Reading List (CP-34C) in respect of all divisions is received in Data Entry Section, “Pre-entry file creation” step is to be executed by the Supervisor Data Entry Section.

In this step two types of pre-entry files are created as under:-

-           IBEFMR_B27MCCYYMM-UPTO500KW.dat
-           IBEFMR_B27MCCYYMM-ABOV500KW.dat

 First file is for the consumers having sanctioned load up to 500 kw and second file is for the consumers having sanctioned load above 500 kw. The readings are entered on these files.

CHECKING OF PROOF LIST OF INDUSTRIAL METER READING LIST CP-34C:-

After completion of entry of all Meter Reading Lists, the proof list for the consumers having sanctioned load up to 500 kw and above 500 kw are obtained separately from the machine room. Each Meter Reading list is required to be 100 % checked from meter reading files. Current MDI reading, present cumulative MDI reading, re-set number, present KWH/ KVARH readings and status codes of each reference number must be compared with actual CP-34 C source data. Meter reading list is checked in accordance with “ list of error messages and codes” printed at the end of the list as below:-

ERROR CODE                                 ERROR MESSAGE
            CD                                          MDI status code invalid                                
            CE                                           KVARH status code invalid
            CF                                           KWH status code invalid
            R1                                           Reference number not found on MF
            M1                                           KWH reading invalid
            M3                                           KWH consumption invalid
            M7                                           KVARH reading invalid
            M9                                           KVARH consumption invalid
            MD                                          MDI reading invalid
            MI                                           Supply point number invalid
            MJ                                           Main/ sub-set code invalid
            MK                                          Total number of sub-sets invalid
            ML                                          Total number of main sets invalid                  

PROCESSING & CHECKING OF “ DATA EDITING OF METER CONSUMPTION” LIST (CC EDIT LIST):-

After successful posting of all miscellaneous inputs data and when it is ensured that all proof lists of CP-34 C are 100 % checked and new cc records have been made for new consumers added through CP-137, “cc-edit listing step” is executed. In this step, two types of cc-edit lists named as “Data editing of meter consumption” are printed. First list is for the consumers having sanctioned load up to 500 kw and second list is for the consumers having sanctioned load above 500 kw. At the same time following two consumption files are also created:-

-                      IBCC_B27MCCYYMM-FILE-UPTO500KW.dat
-                      IBCC_B27MCCYYMM-FILE-ABOV500KW.dat

These lists shows the present and previous readings of KWH and KVARH meters along with computed/supplied consumptions in respect of all consumers. These also give current MDI reading, present & previous cumulative MDI readings and load charged to the consumers. Following error messages appear in the lists, which are required to be checked:-

CODE                        MESSAGE TEXT                            ACTION REQUIRED
 
C-19    Consumption KWH missing.              In all such cases consumption must be verified
from the meter reading list and correct consumption be entered in existing cc record.
C-20    Consumption KVARH missing.                     --------- ---do--------------
C-21    KWH supplied consumption                          --------- ---do--------------                                   does not tally with computed                                                                                consumption.
C-22    KVARH consumption supplied                     --------- ---do--------------                                   does not tally with computed                                                                                consumption.
M-39   Replacement code KVARH given     In such cases, check the source data of CP-138.

CODE                        MESSAGE TEXT                            ACTION REQUIRED

without replacement record.               If replacement data is available, replacement record  must   be  got   posted  through   CP-138,
                                                                        otherwise replacement code must be got omitted
 in existing cc record.
M-40   Replacement code KWH given                      --------- ---do--------------          
without replacement record.
M-41   Replacement code MDI given                        --------- ---do--------------
            Without meter replacement.
M-42   Replacement record KVARH                        Confirmation is required from source data of available but code missing.                       CP-138 and replacement code must be entered
in existing cc record.
M-43   Replacement record KWH is                          --------- ---do--------------                      
available without replacement
 code.
M-44   Replacement record MDI is                            --------- ---do--------------
            Available without replacement
code.
M-50   Meter status code KVARH                Confirm from meter reading list and correction invalid.                                            made in existing cc record.
M-51   Meter status code KWH invalid.                    --------- ---do--------------
M-52   Meter status code MDI invalid.                      --------- ---do--------------
M-53   Defective code missing against          Confirmation required from the meter reading 
previous defective KVARH.              list. Defective code must be entered in the
meter.                                                  existing cc record.
M-54   Defective code missing against                      --------- ---do--------------
            previous defective KWH meter.
M-55   Defective code missing against                      --------- ---do--------------
            previous defective MDI meter.
M-56   Defective code given against              In all such cases, confirm the status from meter
previous OK meter (KVARH).          reading list and correction may be done, if it is due to error. Otherwise no action is required 
CODE                        MESSAGE TEXT                            ACTION REQUIRED

M-57   Active code given against                               --------- ---do--------------
previous defective meter
(KVARH).
M-58   Defective code given against                          --------- ---do--------------
            previous OK meter (KWH).
M-59   Active code given against                               --------- ---do--------------
            previous defective KWH meter.
M-60   Defective code given against                          --------- ---do--------------
            previous OK meter (MDI).
M-61   Active code given against                               --------- ---do--------------
            previous defective MDI meter.
R-03    Reading of KVARH meter >             Reading must be confirmed from meter reading
Range.                                                 List. If reading is incorrect then correction of reading is required in existing cc record
                                                            otherwise concerned A.M. (CS) be informed accordingly. 
R-05    Reading of KWH meter >                              --------- ---do--------------
            Range. 
R-15    Present reading of KVARH               Correction of reading is required in existing cc
            meter < previous reading.                   record.
R-16    Present reading of KWH                                --------- ---do--------------
            Meter < previous reading.
R-17    Present reading of new KVARH       In such cases correction of reading is required
meter < initial reading.                        in existing cc record after confirmation from
(Replacement record).                         reading list and replacement data CP-138.
R-18    Present reading of new KVARH                   --------- ---do--------------
            Meter > range. (Replacement
record).           
R-19    Present reading of new KWH                                    --------- ---do--------------
            Meter  <  initial reading.
            (Replacement record).
CODE                        MESSAGE TEXT                            ACTION REQUIRED

R-20    Present reading of new KWH                                    --------- ---do--------------
            Meter > range. (Replacement
record).           

            Some other abbreviations such as “MPC” and “MRN” are also printed as message in these lists. “MPC” indicates that current MDI reading entered is not the difference of present and previous cumulative MDI readings. The reading of MDI meter is verified from respective “meter reading list (CP-34 C source data)” and correction is marked if so required. The term “MRN” indicates that re-set number given is not in accordance with the re-set number of previous month. (i-e It must be the next higher to the previous month.)  It must be verified from the respective meter reading list as well as assessment list of previous month and correction must be done in the cc record.

            After going through both cc data listings, all marked corrections are entered in the existing cc records through manual entry in meter reading entry file. After making corrections, fresh cc data listings are requested in the machine room and this practice is repeated again and again up to 100 % correctness. The OK lists of “ Data editing of meter consumption” are retained as office record and are used in further checking of MDI billing.

NOTE:-
Whenever an existing cc record is updated due to any reason for any category of consumer i-e (either up to 500 kw or above 500 kw) and cc edit listing step of any category is repeated, the merging step must be repeated for creation of new/updated consumption file.

MERGING OF CC FILES:-

            In this step latest version of CC files i-e “IBCC_B27MCCYYMM-FILE-UPTO500KW.dat” and “IBCC_B27MCCYYMM-FILE-ABOV500KW.dat” are merged in to a single consumption file named as “IBCC_B27MCCYYMM-FILE.dat”. This file is used as main consumption file in billing.

PROCESSING OF RFB CREATION & LEDGER LISTING CP-88 L:-

After posting of all miscellaneous inputs relating to MDI batch on Industrial Master File, RFB creation step is executed. In this step MDI ledger listing is processed and printed along with creation of RFB File. This RFB file is used as master file in billing step. Ledger listing (CP-88 L) of MDI consumers shows the tariff codes, opening balance, net/gross payable amount, payments along with bank codes & payment dates, surcharge levied, unpaid debt, set-aside and component wise up to date outstanding balance of each industrial consumer. Following checks are implemented to ensure accuracy:

-           Check the billing month of ledger listing as previous billing month.
-           Last month due date must be verified from the billing schedule of previous month.
-           There must be no “$” against any consumer in ledger listing. If there is any consumer with “$”, It indicates that there is a problem in the balancing. Find out the reason of “$” by using following formulae and make the remedy.
Closing balance = Net + Surcharge levied – Payment
Or
Closing balance = Net + Surcharge levied – (payment, unpaid debt, set-aside)
-           Cash considered dates must be verified as under:
Cash considered from = Cash posted date of previous month
Cash considered to = Cash posted date of current month
-           Dates must be printed as DD-MM-CCYY
-           Total cash posted on MDI ledger listing must be equal to the total industrial cash posted in between the previous month MDI restore step and current month MDI ledger processing.
-           Set-aside and unpaid debt amounts of ledger listing must be checked as under:
Set-aside amount on CP-88 L = Previous month set-aside + Total advices
    posted during the month – Total with-drawl
    posted during the month
Unpaid debt amount on CP-88 L = Unpaid debt on previous month CP-88 A +
         Total MDI installments posted during the
         month.

PROCESSING OF INDUSTRIAL BILLING:-

When it is ensured that Ledger Listing is 100 % correct in all respects, MDI billing is requested in the machine room.

Industrial Billing is processed as per normal operational procedure by using main consumption file “IBCC_B27MCCYYMM-FILE.dat” and “RFB-FILE.dat” along with other input files and tables required in billing step.      KIOSK file and PC files are generated in the billing step along with other files.

KIOSK file created in the Industrial Billing Step is transferred to PC through FTP and loaded on the website of NADRA and other Commercial Banks providing on-line cash transfer facility to WAPDA Computer Centers.

Following PC files are generated in the billing steps for printing of bills on Laser Printers.
                       
-                      Industrial Billing Main File.
-                      Industrial Billing Meter File.
-                      History File.
-                      DCN File.
-                      Detection Bill File.

These files are transferred to PC through FTP and uploaded for printing of bills on
Laser printer.

            NOTE:-
Same Sub Division Table, Feeder Table, Tariff Table and GSTNO File are used in printing of General as well as Industrial Bills on Laser Printers.



CHECKING OF INDUSTRIAL BILLS AND ALLIED OUTPUTs:-

            Following outputs are received from the machine room after MDI billing.

-                       MDI bills
-                       Detection bills
-                       Billing exception list CP-87
-                       Assessment list CP-88 A
-                       Disconnection notices
-                       List of consumers issued DCNs CP-112
-                       Heavy and credit balances list CP-89
-                       Defective meter list
-                       KVARH < KWH list
-                       Master file list

MDI BILLs:-

MDI bills are required to be checked very carefully before dispatch to field offices. Following checks are must to ensure the accuracy of billing:

-           It is ensured that complete bills are received from the machine room.
-           Quality of printing is satisfactory.
-           It is ensured that all fields are printed in the proper columns.
-           Check billing month, date of reading, issue date of bills and due date of bills from the current month billing schedule. These dates must be in accordance with the billing schedule.
-           Check all the bills of new consumers billed for the first time.
-           Check all the bills where reconnection and disconnection (temporary/ permanent) is affected.
-           Check at least one bill of each tariff and category to ensure proper application of tariff.
-           Random cases of all miscellaneous inputs such as bill adjustment, disconnections, reconnections, court order’s cases, installments, changes and additions must be checked.
-           Electricity duty and other rates of all the tariffs must be checked.
-           Income tax amount of few consumers must be verified from income tax table

TYPES OF ELECTRICITY BILLS:-

Following types of bills are normally issued to the consumers.

NORMAL BILLS:-

 These are the bills, issued to the consumers under normal conditions. The consumers are billed for the consumption of current month as per normal billing procedure.

DISCONNECTION NOTICE BILLS:-

Consumers, who have not paid the bills of previous month and having arrear amount above Rs. 500/-, are issued disconnection notice bills on special bill forms. Disconnection notice is pre-printed on such forms. Through this notice prompt payment is requested.

FIRST BILL FROM DATE OF CONNECTION:-

First bill is issued to the new consumers by taking into account the date of connection and the date of meter reading. The first bill may have the consumption of more than one month when forwarding of basic data to computer centers has been delayed (If billing period exceeds 34 days). So consumption is proportionately divided and billed if it exceeds one month. Average monthly consumption is calculated by dividing total consumption by total period of bill. Average Variable Charges are calculated on the basis of average monthly consumption in respect to tariff rates of that period and is compared to minimum charges. Income tax is calculated on the basis of total bill. The date of connection is also printed on the bill.

RECONNECTION BILL:-

Reconnection bill is always issued on the basis of date of reconnection and date of meter reading. Billing period is calculated in months according to the date of reconnection and date of meter reading. The reconnection date is also printed on the bills. The calculation treatment is the same as in case of first bill.

FINAL BILL UP TO DISCONNECTION:-

At the time of execution of permanent disconnection, meter reading is intimated and a final bill upto disconnection is prepared and issued to the consumer as per applicable tariff.

ESTIMATED BILLS:-

Estimated bills are issued in case where it is not possible to record correct meter reading as in case of defective meters. In such cases, estimated consumption is worked out as below.

Average consumption is calculated for previous “11” months and is compared to corresponding month consumption of previous year. The higher of the two consumptions is charged for calculation of estimated bills.

MDI DETECTION BILLs:-

MDI detection bills must be 100 % checked from the source data of CP-52. It must be ensured that complete bills are printed, for which detection adjustments are posted. Check the billing month, issue date and due date of detection bills as per billing schedule.


BILLING EXCEPTION LIST CP-87:-

Checking criteria of billing exception list “CP-87” of MDI batch is same as in general billing. Only one additional message, i-e current MDI reading is not equal to the difference of present cumulative MDI reading and previous cumulative MDI reading, is printed. This message is printed for the attention of field offices and no action is required by computer centre.

ASSESSMENT LIST CP-88 A:-

Assessment list is a true picture of bills issued to the consumers. It shows type/ status, standard classification code, tariff, minimum load, sanctioned load, date of connection, multiplying factor, present reading, consumption, billable units, component wise opening balance, opening subsidies balance (Tariff & GST), opening agency amount, seasonal period, power factor, component wise assessment, current subsidies (Tariff & GST), agency amount, component wise bill adjustment, current installment, net, late payment surcharge, gross amount payable, unpaid debt, set-aside, previous & present cumulative MDI readings, re-set number, name and address of each consumer. Check the billing month, date of reading, issue date and due date printed on assessment list from the billing schedule of current month. Components of bill printed in the assessment list are as under:-

UNITS (KWH, KVARH):-

  It is the difference of present and previous readings.

UNITS CONSUMED/ BILLABLE UNITS:-

It is the sum of units appearing against each meter of a consumer.

VARIABLE CHARGES:-

It is the cost of energy consumed by a consumer. It is calculated as:

Units consumed X Rate per unit

LOAD CHARGED:-

 It is the load, which is to be charged for calculation of fix charges. Under normal conditions load charged means the load calculated as under:

Current MDI reading X Multiplying factor
           
However in cases where MDI meters are declared as defective, load charged is considered as the highest of the following:
 
a):-  Current MDI reading X Multiplying factor
b):-  50 % of sanctioned load

For D tariffs sanctioned load is considered as charged load

FIX CHARGES:-

Fix charges are calculated as under:

Load charged X Rate per KW

ELECTRICITY DUTY:-

In this column, the duty, which is collected from the consumers and is payable to Provincial Governments, is printed. The rate of ED is different in each province. ED is calculated on the basis of variable charges. Some consumers such as charitable institutions, mosques etc and some Government consumers are exempted from electricity duty.

In Punjab the rates of ED are as under:

1.5 % of variable charges        from tariff “01”, “03”, “04”, “05”, “06”, “73”, “76” and “79”.
1 % of variable charges           from all other connections.

For seasonal connection ED is calculated as under:
Energy charges X 125/100 X Rate
METER RENT:-

Meter rent is printed on the bill as per Master File information.

SERVICE RENT:-

Service rent is also printed on the bill as per Master File information. For streetlight connections it is a part of energy charges and is calculated as under:

Line length X Line rate

POWER FACTOR & LOW POWER FACTOR PENLTY:-

Average power factor of a consumer at the point of supply shall not be less than 90 %. A penalty is charged when power factor of a consumer falls below 0.90. Power factor is calculated by using following formulae:-

P.F  =
 
            KWH Units Charged
            Ö (KWH Units)2 + (KVARH Units) 2

Low Power factor penalty is calculated by using following formulae:-

    Low Power Factor penalty =         (0.90 – P.F) X 2 X Rate of fix charges X
            Current MDI load supplied.



GST SUBSIDY:-

GST subsidy is granted to the domestic residential consumers having monthly consumption less than 100 units and agricultural tube well connections. GST calculated in the bills of such consumers is kept aside as GST Subsidy in the assessment and is being payable by Govt. of Pakistan to all DISCOS.

SEASONAL CHARGES:-

Seasonal charges are collected from the consumers having seasonal connections. Seasonal charges are calculated on the basis of 25 % of supply charges as:

(Variable charges + Fix charges + NJ Surcharge + LPF Penalty) X  25 / 100

INCOME TAX:-

Income tax is received from all commercial and industrial consumers except those consumers who are exempted from Income Tax, on the basis of “Taxable Amount” as per Income Tax Table amended from time to time. “Taxable Amount” is calculated as under:
           
                        =          Variable charges + Fix charges + LPF Penalty
                                    Meter Rent + Service Rent + Seasonal Charges

            If “Taxable Amount” exceeds Rs. 20,000/-, then “Income Tax Table” is not considered and income tax is calculated @ of 10 % of “Taxable Amount”.     

GENERAL SALES TAX (GST):-

General sales tax is also received from all the consumers on the basis of total bill excluding income tax and NJSUR amount and is calculated as:

(Variable charges + Fix charges + ED + Meter rent
 + Service rent + LPF Penalty + Seasonal charges)    X  (16 / 100)

INSTALLMENT AMOUNT:-

In this column, current month installment amount is printed, which is being included in the bill.

BILL ADJUSTMENT:-
 
In this column total of all type of adjustments is printed. Bill Adjustment amount is the part of Current Assessment.  This may either be debit or credit.
 
ARREAR:-
 
 This is the amount of previous bills, which is unpaid and has been included in the current bill.
 
AMOUNT PAYABLE WITHIN DUE DATE:-
 
This is the net amount of the bill and is the total of all components.
 
LATE PAYMENT SURCHARGE:-
 
If a consumer does not pay the bill with in due date or part payment is made by the consumer a 10 % surcharge is levied on the amount payable and is called as late payment surcharge (L.P. Surcharge). LP Surcharge is calculated @ of 10 % of Variable Charges, Fix Charges, LPF Penlty and NJSUR.
 
AMOUNT PAYABLE AFTER DUE DATE:-
 
In this column the gross amount, which is the sum of amount payable within due date and late payment surcharge is printed and is payable after due date.

UNPAID DEBT:-

It is the sum of the remaining installments to be recovered from the consumer in subsequent months.
 
AMOUNT SET -ASIDE:-
 
This is the disputed amount set-aside by some court or departmental orders and has not been included in the current bill.

The statistics printed at the last page of assessment list must also be checked as under.

-           Opening balance of CP-88 A must be equal to the closing balance of CP-88 L.
-           Amount paid printed on CP-88 A must be equal to the total payment amount of CP-88 L.
-           Adjusted units and amount must be equal to the sum of current month CP-52 posted and remaining detections of previous month.
-           Set-aside amount of CP-88 A must be equal to the deferred amount of CP-88 L.
-           (Current installment amount + Unpaid debt amount) of CP-88 A must be equal to the unpaid debt amount of CP-88 L.
-           Units billed KWH & KVARH and MDI load charged of CP-88 A must be verified from OK “Data editing of meter consumption” list.
-           There must be no consumer on CP-88 A with “$” sign. If there is any “$” sign in the assessment, It shows that there is any problem in the billing of that consumer. Calculation of bill in such cases must be checked. The assessment list will be dispatched only after clearing the “$” sign.
  
DISCONNECTION NOTICES:-

All the industrial consumers, who have not paid the bills of previous month and having arrears, are issued disconnection notices printed on special forms. Notice for disconnection is printed on the forms. Check the billing month, date of reading, issue date and due date of DCNs from current month billing schedule.


LIST OF CONSUMERS ISSUED DCNs (CP-112):-

It is the list of all those consumers who are issued DCNs. Check the billing month printed on the list. The statistics ( i-e Total number of DCNs ) must be verified from the serial number of last DCN bill.

RESTORE STEP:-


When the industrial billing is 100 % checked and found satisfactory, assessment restore step is processed. In this step status of master file is updated by restoring assess-out file on master file. As a result of this step, a list named as restore list, is printed and checked in the following way:-

-           Billing month printed on the list must be verified.
-           Verify the due date from current month billing schedule.
-           Total number of records on restore list must be equal to the total number of consumers on assessment list.
-           Total amount restored must be equal to the net amount/ closing balance printed on assessment list.
-           Processing date and time must also be verified.

Note:-            Posting of cash or any other miscellaneous input data is not allowed after
                        the processing of ledger and before the restore step.

POST BILLING STEPS:-

            After successful execution step, following post billing lists are got processed and printed and checked to ensure the accuracy of MDI Billing.

HEAVY & CREDIT BALANCES LIST CP-89:-

This is the list of all those consumers, who are issued the bills of heavy amounts. Check the billing month printed on the list. Verify the closing balances of few consumers from assessment list. In MDI billing it is the part of post-billing step and processed after the restore step.
DEFECTIVE METER LIST:-

            This is the list of all those consumers, who are issued bills on estimated readings due to defective meters. Check the billing month printed on the list. The status of such consumers must be verified from the meter reading list.

KVARH < KWH LIST:-

This is the list of all such consumers having KVARH consumption less than KWH consumption. Verify the consumption of few consumers from “Data editing of meter consumption” list.

MASTER FILE LIST:-



This is a list of Master File, which shows the up to date status in respect of each consumer. Verify the changes and additions posted through master data addition/ change form (CP-137). Check the billing month printed on the list.
WAPDA EMPLOYEES DEPARTMENTAL BILLING

When all the batches of General Billing have been billed, miscellaneous inputs (i.e; CP-52, CP-138 and CP- 139) received during the month have been posted and cash of the last date of month have also been posted, WAPDA Employees Departmental Billing steps are performed. These steps include the billing of WAPDA employees departments. For this purpose, a unique code number is assigned to each WAPDA Employees Drawing and Disbursing officer. These steps are as below.

ASSESSMENT POSTING FILE CREATION:-

The first step executed in WAPDA employees departmental billing, is called as assessment posting file creation. In this step an output file having the information like WAPDA employees consumption of free units, balance units, credit amount etc, is created. This file is further used for departmental billing of batch number “99”. At the completion of this step a list is printed, which shows the successful completion of this step with a summary of records posted. Following checks are implemented to ensure accuracy.

-           Check the billing month printed in the list.
-           Total records printed in this list must be greater than the total of WAPDA employees appearing in the last pages of assessment lists of batches (01 to 21). (i-e from assessment register).

RETRIEVAL AND PROOF LISTING OF DEPARTMENTAL ADJUSTMENTS POSTED THROUGH CP-52:-

            All the adjustments posted through CP- 052, under card type “ W ” against all Drawing & Disbursing officers during the month, are retrieved. These adjustments may either be debit or credit. A list of these adjustments along with drawing & disbursing codes is printed. Totals printed at the end of the list must be equal to the totals of adjustments posted against drawing & disbursing officers as per bill adjustment register.


WAPDA EMPLOYEES FREE ELECTRICITY SUMMARY OF ALLOWANCES BY BATCHES (CP-92):-

            This list reflects the batch wise total free units consumed by WAPDA employees and credit amount in respect of these units. This list is printed sub division wise. Following checks are implemented.

-           Check the billing month printed in the list.
-           Total free units printed on this list must be equal to the total of WAPDA employees units recorded batch wise in assessment register.
-           Total amount of this list must be equal to the total credit amount (batch 01 to 21) as recorded in assessment register.

ASSESSMENT LIST OF WAPDA EMPLOYEES (RFB):-

            In this step the current month assessment posted file and current month department file is used. A new file named as  “W/E RFB.” is created. A detail list is printed department wise with in a sub division along with “posted un-posted bill adjustment list”. Divisions and circle totals are also printed. This list shows previous month closing balance, previous month payments posted, current month opening balance, units, assessment, adjustment and Closing balance at the end of the month. This list also gives component wise current assessment. This is the most important list created in WAPDA Employees Departmental Billing. Following checks are implemented.

-           Check the billing month printed in the list.
-           Previous closing balance printed in this list must be equal to the closing balance from previous month assessment.
-           Payments must be verified from the payments of last month CP–91 A (Free Electricity Assessment Summary)
-           Current month opening balance  =  Previous closing balance -  Previous month
         payments
-           Current month closing balance  =  Opening balance + Assessment  (+ or -)
      Adjustments.
-           Total (posted  + un-posted) adjustments  =  Total of proof list of CP- 93 A
-           Posted adjustment of Assessment  =  posted adjustment of “posted un-posted list”.
-           Units printed in W/E assessment  =  Total Free units recorded in assessment
-                                 register.
-           Total assessment  =  Total credit amount (batch 01 to 21) as recorded in the
          assessment register.

WAPDA EMPLOYEES RESTORE:-

            After successful completion of all above steps, the restore of WAPDA employees department file is performed. It must be ensured that the restore step has been proceeded successfully and no record has been rejected. Following checks are implemented to ensure accuracy.

-           Check the billing month printed in the list
-           Total record in restore list = Total record in assessment list.

WAPDA EMPLOYEES FREE ELECTRICITY ASSESSMENT SUMMARY (CP-91):-

            In this report the detail of each WAPDA employee i-e, reference number, free units consumed, balance units, name of WAPDA employee and the amount credited and posted as payment, is listed for each department in a particular division.. Following checks are implemented to ensure validity.

-           Check the billing month printed in the list.
-           Total employees, units charged and amount must be reconciled with the total WAPDA employees, free units and credit amount of all batches recorded from last pages of CP-88 A of general billing.

DEPARTMENT WISE PAYMENT POSTED LIST (SP-WE):-

            This is a special report, which shows opening balance, adjustment, current assessment, net and payment posted against each department in a division. Four digits department code is converted in to complete reference number having batch as “ 99” in each sub division. Two zeros are added in the left side, one zero is added on the right side and check digit is calculated accordingly. Following checks are performed.

-           Check the billing month printed in the list
-           Opening balance, adjustment, current assessment and net printed in SPWE list must be verified from W/E assessment (CP- 88).
-           Payment must be verified from CP–91 A report. This payment is appeared as WAPDA Employees IOT in CP-110 and other monthly outputs.
























DEAD DEFAULTER BILLING BATCH NO. “26”


            When the connection of a consumer is permanently disconnected and the equipment installed is removed due to non-payment or on consumer’s own request, arrear bill is issued to the consumer. If this arrear bill remains un-paid for a period of three years, the consumer is declared as dead defaulter. The security paid by the consumer is adjusted against arrear and consumer is shifted in the dead defaulter batch i-.e,  (batch number 26). The billing of batch number 26 is called as “Dead Defaulter’s” billing and is processed just before the start of monthly steps. Following steps are performed in the dead defaulter billing.
  
LEDGER LISTING & RFB CREATION:-

            In this step RFB File is created which is used for onward billing steps. Ledger listing is printed in this step. Following checks are implemented.

-           Check the billing month of the ledger listing as previous month.
-           Component wise closing balance must be compared to the component wise opening balance of assessment list.

BILLING & ASSESS-OUT FILE CREATION:-

The second step is the processing of billing of batch 26. An out-put file called as “ASSESS-OUT FILE” is created as a result of billing.

PRINTING OF ASSESSMENT LIST (CP- 88 A):-

In this step assessment list is printed. This list is required to be 100 % checked in the following ways.

-           Check the billing month printed in the list as current billing month.
-           Total number of records in CP- 88 A must be equal to the total number of records in CP- 88 L.
-           Component wise opening balance in CP-88 A must be equal to the component wise closing balance of CP- 88 L.
-           Set-aside amount of CP- 88 A must be verified from deferred amount in CP- 88 L.
-           Total adjusted units and amount appearing in CP-88 A must be equal to the total adjusted units and amount of batch number 26 as recorded in the bill adjustment register.
-           Total Assessment        =          Total Bill Adjustment Amount

NOTE:-          There must be no  “$” sign in CP- 88 L OR CP- 88 A. If  “$” sign is appearing in CP-88 A or CP-88 L, balance or billing computation of reference number with “$” sign must be manually verified and needful must be done if so required under the intimation of Dy: Manager (CO) and Dy : Manager (P/SA).

RESTORE ON MASTER FILE:-

            After Successful completion of billing steps of Batch No.26, when it is ensured that billing is 100 % correct and accurate, the restore step is executed. In this step assess- out file is restored on master file in order to update the status of master file. A restore list is printed. Following checks are implemented.

-           Check the billing month printed in the list
-           Verify the total number of records printed in the restore list from assessment list.
-           Total restored amount must be equal to the net amount printed in assessment list    CP- 88 A.



PROCESSING OF MONTHLY REPORTS.

            After successful completion of bills of all batches, posting of all miscellaneous inputs data, complete cash posting of all dates and successful completion of WAPDA employee departmental billing and dead defaulter’s billing, monthly statistical file is generated to process month end reports. These reports are considered to be very important and are used for accountability of performances at different level. Following special steps are required to be run before generating statistical files.

MONTHLY BILL ADJUSTMENT POSTED LIST (CP-88 S):-

            All the “after billing adjustments” are accumulated in monthly reports except “after billing detection adjustments” posted under card types “C, D, and E”. These adjustments are processed at month end and as a result, a list named as CP–88 S, is printed. This list reflects the units adjusted, component wise amount adjusted, and closing balance before and after the posting of adjustments in respect of each consumer. This list is printed batch wise in each sub division. An abstract of above information is also printed at sub division, division and Circle level. Following checks are implemented to ensure the accuracy.

-           Check the billing month printed in the list.
-           Circle totals, i-.e number of records, units adjusted and amount adjusted in respect of each batch must be verified from the totals of “remaining adjustment (normal)” as recorded batch wise in the bill adjustment register, after addition of PTV Fee adjusted through CP-52 T and subtraction of W105 adjustment in the following ways:

a)         Units adjusted of each   =   Normal unit adjusted of each batch from
batch (CP-88 S)                  adjustment register    
b)                  Amount adjusted of each =  Normal amount adjusted of each batch  +  After batch (CP- 88 S)                 billing PTV fee adjusted through CP-52 T of
each batch  - W105 adjustment created.
 

SCARP IOT POSTING:-

A Special procedure has been introduced for the payment of electricity dues against scarp tube-wells of provincial Government. In this step total outstanding amount against scarp connections is retrieved and posted as IOT payments on the master file. The amount posted in this step is adjusted out of the electricity duty payable to Provincial Government. The following reports are printed.

-           Single page summary of amount retrieved.
-           Page showing posted statistics.
-           Reference number wise list of scarp tube wells.

Check the billing month printed in these lists. Total amount printed in above lists must be same.

POSTING OF PAYMENTS AT SOURCE (Adjuster):-

            Some Government departments (Federal as well as provincial) pay their electricity bill through adjuster. These payments are called as “at source payment”. The adjuster files are prepared at WAPDA Computer Centres (HQ) WAPDA House Lahore at the format of CP-139 entry file i-e “X139TEF1.dat”. The payments are posted on computer master file as   IOT under special Adjustment Note number and bank codes as “80000”, “82000”, “90000” and “92000”. The “at source payment” of each department is distributed among its electricity connections throughout the country on the basis of last month outstanding amount as appeared in the previous month Master Files (General & Industrial) of each DISCO available at WCC, (HQ) Lahore. Then these adjuster entry files are sent to the regional computer centers of all DISCOs. At regional computer centers these files are sorted Circle-wise and are sent to circle computer centers for onward posting on master file of current month. The adjuster payments are posted before the processing of weekly cash reports of last week ending. These payments must be posted 100 % and it is ensured that no record of adjuster is rejected. Any error message (if appearing) must be got cleared as per normal procedure of CP-139. In case of change of reference, old reference number is required to be corrected by new reference number. Adjuster amount cannot be posted against consumer appearing in Batch number 26. In such cases the said amount is posted against any other reference of same department.  When a consumer is converted from Government to private, the adjuster amount is posted against any other reference of same department.
 
POSTING OF PAYMENT MADE BY GOVERNMENT OF PAKISTAN AGAINST SUBSIDY (GOP PAYMENTS:-

            Government of Pakistan is providing subsidy for GST calculated in the electricity bills of following consumers:-

-           Residential consumers falling under tariff A-1 having monthly consumption up to 100 units.
-           Agricultural Tube wells falling under tariff D-2 (i).

When Government of Pakistan make some payments against GST subsidy amount, Company wise sharing of this amount is done on the basis of outstanding subsidy amount existing on the Master Files of previous month available at WAPDA Computer Centres (HQ) WAPDA House Lahore and Company wise share files are sent to Regional Computer Centres. At Regional Computer Centres, share files of all Computer Centres are created and newly created share file along with a list indicating the GOP Subsidy payment of each circle is sent to each Computer Centre of the DISCO.

            The step-wise posting procedure of GOP payment is as under:

SHARE FILE UPDATION:-

                        
In this step GST Subsidy Receivables are updated on share file as per current Master File. A single page statistical list reflecting the up-to date GST Subsidy receivable amount is also printed in this step.

 

 



GST SUBSIDY FILE CREATION:-


In this step, the payment received against GST Subsidy Receivables, is shared consumer-wise by using updated share file and current Master File. A payment retrieval file is created as a result of this step.

GST SUBSIDY PAYMENT FILE LISTING:-


The payment retrieval file created in the above step is sorted and listed in this step. The payment shown in this list must be equal to the amount appearing in the list of share file received from WCC, (HQ), Lahore.

GST SUBSIDY POSTING ON MASTER FILE:-


In this step, the payment shown in the payment retrieval file is posted on General as well as Industrial Master File of current month. A payment summary file is created in this step and is required to be merged in the monthly PSUM-MERG-MMCCYY.dat before sorting step.

 

SPECIAL CP-135 LISTING:-


In this step, a special listing at the pattern of monthlyCP-135 is printed from payment summary. This list reflects the sub division wise amount posted against GST Subsidy. The total amount of special CP-135 must be equal to the payment shown in the list of share file received from WCC, (HQ), Lahore.
 
INVALID FEEDER STEP:-

In this step a list is printed showing all reference numbers added on master file with invalid feeders. A feeder is said to be invalid if it does not exist in feeder table under same sub division code. Feeder codes of such consumers must be updated according to the sub division code. After updation this step is repeated. Before starting the month end proceedings, this list must be printed with nil reference number.

EXECUTION OF MONTHLY STATISTICAL FILE


            After completion of steps mentioned above, monthly statistical file creation step, generally known as “Total File” step, is executed. In this step opening balance, current assessment, closing balance and all other allied information in respect of all the consumers existing on master file are added up. All month end reports are based on total file generated in this step.

Contents of each monthly report and checks implemented are given below.

 

FEEDER WISE UNITS BILLED LIST (CP-94): -


            This report is printed sub division wise and reflects the total connected load and net units billed in respect of each feeder. Following checks are implemented to check this report.

-           Check the billing month printed in the List
-           Units sold of CP-94 = Units billed (General & MDI) + Units adjusted (General&
 MDI) as per assessment register & CP-88 S
-           Units sold of CP-94 = Units billed (CP-95) + Units adjusted (CP-95)
-           Total load of CP-94     =      Total load of CP- 95

BILLING SUMMARY (CP- 95):-


            This report is generated from total file and reflects the component wise billing, adjustment and balances. In CP-95 all batches of each sub division are displayed with full information added batch wise. Tariff wise summary of each sub division is displayed along with the additional summaries of bill adjustment and balances. All these summaries are added at division, circle and region level. Following Checks are performed.

-           Check the billing month printed in the list
-           Total number of consumer      (i)         =          Total number of consumer in
of  CP-95 (Billing Summary)                          CP-110 and CP-41
(ii)        >          Total number of consumer of all
                                    batches (i-e batch 01 to 21, 26 & 27) 
-           Total Sanctioned Load           =                      Total Connected Load of CP-94
(Rounded) of CP-95
(Billing Summary)            
-           Unit billed of CP- 95              =                      Total units billed of all batches.
(Billing Summary)                                           (Batch 01 to 21,26 & 27)
-           Total NJSUR of CP-95           =                      Total NJSUR of all batches
(Billing Summary)                                           (batch 01 to 21, 26,27 & 99 )
-           Total Variable Charges of       =                      Total Variable Charges all batches
CP-95 (Billing Summary)                               (batch 01 to 21, 26 27 & 99)
-           Total Fix charges of               =                      Total Fix charges of all batches
CP-95 (Billing Summary)                               (batch 01 to 21, 26 & 27)
-           Total PF. penalty of                =                      Total PF. penalty of batch No. 27.
CP-95 (Billing Summary)                              
-           Total season charges of           =                      Total season charges of batch No. 27.                                                              
CP-95 (Billing Summary)                              
-           Total meter rent of CP-95      =                      Total meter rent of all batches
(Billing Summary)                                           (batch 01 to 21, 26 ,27)
-           Total service rent of CP-95    =                      Total service rent of all batches
(Billing Summary)                                           (batch 01 to 21, 26 ,27)
-           Total ED of CP-95                  =                      Total ED of all batches
(Billing Summary)                                          (batch 01 to 21, 26 ,27)
-           Total adjustment amount of    =                     Total Adjustment amount of all
CP-95 (Billing Summary)                               batches (batch 01 to 21, 26, 27 & 99)
+  CP-88 S adjustment amount + GST Subsidies adjustment of CP-88 S  + Others Subsidies adjustment of CP-88 S           
-           Surcharge levied of CP-95      =                      Surcharge levied of total file list,
(Billing Summary)                                           CP-109 and CP-110
-           Total PTV Fee of CP-95         =                      Total PTV Fee of all batches
(Billing Summary)                                           (batch 01 to 21, 26 & 27 )
-           Total GST of CP-95                =                      Total GST of all batches
(Billing Summary)                                           (batch 01 to 21, 26 ,27 & 99 )
-           Total income tax of CP-95      =                      Total income tax of all batches
(Billing Summary)                                           (batch 01 to 21, 26 & 27 )
-           Total Rounded factor of         =                      Total rounded factor of all batches
            CP-95 (Billing Summary)                               (batch 01 to 21, 26 & 27) + CP-88 S
-           Total units adjusted of            =                      Total units adjusted of all batches
CP-95 (Billing Summary)                               (batch 01 to 21, 26, 27) + Units
(Bill Adjustment Pages)                                  adjusted in CP-88 S
-           Total assessment of                 =                      Total assessment of all batches
CP-95  -  Surcharge levied                              (batch 01 to 21, 26, 27 & 99) 
+  Bill adjustment batch 99
 + Bill adjustment CP-88 S
 + GST Subsidy adjustment of CP-88 S
+ Other Subsidy adjustment of CP-88 S - round factor of CP-88 S - current installment MDI
-           Total assessment of                 =                      Net assessment of CP-110 list
CP-95  -  Surcharge levied                               

 

SURCHARGE SUMMARY BY BATCHES (CP-109): -


This list reflects the batch wise amount of surcharge levied at sub division and division level. Following checks are performed.
-           Check the month end printed in the list.
-           Total amount of surcharge levied of this report must be verified from total file list, CP-95 and CP-110.

OUTSTANDING EQUIPMENT REMOVAL ORDER LIST (CP-114):-

This is the list of those consumers who are issued equipment removal orders but remained un-actioned for a period of more than 67 days. Following Checks are performed.
-           Check the month end printed in the list.
-           Check random cases, where CP-138 for permanent disconnection is posted to ensure that these reference numbers are not appearing in CP-114 list.
-           Total number of outstanding EROs in CP-114 list must be equal to the total number of consumers printed in CP-114 A report.
-           Total outstanding amount on CP-114 list must be equal to the total outstanding amount on CP-114 A.

 

SUMMARY OF OUTSTANDING EQUIPMENT REMOVAL ORDER (CP-114-A):-

 

            This is the division wise summary of consumers appearing in CP-114 list. This list reflects the number of consumers and total outstanding amount in respect of each division. Following checks are implemented.
-           Check the total number of consumers and outstanding amount from the totals of
CP-114 list.
-           Check the month end printed in the list.

NOTE:-          CP-114 list is printed separate for Government and Private consumers. A combine list of CP-114 is also printed.

 

AGE ANALYSIS REPORT OF BILLING EXCEPTIONS (CP-87 A):-


It is an abstract of CP-87 containing age analysis of billing exceptions generated from batch wise billing exceptions during last month. The total count of consumers against each type of exception is listed at sub division/ division/circle and region level. Following checks are performed.
-           Check the billing month printed in the list.
-           Statistics of all exceptions in CP-87 of all batches should be confirmed with statistics of CP-87 A appearing at sub division / division level.

 

AGE ANALYSIS OF CASES OF ESTIMATED READINGS (CP- 90 A):-


            It is an age analysis monthly report of cases billed on estimated reading. This list is generated from batch wise billing of all batches processed during last year or more. It gives tariff wise detail of defective and lock cases with in sub division. Following checks are performed.
-           Check the billing month printed in the list.
-           Total number of records must be verified from reference number wise list CP-90.
-           Volume of CP-90 A should be compared to volume of previous month CP-90 A.
 
LIST OF CONSUMERS BILLED ON ESTIMATED READING (CP-90):-

This is the reference number wise list of all those consumers billed on estimated reading due to defective meters. This list is printed for the monitoring of field staff. Following checks are implemented.
-           Check the month end printed in the list.
-           Total number of consumers printed in the list must be equal to the statistics printed in CP- 90 A report.

 

MONTHLY BILL ADJUSTMENT REPORT (CP-111 A):-


            All the adjustments posted through CP-52 and CP-136 D in a calendar month are listed in this report. This list is printed reference number wise. Main dates against all adjustments are reflected. This list is sorted in order of batch number with in each division. Following checks are implemented.
-           Check the month end printed in the list.
-           Total adjusted units in this report must be equal to the total (detection + normal) units adjusted as recorded main date wise in bill adjustment register.
-           Total normal amount adjusted in this report must be equal to the total of normal adjustments recorded main date wise in bill adjustment register.
-           Total detection amount adjusted in this report must be equal to the total of detection adjustments recorded main date wise in bill adjustment register.

 

LIST OF CONSUMERS DISCONNECTED FROM POLE TEMPORARILY OR PERMANENTLY: -

           
            This is a consumer wise list of all those consumers having temporary or permanent disconnected status on master file. Following checks are implemented.
-           Check the billing month printed in the list.
-           Check random cases of this list with the posting list of CP-138 under card type “3” or “4” (temporarily and permanently disconnected respectively).

 

SECURITY DEPOSIT LIST (CP- 97):-


This list is required to be printed after one year. This list reflects the batches wise security deposited by various consumers. This report should be randomly checked by confirming security amounts, updated or added through CP-136 (Master Data Addition /Change form). Check the reference number wise adjustments in batch 26 affected through CP-116.

BATCH DEBTOR LEDGER (CP-110):-


            This is an important monthly report, which reflects batch wise opening balance, current assessment, surcharge levied, current installment, un-paid debt, deferred amount, Subsidies/Agency amounts, payments, transfer in-out amount, closing balance, spill over and net arrears. CP-110 file is generated during the execution of monthly statistical file, (i-e total file). Following steps are performed in the processing of this report.

POSTING OF PAYMENTS ON CP-110 FILE: -

In this step all type of payments consolidated in a single payment summary file, are posted on CP-110 file.

POSTING OF TRANSFER IN-OUT FILES ON CP-110 FILE:-

In this step all types of transfer in-out files, generated in change of reference steps at the start of billing cycle, are posted on CP-110 file. Consumers wise lists of transfer in & out named as CP-153 and CP-154 are also printed.

LISTING OF CP-110:-

In this step, listing of CP-110 (i-e, Batch Debtor Ledger) is processed. This list must be checked very carefully.

 Following checks are performed to ensure the accuracy of report.

-           Check the billing month printed in the list
-           Total consumer on CP-110     =          Total number of consumer on CP- 95
-           Opening balance of CP-110    =          Closing balance of previous month CP-110
-           Net assessment of CP- 110     =          Assessment – Surcharge levied of CP-95
-           Total assessment of CP-110    =          Net assessment + opening balance of
CP-110
-           Surcharge levied CP-110        =          Surcharge levied amount of Total File List,
                                                                        CP-95 & CP-109
-           Current installment     of         =          Total current installment charged during the
CP-110                                                month as appearing in CP-88 A of all batches
-           Un-paid debt of CP- 110        =          Total un-paid debt of all batches in CP-88 A
 +  Total installment posted after billing of
 each batch.    
-           Deferred amount of CP-110   =         Deferred amount of previous month CP-110
 + Total advices posted during the month –
 Total with-drawls posted during the month.
-           Total Agency Amount of        =          Agency amount of CP-120 A
CP-110
-           Normal cash posted of            =         (i) Total general cash posted + Total
CP-110                                                     industrial cash posted of all main dates of
                 the month
                                                                        (ii) Total cash posted to own division + total
cash posted on behalf of other division as appearing in month CP-108.
-           Un-identified cash CP-110     =          Total un-identified cash posted in all dates
 of CP-139 Transaction type “1”
-           IOT. Cash of CP-110              =          (i) Total IOT cash appearing in monthly
                                                                              CP135 + Total IOT cash appearing in
                                                                               Special CP-135 (GST Subsidy Payment)                       
                                                                        (ii) Total IOT posted in all main dates of
CP-139 transaction type “7” + GST Subsidy Payment amount - total IOT reversed through CP-139 transaction type “8”
-           W/E IOT cash of CP-110       =          Total payment appearing in W/E CP-91 A
                                                                        report.
-           Scarp Tube well IOT of          =          Total payment appearing on Scarp tube well
CP-110                                                list.
-           Security adjusted of CP-110  =          Total security adjusted in all main dates of
 CP-139 transaction type “4”.
-           Journal adjustment  (credit)    =          i):  Total amount appearing as debit and
and journal adjustment                             credit in Monthly Cp-130 report.
(debit) of CP-110                                ii)   Total journal adjustment (credit or debit)
posted in all main dates of  CP-139           “transaction type 3” (debit and credit amounts are always equal).
-           Inter divisional normal cash    =          i) Total amount appearing in monthly
CP-110.                                                   CP-128 report.
                                                            ii) Total inter-divisional cash of all weeks
     as recorded in Cash Posting register.
-           Inter division un-identified     =          Total amount appearing in monthly CP-132
            cash CP-110                                        report.
-           Inter division journal               =          Total debit and credit amount appearing in
            adjustment debit/ credit                      monthly CP-131 report.
            CP-110
-           Total payments of CP-110      =          Total cash posted during the month as appearing
in CP-108 and CP-139 as well as W/E IOT & Scarp IOT.
-           Written off amount of            =          Total written off amount posted in all main
CP-110.                                               dates of CP-139 transaction type “6”.
-           Amount transfer in-out must be equal to the amount appearing in CP-153.
-           Closing balance is the cumulative physical outstanding amount of all consumers on computer master file at the end of the month including the set-aside and unpaid debt amount.
-                      Spillover amount should be reconciled with the spillover amount appearing in CP-120A report.
-                      Net arrear on CP-110 should be equal to the (closing balance – spillover amount) as on CP-110.

DIFFERENCE IN BALANCES:-

Closing balance in CP-110 are calculated by applying the following formula:-

Closing Balance          =          Opening balance + Net Assessment + Surcharge levied – Total
payment + Amount transfer in – Amount transfer out – Bad debts written off.

If this equation does not tally, difference appears in CP-110 resultantly.  In normal circumstances there should be no difference.  If any difference appears, it must be got investigated in the following ways.

-                      Ensure that all routine checks of CP-110 as listed above have been proved and verified.
-                      Ensure that WAPDA Employees departmental billing and dead defaulter’s billing have been processed successfully before processing of monthly reports.
-                      Ensure that the reply at the time of change of reference number step at the start of the month was correctly given.  It must indicate the month for which billing is to start.
-                      The transfer-in and transfer-out amounts in CP-110 (if any) should be confirmed from CP-153 at batch, sub division, division and circle level.
-                      It is to be ensured that all payment summary files (i-e Normal, 139, WAPDA Employee and GOP) are properly merged.
-                      Locate the batch (s) where the difference is appearing.  Confirm that opening balance of that batch on CP-110 is equal to the closing balance of the same batch in last month CP-110.
-                      Check the assessment list of batch showing difference in CP-110 list.  Ensure that no erroneous record with “$” sign is appearing on CP-88 A report. In case there is a record with “$*, investigate the case under intimation to Dy: Manager (C.O) & Dy: Manager (P/SA).
-                      CP-88L should be confirmed by using following formulas:-
i) Closing balance = Net + Surcharge levied – Payments
ii) Closing balance = Net + Surcharge levied – Payments – Unpaid debts – Set-aside
                                    + Withdrawal.

Second formula is used in case if some set-aside or installment transactions have been effected.
If this equation does not tally investigate at individual consumer level in CP-88L to find the reasons of difference and determine the type of error.

CP-120A (ENERGY DEBTORS RECEIVABLES ANALYSIS:-

This is a detailed report of arrears analysis along with their ages.  In this report, receivables are categorized into Government, Private, Disconnected and WAPDA Employees.  Total arrears as well as tariff wise arrears are given against each category according to their ages.  Following checks are performed to ensure the accuracy:-

-                      Check the billing month printed in the list.
-
Assessment of CP-120A
=
Net assessment of CP-110
-
Progressive un-identified of      CP-120 A
=
Closing balance of CP-107 of last week ending of the month
-
Spillover amount (CP-120A)
=
Spillover amount of CP-110
-
Unpaid debt (CP-120A)
=
Unpaid debt of CP-110
-
Deferred amount of CP-120A
=
Deferred amount of CP-110
-
Agency amount of CP-120A
=
Agency amount of CP-110
-
Arrears of CP-120A
=
Closing balance of CP-110 + Credit balances of CP-120A – unpaid debt – deferred amount – spillover – Agency amount.
-
Net Arrear of CP-120A
=
Arrears – Progressive un-identified
-
Receivable of CP-120A
=
Net arrear + Spillover + unpaid debt + deferred amount + Agency amount.
-
Net receivable of CP-120A
=
i)                    Receivable – credit balances of CP-120A
ii)                  Closing balance of CP-110 – progressive un-identified


CP-120A SUMMARY “ENERGY DEBTORS RECEIVABLE ANALYSIS” (ABSTRACT):-

This list is an abstract of the detailed CP-120A report.  In this report all statistics appearing in D-CP-120 A report are summarized according to their ages.  These statistics are rounded and decimal points are ignored.  Following checks are implemented:-

-                      Check the billing month printed in the list.
-                      Unpaid debt, Deferred amount, Agency amount, Spillover amount, Progressive un-identified, Total arrears, Credit balances and Receivables of CP-120A summary must be compared to the detailed CP-120A report.

GOVERNMENT DEPARTMENT REPORTS:-

Following reports are generated at the end of each month for Government departments:-

-           G-STAT-P List
-           Government Assessment & Realization report (division wise) and (sub division wise)
-           Age analysis Arrears report
-           Government department list (Summary of assessment, realization & arrears).

G-STAT-P LIST:-

This list reflects the statistics of Government file consumers.  These statistics must be reconciled with the statistics of previous month to ensure correctness of report.  Following checks are required to be performed:-
-           Check the month end printed in the list.
-           Records “read form balance file” must be compared with the previous month Government reports.
-           Records written on Government file   =   Records read from balance file +
                                                                              Records transferred in
-           Records written on Balance file         =   Record written on Government file -
     Records transferred out
-           Transferred-in and transferred-out records and amount must be verified from Government Assessment & Realization report.
-           Units sold, Payments, Assessment, Surcharge levied, Opening balance and Closing balance must be compared to the Government Assessment & Realization report.
-           Opening balance  =     Previous month closing balance + Amount Transferred
in – Amount transferred out.
-           Payment posted at source must be equal to the “adjuster amount + Scarp payment” posted during the month.

GOVERNMENT ASSESSMENT & REALIZATION REPORT (DIVISION WISE & SUB DIVISION WISE):-

This is the most important detailed report of Government department reflecting consumer number wise assessment, realization and receivable.  This report is printed in the order of Federal Government departments, Autonomous Bodies under Federal Government, Provincial Government departments, Autonomous Bodies under Provincial Government, Local Bodies under Provincial Government, Local Bodies under Federal Government, City District Government, TMAs under City District Government and other departments.  This list is printed division wise as well as sub division wise at the same pattern.  Government consumers with invalid Government department codes (if any) are listed separately.  Following checks are performed to ensure accuracy of the report.

-           Check the month end printed in the list.
-           Total records, Units, Opening balance, Current assessment, Payment, Surcharge levied, Closing balance, Transfer-in, Transfer-out records and Amount must be equal to the statistics printed on G-STAT-P list.
-           Opening balance  =     Closing balance of previous month GASS_ list +
Amount transferred-in – Amount transferred-out
-           Closing balance   =      Opening balance + Current assessment – Total payment
 + Surcharge levied.
-           Net arrears            =     Closing balance – Spillover.
-           Adjuster payments of this report must be equal to the sum of Adjuster amount and Scarp payment posted during the month.

AGE ANALYSIS ARREARS REPORT:-

This report shows age analysis of arrears outstanding against Government department connections.  This report is printed in the order of category (i.e. Federal, Provincial, Autonomous bodies, Local bodies, City district and TMAs etc) within the division.  Following checks are performed.

-           Check the month end printed in the list.
-           Total arrears excluding credit balances of this report must be equal to the net arrears of Government Assessment and Realization report at division level and circle level.

Note:-  Rounded arrears are printed in this report, so a  difference of insignificant amount may be due to rounding and is required to be ignored.

GOVERNMENT DEPARTMENT LIST (SUMMARY OF ASSESSMENT, REALIZATION & ARREARS):-

This report reflects the assessment, realization and arrears of each Government department.  The invalid Government departments are also listed at the top of this table.  Following checks are implemented:-

-           Check the month end printed in the list.
-           Grand total of each component of this report must be reconciled with the total of Government Assessment and Realization report.

VAX-PC-STAT LIST:-

This list shows the General statistics for PC files generated from Vax.  This is a very important report indicating the performances of field offices.  This list has three sections and reflects the number of defective meter cases, lock meter cases, same to same reading cases, new connections delayed, position of outstanding EROs (CP-114) and the details of units and amount adjusted in respect of each sub division.  Following checks are performed to ensure accuracy:-

-                      Check the billing month printed in the list.
-                      Total consumer + B26 consumer = consumer on CP-95.
-                      Number of defective and lock meter must be compared to the CP-90A statistics.
-                      Number of EROs and closing balance must be equal to the same information in CP-114A report.
-                      Total amount and units adjusted must be compared to the units and amount adjusted of CP-95.
-                      As adjustments of units without any amount are not allowed as per procedure.  So the columns relating to the “adjustment of units only” must be equal to zero.

P-DEF-LIST:-

This list shows the circle wise analysis of arrears against private consumers having permanent disconnected status on Master File at the end of the month.  Check the date printed in the list as the last date of the month ending. Total amount of this list must be equal the arrears after subtracting credit balances against Private “P-DISC.” consumers as shown in CP-120 A summary list.

GST RETRIEVAL & LISTING:-

In this step two types of lists are generated.  First is printed tariff wise and second is printed sub division wise.  These lists show the amount of GST billed (protected & non protected) and collected (protected & non protected) during the month. Following checks are performed to ensure accuracy:-

-                      Check the month end printed in the list.
-                      Protected GST amount must be equal to the amount printed in the GST Subsidy column of Net Assessment of CP-110 or CP-41.
-                      Non protected GST amount  =  Total GST amount – GST Subsidy amount
-                      Total GST of this report must be equal to the amount printed in the GST column of net assessment of CP-110 or CP-41.
-                      Payment against Protected GST must be equal to the payment posted as GST Subsidy at month end.
-                      Payments against “Non protected” GST of this report must be equal to the amount printed in the GST column of total payments of CP-110 or CP-41.
-           Total “GST collected” must be equal to the sum of GST collected against Protected and GST collected against “Non protected” of CP-110 or CP-41.

CP-112 A (SUMMARY OF OUTSTANDING EROs):-

This is the summary of outstanding disconnection orders against which, equipment is required to be removed. This list shows the number of EROs and amount of arrears outstanding.  This list provides opening balance of EROs at the start of the month, total number of EROs issued during the month, total number of EROs paid / executed during the month and the closing balance of EROs at the end of the month.  Following checks are performed:-

-                      Check the month end printed in the list.
-                      Opening balance of this report must be equal to the closing balance of previous month CP-112A report.
-                      Number of EROs issued during the month must be equal to the total of “EROs issued during the month” from CP-112 of all batches.
-                      Number of EROs executed must be compared with the statistics of CP-138 posted during the month.  (CP-138 transaction type “4”).

CP-41 RETURN OF CONSUMER BILLING AND COLLECTION OF DIVISION:-

This is the most important operational report, which reflects opening balance, billing, collections, and closing balance in respect of each division.  Following steps are required to be performed before processing of this report:-

-           CP-152 “Cost of service connection and reconnection fee received through demand notices, cash books and IOT credit advices” entry and proof listing.
-           Cash file creation.
-           Merging of Miscellaneous transaction files.
-           Posting of Miscellaneous transaction files.
-           CP-41 listing.

CP-152 “COST OF SERVICE CONNECTION AND RECONNECTION FEE RECEIVED THROUGH DEMAND NOTICES, CASH BOOKS AND IOT CREDIT ADVICES” ENTRY AND PROOF LISTING:-

This is an input form received at the month end from each Assistant Manager’s (C.S) Office.  This form provides the amount of security received through cash and IOT, service cost, reconnection fee, remittance of cost received, security deposits adjusted, refunded and credited through IOT.  This information is required to be entered.  Proof list of CP-152 is checked 100% from the source data.  It is ensured that all statistics on CP-152 list are correct.  An input file named as “41S” is generated, which is used in processing of CP-41.


            CREATION OF CASH FILES:-

In this step all the cash files used as input files in processing of CP-41 list are created.

            MERGING OF MISCELLANEOUS TRANSACTION FILES:-

In this step all the miscellaneous transaction input files created in the above step are merged.

            POSTING OF MISCELLANEOUS TRANSACTION FILES:-

                        In this step all the files merged in the above step are posted on CP-41 file.

CP-41 LISTING:-

In this step CP-41 listing is processed.  Two types of CP-41 listing is processed.

-           CP-41 list with difference in which CP-41 file information is compared to the information of CP-110 file and difference is calculated.
-           CP-41 list-new for circulation in field offices.

CHECKING OF CP-41 LISTING:-

Following are the routine checks of CP-41 listed section wise:-
 
-           Check the month end printed in the list.

SECTION “A” BILLING & COLLECTION:-
 
1.
Balance outstanding at the start of the month in CP-41
=
i)                    Closing balance of the last month CP-41
ii)                  Opening balance of CP-110 – progressive un-identified amount at the start of the month.
2.
Billing for the month of CP-41
=
i)                    Total Assessment of CP-95
ii)                  Net Assessment + Surcharge levied of CP-110
iii)                Grand total of section “B and C” of CP-41.
4(i)
Collection during the month of CP-41
=
i)                    Cash posted to own Division + un-identified cash as appearing in Cp-108
ii)                  Total Gen cash posted + Total Industrial cash posted + un-identified cash – Cash posted to other division (total of CP-127 of all weeks) as per cash posting register.
4(ii)
Adjustment against consumer’s Security deposit of CP-41
=
i)                    Security adjusted amount of CP-110
ii)                  Total security adjusted in all main dates of CP-139 transaction type “4”.
4(iii)A
Inter Division Normal Cash of CP-41
=
i)                    Inter Division normal cash of CP-110
ii)                  Total amount of CP-127 of all weeks
4(iii)B
Inter Division Journal Adjustment (CR) of CP-41
=
i)                    Inter Division Journal adjustment credit amount of CP-110
ii)                  Journal adjustment amount (credit) of CP-131
4(iii)C
Inter Division Un-identified cash adjustment of CP-41
=
i)                    Inter division un-identified cash of CP-110
ii)                  Total amount appearing in CP-132
4(iii)D
I.O.T cash of CP-41
=
i)                    IOT cash appearing in CP-110
ii)                  Amount in CP-135 + Amount in Special CP-135 (GST Subsidy)
iii)                Total IOT posted in all main dates of CP-139 transaction type “7” + Payment posted as GST Subsidy – Total IOT amount reversed in all main dates of CP-139 transaction type “8”
4(iii)E
W/E IOT amount of CP-41
=
i)                    W/E IOT amount appearing in CP-110
ii)                  Total payment appearing in CP-91A
4(iii)F
Tube well IOT against ED of CP-41
=
i)                    Tube well IOT against ED amount of CP-110
ii)                  Total amount appearing in scarp tube well list.
4(iv)A
Within Division journal adjustment (credit) of CP-41
=
i)                    Journal adjustment credit amount in CP-110 – Inter Division Journal adjustment (credit) amount in CP-110
ii)                  Credit amount in CP-130
4(iv)B
Within Division un-identified cash adjustment of CP-41
=
Un-identified cash of CP-110 –              Inter division un-identified cash            of CP-110
4(v)
Bad debts written off amount of CP-41
=
i)                    Written off amount appearing in CP-110
ii)                  Total written off amount posted in all main dates of CP-139 transaction type “6”
6
Inter Division transfer-in amount of CP-41 at division level
=
Amount transfer-in of CP-110 at division level
7(i)
Inter Division Jouranl adjustment (debit) of CP-41
=
i)                    Inter Division Jouranl adjustment (debit amount) of CP-110
ii)                  Journal adjustment amount (debit) of CP-131
7(ii)
Inter Division un-identified issued of CP-41
=
i)                    Inter Division un-identified cash of CP-110
ii)                  Total amount appearing in CP-132
7(iii)A
Within division Journal adjustment (debit) of CP-41
=
i)                    Journal adjustment (debit amount) in CP-110 – Inter Division Journal adjustment (debit amount) in CP-110
ii)                  Debit amount in CP-130
7(iii)B
Within division Un-identified cash adjustment of CP-41
=
Un-identified cash of CP-110 – Inter division Un-identified cash of CP-110
8
Un-identified cash deletion of CP-41

Total amount of un-identified cash deleted in all main dates of CP-139 transaction type “2”
9
Inter Division transfer-out amount of CP-41 at division level
=
Amount transfer-out of CP-110 at division level

Note:   Inter Divisional transfer-in and transfer-out amount of CP-41 must be compared to the transfer-in and transfer-out amount of CP-110 at Divisional level. (CP-154)

10        Balance at the end of the month is calculated as:-
            Balance           =          1 + 2 – 4 + 6 + 7 + 8 - 9
11        Actual balance of CP-110                   =          Closing balance of CP-110 – progressive
un-identified amount at the end of the month.
12        This is the difference of amount at serial number 10 and 11 i.e. the difference of CP-41 balances with physical balances of CP-110.
13        Subsidies amount in CP-41     =          Agency total amount of CP-110

            In normal circumstances there should be no difference in item No.10 and 11.  However, in case there is some difference as shown in item No.12, the same amount should be appearing in the difference column in CP-110.  This difference may arise due to either or all of the following reasons:-

                        -           Operational problem
                        -           Programming problem
                        -           Out of procedure operation

            In order to locate this difference same techniques should be adopted as in CP-110 difference.

            Apart from all routine checks as already specified, Manager (MIS) will have to be very vigilant in sorting out the difference appearing in item 12 of section “A”. CP-41 is one of the most sensitive management report presented to the Authority. It is absolutely essential that if any difference appears in item 12, it must be personally investigated by the Manager (MIS).

            Although un-identified cash balance and adjustments are included in the items as mentioned above, the detail of information about un-identified cash is listed at the end of section A to facilitate the Assistant Manager’s (C.S) Office in reconciliation.  These are checked in the following manner:-

-
Progressive un-identified at the start of the month
=
i)                    Opening balance of CP-107 of first week.
ii)                  Progressive un-identified at the end of the month of “last month CP-41”
-
New un-identified during the month
=
i)                    Un-identified amount appearing in CP-108
ii)                  Total un-identified amount appearing in the CP-107 of all weeks.
-
Un-identified adjusted during the month
=
i)                    Total amount posted in all main dates of CP-139 transaction type “1”
ii)                  Total identified amount as appearing in CP-107 of all weeks
-
Un-identified adjusted during the month with “D”
=
Total amount posted in all main dates of CP-139 transaction type “2”
-
Progressive un-identified at the end of month
=
i)                    Closing balance of CP-107 of last week of the month.
ii)                  Progressive un-identified at the start of the month + new un-identified during the month – un-identified adjusted during the month - un-identified deletions.
-
Federal Govt. Liabilities + Provincial Govt. Liabilities + Prime Minister Subsidy of CP-41 List
=
Agency total amount appearing in the “other” column of CP-110 List.
-
GST Subsidy of CP-41 List
=
Agency total amount appearing in the “GST” column of CP-110 List

SECTION “B” ANALYSIS OF ENERGY BILLED:-

This section reflects the tariff wise analysis of energy billed as appearing in CP-95.  Tariff wise unit rate charged is also calculated.

-           No. of consumer in CP-41      =          No. of consumer on CP-95 & CP-110
-           Units sold in CP-41                =          Net units billed on CP-95 (balance page)
-           Variable charges of CP-41      =          Variable charges + season charges – Round
factor of CP-95 (balance page)
-           Fix charges, LPF penalty        =          Fix charges, LPF penalty and ED of CP-95
            and ED of CP-41                                (balance page)

SECTION “C” ANALYSIS OF OTHER CHARGES:-

This section reflects the other charges as appearing in CP-95

-           Meter rent of CP-41                            =          Meter rent of CP-95 (balance page)
-           Public Lighting + Service                   =          Service rent of CP-95 (balance page)
            Rental of CP-41
-           Surcharge Levied, Income Tax           =          Surcharge Levied, Income Tax, GST,
            GST, PTV Fee & NJSUR of                          PTV Fee & NJ Surcharge of CP-95
            CP-41                                                              (balance page)
-           GST Subsidy amount in section C      =          Current GST Subsidy batch 01 to 21, 26
of  CP-41                                                        & 27 (Assessment Register) + GST Subsidy adjusted through CP-88 S
-           Total of secton:B and Section:C should be equal to the total billing amount as appearing in section:A of CP-41

Note:   The contents of Section “B” and “C” are not same in CP-41 list & CP-41-NEW list, but total of section “B” and “C” is always equal to the total billing amount as appearing in section:A of CP-41.

SECTION “D” ANALYSIS OF FREE ELECTRICITY:-

This section reflects the analysis of WAPDA Employees and free electricity units & amount credited to the employees.  The information in this section must be reconciled with the CP-91A report.

SECTION “E” SECURITY DEPOSITS:-

This section reflects the security deposits information as provided by the Assistant Manager’s (C.S) Office in CP-152 every month.

-
Opening balance of Security deposits of Cp-41
=
Closing balance of security deposits on last month CP-41
-
New deposit received during the month as per CP-41
=
Security received through cash + Security received through I.O.T as per proof list of CP-152
-
Security deposit adjusted and refunded of CP-41
=
Security deposit adjusted and refunded as per proof list of CP-152
-
Balance at the end of the month
=
Balance at the start of the month + new deposits received – deposit adjusted – deposit refunded.

SECTION “F” ABSTRACT OF CASH COLLECTION:-

This section reflects the abstract of cash collection in two accounts known as billing cash collection and demand notices cash collection.

BILLING CASH COLLECTION:-

-
Balance at the start of the month of CP-41
=
i)                    Balance at the end of the month of last month CP-41
ii)                  Balance at the start of the month of CP-104
-
Consumer billing collection + RCO fee + installment (RCO) + Installment (cost of meter) of CP-41
=
Total collection of CP-104
-
Remittance of CP-41
=
Net remittance appearing in CP-104
-
Balance at the end of the month of CP-41
=
Balance at the start of the month + consumer billing collection + RCO fee + Installment (RCO) + Installment (cost of meter) - remittances

DEMAND NOTICE CASH COLLECTION:-

-
Balance at the start of the month of CP-41
=
Balance at the end of the month of “CP-41 of last month “.
-
Service connection cost, security deposits and RCO fee of CP-41
=
Service cost, security deposit through cash and RCO fee as per proof list of CP-152
-
Remittance of CP-41
=
Remittance of cost received as per proof list of CP-152
-
Balance at the end of the month of CP-41
=
Balance at the start of the month + Service cost + Security deposits + RCO fee – remittance.

SECTION “G” BREAKUP OF BALANCES CATEGORY WISE:-

This section reflects the abstract of Opening balance, Assessment, Surcharge levied, Realization, Closing Balance, Spillover and Net arrear for different category of Government consumers as well as private consumers.

-                      All components of each category of Government departments as well as total governments must be reconciled with the Assessment and Realization report.
-                      Opening balance of CP-41 must be equal to the closing balance of “CP-41 of previous month”.
-                      Opening progressive un-identified must be equal to the closing progressive un-identified of “CP-41 of previous month”.
-                      Assessment, closing balance, progressive un-identified of CP-41 must be equal to the assessment, receivable and progressive un-identified of CP-120A report.
-                      Payments, written off and surcharge levied amount of CP-41 must be reconciled with CP-110 report.
-                      Net arrear of CP-41 must be equal to the net arrear of CP-110 after subtracting the progressive un-identified amount.

 

PTV FEE MONTHLY PROCEDURE:-


            Television License Fee has been collected from Residential and Commercial Consumers through electricity bills since July, 2004. At the end of every month a PTV procedure is to be executed. As a result a PTV file is created from month-end General & Industrial Master files. At the same time a statistical report is also generated.

            Following are the main steps of Monthly PTV Procedure.

-                      Creation of Sequential PTV file.
-                      Conversion of Sequential PTV file to Indexed PTV file.
-                      Payment Posting on PTV file.
-                      Statistical Listing.

CREATION OF SEQUENTIAL PTV FILE:-

            In this step, a Sequential PTV file is generated from month-end General and Industrial Master Files. Reference Number, Tariff Code, Name & Address, Old Reference Number, Standard Classification Code, Rural/Urban Code, Govt. Code, Number of TV, Current Due Date, Consumption, Opening Balance of PTV Fee, Current Assessment of PTV Fee, Closing balance of PTV Fee, PTV Fee deferred, PTV Fee adjusted and Disconnection Status are retrieved in this Sequential PTV File.

CONVERSION OF SEQUENTIAL PTV FILE TO INDEXED PTV FILE:-  

            The Sequential PTV File generated in the above step is converted into indexed PTV File in this step.

PAYMENT POSTING ON PTV FILE:-

            In this step, payment received against PTV License Fee is posted on newly created Indexed PTV file by using monthly PAYM-FILE-MMCCYY.srt. A PTV-PAY-POST list is also generated in this step. In this file total number of records and total payment posted against PTV Fee is reflected. The amount reflected in this list must be equal to the payment reflected in PTV column of CP-110 or CP-41 list.

STATISTICAL LISTING:-

In this step, a division-wise statistical summary list is printed. In this list PTV Fee Amount billed and adjusted, Payments, Receivable and Spillover against PTV Fee are reflected. Each component is to be verified from CP-95, CP-110 or CP-41 reports of relevant month.

SPECIAL DEFAULTER BILL PROCEDURE (SPLDEF):-

The Authority has provided an incentive package for defaulters having defaulter age five years (60 months) and above to motivate them for payment. For this purpose 50% rebated bills are issued to such defaulters after every six months. 50% of arrear is shown as due amount in these bills. At the same time a special bill file named as “SPLDEF” is also created for monitoring of payment made by such consumers. At the end of every month “SPLDEF” file is got re-numbered from CH file of relevant month. Payments and Adjustments are also posted on this “SPLDEF” file. Following lists are also printed at the same time:-

-                      SPLDEF-REF-LIST-MMCCYY.dat
-                      SPLDEF-STAT-LIST-MMCCYY.dat
SPLDEF-REF-LIST-MMCCYY.dat is printed reference number wise. Actual Balance Amount, Rebate Amount, Rebated Bill Amount, Payment (i-e Full, Part or Exception Cases) and Closing Balance (i-e Actual and Rebated) against each consumer are printed in this list. Remarks (i-e Full or Part Payment) are also printed. The closing balances of all the consumers who have paid 50% rebated bill as per SPLDEF-REF-LIST-MMCCYY.dat is required to be written off through CP-139 Transaction Type “6”.

 

In the SPLDEF-STAT-LIST-MMCCYY.dat list, abstract of above-mentioned information is printed sub division wise.

 

Total number of consumers and actual bill amount must be verified from the list initially created at the time of freezing the arrear file.  

 

MONOTORING OF ARREARS AGAINST FROZEN FILE:-

 

            Frozen files named as “CURPVT120-REG-MMCCYY.dat” may be created from arrear file of any month at any time at the desire of Authority. In this file arrears against running defaulters (Private and Govt.) are freezed at the level of frozen month as desired by the authority. After being freezed, the arrear amount is to be monitored every month. For this purpose frozen file is renumbered from “TRANSFER-INOUT-CCYYMM.dat” of relevant month. Then the balances are posted on frozen file from month-end General as well as Industrial Master File. The statistical lists are processed in different ways and submitted to the Authority for monitoring purposes. The arrear status for the month for which the arrears are freezed is required to be verified from “S-CP120A-LIST-MMCCYY.dat” of relevant month.

            Closing balance must be verified as per following formulae.

Closing Balance                 =               Arrear Freezed – Payment + or – Bill Adjustment



CHANGE OF REFERENCE STEPS


After successful completion of month end reports, backup of all month end file and master file is performed on cartridge and retained in the Computer Centre as a reserve.  After completion of backup, change of reference steps are processed.  These steps are listed below:-

-           General transactions posted at month end.
-           Industrial transactions posted at month end.
-           Deletion of Miscellaneous transactions from the main file.
-           CP-116 processing.
-           Reconnection posting of batch No.26.
-           Posting of CP-142
-           Monthly WAPDA Employee updating.
-           Monthly WAPDA Employee EPF Level Posting Steps.

GENERAL TRANSACTIONS POSTED AT THE MONTH END:-

In this step transactions such as change of references, tariff codes, ED codes, Rural / urban codes and Government department codes which are kept pending at the time of posting of CP-136, are posted on Master File after the completion of billing cycle and before the start of next billing cycle.  As a result of this processing change of reference list is printed and transfer in-out file is generated which is required to be used in the monthly steps of next billing month.  Change of reference list is checked in the following way:-

-                      Check the billing month in the report (i-e. the month for which billing is to be started”.
-                      Check the random cases of all types of month end transactions from the source data.
-                      Remarks column should be observed in case of rejection.
-                      Region / Circle codes of new reference numbers must be valid.
INDUSTRIAL TRANSACTIONS POSTED AT MONTH END:-

In this step MDI transactions, which are kept pending at the time of posting of CP-137, are posted on Industrial Master File.  Processing and checking criteria is same as discussed in the above step.

DELETION OF MISCELLANEOUS TRANSACTIONS FROM THE MAIN FILE:-

In this step General & Industrial transactions posted in step “1” and “2” are deleted from the main file.  Ending month is given as reply in the processing of this step.  Sub division wise statistics are printed as a result.

            CP-116 PROCESSING:-

Security adjustment records posted in all main dates of CP-139 transaction type “4” are accumulated in a file which is used to process CP-116 before the start of new billing cycle.  This report reflects the detailed information of each posted record.  The new reference numbers in batch No.26 are also listed. In Batch number 26, new reference numbers are to be allotted by the computer automatically in seven digits. It is the next number falling in the serial of sub division. The check digit is calculated as per formulae.

 CP-116 list also gives the detail of security amount on Master File, Security amount adjusted and closing balance.  These reference numbers are also added in the transfer in-out file generated in change of reference step.

            RECONNECTION BATCH NUMBER 26:-

All the reference numbers, which are reconnected from batch No. 26 are also processed before the start of new billing cycle.  CP-138 of all reference numbers is entered in the single main date, which is got listed and edited as per normal procedure.  At the time of posting all records relating to General batches are reconnected in their respective batches while rec-status “D” is added against the reference No. of batch 26.  A separate transfer in-out file is generated in this step and is to be used in the monthly steps of next month.  As for as reconnection of MDI consumer is concerned, reconnection is affected in batch No.26 and later on these consumers are transferred to Industrial batch through CP-142.

Note:   Reconnection of consumers existing in batch number 26 is allowed at the start of billing cycle only.

            CP-142 PROCESSING:-

All the account numbers, which are required to be transferred from General batches to Industrial batch and vice versa, are processed in the single main data of CP-142.   CP-142 is got entered, listed and edited as per normal procedure.  The posting of CP-142 is requested at the end of billing cycle and before the start of new billing cycle.  A separate transfer-in-out file is generated in this step and is required to be used in the monthly steps of next month.

            WAPDA EMPLOYEE MONTHLY UPDATING:-

In this step deletions of free electricity supply facility of WAPDA Employees and change of reference numbers regarding free electricity facility as a result of shifting of free electricity facility from one place to another, which are kept pending at the time of posting of CP-93, are affected.  Ending month is given as reply in the processing of this step.

Note:   WAPDA employee’s balance units are required to be updated at the start of billing cycle in the month of July according to the maximum free units allowed to each employee in a year as per basic pay scale.




            WAPDA EMPLOYEE LEVEL POSTING STEPS:-

As per procedure, A WAPDA Employee can avail free electricity facility up to the prescribed units limit but only at one place anywhere in Pakistan. This means free supply facility is not allowed more than one place at a time. Some dishonest employees try to avail this facility more than one place. In order to control the misuse of this facility, free supply is controlled through EPF/ GPF Numbers. At the start of billing cycle, following WAPDA Employee Level Posting steps required to be executed.

W/E COMPLETE LIST & PRE-ENTER CREATION:-

In this step a pre-entry file is created from General Master File and EPF File. All the consumers whose free electricity facility is added first time either by addition or by change of reference number through CP-93 and W/E flag is zero, are retrieved. At the same time a list named as “WE-COMPLETE LIST” is also generated. This list reflects the EPF number, complete reference number (i-e Batch Number, Sub Division Code, Account Number and Check Digit), W/E flag pre-printed as zero, name of WAPDA employee on W/E file and name of WAPDA employee on EPF file. Names on both files are compared with each other. If the names on both files are same W/E flag is required to be updated as “1” and if these are differing W/E flag is required to be updated as “2” which means the stoppage of free electricity facility.

            SORTING OF PRE-ENTRY FILE:-

In this step pre-enter file created in above step is sorted in the order of batch number at the first stage and then in the order of sub division in each batch.

           


ENTRY/ UP-DATING:-

In this step W/E flags are being updated as “1” or “2” after reconciliation as discussed in first step through manual entry.
           
            PROOF LIST:-

In this step proof list is obtained after entry. This proof list is required to be checked from the complete list where the up-dated W/E flags are marked. Errors/ Correction (if any), are got corrected.
           
            POSTING ON MASTER FILE:-

In this step pre-entry file is posted on Master File. W/E flags of all the consumers existing as zero are up-dated as “1” and “2” during this posting

DUPLICATE FREE SUPPLY LISTING:-

In this step all the consumers availing free electricity facilities at two places in a Circle or in a Region or throughout at WAPDA level are retrieved. The files retrieved at circle level are posted on Master File. During posting W/E flag is up-dated as “3”. The files retrieved at regional level (if any), is posted on Master File. During posting W/E flag is up-dated as “4”. At WAPDA level the duplicate free supply consumer ‘s file, called as “ALL-DUP” file, is created at WCC (HQ), Lahore. Then this file is sent to all regional computer centers from where these files are sent to each circle for posting. At circle level these files are posted on Master File. During posting W/E flag is up-dated as “5”.

CP-22 LINE LOSSES REPORTS


            The electricity, generated in Power Houses, is distributed among the consumers via grid stations through 11 KV Feeders.  The total electricity generated in Power Houses is not 100% assessed in the billing.  Some losses may occur due to the following reasons:-

          TECHNICAL LOSSES:-
           
These are the losses, which may occur due to continuous sparking on sub-standard lines.  This is merely because of obsolete transmission system.

          ADMINISTRATIVE LOSSES:-
           
Some dishonest consumers involve in the theft of electricity i.e. physically the electricity is consumed but not taken into account for the purpose of billing.  These losses are called as administrative losses.

            A procedure has been introduced for accumulation of such losses. Line losses reports called as CP-22 reports are prepared in the computer centres. These reports reflect monthly/progressive number of units received, billed and lost in respect of each feeder. Percentage losses are calculated on the basis of units received at feeder, sub division, division, circle and company level. 

UNITS RECEIVED:-

These are the units sent out by the grid stations for the purpose of distribution among the consumers.  For this purpose meters are installed against each 11 KV feeder at the grid stations.  The reading is recorded by the SSO / in-charge of the grid station on the last date of the month exactly at 24:00.  Units received are the difference of present reading and the reading recorded in the previous month after proper application of multiplying factor. 

UNITS BILLED:-

The units, which are accounted for the purpose of billing in one billing cycle, are called as units billed.  These are the units actually sold to the consumers and are taken from the monthly billing statements at the end of each billing cycle.

UNITS LOST:-

            This is the difference of units received from grid stations and units billed in that billing cycle in respect of each feeder.  These are the units, which are actually lost during transmission due to technical / administrative reasons.

The reading of each feeder of the grid is recorded at the grid stations and is supplied to the computer centre through following inputs:-

            CP-22 B                      11 KV Feeder wise units sent out from Grid Stations.
            CP-22 C                      Grid station meter change/meter reading correction statement.

DISPATCH OF CP-22B PRE-ENTRY LIST:-

After processing the additions / changes received (i.e. allotment of new feeder or any change in feeder particulars) CP-22B pre-entry list is processed at least five or six days prior to the date of reading.  This list acts like blank meter reading list having feeder code, name of feeder, previous reading, meter range and multiplying factor pre-printed and keeping the present reading, units sent out, round completion code and meter status code column blank.  CP-22B pre-entry list is checked in the following manner before dispatch to S.S.&T. divisions:-

-           Check the billing month printed in the list as current billing month ended
-           Confirm that all the changes / additions have been effected successfully.
-           Verify the previous reading in few cases from the readings of CP-22B of previous month.
-           Check the printing quality of the list.
CP-22B pre-entry list is printed grid station wise.  This list is sorted according to the jurisdiction of S.S.&T. divisions.  The page numbers are recorded in the dispatch register and sent to concerned S.S.&T. division by mail.

RECORDING OF READINGS IN CP-22B PRE-ENTRY LIST:-

After receiving from computer centre the concerned S.S.&T. division handed over the CP-22B pre-entry list to the SSO/In-charges of grid stations.  They record present reading in the respective columns against each feeder on last day of the month at 24:00.  Units sent out are calculated after proper application of multiplying factor and entered in the relevant column.  Round completion code “C” is also entered in the round completion code column where the meter has completed its round.  In case, where the old meter replaced by new one, code “R” is entered in the meter status code column. Each page of CP-22 B pre-entry list is to be signed by the Deputy Manager, S.S.&T. division concerned.  Meter readings are recorded as per range of the meter upto maximum 13 digits keeping the right three digits as decimal points.  Units sent out are recorded upto maximum 13 digits and have no decimal point at all.

FILLING OF CP-22C GRID STATION METER CHANGE/METER READING CORRECTION STATEMENT:-

CP-22C Grid Station meter change / meter reading correction statement is filled in all the cases where old meter is being replaced by a new one.  Following procedure is adopted to fill in the CP-22C statement:-

-           Enter the billing month on the top of CP-22C as current billing month ended.
-           The name of grid station must also be entered on the top of the form.
-           Enter a valid feeder code existing in the feeder table as well as in CP-22 master file.
-           Name of the feeder is also entered.
-           Meter number of the new meter installed must be filled in the meter number column.
-           Two digits maximum range of the meter is required to be entered in the meter range column.  The range of the meter must be from “04” up to “10”.
-           Multiplying factor of new meter installed upto maximum “9” digits must be entered in the respective column.  The right three digits represent the decimal points.
-           Enter the reading at which the old meter is removed as final reading.  The reading must be entered upto maximum “13” digits keeping the last three digits as decimal points.
-           Enter the initial reading of new meter installed upto maximum “13” digits keeping the right side three digits as decimal points.
-           CP-22C statement must also to be signed by the Deputy Manager S.S. & T. division concerned.

RECEIPT OF CP-22B AND CP-22 C IN COMPUTER CENTRE:-

After recording the reading in CP-22B pre-entry list and after proper filling of CP-22C statement, these inputs are received in the Computer Centre upto 3rd day of each month.  Following checks are performed in computer centre while receiving the CP-22 inputs:-

-           Check the month end printed in the list as the current billing month ended.
-           The signatures of concerned Deputy Manager S.S.&T. division must be available along with stamp in case of 66 KV/132 KV grid stations on each page of CP-22B Pre-entry list.  In case of 220 KV grids these pages are to be signed by the Senior Engineer.
-           The writing must be legible and there should be no cutting / over writing in the present reading and units sent out recorded.  If due to some reason, cutting / overwriting is accepted, it must be signed by the Deputy Manager S.S.& T. division, Senior Engineer or any other official authorized by them.
-           The number of pages in respect of each S.S.&T. division must be checked as recorded in the dispatch register at the time of initial dispatching of CP-22 B pre-entry list.  It must be ensured that no page of CP-22 B pre-entry list is missing.
-           Present reading and units sent out as recorded in the CP-22 B pre-entry list must be verified in respect of each feeder in the following manner:-

Units sent out  =  (Present reading – Previous reading) x multiplying factor.
In case of any discrepancy matter must be consulted with the official of S.S.&T. division concerned.
-           It must be ensured that readings are recorded with three decimal points and are within the limits of maximum “13” digits according to the meter range.
-           It must be ensured that recorded readings are not greater then their respective ranges in any case.
-           The present reading recorded must always be greater than or equal to the previous reading except in case of round completion or replacement.
-           The present reading should not be left blank in any case.
-           The units sent out must always be recorded within the range of maximum “13” digits.
-           The total of units sent out in respect of all the feeders of a grid Station is entered at the bottom of the page as page total.
-           Calculation of units sent out must be verified in case of round completion code “C”.
-           It must be ensured that complete information in CP-22C statement is properly recorded in all the cases where meter status code “R” is entered.
-           Check the feeder codes entered in the CP-22C statement.  These feeder codes must be valid existing in feeder table as well as present on CP-22 master file.  It must also be ensured that status code “R” is entered in CP-22B pre-entry list against the feeder codes entered in CP-22 C statement.
-           The range of new meter recorded in CP-22C statement must be within the range of “04 to 10”.
-           The multiplying factor of the new meter recorded in CP-22C statement must be upto the maximum “9” digit with “3” decimal points.
-           The final reading of meter removed in CP-22C must be greater than or equal to the previous reading.  It must be recorded upto maximum “13” digits with 3 decimal points.
-           The initial reading of new meter recorded in CP-22C must be less than or equal to the present reading recorded in CP-22B pre-entry list.  It must be recorded upto maximum “13” digits with 3 decimal points.
-           The units sent out in case of meter replacement must be verified in the following manner:-

A “Units sent out of removed meter” =  (Final reading of old meter – Previous
    reading) X Multiplying factor of old
    meter.

B “Units sent out of installed meter” =  (Present reading of new meter – Initial
    reading of new meter) X Multiplying
    factor of new meter.
Total units sent out by the feeder        =         A + B

When CP-22B and CP-22C is received and checked 100% in respect of all S.S.&T. divisions. CP-22 B is arranged in the order of page number.  Then complete CP-22B pre-entry list along with CP-22 C of all divisions is sent to data entry section for entry purposes.  When it is intimated by the Data Entry Supervisor, that entry of CP-22 B and CP-22 C is completed, proof lists are requested in the machine room.

NOTE:-          For each entry of CP-22 C, the code “R” must be entered against the relevant feeder during the entry of CP-22 B other wise the record will not be created in CP-22 C entry file.
 
CP-22 C PROOF LIST CHECKING:-

After receiving the proof list of CP-22C “Grid Station meter change / meter reading correction statement” from the machine room, it is required to be got edited 100 % from the source data. Complete information regarding the “replaced meter” is to be checked.  Billing month printed in the list must also be checked.  Data entry errors must be marked in red ink.  The following types of error messages may appear in the proof list.
           

ERROR CODE
MESSAGE TEXT
ACTION REQUIRED
01
Feeder code not available in feeder table.
It may be due to the wrong entry of feeder code or replacement code “R” is not entered in CP-22B pre-entry list against the respective feeder code.  The feeder code may be got corrected in CP-22C after consulting from source data or enter the replacement code “R” against the relevant feeder code.
02
Previous (Final) reading must be greater than zero.
Correct the reading as per source data.  Previous (final) reading in CP-22C must be greater than zero as well as pervious reading in CP-22B
03
Multiplying factor should not be less than “1.000”.
Correct the multiplying factor of new meter installed in CP-22C after consulting the source data.  However, multiplying factor of digital meter having range as “8” is acceptable less than “1.000” as “0.500”
16
CP-22C record must be given if meter status code is one of “R”, “U” and “N”.
Status code “U” and “N” are not in use.  If meter status code “R” is given, CP-22C record must be added after consulting from source data.
17
Non of the fields in CP-22C is left blank when meter status code is “R”.
If the meter status code is “R”, all columns of CP-22C i.-e. meter number, range, multiplying factor, final reading and initial reading must be filled.
22
Adjusted units incorrect according to new reading.
Not in use.

            After marking all the errors / corrections in CP-22C proof list and after making additions of all missing entries, proof list is sent to data entry section for correction purpose.  When it is intimated that corrections / additions are got entered, a fresh proof list is again requested.  This process is repeated again and again till the 100% correctness is ensured.  When it is ensured that CP-22C is error free and no error message is appearing in the final proof list, it is retained as office record.


CP-22B PRE-ENTRY PROOF LIST CHECKING:-

After receiving the proof list of CP-22B from the machine room, 100% checking of present reading and units sent out from the source data is required.  The billing month printed in the list is also checked being the current billing month ended.  It must be checked that entries are available in the proof list for all the new feeder codes allotted. Round completion code “C” is required to be checked where the meter has completed its round.  Units sent out in such cases must also be checked.  Meter status code “R” is also checked against the feeders reflecting in CP-22C proof list.  Units sent out in replacement cases must also be got checked from the source data of CP-22B.  Data entry errors must be marked in red ink.  Following errors messages may appear in the proof list and are required to be removed.
           
01
Feeder code not available in feeder table.
Add the feeder code in the feeder table if it is allotted first time, otherwise the record must be got deleted from CP-22B proof list.
02
Previous reading must be greater than zero.
If a new record is added in CP-22 B proof list, previous reading must be greater than zero. Correction required after consultation from source data.
03
Multiplying factor should not be less than “1.000”.
If a new record is added, multiplying factor should not be less than 1.000.  However, in case of digital meter. 0.500 MF is also acceptable.  Correction required after consultation from source data.
04
Previous reading should not be greater than final reading.
Check the final (present) reading from the source data and reading must be got corrected in CP-22B proof list.
05
Present reading must be equal to the previous reading if meter status code is “D”.
Meter status code “D” is not in use
06
Units sent out / computed must be equal to the units given.
Check the present reading as well as units sent out from the source data and correction must be made accordingly if it is due to data entry error otherwise present reading must be entered as per source data of CP-22 B pre-entry list.
07
Round completion code must be either “C” or left blank.
Check the round completion code column. Enter “C” if the round is completed otherwise left blank.
08
Meter status code must be “R”, ”U”, ”N” or “D”.
Check the meter status code column.  Enter “R” in case of replacement of meter otherwise left blank as codes “U”, “N” and “D” are no more in use.
09
First Sub Division code cannot be left blank.
Check the column of first sub division and enter the relevant valid Sub division code of the feeder.
10
Sub division code should be available in sub division table.
Check the sub division code and correction must be made accordingly
11
% age of share should be equal to or less than 100.
If a feeder is shared by two sub divisions the sum of % ages of all sub divisions must be equal to 100.
12
% age of share not provided for the sub division.
If a feeder is shared by more than one sub division  % age share must be given for each sub division according to the share.
13
% age of share should be left blank for blank sub division.
If a feeder is not a sharing feeder, % age column should be left blank and computer will charge 100% to the relevant sub division.
14
% age of share should be greater than zero.
In case of sharing of feeder, % age share of each sub division must be greater than zero
15
Sum of all % ages should be equal to 100.
In case of sharing of feeder, sum of % ages of all sub divisions must be equal to 100.
16
Verified reading or not numeric for adjustment.
Adjustment of units is no more in use
17
Verified reading incorrect for adjusted units.
-do-
18
Adjusted units blank or not numeric.
-do-
19
Units sent out not numeric.
Check the units sent out from the source data and required to be entered in the respective column.
20
Units sent out incorrect after adjustment.
Adjustment of units is no more in use.

NOTE:-          In case of sharing feeder, Sharing sub division code & relevant % must be entered in CP-22 B entry file and principal sub division must not be updated in any case.

After removing all the error messages, CP-22B list is sent to data entry section for correction purposes.  When all the marked corrections and additions are entered, proof list of CP-22 B is again requested.  This process is repeated again and again upto 100 % correctness.  When it is ensured that CP-22 B proof list is error free and no error message is appearing, % ages of shares in respect of each sub division is properly entered in case of all sharing feeders and in case of creation of new sub division or bifurcation, the sub division codes are properly updated in feeder table as well as CP-22B entry file, final proof list of CP-22B is obtained and retained as office record. 

PROCESSING OF CP-22A AND CP-22 REPORTS:-

            When it is ensured that CP-22B and CP-22C are error free, feeder codes and sub division codes are got corrected in feeder table as well as in CP-22B entry file, and total files from all the circles are received and merged in the re-tot step, CP-22A list is requested in the machine room.


CP-22A FEEDER WISE LINE LOSSES ANALYSIS:-

This is an important report, which reflects line losses in respect of each feeder relating to a division.  This report provides load in KW, total number of consumers, monthly units received and billed, progressive units received and billed, monthly % age losses and progressive % age losses of all the feeders.  This report projects the feeder wise losses at each division.  At the end of each division, an abstract showing the sub division wise load, number of consumers, units received, units billed, units lost and % age losses is printed.  Totals are also printed at division, circle and company level.  Following checks are performed to ensure the accuracy of report:-

-           Check the month printed in the list as current billing month ended.
-           Verify the names of Sub Divisions, Divisions, Circles and Company from the tables.
-           Load in KW must be equal to the load printed in CP-95 (balance pages) of all the circles.
-           Units received must be equal to the units received as per OK proof list of CP-22B.
-           Units billed / sold must be equal to the sum of units billed as per CP-94, CP-95 (balance section) and CP-41 section “B” of all the circles.
-                      Units lost         =          units received  – units sold
-                      % age losses = units lost / units received x 100
-                                                                                                                                              Progressive Units received     =          Progressive units received of previous month + Current month units received
-                                                                                                                                              Progressive Units billed          =          Progressive units billed of previous month + Current month units billed
-                      Progressive Units lost             =          Progressive units received – Progressive units billed
-                      Progressive % age losses         =          Progressive units lost / progressive units
received x 100
-                      Total number of consumers must be equal to the sum of total consumers as per CP-95, CP-110 of all the circles.
-                      It is ensured that new feeders added (if any), are included in the CP-22A report. Progressive units received, billed and lost against new feeders must also be verified from source data.
-                      Check the % age of the units in case of sharing feeders.

            When CP-22A report is found satisfactory, it is presented to the Manager Commercial for confirmation.  After confirmation from the Manager Commercial, four copies of this report are sent to Assistant Managers (C.S) for onward submission to field offices.

Note:-  If any invalid feeder code is appearing in CP-22A report, the matter may be got resolved with the help of programming section.

                        Feeder code 666666 represents the batch “26”
                        Feeder code 888888 represents the un-identified feeder
                        Feeder code 999999 represents the WAPDA Employee

CP-22 LINE LOSSES, BILLING AND ARREAR ANALYSIS:-

After successful processing of CP-22A report and merging of payments of all the circles, CP-22 “Line Losses, Billing and Arrear Analysis report” is requested in the machine room.  This is an important report which reflects the monthly and progressive units received, billed, adjusted and lost as well as calendar month assessment, payments, spillover, and receivable in respect of each feeder.  Tariff wise break-up of receivables are also reflected.  This list is printed sub division wise.  Sub division / Division / Circle and Company totals of these information are also printed.  Unit rate is also calculated by dividing total assessment by net units billed.  Following checks are performed to ensure the accuracy of this report:-

-                      Check the billing month printed in the list as current billing month ended.
-                      Monthly units received, billed and lost must be equal to the CP-22A report.
-                      Progressive units received, billed and lost must also be compared with the CP-22A report
-                      Monthly and progressive % age losses must be equal to the monthly and progressive % age losses printed in the CP-22A report.
-                      Total units adjusted must be equal to the sum of units adjusted as per CP-95 (bill adjustment section) of all the circles.
-                      Progressive units adjusted       =         Progressive units adjusted of previous month + Current month units adjusted
-                      Average unit rate                    =          Assessment / Net units billed
-                      Total assessment must be equal to the sum of the assessments of all the circles as per CP-41 section “A”.
-                      Total payment must be equal to the total payment of MIS-RPT 1 & 3.
-           Spillover must be equal to the spillover amount as per MIS-RPT 1 & 3, CP-41 or CP-120A of the region.
-                      Total receivable amount must be equal to receivable amount as per MIS-RPT 1 & 3, CP-41 or CP-120A of the region.
-                      Total number of consumers must be equal to the sum of consumers of all the circles as per CP-95, CP-110 and CP-41 of the region.
-                      Total connected load in KW of CP-22 report must be equal to the sum of load of all the circles as per CP-95 (balance section).

When CP-22 report is found 100% correct, it is required to be dispatched to field offices through circle computer centers. 


NOTE.

i):         There must be no feeder in CP-22 reports with zero consumer, which  resulting 100 % losses. This may be due to the reason that new feeder is physically energized and consumers have been shifted to new feeder but their feeder codes are not updated on General & Industrial Master files. Necessary updation on billing Master Files is required before processing of CP-22 reports.
ii):        For line losses purpose July to June is considered as financial year.  Progressive information at any stage are considered as total from the month of July to date in each year.

No comments:

Post a Comment