The condominium split expenses and gas in a spreadsheet, and the annual financial report took days every year.

CondoMínimo · Condominium · In production since March 2026

Problem
Expense and gas splitting in a spreadsheet and a financial report that took days.
What I did
Gas readings with automatic splitting, monthly closing with bank slips and an annual report for the financial statement.
Result
Gas is read per apartment and split by the system, and the annual report comes out ready for the financial statement. In production since March 2026.

Gas per apartment

What I observedThe condominium split expenses and gas in a spreadsheet.

What I decidedGas reading per apartment: from the previous and current readings, the system calculates consumption in m³ and the gas cost, split automatically.

System screen: Gas per apartment

Monthly closing

What I decidedMonthly financial closing that combines gas, fixed expenses, the reserve fund and the maintenance fee, with one bank slip per apartment and payment tracking.

System screen: Monthly closing

Gas purchase

What I decidedGas purchase control: refill history and price per cubic meter.

Financial statement

What I observedThe annual financial statement took days every year.

What I decidedAnnual report ready for the financial statement, with income and expenses per month, account balance and the year's biggest expenses.

System screen: Financial statement
Role
Requirements gathering, interface design, database, API, front end and deployment: Álvaro Marinho.
Period
In production since March 2026
Technologies
Angular, TypeScript, Node.js, Express, Sequelize, MariaDB, Bootstrap 5, Chart.js, PDFKit, JWT, PM2, nginx, GitHub Actions