| dc.contributor.advisor | Viana, Eka Dasra | |
| dc.contributor.author | Rahmadini, Tazkia Aura | |
| dc.date.accessioned | 2026-07-29T08:33:16Z | |
| dc.date.available | 2026-07-29T08:33:16Z | |
| dc.date.issued | 2026 | |
| dc.identifier.uri | http://repository.ipb.ac.id/handle/123456789/176206 | |
| dc.description.abstract | Perkembangan teknologi informasi mendorong pelaku usaha, termasuk usaha jasa, untuk menerapkan sistem informasi yang mampu mendukung pengelolaan transaksi dan penyusunan laporan keuangan secara lebih efektif dan efisien. Penelitian ini bertujuan mengidentifikasi permasalahan pencatatan dan pelaporan keuangan pada UMKM Zada Tour & Travel, merancang sistem pencatatan transaksi keuangan berbasis Microsoft Excel VBA, serta mengevaluasi kesesuaian laporan keuangan yang dihasilkan dengan SAK EMKM. Penelitian menggunakan pendekatan applied research dengan metode studi kasus. Data dikumpulkan melalui observasi, wawancara, dokumentasi dan studi pustaka sedangkan pengembangan sistem menggunakan metode SDLC model Waterfall dengan pengujian blackbox testing dan evaluasi menggunakan metode PIECES. Sistem menghasilkan laporan keuangan yang sesuai dengan SAK EMKM serta meningkatkan efisiensi pencatatan transaksi. | |
| dc.description.sponsorship | The advancement of information technology has encouraged business entities, including service-based enterprises, to implement information systems that support transaction management and financial statement preparation more effectively and efficiently. This study aims to identify the problems in the financial recording and reporting process at Zada Tour & Travel, develop a financial transaction recording system based on Microsoft Excel Visual Basic for Applications (VBA), and evaluate the conformity of the resulting financial statements with the Financial Accounting Standards for Micro, Small, and Medium Entities (SAK EMKM). This study employed an applied research approach using a case study method. Data were collected through observation, interviews, documentation, and literature review, while the system was developed using the SDLC Waterfall model with Black Box Testing and evaluation using the PIECES framework. The developed system produces financial statements in accordance with SAK EMKM, improves the efficiency of transaction recording. | |
| dc.language.iso | id | |
| dc.publisher | IPB University | id |
| dc.title | Perancangan Sistem Pencatatan Transaksi Keuangan Berbasis Microsoft Excel VBA pada UMKM Zada Tour &Travel | id |
| dc.title.alternative | Design of a Financial Transaction Recording System Based on Microsoft Excel VBA for Zada Tour & Travel MSMEs | |
| dc.type | Tugas Akhir | |
| dc.subject.keyword | microsoft excel VBA | id |
| dc.subject.keyword | statement financial | id |
| dc.subject.keyword | SAK EMKM | id |
| dc.subject.keyword | accounting information systems | id |
| dc.subject.keyword | MSMEs | id |
| dc.subtype | Undergraduate Theses | |
