The application of the Microsoft Excel Electronic spreadsheet (ME) in the materials accounting in the mining enterprises owned by the Vietnam Mineral Coal Industry Group
- Authors: Ngoc Bich Thi Nguyen *, Hanh Hong Thi Pham
Faculty of Economics and Business Administration, Hanoi University of Mining and Geology, Vietnam
- Keywords: Materials Accounting, Microsoft Excel.
- Received: 18th-Aug-2020
- Revised: 15th-Sept-2020
- Accepted: 31st-Oct-2020
- Online: 31st-Oct-2020
The article refers to the application of the Microsoft Excel Electronic spreadsheet (ME) in materials accounting. Base on the practical study of the materials accounting in the mining enterprises owned by the Vietnam Mineral Coal Industry Group (TKV) in conjunction with the study of 200/BTC-TT in 2014, the group of authors have designed the sheets to serve for the accounting of materials in the mining enterprises. In this, the sheets save the basic information about the business, the sheets of ME are designed to store the data (the inputs for materials accounting), and the sheets for the output of the material ledger. The sheets are designed with a friendly interface, complied with the regulations of the Ministry of Finance and in accordance with the actual conditions in the mining business. The functions of ME are the maximum used for the computational formulas in the ledger to ensure complete automation of writing ledger. In other words, each time the accounting document is entered in the Database, the ledger is updated immediately by using real-time processing. It is possible to say the research results of the article can be considered as a software written on the background of the ME for accounting work.
Phạm Thị Hồng Hạnh, (2018). Nghiên xây dựng hệ thống thông tin kế toán phục vụ quản trị chi phí trong các doanh nghiệp khai thác than thuộc Tập đoàn Công nghiệp Than – Khoáng sản Việt Nam. Luận án tiến sỹ. Trường Đại học Mỏ-Địa chất. Hà Nội.
Nguyễn Thị Bích Ngọc, (2010). Tin học ứng dụng trong kinh tế. Trường Đại học Mỏ Địa chất, Hà Nội.
Bùi Thị Thu Thủy, (2014). Nguyên lý kế toán. Nhà xuất bản Khoa học kỹ thuật, Hà Nội.
https://thuvienphapluat.vn/van-ban/Doanh-nghiep/Thong-tu-200-2014-TT-BTC-huong-dan-Che-do-ke-toan-Doanh-nghiep-263599.aspx - Thông tư hướng dẫn chế độ kế toán doanh nghiệp