Land Plot Sales Information System with Automatic Installment Tracking
Keywords:
sales information system, land plot, multi-year installment, waterfall method, property developerAbstract
Mid-scale property developers in Indonesia commonly still rely on manual ledger-based recording for land plot sales transactions and multi-year installment tracking, leaving data vulnerable to loss and making arrears detection difficult. This study designs and builds a prototype Land Plot Sales Information System at CV. Ariesta Prima Palembang using a five-phase Waterfall method, with web-based implementation (PHP, MySQL, Bootstrap); data collection was carried out through observation of transaction flows, interviews with five informants, and analysis of contract documents from four projects. The database design was upgraded from the two-table structure of the manual system to a normalised five-table model (project, plot, customer, contract, installment) that accommodates multi-project dimensions and automated installment schedules. Black-Box testing of 26 scenarios showed 100% functional conformance; User Acceptance Testing with 11 cross-role respondents yielded a Likert mean of 4.3 out of 5 with 87% acceptance, where the Finance Division gave the highest score due to reduced manual reconciliation workload. The contributions of this study include mapping the requirements of mid-scale property sales information systems that are rarely addressed in Indonesian retail literature and a database design that can serve as a reference for similar developers.
References
- B. Hartono, "Sistem Informasi Penjualan Berbasis Web Pada Toko Buku Putra Ilmu Semarang," Jurnal Ilmiah Sistem Informasi, vol. 3, no. 3, hal. 11–18, 2025, doi: 10.51903/qbaxkk13.
- F. Herik, Kristina, dan T. Willay, "Rancang Bangun Sistem Informasi Persediaan Dan Penjualan Barang Pada Toko Herik Berbasis Web," INTEKSIS, vol. 12, no. 2, hal. 40–50, 2025, doi: 10.66003/inteksis.v12i2.10590.
- D. Joel dan Wasino, "Perancangan Sistem Informasi Penjualan Produk Interior Pelengkap Jendela dan Ruangan Berbasis Web," Jurnal Ilmu Komputer dan Sistem Informasi, vol. 13, no. 1, 2025, doi: 10.24912/jiksi.v13i1.32878.
- D. N. Sari, V. Amalia, dan D. Apriadi, "Penerapan Metode Waterfall dalam Perancangan Sistem Informasi Penjualan dan Persediaan Barang," Jurnal Komputer Teknologi Informasi Sistem Informasi (JUKTISI), vol. 4, no. 2, hal. 621–630, 2025, doi: 10.62712/juktisi.v4i2.489.
- S. Sudjalmo dan T. Willay, "Perancangan Sistem Informasi Persediaan dan Penjualan Pada PT. Anzon Autoplaza Pontianak Dengan Pencarian Sekuensial," Jurnal Esensi Infokom, vol. 9, no. 2, 2025, doi: 10.55886/infokom.v9i2.344.
- E. Arribe, E. Safitri, dan U. Isnaini, "Rancang Bangun Sistem Informasi Penjualan Mobil Bekas Berbasis Web Pada Showroom Gunmobilindo," Jurnal Esensi Infokom, vol. 8, no. 1, hal. 32–39, 2024, doi: 10.55886/infokom.v8i1.846.
- K. Ulum, K. Hati, dan Aristejo, "Sistem Informasi Pemesanan dan Pemasangan Aluminium dan Kaca Berbasis Web pada Ical Karya Kaca Aluminium," Jurnal Sistem Informasi, vol. 14, no. 1, hal. 45–50, 2025, doi: 10.51998/jsi.v14i01.609.
- Syahrian dan S. Yunita, "Implementasi Metode CRM Pada Sistem Informasi Penjualan Barang Elektronik," Informasi Interaktif: Jurnal Informatika dan Teknologi Informasi, vol. 7, no. 3, hal. 170–176, 2023, doi: 10.37159/jii.v7i3.7.
- H. Yakub, B. Daniawan, A. Wijaya, dan L. Damayanti, "Sistem Informasi E-Commerce Berbasis Website Dengan Metode Pengujian User Acceptance Testing," JSITIK: Jurnal Sistem Informasi dan Teknologi Informasi Komputer, vol. 2, no. 2, hal. 113–127, 2024, doi: 10.53624/jsitik.v2i2.362.
- R. Sutjiadi, T. Rahmawati, dan A. A. Prahartiwi, "Algoritma C4.5 Untuk Klasifikasi Kelayakan Kredit Calon Debitur Pada Sistem Informasi Penjualan," Jurnal Sistem Informasi Bisnis, vol. 12, no. 2, hal. 89–97, 2022, doi: 10.21456/vol12iss2pp89-97.
- Waliyah, F. Aprilyani, Muchlis, dan V. Febriyanti, "Pengembangan Sistem Informasi Penjualan Berbasis Web," Jurnal Sistem Informasi, vol. 14, no. 2, hal. 51–59, 2025, doi: 10.51998/jsi.v14i02.643.
- W. S. Dharmawan, "Penerapan Model Rapid Application Development Dalam Pembuatan Sistem Informasi Akuntansi Penjualan Dan Pembelian Berbasis Web," Jurnal Sistem Informasi Akuntansi, vol. 6, no. 1, hal. 65–73, 2025, doi: 10.31294/justian.v6i1.8803.
- A. E. Tampubolon dan F. Hidayat, "Perancangan Sistem Informasi Inventarisasi Aset Berbasis Web Menggunakan Metode Waterfall," Zona Komputer, vol. 13, no. 3, 2024, doi: 10.37776/zkomp.v13i3.1458.
- H. Putra dan O. Amelia, "Implementasi Metode Waterfall Pada Sistem Informasi Laporan Kinerja Berbasis Website," Jurnal Komputer Teknologi Informasi dan Sistem Informasi (JUKTISI), vol. 3, no. 1, hal. 706–713, 2024, doi: 10.62712/juktisi.v3i1.250.
- Chandra dan D. Setiawan, "Perancangan Sistem Informasi Pada JJ Gym Menggunakan Metode Waterfall," Jurnal SANTI - Sistem Informasi dan Teknik Informasi, vol. 3, no. 3, hal. 144–152, 2024, doi: 10.58794/santi.v3i3.688.
- B. Fachri, C. Rizal, dan Supiyandi, "Penerapan Metode Waterfall Dalam Perancangan Sistem Informasi Merdeka Belajar Kampus Merdeka Berbasis Web," Jurnal Komputer Teknologi Informasi dan Sistem Informasi (JUKTISI), vol. 2, no. 3, hal. 591–597, 2024, doi: 10.62712/juktisi.v2i3.147.
- N. Fikri, E. Saputra, Syaifullah, M. Fronita, dan A. Marsal, "Implementasi Layanan Payment Gateway pada Sistem Informasi Travel Haji dan Umroh," Jurnal Teknologi Sistem Informasi dan Aplikasi, vol. 7, no. 3, hal. 1055–1062, 2024, doi: 10.32493/jtsi.v7i3.40637.
- M. Maghfiro dan A. Homaidi, "Perancangan Sistem Informasi Inventaris di Kantor Desa Sumberanyar," JUSTIFY: Jurnal Sistem Informasi Ibrahimy, vol. 3, no. 2, hal. 141–149, 2025, doi: 10.35316/justify.v3i2.5892.
- Syahrian dan S. Yunita, "Implementasi Metode CRM Pada Sistem Informasi Penjualan Barang Elektronik," Informasi Interaktif: Jurnal Informatika dan Teknologi Informasi, vol. 7, no. 3, hal. 170–176, 2023, doi: 10.37159/jii.v7i3.7.
- Novilia dan Wasino, "Perancangan Sistem Informasi Manajemen Data Pemesanan Berbasis Website PT. APB," Jurnal Ilmu Komputer dan Sistem Informasi, vol. 12, no. 1, 2024, doi: 10.24912/jiksi.v12i1.28272.