MoneyNote (Solo Project)

About This Project

MoneyNote – Personal Finance Management System

· Google Apps Script & Spreadsheet Based · Bandung, West Java, Indonesia

MoneyNote is a personal web-based application built using Google Apps Script and Google Spreadsheet as the database. It functions as an integrated finance management system to automatically calculate monthly income, expenses, and allowance allocations such as play money, principal fund, and savings. The entire calculation logic is fully automated using QUERY and ARRAYFORMULA functions, providing real-time updates without manual recalculation.

System Overview

Developed a dynamic finance tracking form using HTML, CSS, and Google Apps Script.
Connected directly to a Google Spreadsheet acting as a live financial database.
Integrated read-only dashboards for monthly summary visualization.

Data Automation & Calculation Logic

Used ARRAYFORMULA to auto-expand calculations for new income or expense entries.
Implemented QUERY to summarize income and expenses by month, category, and type.
Calculated allowance allocations (Play, Principal, and Saving) based on predefined percentage logic.
Generated total balance and net difference automatically on every record update.

Dashboard & Visualization

Displayed financial summaries using embedded Google Charts visualizations.
Showed monthly expenditure breakdown and savings progress in percentage.
All updates reflected in real time upon new transaction submission.

Data Management & Tracking

Maintained a structured spreadsheet layout for Income, Expenses, and Summary sheets.
Implemented automatic monthly grouping using QUERY with date filters.
Separated editable sheets (for form submission) and read-only sheets (for calculation output).
Ensured data integrity through locked formula columns and restricted editing zones.

Outcome & Impact

Achieved a fully automated personal finance tracker with zero manual recalculation.
Increased awareness of spending patterns and monthly saving consistency.
Improved budgeting discipline through clear separation of allowance categories.
Delivered a lightweight, serverless solution — hosted entirely within the Google ecosystem.