ABSTRACT
Banks must maintain, calculate, and monitor liquidity using the Liquidity Coverage Ratio (LCR) indicator. In Indonesia, they reported daily, monthly, or quarterly online through a paper template prepared by the Financial Services Authority (OJK). This reporting must accurate and on time or be subject to penalties. For banks that are still processing LCR semi-automatically, this reporting system is an obstacle that they continue to face and resolve. This article discusses the automation process method developed using the concept of Extract Transform Load (ETL), with a waterfall software development model, so that daily reports are generated automatically. This article proposed a methodology to anticipate problems in integrating banking with regulators by applying one of the Basel III frameworks, primarily based on Indonesia's case studies. The finding of the research is a method for the LCR report process through ETL. The proposed ETL method in this research had proven used success in processing LCR in the banking industry. This method is a solution and recommendation for banks in making reports based on Basel III to complete LCR reporting through the ETL method.â¢o Maintain, calculate, and monitor liquidity using the Liquidity Coverage Ratio (LCR) indicator in Banking .â¢o Automation process method developed using the concept of Extract Transform Load (ETL).â¢o Recommendation for Banks to complete LCR reporting through the ETL method).