PERANCANGAN SISTEM KEUANGAN DAN HARGA POKOK PENJUALAN BERBASIS SPREADSHEET UMKM KOPI MASSA

Adinta Putri Ramadani, . and Samudra Sangga Lelana, . and Rayhan Habib Abdullah, . (2026) PERANCANGAN SISTEM KEUANGAN DAN HARGA POKOK PENJUALAN BERBASIS SPREADSHEET UMKM KOPI MASSA. Tugas Akhir thesis, Universitas Pembangunan Nasional Veteran Jakarta.

[img] Text
ABSTRAK.pdf

Download (15kB)
[img] Text
AWAL.pdf

Download (1MB)
[img] Text
BAB 1.pdf
Restricted to Repository UPNVJ Only

Download (227kB)
[img] Text
BAB 2.pdf
Restricted to Repository UPNVJ Only

Download (500kB)
[img] Text
BAB 3.pdf
Restricted to Repository UPNVJ Only

Download (1MB)
[img] Text
BAB 4.pdf

Download (198kB)
[img] Text
DAFTAR PUSTAKA.pdf

Download (74kB)
[img] Text
RIWAYAT HIDUP.pdf
Restricted to Repository staff only

Download (63kB)
[img] Text
LAMPIRAN.pdf
Restricted to Repository UPNVJ Only

Download (1MB)
[img] Text
HASIL PLAGIARISME.pdf
Restricted to Repository staff only

Download (9MB)
[img] Text
ARTIKEL KI.pdf
Restricted to Repository staff only

Download (835kB)

Abstract

Kopi Massa MSME still faces challenges in managing its finances, including unstructured transaction recording, difficulties in monitoring cash flow, and the absence of a systematic approach to calculating the Cost of Goods Sold (COGS). These conditions result in inaccurate financial reports that are unable to optimally support business decision-making. This final project, undertaken by the authors, aims to produce a spreadsheet-based financial recording and COGS calculation system integrated with the AppSheet application, in order to support more effective, efficient, and accurate financial management for Kopi Massa MSME. The methods employed include literature review, interviews, observation, documentation, and data analysis to identify needs and design a system tailored to the MSME's requirements. The outcomes of this project encompass a financial recording system comprising menus for sales, purchases, cash inflows, cash outflows, production, inventory, and automatic COGS calculation. The system also generates more structured financial reports in accordance with SAK EMKM standards, improves the accuracy of transaction recording, and facilitates easier monitoring of cash flow and inventory, thereby supporting more informed business decision-making. Accordingly, the system serves as a practical and affordable solution for MSMEs to enhance the quality of financial management and ensure business sustainability

Item Type: Thesis (Tugas Akhir)
Additional Information: [No. Panggil : 2310102004, 2310102020, 2310102034} {Pembimbing Murdhaningsih] {Penguji 1: Agustina Riyanti] [Ketua Penguji : Nabillah Farras Luthfi]
Uncontrolled Keywords: AppSheet, Cost of Goods Sold, Financial Reports, SAK EMKM, Spreadsheet, MSME
Subjects: H Social Sciences > HF Commerce > HF5601 Accounting
H Social Sciences > HG Finance
Divisions: Fakultas Ekonomi dan Bisnis > Program Studi Akuntansi (DIII)
Depositing User: SAMUDRA SANGGA LELANA
Date Deposited: 03 Sep 2026 03:00
Last Modified: 03 Sep 2026 03:00
URI: http://repository.upnvj.ac.id/id/eprint/51183

Actions (login required)

View Item View Item