Perancangan Dan Implementasi Sistem Batas Kredit Piutang Berbasis Microsoft Excel Vba Pada Umkm S.O Pesona Asri

Abstract

Penelitian ini dilatarbelakangi oleh pencatatan piutang yang masih dilakukan secara manual pada UMKM S.O Pesona Asri, yang menyebabkan kesulitan dalam memantau saldo piutang dan keterlambatan penagihan. Penelitian ini menggunakan metode kualitatif deskriptif dengan teknik pengumpulan data melalui observasi, wawancara, dan dokumentasi. Tujuan dari penelitian ini adalah merancang dan mengimplementasikan sistem batas kredit piutang berbasis Microsoft Excel VBA untuk meningkatkan efisiensi pencatatan, akurasi data, serta pengawasan terhadap batas kredit dan jatuh tempo. Sistem dikembangkan melalui tahapan analisis kebutuhan, perancangan, dan pengujian. Fitur utama meliputi pencatatan penjualan kredit, perhitungan otomatis piutang, pemantauan batas kredit, cetak invoice, dan peringatan jatuh tempo. Hasil evaluasi menggunakan metode PIECES menunjukkan bahwa sistem ini dapat meningkatkan efisiensi operasional, mempermudah proses penagihan, serta mengurangi risiko keterlambatan pembayaran. Sistem ini juga bersifat praktis, mudah dioperasikan, tidak memerlukan koneksi internet, dan bebas biaya tambahan. Implementasi sistem terbukti menjadi solusi efektif, terjangkau, dan berkelanjutan dalam pengelolaan piutang pada UMKM S.O Pesona Asri.

This study addresses the challenges faced by MSME S.O Pesona Asri due to the manual recording of accounts receivable, which has resulted in difficulties in monitoring outstanding balances and delays in collections. The research adopts a descriptive qualitative method, with data collected through observation, interviews, and documentation. The objective of this study is to design and implement an accounts receivable credit limit system using Microsoft Excel VBA to enhance recording efficiency, data accuracy, and monitoring of credit limits and due dates. The system was developed through several stages, including needs analysis, system design, and testing. Its main features include credit sales recording, automated receivables calculation, credit limit monitoring, invoice generation, and due date alerts, supported by conditional formatting, data validation, and structured formulas. Evaluation using the PIECES framework indicates that the system improves operational efficiency, facilitates the billing process, and reduces the risk of late payments. Additionally, the system is practical, user-friendly, does not require an internet connection, and is free of additional costs. Overall, the implementation of this system proves to be an effective, affordable, and sustainable solution for managing accounts receivable at MSME S.O Pesona Asri.