Ashari, Mochammad Gaza Choirul (2025) Implementasi Excel For Accounting Sebagai Sistem Pembukuan Dalam Meningkatkan Efektifitas Keuangan Pada Arus Pendapatan Di Okalo Barbershop. Diploma thesis, Universitas Hayam Wuruk Perbanas.
![[img]](http://eprints.perbanas.ac.id/style/images/fileicons/text.png) |
Text
Artikel.pdf Restricted to Repository staff only Download (425kB) |
|
Text
COVER.pdf Restricted to Registered users only Download (1MB) |
|
Text
BAB I.pdf Download (590kB) |
|
Text
BAB II.pdf Download (1MB) |
|
Text
BAB III.pdf Restricted to Repository staff only Download (592kB) |
|
Text
BAB IV.pdf Restricted to Repository staff only Download (1MB) |
|
Text
BAB V.pdf Download (251kB) |
|
Text
LAMPIRAN.pdf Restricted to Repository staff only Download (1MB) |
Abstract
Okalo Barbershop still uses manual financial recording methods with handwritten notes, which causes various problems such as potential recording errors, inefficiency, risk of data loss, and internal conflicts between owners and employees. To overcome these problems, a digital-based accounting information system was designed that is integrated with the Google Workspace platform. This system utilizes Google Forms as the data input medium, Google Drive as the document storage location, and Google Sheets as the financial data processing tool. Features such as autofill, filters, and automatic formulas like IF, SUMIF, and SUM are used to support the creation of accurate and efficient reports. The financial reports generated cover the period of July 2025, including account codes, general journals, income statements, and balance sheets, in accordance with SAK EMKM standards. The implementation of this system facilitates real-time data tracking, minimizes human error, and enhances data integrity. Additionally, this system serves as a strategic tool to support the digitalization of SMEs and improve financial management quality at Okalo Barbershop.
| Item Type: | Thesis (Diploma) |
|---|---|
| Subjects: | 600 - TECHNOLOGY > 650 - 659 MANAGEMENT & PUBLIC RELATIONS > 657 - ACCOUNTING > 657.028 - ACCOUNTING INFORMATION SYSTEMS 600 - TECHNOLOGY > 650 - 659 MANAGEMENT & PUBLIC RELATIONS > 657 - ACCOUNTING > 657.42 - COST ACCOUNTING |
| Divisions: | Finance and Banking Diploma > Practice Working Report |
| Depositing User: | MOCHAMMAD GAZA CHOIRUL ASHARI |
| Date Deposited: | 19 Sep 2025 03:08 |
| Last Modified: | 19 Sep 2025 03:08 |
| URI: | http://eprints.perbanas.ac.id/id/eprint/13782 |
Actions (login required)
 |
View Item |