Permana, Andini Safira (2025) Sistem Manajemen Piutang Berbasis Excel For Accounting pada PT. Nawasena Karya Prima. Diploma thesis, Universitas Hayam Wuruk Perbanas.
![[img]](http://eprints.perbanas.ac.id/style/images/fileicons/text.png) |
Text
ARTIKEL ILMIAH.pdf Restricted to Registered users only Download (2MB) |
|
|
Text
COVER.pdf Restricted to Registered users only Download (1MB) |
|
|
Text
BAB I.pdf Download (317kB) | Preview |
|
|
Text
BAB II.pdf Download (668kB) | Preview |
|
|
Text
BAB III.pdf Restricted to Registered users only Download (278kB) |
|
|
Text
BAB IV.pdf Restricted to Registered users only Download (4MB) |
|
|
Text
BAB V.pdf Download (269kB) | Preview |
|
|
Text
LAMPIRAN.pdf Restricted to Registered users only Download (1MB) |
Abstract
PT. Nawasena Karya Prima is currently grappling with the challenges posed by the manual management of accounts receivable, which has resulted in delays in debt collection and difficulties in monitoring the status of outstanding payments. The objective of this study is to develop a system for managing accounts receivable in Excel for Accounting that utilizes VBA macros to automate the recording, monitoring, and reminder of overdue payments. The study employs a qualitative approach, examining the system's design through observational studies, interviews, and document analysis of credit transactions from May to June of 2025. The result of the implementation is a system of Excel that is integrated with features for inputting data, electricity, dashboard monitoring, and automated reminders. The integration of these features has the potential to increase the efficiency of managing accounts receivable, minimize the delay in invoicing, and provide accurate information about the status of accounts receivable. The integration of these features also has the potential to create a more structured and accountable workflow. Keywords: Excel for Accounting, VBA, Automation, Accounts Receivable, PT. Nawasena Karya Prima
| Item Type: | Thesis (Diploma) |
|---|---|
| Subjects: | 600 - TECHNOLOGY > 650 - 659 MANAGEMENT & PUBLIC RELATIONS > 657 - ACCOUNTING > 657.092 - ACCOUNTANTS |
| Divisions: | Accounting Diploma > Practice Working Report |
| Depositing User: | ANDINI SAFIRA PERMANA |
| Date Deposited: | 17 Sep 2025 04:05 |
| Last Modified: | 17 Sep 2025 04:05 |
| URI: | http://eprints.perbanas.ac.id/id/eprint/13748 |
Actions (login required)
 |
View Item |