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.

Solution appliedGas 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

Gas purchase

What I observedThere was no record of gas purchases or of the price paid per cubic meter.

Solution appliedGas purchase control: refill history and price per cubic meter.

System screen: Gas purchase

Monthly expenses

What I observedThe condominium's expenses sat loose in a spreadsheet, with no split between what residents share and what the condominium pays alone.

Solution appliedEach expense is marked as shared or not, and the previous month's fixed bills can be entered again in one click. The screen shows the period total, the change from the previous month and the account balance.

System screen: Monthly expenses

Monthly closing

What I observedClosing the month meant gathering gas, expenses and fees by hand and preparing each apartment's charge.

Solution appliedMonthly 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

Bank slips and payments

What I observedKnowing who had paid and who was late meant checking the bank statement resident by resident.

Solution appliedOne screen per closing lists each apartment's bank slip with its status (paid, open or late) and the totals for each. Whoever manages it marks a payment, or undoes it, right there.

System screen: Bank slips and payments

Financial statement

What I observedThe annual financial statement took days every year.

Solution appliedAnnual 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