Google Forms & Sheets Cashbook
Adrian Suryawinata
Google Forms & Sheets Cashbook Automation
Developed an automated cashbook system using Google Forms, Google Sheets, and Google Apps Script to simplify financial transaction recording.
The project involved:
Creating a Google Form for recording income and expenses.
Automatically transferring form submissions into a structured transaction ledger.
Implementing automatic date and time recording with optional manual overrides.
Organizing transaction categories, amounts, and payment sources.
Generating financial summaries to monitor income, expenses, and balances.
Supporting continuous cash balance tracking across reporting periods.
Tools: Google Forms, Google Sheets, Google Apps Script.
Real project. Portfolio preview reconstructed using anonymized example data to protect private financial information.
Like this project
Posted Oct 31, 2026
Google Forms & Sheets Cashbook Automation Developed an automated cashbook system using Google Forms, Google Sheets, and Google Apps Script to simplify financ...
Likes
0
Views
0
