Perancangan Dashboard Laporan Piutang Berbasis Power BI untuk Optimalisasi Penagihan pada PT Kanitra Mitra Jayautama

Abstract

PT Kanitra Mitra Jayautama (Kamaju) merupakan perusahaan yang bergerak di bidang penyedia jasa tenaga kerja (manpower supply), dimana masih mengalami keterbatasan seperti kurangnya visibilitas terhadap status piutang, keterlambatan identifikasi piutang jatuh tempo, serta kesulitan dalam memonitor kinerja penagihan. Tujuan perancangan dashboard account receivable report berbasis Microsoft Power BI dalam rangka mengoptimalkan proses penagihan piutang yang dinilai belum maksimal. Metode yang digunakan dalam penelitian yaitu observasi, wawancara, dokumentasi, dan studi pustaka. Hasil dan pembahasan dalam laporan proyek akhir ini menguraikan bagaimana proses penagihan piutang yang diterapkan saat ini, kemudian menemukan permasalahan yang terdapat pada proses penagihan piutang untuk selanjutnya ditemukan langkah strategis dengan merancang dashboard interaktif. Pembuatan dashboard dilakukan melalui 4 tahap yaitu perencanaan, perancangan, penerapan, dan pengujian sistem. Setelah dilakukan pengujian sistem dilakukan evaluasi perbandingan sistem lama dengan sistem baru dengan pendekatan black box. Dengan adanya dashboard AR Report berbasis Power BI ini dapat meningkatkan optimalisasi dari proses pelaporan, penagihan, dan pengambilan keputusan bisnis pada PT Kanitra Mitra Jayautama.

PT Kanitra Mitra Jayautama (Kamaju) is a company engaged in manpower supply services. However, the company still faces several limitations, such as a lack of visibility into the status of accounts receivable, delays in identifying overdue receivables, and difficulties in monitoring collection performance. The purpose of designing an accounts receivable dashboard using Microsoft Power BI is to optimize the collection process, which is currently considered inefficient. The methods used in this research include observation, interviews, documentation, and literature review. The results and discussion in this final project report describe the current receivables collection process, identify existing issues, and propose strategic solutions by developing an interactive dashboard. The dashboard development is carried out in four stages: planning, design, implementation, and system testing. After the system was tested, a comparison evaluation between the old and new systems was conducted using the black box approach. The implementation of this Power BI-based Accounts Receivable Report Dashboard is expected to enhance the optimization of reporting, collection, and business decision-making processes at PT Kanitra Mitra Jayautama.