Indonesian Journal of Law and Economics Review
Vol. 21 No. 1 (2026): February

Analysis of the Implementation of Raw Material Inventory Management and Recording Using Stock Cards and Spreadsheets to Support Internal Control at CV Gemilang Ratabata: Analisis Penerapan Pengelolaan dan Pencatatan Persediaan Bahan Baku Berbasis Kartu Stock & Spreadsheet dalam Mendukung Pengendalian Internal pada CV Gemilang Ratabata

Silfa Natari Lutfianti (Program Studi Akuntansi, Universitas Muhammadiyah Sidoarjo)
Fityan Izza Noor Abidin (Program Studi Akuntansi, Universitas Muhammadiyah Sidoarjo)



Article Info

Publish Date
20 Sep 2026

Abstract

General Background: Internal control is essential for maintaining accurate inventory information and supporting effective business operations. Specific Background: CV Gemilang Ratabata uses stock cards and spreadsheets to manage and record raw material inventory, but its semi-manual system may cause delays in updating inventory records. Knowledge Gap: Previous studies have discussed internal control and inventory management, while studies specifically examining the combined use of stock cards and spreadsheets in supporting internal control remain limited. Aims: This study analyzes the implementation of raw material inventory management and recording using stock cards and spreadsheets and evaluates their role in supporting internal control at CV Gemilang Ratabata. Results: A descriptive qualitative method was applied through observation, interviews, and documentation involving operational, finance, purchasing, field coordination, kitchen, bar, and academic informants. The findings show that the company implements stock checking, stock opname, purchase requests, purchasing, goods receipt, stock recording, reconciliation, and monitoring. These practices support internal control through segregation of duties, risk assessment, control activities, information and communication, and monitoring. Novelty: The study examines the combined application of stock cards and spreadsheets within a food and beverage company as a semi-manual inventory recording approach. Implications: Consistent recording, stronger monitoring, and periodic evaluation are needed to maintain inventory accuracy and support internal control. Key Findings Highlights Semi-manual recording remains prone to delays during busy operations. Segregation of duties and reconciliation help maintain data accuracy. Periodic physical checks identify discrepancies between records and actual quantities. Keywords : Raw Material Inventory, Inventory Recording, Stock Cards, Spreadsheets, Internal Control

Copyrights © 2026






Journal Info

Abbrev

ijler

Publisher

Subject

Economics, Econometrics & Finance Law, Crime, Criminology & Criminal Justice

Description

Indonesian Journal of Law and Economics Review (IJLER) is published by Universitas Muhammadiyah Sidoarjo four times a year. This journal provides immediate open access to its content on the principle that making research freely available to the public supports a greater global exchange of ...