budget-visualizer

The School Accounting Budget Status Board is a web-based visualization tool that loads Excel files downloaded from Edufine and helps users grasp complex school budget data at a glance. Files are not uploaded to a server; they are read directly in the current browser, and the tool can be used without signing up or storing data in a separate database. Basic use involves loading either the Business Management Card (Current Amount) or Business Management Card (Budget) file. From this file, users can check their own budget, committed expenditure amounts, planned future spending, expected balances reflected in plans, balances by detailed project and detailed category, and projects with large remaining balances. The Expenditure Budget Execution Status List can also be loaded, but because it lacks a payment amount column, it is displayed only up to the commitment stage. Using the execution plan feature, users can enter planned future spending in advance and have it immediately reflected in expected balances. Entered values are saved in the browser's localStorage so they can be reviewed again on the same device, and the original Edufine data is not modified. On shared PCs, the Clear Data feature can delete both the loaded Excel data and saved entries at once. Adding the 102-2 execution performance file allows the school's overall budget to be viewed by payment completed, payment pending, and uncommitted statuses. Users can drill down through the hierarchy of policy project → unit project → detailed project → detailed category, and separately view projects with large payment-pending amounts or uncommitted balances. It also supports entering planned spending amounts for administrative expense budgets, balances, and calculation details. Linking the 201 revenue data enables a supplementary settlement forecasting feature that shows revenue and expenditure flows together and calculates the estimated net surplus carryover. However, this is intended only to gauge trends based on current data and does not replace final settlement documents. Technically, the project is built with Next.js. It can be run locally with Node.js 22 or higher and npm, or deployed by connecting the GitHub repository to Vercel. Amounts are displayed in easy-to-read units of eok and man won, and status colors and hierarchical bar charts distinguish execution stages and budget sizes.