SpendLite: Desktop budgeting and personal finance tracker

ROLEFull-stack Engineer
DURATIONJune 2025
TEAM1 Full-stack Engineer
TECH STACKVB.NET, MySQL, Guna UI2, OxyPlot, SMTP

Overview

SpendLite is a desktop-based personal finance management application designed to help individuals, students, and professionals track their income, expenses, and savings. It provides a centralized platform for recording transactions, monitoring spending habits, and managing personal budgets. With categorized records, date-based filters, and visual financial charts, the system makes personal bookkeeping easier and helps users make better financial decisions.

Problem

Managing personal finances can be challenging without a reliable system for recording and monitoring transactions. Traditional methods, such as paper ledgers and scattered spreadsheets, often make it difficult to track expenses, review financial records, and maintain a consistent budget.

  • Disorganized Financial Records: Transactions recorded in different places make it difficult to maintain a complete and organized financial history.
  • Inefficient Expense Tracking: Finding past transactions and calculating total income or expenses can be time-consuming without searchable records.
  • Limited Financial Insights: Numerical records alone make it harder to understand spending patterns and compare income, expenses, and savings.
  • Difficult Periodic Monitoring: Reviewing financial activity across daily, weekly, monthly, and yearly periods can become inconvenient when using static records.

Solution

SpendLite is a desktop application built with a VB.NET Windows Forms frontend, a MySQL database, and the Guna UI2 framework for a modern user interface. It uses OxyPlot to display financial data through visual charts and SMTP email services to send 6-digit OTP verification codes for secure account registration and password recovery.

SpendLite - Financial Breakdown Dashboard and Add Transaction ModalClick to zoom

The system allows users to record income, expenses, and savings with customized transaction dates and categories. Users can search and manage records, filter transactions by day, week, month, or year, and monitor their current financial balance through automatically calculated summaries. The application also supports CSV exports for external recordkeeping and provides a personal dashboard where users can edit or delete their transactions.

SpendLite - Periodic Expense List and Transaction Management TableClick to zoom