Financial Dashboard Lab

Build a complete Financial Dashboard System in Google Sheets.

WHAT YOU'LL BUILD:

• Bank transaction importer (JSON/CSV)
• - Auto-categorization engine for transactions
• - Tax deduction identifier and tracker
• - Interactive HTML dashboard with charts and KPIs

WHAT'S INCLUDED:

• Starter repository with scaffolded code
• - Step-by-step requirements document
• - 26 automated tests to validate your work
• - One round of code review on your PR submission
• - Discord community access for support

WHO THIS IS FOR:

• You can write JavaScript and understand Google Apps Script basics
• - You have 12-16 hours over 2-4 weeks
• - You want a real financial tool you can use

SKILLS YOU'LL LEARN:

• Data import pipelines with error handling
• - Pattern matching for transaction classification
• - HTML Service dashboards with live data
• - Custom Google Sheets menus and triggers

PREREQUISITES:

• JavaScript proficiency
• - Basic Google Apps Script knowledge
• - GitHub account for forking starter repo

SUPPORT:

• Async support via GitHub Issues
• - Discord community (#financial-dashboard channel)
• - Response within 24 hours on business days

Use code EARLYBIRD20 for 20% off!