APLIKASI MONITORING PIUTANG PELANGGAN REKENING LISTRIK BERBASIS WEB DI PLN ULP MAGELANG KOTA

Account Receivable are a classic problem facing companies that have postpaid customers. As long as a company has postpaid customers, there is always the potential for overdue payment. PT PLN (Persero) ULP Magelang Kota as the electricity provider in the City of Magelang and some Magelang Districts has a total of 113,775 postpaid customers. This becomes a challenge for PLN to reduce the potential arrears that will arise. If the number of customers is divided by 78 existing officers, on average each officer is burdened with billing (contracted as P5K work, namely Management of Termination, Demolition, and Reconnection of Customers) to reach 1,458 customers per month. Even though this officer still has 2 other jobs, namely Management of Customer Data Recording which is carried out for about 5 working days, and Recording of Stan Meter Numbers and Abnormalities. Then the productivity of officers really needs to be monitored to ensure work can be completed. To monitor the movement of the arrears emphasis still use manual processing with formulas in Ms Excel. Relate the arrears data to the officer area using the VLOOKUP formula and then process it again with the Pivot Table, then mark it with the Contional Formatting formula in the achievement column. The status is red, yellow, or black. This requires designing and building web-based applications that can reduce manual processing in monitoring the performance of accounts receivable so that the target of overdue suppression can be achieved.