How to Build an Income and Expense Tracker Web App Using Apps Script | R41

R41 is a personal finance tracker that takes one thing seriously most spreadsheet trackers gloss over: money in your hand and money in the bank are not the same money. The dashboard shows income, expenditure, cash and accounts as four separate figures, and you move between the last two deliberately rather than pretending they are one pot.

Recording what comes in and goes out

One form handles both. Choose the entry type — income or expenditure — and the record lands in the matching sheet. Category and payment method are dropdowns fed from the spreadsheet, so adding Freelance, Utility Water or a new payment method is a row you type, not a code change. Every field has to be filled before it will save, and before it does the app reads the entry back to you — type, category, payment method, date — and asks whether it is right. That confirmation is what stops a mistyped amount becoming a month of confusion.

Cash and accounts kept apart

Income defaults to cash. If it actually landed in a bank, you register that account with its balance and the Accounts tile totals your banks separately. Deposit and Withdraw move money between cash and an account, and the balances update as soon as you confirm — so the tracker reflects where the money actually is, not just how much there is.

Reports you can take away

Income and expenses each get their own report with the full history: type, category, date, description and amount. Search across them, then copy, download to Excel, export a PDF or print.

Behind a login

The whole dashboard sits behind a username and password, which matters for a file whose entire contents are your own finances.