Dea Tiara Monalisa Butar-Butar, Juwenni Chia

Designing Accounting Software Using Microsoft Access For Cv C&L Ocean Ship

Introduction

Designing accounting software using microsoft access for cv c&l ocean ship. Automate accounting for CV C&L Ocean Ship with custom Microsoft Access software. Improve financial reporting, track inventory, and boost MSME decision-making.

Abstract

The deficient accounting recording system in CV C&L Ocean Ship is a result of manual transaction recording, causing inefficiencies and rendering financial reports irrelevant. This situation leads to potential inaccuracies and gaps in the completeness of reports crucial for decision-making. The objective of this community service initiative is to establish a Microsoft Access-based accounting system, encompassing forms, a bookkeeping system, and financial reporting. The methodology involves data collection through observations and partner interviews. The system includes three master lists there are main menu, transaction menu and report menu. The main menu has chart of account, inventory, supplier list, customer list, sales list, and employee list. Transaction menus have six forms to help owner record their daily transaction. The last one is the report menu contains nine types of financial reporting to assist the owner in knowing better about the company. These outputs are designed to assist Micro, Small, and Medium Enterprises (MSMEs), like CV C&L Ocean Ship, in gaining insights into inventory turnover and financial conditions beyond just cash flows. Consequently, MSMEs can enhance decision-making processes, boost sales, and better monitor their inventory.

Review

This paper addresses a highly pertinent issue concerning the critical need for robust accounting systems within Micro, Small, and Medium Enterprises (MSMEs), exemplified by CV C&L Ocean Ship. The abstract clearly articulates the significant challenges faced by businesses relying on manual accounting, including operational inefficiencies, irrelevant financial reporting, and the consequent hindrance to effective decision-making. The stated objective to establish a Microsoft Access-based accounting system is a direct and practical response to these deficiencies, aiming to provide a foundational digital solution for improved financial management and decision support for the target enterprise. The methodology, involving data collection through observations and partner interviews, appears appropriate for understanding the specific needs of the target MSME. The proposed system design details a comprehensive structure, encompassing a main menu with essential master lists (chart of accounts, inventory, customer/supplier details), six transaction forms for daily recording, and a report menu offering nine types of financial reports. While Microsoft Access provides a low-cost, accessible platform for custom database solutions, particularly for smaller enterprises, a critical review might question its scalability, security features, and long-term maintainability compared to more dedicated accounting software solutions, especially as the MSME grows. The abstract does not elaborate on the specific accounting principles integrated or the level of user training provided, which are crucial for the successful adoption and utility of such a system. The envisioned outputs of this initiative are commendable, specifically aiming to empower MSMEs with insights into inventory turnover and comprehensive financial conditions beyond mere cash flow tracking. This directly contributes to enhancing decision-making, boosting sales, and improving inventory monitoring, which are vital for sustainable growth. The project's focus on a "community service initiative" further highlights its practical contribution to local business development. For future considerations, it would be valuable to see longitudinal studies on the system's actual impact on business performance and owner decision-making, as well as an assessment of the transferability of this Access-based model to other MSMEs, considering their varied operational complexities and technical capabilities. Further work could also explore the integration of basic data analytics capabilities within the Access framework or the pathway for upgrading to more robust platforms as the business scales.

Full Text

Comments

You need to be logged in to post a comment.