Income & Expense Budget Tracker Dashboard | Google Sheets & Apps Script (D23)

A personal finance dashboard on Google Sheets that covers the three things a budget spreadsheet usually cannot: live currency conversion, shared expenses between people, and a dashboard that updates itself instead of being rebuilt each month.

What it does

Income and expenses are entered and immediately reflected on a real-time dashboard. Live exchange rates are pulled from a currency API, so someone earning or spending in more than one currency sees a true position rather than one converted at a rate they set months ago. The friend debt tracker handles the money you lent or split — the category that quietly disappears from most budgets — and role-based access means a household or a team can share the app without everyone having the same rights.

Highlights

• Income and expense management
• Real-time, auto-updating financial dashboard
• Currency converter with live rates
• Friend debt tracker for shared and lent money
• Role-based access for admin and user
• Google Sheets as the database — your data stays yours

Who it is for

Households, freelancers and solopreneurs budgeting seriously, groups splitting shared costs, and anyone dealing in more than one currency who is tired of a spreadsheet that is out of date the moment rates move.