Article Per Year (5 Year)
p-Index From 2021 - 2026
0.23
P-Index
This Author published in this journals
All Journal Agregat: Jurnal Ekonomi dan Bisnis
Agustina Dwi Purnamasari
Universitas Indonesia
Economics, Econometrics & Finance

Published : 1 Documents Claim Missing Document
Claim Missing Document
Check
Articles

Found 1 Documents
Search

 1 
Accounting Information System Design for Revenue and Expenditure Cycles: Family Optic Agustina Dwi Purnamasari; Indah Melati
Agregat: Jurnal Ekonomi dan Bisnis Vol. 10 No. 2 (2026)
Publisher : Universitas Muhammadiyah Prof. DR HAMKA.

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.22236/agregat_vol10.i2/24037

Abstract

This study aims to analyze the business processes and design a Microsoft Excel based accounting information system for Family Optic. Currently, transaction recording at Family Optic is conducted manually using handwritten records, resulting in unstructured transaction documentation, limited inventory monitoring, and revenue estimates based on assumptions. To address these issues, this study designs an accounting information system for the revenue and expenditure cycles. This study employs the System Development Life Cycle (SDLC) method and incorporates the threats and controls framework to identify risks and determine appropriate controls for both cycles. The proposed Excel based accounting information system was tested through transaction simulation only. Therefore, scope of this study is limited to system design and simulation based testing. Full implementation and operational use were beyond its scope. The resulting system integrates a chart of accounts, inventory master data, purchase and sales records, cash receipts and cash disbursements records, journals, and income statements. The design system supports more systematic transaction recording, enables perpetual inventory monitoring, and generates more  structured financial information to facilitate business decision making.
Co-Authors Indah Melati