The household budget lived in a spreadsheet nobody kept up to date.

EconoMês · Household finances · In production since May 2026

Problem
Household budget in a spreadsheet nobody kept up to date, with fixed bills entered again every month.
What I did
Transactions per account and card, categories with a default account, recurring and installment transactions, and yearly reports with fixed and variable spending.
Result
Recurring transactions repeat on their own and the yearly reports come out ready. In production since May 2026.

Categories with a default account

What I observedOn every transaction you had to remember which account or card the expense had come from.

Solution appliedCategories have subcategories (Food, Groceries, Bakery) and each one can have a default account or card. When you pick the category, the transaction already comes with the right account.

System screen: Categories with a default account

The month per account and card

What I observedIn the spreadsheet, what left the checking account and what went on the card were mixed together, and the monthly balance did not match the statement.

Solution appliedThe month screen shows income, expenses and balance, grouped by category, with one tab per account and card. You can see everything together or only what went through one account.

System screen: The month per account and card

Recurring transactions

What I observedRent, internet, school and salary were typed in again every month.

Solution appliedEach fixed bill is registered once, with category, account and amount. At the start of the month, one button imports them all into the transactions, and the amount can still be adjusted.

System screen: Recurring transactions

Installment purchase

What I observedA purchase in 6 installments vanished from the spreadsheet after the first one, and the next month arrived with a surprise.

Solution appliedThe person enters the total amount and the number of installments, and the system creates one per month. The description accepts sums (10+13.5) and works out the total on its own. Changes apply to one installment, to the following ones or to all of them.

System screen: Installment purchase

Report by card statement

What I observedThe card statement closes mid-month, and the calendar-month report showed spending that would only be billed the next month.

Solution appliedThe yearly report has two views: by purchase date and by statement, respecting each card's closing day. It shows income, expenses and balance month by month, expenses by category and the installments still to come.

System screen: Report by card statement

Fixed, variable and out-of-pattern spending

What I observedAt the end of the year nobody knew how much of the budget was fixed commitments, nor which category had weighed more than usual.

Solution appliedThe report splits fixed from variable spending, points out the months when a category went off pattern and compares each category with the previous year.

System screen: Fixed, variable and out-of-pattern spending
Role
Requirements gathering, interface design, database, API, front end and deployment: Álvaro Marinho.
Period
In production since May 2026
Technologies
Angular 22, Bootstrap 5, Chart.js, TypeScript, Node.js, Express 5, Sequelize, MariaDB 10.11, autenticação JWT, PDFKit, PWA, CI/CD com GitHub Actions, VPS Linux (PM2 e nginx)