Universitas Airlangga Official Website

Computer-based cash sale accounting information system design in NSC Polytechnic Surabaya canteen

Photo by Onolni com

The accounting information system is a tool to carry out control, one part with other parts involved will control each other. Sales transaction events are communicated through an accounting information system to interested parties in the form of sales reports and financial reports. In order to support sales activities that occur, we need information that presents the results of business sales that can be used to make further decisions. The information must be accurate, relevant, timely, and complete so that it can later be used by users of the information. To get this information, a good and accurate accounting information system is needed.

NSC Polytechnic Surabaya canteen is located at NSC Surabaya Polytechnic campus. The location is in st. Basuki Rahmat 85 Surabaya. The canteen is an individual business that rents space in the NSC Polytechnic Surabaya campus and is engaged in the business of food and beverages. The canteen sells a variety of delicious and economical food and beverage menus that are affordable to students and community around campus. The food menu includes nasi campur, fried noodles, nasi lodeh, etc. While the drink menu includes: nutri sari drink, milo drink, ABC coffee drink, etc. NSC Polytechnic Surabaya Canteen is a business that is engaged in food culinary. To meet the needs of students, campus employees, and lecturers as well as the community around the campus, the NSC Polytechnic Surabaya campus provides a canteen so that they do not need to leave campus to meet their needs. Various kinds of food and beverage menus provided by the NSC Polytechnic Surabaya canteen, from snacks to heavy meals, are presented at the NSC Polytechnic Surabaya canteen. Transaction activities carried out by the canteen owner are namely cash sales, cash purchases, and inventories.

Sales is an influential activity in trading businesses such as the canteen at NSC Polytechnic Surabaya campus. Many canteens wish to increase sales through providing technological innovations in providing services. Technology is developed as a means of obtaining sales information in order to make a decision using sales accounting information systems. A sales accounting information system will help canteen managers at the NSC Polytechnic Surabaya campus, such as speed in handling sales, reducing the risk of errors that occur in sales, saving administrative management, and easy control.

Sales transactions in the NSC Polytechnic Surabaya campus canteen are still recorded manually, making it difficult for canteen owners to obtain accurate information about the results of their sales. The sales accounting information system uses a MySQL database. MySQL database is a free database server that can be used for personal or business purposes alone without buying a license. The programming language used is using the Microsoft Visual Basic 6.0 programming language.

Based on the results of PIECES analysis, the process of recording cash sale transactions in the NSC Polytechnic Surabaya canteen is more organized and orderly, and this system has been feasible to be implemented in order to obtain accurate, relevant, and up-to-date information when needed, this computerized system is feasible because the technology used is adequate and easy to obtain and the value of profit is greater than the costs incurred, this system minimizes data loss and damage because this system stores data in protected database security from virus or malware attacks, using paper media for proof of sales transactions and proof of payment for room rent only. If we want to print a report stored in a database, then it can be printed at any time, service to customers can only be done at the NSC Polytechnic Surabaya canteen during working hours and come directly to the NSC Polytechnic Surabaya canteen so that we can know the number of customers present. The design stage of a computer-based cash sale accounting information system includes 3 designs: input design, output design, and database design.

Author: Prasetyo Widyo Iswara, S.E., M.A. & Nina Triolita, S.E., M.M.

Journal link: https://ojsicobuss.stiesia.ac.id/index.php/icobuss1st/article/view/170