Skip to main content
journal@msti-indonesia.com 081377790601
Register
Articles

Development of Budget Management System Using Visual Basic .NET and MySQL Database: A Desktop Application for Personal Financial Tracking

  • 1* SourceCodester Community

* Corresponding Author: Janobe Janobe

Open Access
DOI
https://doi.org/10.59431/jda.v4i1.660
Published
Pages
24-33

Issue

Vol. 4 No. 1 (2025)

Journal Dekstop Application (JDA)
June

Abstract

This study developed a desktop-based Budget Management System using Visual Basic .NET 2015 and a MySQL database to address the growing need for simple, secure, and offline financial management tools. The system enables users to record, update, and review income and expenses while automatically generating summaries of total income, total expenses, and current balance. Designed under the Software Development Life Cycle (SDLC) framework, it prioritizes usability, reliability, and privacy by storing all data locally and eliminating dependency on internet connectivity or subscription-based platforms. Testing results confirm that the system performs efficiently, remains stable even with large datasets, and is intuitive for users of varying technical backgrounds. Beyond its practical value, the system serves educational and developmental purposes by illustrating principles of database integration, user interface design, and software engineering in Visual Basic .NET. Although current limitations include manual installation and single-user operation, these provide clear directions for future improvement, such as automated setup, cross-platform compatibility, and advanced visualization features. Overall, the project demonstrates that accessible and privacy-oriented technology can significantly improve personal financial management while promoting financial literacy and independence.

Keywords

Budget Management System Visual Basic .NET MySQL Financial Literacy Desktop Application

How to Cite

Janobe, J. (2025). Development of Budget Management System Using Visual Basic .NET and MySQL Database: A Desktop Application for Personal Financial Tracking. Journal Dekstop Application (JDA), 4(1), 24-33. https://doi.org/10.59431/jda.v4i1.660

References

  • Ameriks, J., Caplin, A., & Leahy, J. (2003). Wealth accumulation and the propensity to plan. The Quarterly Journal of Economics, 118(3), 1007–1047. https://doi.org/10.1162/00335530360698487
  • Andriana, M., Panjaitan, R., & Sumarlin, T. (2021). Sistem informasi pengelolaan anggaran dengan metode R&D. Evolusi: Jurnal Sains dan Manajemen, 9(2). https://doi.org/10.31294/evolusi.v9i2.11147
  • Fernandes, D., Lynch, J. G., & Netemeyer, R. G. (2014). Financial literacy, financial education, and downstream financial behaviors. Management Science, 60(8), 1861–1883. https://doi.org/10.1287/mnsc.2013.1849
  • Grable, J. E., & Joo, S. H. (2004). Environmental and biopsychosocial factors associated with financial risk tolerance. Financial Counseling and Planning, 15(1), 73–82.
  • Lusardi, A., & Mitchell, O. S. (2014). The economic importance of financial literacy: Theory and evidence. Journal of Economic Literature, 52(1), 5–44. https://doi.org/10.1257/jel.52.1.5
  • Microsoft Corporation. (2015). Visual Basic .NET language specification. Microsoft Developer Network. https://docs.microsoft.com/en-us/dotnet/visual-basic/
  • Oracle Corporation. (2023). MySQL 8.0 reference manual. https://dev.mysql.com/doc/refman/8.0/en/
  • Patel, N. K., & Patel, R. M. (2016). Development of personal finance management system using .NET framework. International Journal of Computer Applications, 145(8), 23–27. https://doi.org/10.5120/ijca2016910720
  • Ramsey, D. (2013). The total money makeover: A proven plan for financial fitness. Thomas Nelson Publishers.
  • Riadi, R., Tedja, B., & Basatha, R. (2024). Pembuatan aplikasi toko komputer dengan CRUD berbasis Visual Basic dan MySQL. Al-Dyas, 4(1), 411–423. https://doi.org/10.58578/aldyas.v4i1.4518
  • Setiawan, T. (2025). Sistem informasi penggajian pegawai berbasis desktop pada CV. Hijab Geulis Konveksi. Internal: Information System Journal, 8(1), 37–46. https://doi.org/10.32627/internal.v8i1.1424
  • Shim, S., Barber, B. L., Card, N. A., Xiao, J. J., & Serido, J. (2010). Financial socialization of first-year college students: The roles of parents, work, and education. Journal of Youth and Adolescence, 39(12), 1457–1470. https://doi.org/10.1007/s10964-009-9432-x
  • Tafonao, R., Hondro, R., & Panjaitan, M. (2023). Perancangan sistem informasi anggaran pendapatan belanja daerah kecamatan dengan metode line-item budgeting. Bulletin of Information and Data Science (Bulletinds), 2(3), 118–123. https://doi.org/10.47065/bulletinds.v2i3.5312
  • Thaler, R. H., & Sunstein, C. R. (2008). Nudge: Improving decisions about health, wealth, and happiness. Yale University Press.
  • Troelsen, A., & Japikse, P. (2017). Pro Visual Basic 2015. Apress.
  • Ultariani, N., Putra, N., & Amroni, A. (2020). Perancangan sistem informasi persediaan dan penjualan pada Toko Ria Bangunan dengan menggunakan bahasa pemrograman Visual Basic 2010 dan database MySQL. Jurnal Digit, 10(2), 220. https://doi.org/10.51920/jd.v10i2.172
  • Xiao, J. J., & O’Neill, B. (2016). Consumer financial education and financial capability. International Journal of Consumer Studies, 40(6), 712–721. https://doi.org/10.1111/ijcs.12285
  • Zaltin, A. (2025). Sistem informasi penerimaan dan pengeluaran kas berbasis desktop. RJTI: Rekayasa Jaringan dan Teknologi Informasi, 4(2). https://doi.org/10.30606/rjti.v4i2.3447

Author Biographies

  • Janobe Janobe, SourceCodester Community

    Independent Developer, SourceCodester Community, Philippines.

License

Copyright (c) 2025 Journal Dekstop Application (JDA)

This is an open-access journal. All articles are distributed under the terms of the Creative Commons Attribution 4.0 International License (CC BY 4.0), which permits unrestricted use, distribution, and reproduction in any medium, provided the original work is properly cited.

Under this license, you are free to:

  • Share: Copy and redistribute the material in any medium or format.
  • Adapt: Remix, transform, and build upon the material for any purpose, even commercially.

Attribution Requirements:
You must give appropriate credit, provide a link to the license, and indicate if changes were made. You may do so in any reasonable manner, but not in any way that suggests the licensor endorses you or your use.

Copyright and Retention:
Authors retain copyright without restrictions and grant this journal the right of first publication under an open-access model. The journal retains non-exclusive publishing rights for archiving, indexing, and scholarly dissemination.

Usage Statistics