Penerapan Microsoft Excel dalam Pengolahan Data Transaksi dan Penyusunan Laporan Keuangan pada PT XYZ

This study describes how PT XYZ, a goods procurement company, uses Microsoft Excel to process transaction data and prepare financial statements. A descriptive qualitative approach was employed, using observation and documentation during a one-month internship. The data covered three months of company transactions in 2025. The findings show that transactions were recorded according to the chart of accounts (COA) and that account balances were processed through interconnected Excel worksheets. These worksheets included the general journal, sales journal, trial balance, and a worksheet combining balance sheet and profit and loss data. Together, they supported the preparation of the balance sheet, income statement, and statement of changes in equity. Linking the worksheets helped organize transaction data and carry account balances into the financial statements. The accuracy of the resulting information depended on complete supporting documents, careful transaction recording, and verification of account balances. During the study period, the company had yet to prepare a statement of cash flows and notes to the financial statements. The study documents how Excel supported the company’s reporting needs without quantifying changes in reporting effectiveness or accuracy.