Student organizations in the Faculty of Economics and Business, Diponegoro University (FEB Undip), are required to prepare financial reports as part of their accountability for faculty-provided funds. The Non-Profit Organization Accounting Information System (SI AFIT), designed to assist in recording and preparing financial reports, currently faces limitations that hinder its effectiveness. This research aims to develop an improved version of SI AFIT using Microsoft Excel to address these challenges.

The study employed interviews with system users—comprising treasurers, auditors, and socializers from student organizations—alongside system observations and analysis of user guides to identify existing problems, their causes, and potential solutions. The findings revealed a critical issue: the lack of synchronization between the input and output modules in the previous system. To address this, researchers designed both logical and physical models of the system to guide the development process.

The improved system was tested by simulating 150 cash-in transactions, 500 cash-out transactions, and 54 memorial transaction accounts. Results demonstrated that the updated system effectively resolved prior issues, enabling better financial recording and reporting processes. This development highlights the potential of Excel-based accounting systems in supporting financial transparency and accountability within student organizations.