RentControl · Real estate portfolio management

    The pension fund's properties managed as investments of the plans

    RentControl brings together properties, units, lease and loan-for-use agreements, billing and accounting. Each entry is split between portfolios and plans by each unit's percentage and goes to the fund's ERP. The tenant accesses payment slips, statement and documents through a dedicated portal.

    RentControl

    Real estate portfolio management.

    Who it is for
    Closed pension funds (EFPC) with real estate in the investment portfolio of their plans.
    What it covers
    Properties and units, agreements, entries split between plans, payment slips, indexes, reports and documents.
    Integration
    Accounting, authorization and settlement in the fund's ERP, through an API.
    How it is delivered
    Web system, accessed through the browser, with a separate portal for the tenant.

    A real estate portfolio that stays on the balance sheet

    Closed pension funds cannot buy real estate, but since March 2025 they are no longer required to sell their holdings by 2030. Funds that own property will keep managing rent, adjustments, defaults and accounting, with the income of each unit belonging to one or more plans.

    • The rent belongs to more than one plan

      An office in the building belongs to two plans in different percentages. The rent received has to be split, posted and accounted for in each plan, month by month, in a spreadsheet.

    • The adjustment depends on an index typed by hand

      On the agreement's anniversary, someone looks up the IGP-M or IPCA for the period, calculates the accumulated rate and updates the amount. A month mixed up changes the rent until the next adjustment.

    • The same entry is made twice

      Income is recorded in the property control and again in the accounting system. When the submission fails, nobody knows for sure what went in and what has to be redone.

    • The property data is scattered

      Land registry number, areas, acquisition cost of land and building, insurance, property tax (IPTU) and appraisal reports sit in different folders when the annual appraisal or a sale comes around.

    Regulation and official data

    Situations in the real estate portfolio and what the system does

    Cases from the routine of those who manage the properties of a closed pension fund.

    • A building with offices owned by different plans

      The units of a commercial building belong to different plans, in different percentages, and the rent from each one has to reach the right plan.

      What the system does

      Each unit is linked to portfolios and plans with its ownership percentage, and unit groups define the allocation for a set of units. Each entry is split automatically by these percentages. When a percentage changes, the allocation is reprocessed and the previous history is kept.

    • The agreement's anniversary has arrived

      The lease is adjusted by the IGP-M accumulated over twelve months, and another agreement in the same portfolio uses the IPCA.

      What the system does

      Each agreement has its own adjustment index. The series are imported from the Central Bank of Brazil's Time Series Management System (SGS), such as IPCA, IGP-M, INPC, TR, IGP-DI and Selic, and the accumulated rate for the period is calculated by compounding.

    • The tenant paid late

      The rent fell due on a municipal holiday and was paid days later. The charge needs a penalty and inflation adjustment.

      What the system does

      The entry keeps the original, updated and paid amounts, with a penalty as a percentage or in reais, inflation adjustment and discount. The due date takes into account the registered national, state and municipal holidays, and the payment slip is issued with penalty, interest and payment instructions.

    • Month-end close in the ERP

      The month's rental income has to enter the accounts of each plan, and one of the submissions came back with an error.

      What the system does

      Entries go to the fund's ERP through an API: accounting, status inquiry, authorization and finalization with the payment slip data. The allocation is validated before submission, with a configurable tolerance, and the return is tracked allocation by allocation. Only what failed is resent.

    • Corporate tenant with withholdings

      The tenant is a company, and accounting needs the taxes on each receipt broken out.

      What the system does

      Each entry itemizes withholding income tax (IRRF), PIS/PASEP, COFINS and CSLL, separates the pass-through of condominium fees and property tax from the rent amount and calculates the agreement's management fee. The accounting breakdown links each item to the debit and credit accounts.

    • The council asks for the return of each property

      In the review of the investment policy, the council wants to compare the return of the portfolio's properties over the last twelve months.

      What the system does

      The return by property report determines the opening and closing book value, the income for the period and the rate of return on the acquisition cost, with a comparison between properties.

    • Annual appraisal or preparing a sale

      The appraiser asks for the land registry number, areas and the acquisition cost split between land and building. A sale requires at least three appraisal reports.

      Source: Resolução Previc nº 23/2023 (consolidated text), art. 197 (opens in a new tab).

      What the system does

      The property record keeps the land registry number, built and land areas and the acquisition costs of land and building. Units keep leasable and common areas, ideal fraction, insurance, accumulated depreciation and property tax. Appraisal reports stay attached to the property in document management.

    • The tenant asks for a copy of the payment slip

      The tenant calls to ask for a payment slip, the year's statement and the agreement amendment.

      What the system does

      On the tenant portal, with access restricted to their own agreement, the tenant downloads payment slips, checks the statement with the status of each payment, sees the documents sent by the fund, uploads attachments and exchanges messages with the manager.

    RentControl modules

    From the property record to the council report, on the same base of agreements and entries.

    Properties and units

    The property as an asset of the plan, with the data that accounting and the appraiser ask for.

    • Property with address, municipality by IBGE code, land registry number and acquisition date
    • Acquisition costs split between land and building
    • Units: offices, stores, apartments, warehouses and parking spaces, each with its own code
    • Leasable, common and built areas, ideal fraction and ownership percentage
    • Area measurements with a history of changes
    • Insurance period and amount, accumulated depreciation and property tax per unit
    • Unit status: available, leased, under renovation or written off
    • Accounting classification of each unit

    Agreements and counterparties

    Lease, loan for use and other configurable types, linked to the unit and to the tenant.

    • Agreement's own number, start and end dates and term in months
    • Adjustment index per agreement
    • Rent, property tax and condominium fee amounts per agreement
    • Management fee as a percentage or fixed amount
    • Agreement status: in force, ended or terminated, with a history of changes
    • Individual and corporate tenants, reused across several agreements and properties
    • Counterparty's accounting account in the ERP
    • Suppliers with bank details for expense entries

    Portfolios, plans and allocation

    The income of each unit is distributed among the plans that own it.

    • The fund's investment portfolios
    • Benefit plans with CNPB (the plan registration number) and plan design
    • Link of each unit to the plans with an ownership percentage
    • Unit groups for allocating a set of units
    • Automatic allocation of each entry between portfolios and plans
    • Allocation reprocessing with the history preserved

    Finance and billing

    An entry goes through five states: drafting, generated, posted, authorized and paid.

    • Rent, property tax and condominium fee income, and expenses per agreement
    • Accrual, posting, due and payment dates
    • Original amount, amount updated by the index and amount paid
    • Penalty, inflation adjustment and discount as a percentage or in reais
    • IRRF, PIS/PASEP, COFINS and CSLL itemized per entry
    • Entry templates for batch generation of recurring entries
    • Payment slips (boletos) with bank reference number, payment code line, penalty, interest and instructions
    • Accounting classifications linked to the ERP chart of accounts, bank accounts and holidays

    Economic indexes

    The series come from the Central Bank, with no typing.

    • Adjustment indexes, reference values and interest rates with historical series
    • Percentage value and absolute value per month
    • Accumulated rate for the period by compounding
    • Batch import through the Central Bank API, with update of months already stored
    • Any series from the Time Series Management System, in addition to the usual ones

    Tenant portal and documents

    The tenant checks payment slips, statement and documents without asking the team.

    • Individual access per agreement, separate from the team's access
    • Dashboard with the agreements and the status of each one
    • Statement of entries and payment slip download
    • Documents sent by the fund and attachments uploaded by the tenant
    • Messages between manager and tenant, with the history linked to the agreement
    • Document management with attachments to agreements, properties and entries, configurable types and in-browser viewing

    From the agreement to the plan's accounts

    The path of a rent payment in RentControl.

    1. 01

      Register the property and the units

      Land registry number, areas, acquisition costs and, for each unit, the plans that own it and the percentage of each one.

    2. 02

      Record the agreement

      Unit, tenant, term, amounts, adjustment index and management fee.

    3. 03

      Generate the month's entries

      The templates generate recurring rents, charges and pass-throughs in batch. Each entry is created already split between portfolios and plans.

    4. 04

      Post to the ERP

      The API submission records the order code returned by the ERP, checks the status and authorizes. Failures are flagged for resubmission.

    5. 05

      Bill and collect

      The payment slip goes to the tenant portal. Payment is recorded with penalty, adjustment or discount, and the entry reaches the paid state.

    6. 06

      Report

      The detailed, summary, accounting position and return by property reports come from the same set of entries.

    Reports

    Generated as PDF in the browser, with export to Excel and Word.

    Reports
    DocumentFor whomContents
    Detailed income and expensesAccounting and investment managementEntries for the period by due date, accrual, posting or payment, filtered by plan, portfolio and property, with subtotals by property and type.
    Consolidated summaryExecutive boardIncome and expenses for the period totaled by entry category.
    Accounting positionAccounting, auditors and Deliberative CouncilAccounting balances of the real estate portfolio by account, in the structure of the ERP chart of accounts.
    Return by propertyInvestment management and councilsOpening and closing book value, income for the period and rate of return on the acquisition cost, with a comparison between properties. Twelve months by default.
    Statement of entriesBilling team and tenantEntries by agreement, period and status, with the items of each one.
    Payment slipTenantDue date, bank reference number, payment code line, penalty, interest, deductions and additions.

    Swipe the table sideways to see all columns.

    Integrations

    • The fund's ERP

      Accounting, status inquiry, authorization and finalization with payment slip, through an API, with separate credentials for testing and production and a log of each exchange.

    • Central Bank of Brazil

      Import of index series through the Time Series Management System, by period.

    • Chart of accounts

      Entry classifications and counterparty accounts linked to the ERP accounts.

    • Export

      Reports in PDF, Excel and Word.

    Access, logging and security

    • Team users with email and password
    • Each fund operates with isolated data and its own integration configuration
    • Tenant portal with separate authentication, restricted to the tenant's own agreement
    • Log of operations with user, date and time, action, screen and description
    • Log viewer with filters by date, user and operation type
    • Deactivated records keep their history
    • Each exchange with the ERP is logged, with the return status of each allocation

    Implementation

    Each implementation is parameterized for the fund: portfolios and plans, properties and units with the allocation percentages, agreements in force, accounting classifications and accounts, and the ERP integration. Datacoder supports the initial load and the first month-end closes with the fund's team.

    • Setup of properties, units and links to portfolios and plans
    • Loading of agreements in force, with indexes and amounts
    • Entry templates for recurring receipts
    • Accounting classifications linked to the ERP chart of accounts
    • ERP integration credentials for testing and production
    • Tenant access to the portal

    Frequently asked questions

    See RentControl in action

    Schedule a demo