← All cases

° Family-owned rental properties, São Paulo city, Brazil

A family company that rents out its properties closed the month's billing in a file only one person could open at a time. Now the batch goes out in one day, the bank confirms every boleto and PIX paid and the agencies' statements are checked line by line.

The starting point

The month's billing depended on one file shared in the cloud: dozens of rents, with property tax, water, expenses and the pro rata for tenants moving in or out, in a 30-tab spreadsheet full of formulas and macros. One person blocked another's work, and one mistake in the file could compromise the financial data. Boletos and reminders depended on a macro on a single computer, with no personal logins and no record of who changed what. Changing a boleto already issued meant going through the bank's channel. The agencies' statements were checked by the total, where two equal and opposite errors disappear.

What we changed

We moved properties, contracts, charges and expenses into our own module in Odoo, with a personal login for everyone and a record of every change. The month's billing goes out in a batch: the system works out the pro rata, adds water and expenses, issues boleto and PIX at the bank, and stops when a decision is missing. The bank confirms every boleto and PIX paid, and anything paid another way is recorded with date, amount and who did it. Reminders go out on their own, and extending, correcting or cancelling a boleto is done from inside the system. PDF statements from five agencies are read by the system and checked line by line: rent, property tax, fees. A dashboard shows the state of the portfolio.

See the before and after as a diagram

Before

  • One file for everyone: one person blocks another
  • Boletos and reminders tied to a macro on a single computer
  • Statements checked starting from the total

After

Odoo
  • Properties and contracts
  • Monthly billing in a batch
  • Expenses and water
  • Portfolio dashboard

Have a similar problem? Tell us in the conversation.

You send a message and we reply within one business day to set up the conversation. If it makes sense for both sides, you see a first version of your process working before you sign.

In the first conversation you talk directly to Rafael, Renan or Victor, not a sales script. Meet the team