Liable · Sponsor debt control
Sponsor debt agreements, from the installment schedule to the accounting settlement
Liable controls the debt agreements that sponsors sign with the pension fund: deficit funding, past service and late contributions. It generates the schedule using the PRICE table (constant-installment amortization) with inflation adjustment, calculates late-payment charges, recalculates the installments after an extraordinary amortization, issues the billing and reporting documents and sends each installment to the ERP already split by plan.
Liable
Control of sponsor debts.
- Who it is for
- Closed pension funds (EFPC) with sponsor debt agreements
- What it covers
- Agreement, schedule, adjustment, charges, payments, allocation between plans and sub-groups, documents, dashboard and accounting
- Calculation
- PRICE table with monthly adjustment by INPC, IPCA or IGP-M
- How it is delivered
- Web application, in the fund's environment or in the cloud, integrated with the pension ERP
A debt that lasts years, split between plans and adjusted every month
The agreement with the sponsor is signed once, but the calculation changes every month: a new index, an installment paid late, an overpayment, the allocation between plans. Whoever controls it in a spreadsheet recalculates everything by hand.
Today's installment depends on all the previous ones
Each installment starts from the balance of the previous one, with the month's interest and adjustment. An index entered wrongly or an unscheduled payment changes every subsequent installment.
The same payment goes to more than one plan
The debt is allocated between plans and sub-groups. Billing, deposit and accounting have to be separated by plan, with each plan's account and CNPJ (company tax ID).
Late payment has a cost and a deadline
An installment paid after the due date carries a penalty, default interest and adjustment. Under the funds' accounting rules, how long a receivable is overdue determines the loss provision on the plan's balance sheet.
Each department wants the agreement in a different format
The council wants the balance by plan, accounting wants the breakdown of the installment, the sponsor wants the billing notice. Without a single record, each document comes from a different spreadsheet.
Regulation and official data
The plans' deficit is funded by sponsors, participants and beneficiaries, in proportion to their contributions. When a sponsor withdraws, it remains bound by the commitments assumed up to the date of withdrawal.
Source: Lei Complementar nº 109/2001 (supplementary pension law), arts. 21 and 25 (opens in a new tab).
Deficit funding, past service and late contributions must be formalized with the sponsor in a debt acknowledgment instrument, specifying the amount, term, installment amount, dates, interest, penalties and guarantees.
Source: Resolução CNPC nº 42/2021, arts. 1 and 2 (opens in a new tab).
Sponsor debt instruments for past service and for funded technical deficit are recorded in the Contracted Operations group of Pension Receivables (Realizável Previdencial), under Assets.
Source: Resolução Previc nº 23/2023 (consolidated text), art. 185 (opens in a new tab).
The notes to the financial statements show the breakdown of late and contracted contributions by sponsor and by plan, with the contracted amount, term, installment, due date and interest of each operation.
Source: Resolução Previc nº 23/2023 (consolidated text), art. 208-A, XXI and XXIII (opens in a new tab).
The loss provision on receivables follows how long the installment is overdue: at least 1% between 31 and 60 days, rising by brackets up to a full provision above 360 days.
Source: Resolução Previc nº 23/2023 (consolidated text), art. 199 (opens in a new tab).
At the end of 2025, 155 plans of closed pension funds were in deficit.
Source: Previc, 2025 Report on Closed Supplementary Pensions (opens in a new tab).
Where Liable fits into the routine
Situations in the life of a sponsor debt agreement, and what the system does in each one.
Signing a deficit funding agreement
Sponsor and fund close the debt acknowledgment: amount on the base date, down payment, number of installments, annual interest rate, adjustment index, penalty and default interest, allocation between plans.
Source: Resolução CNPC nº 42/2021, art. 2 (opens in a new tab).
What the system does
The agreement is registered with these parameters. The Calculate button converts the annual rate into the equivalent monthly rate, deducts the down payment and calculates the PRICE installment. The Generate entries button creates the down payment installment and all installments for the term.
The month's index is published
The month's INPC, IPCA or IGP-M is out. The installments not yet paid were projected with the last known index and need to be updated.
What the system does
The team enters the monthly change in the index records. The Update future tool recalculates the unpaid installments with the published index, and the outstanding balance follows.
Installment paid after the due date
The sponsor makes the deposit late. The fund needs to charge the fees set in the agreement and know how many days the installment has been overdue.
Source: Resolução Previc nº 23/2023 (consolidated text), art. 199 (opens in a new tab).
What the system does
The installment card counts the days between the due date and the payment and adds to the installment the agreement's penalty, default interest pro rata per day and the inflation adjustment up to the payment date. Confirm payment records the date, the amount and the Received status.
Sponsor pays more
The sponsor decides to prepay part of the debt and deposits more than the month's installment.
What the system does
The excess is treated as an extraordinary amortization: it reduces the principal balance and recalculates the future installments, keeping the term and reducing the installment amount.
Debt allocated between plans and sub-groups
The same debt acknowledgment covers more than one plan, and one of the plans has sub-groups (submassas). Each part has to be billed, deposited and accounted for in the right plan.
What the system does
The allocation is in the agreement, as percentages by plan and sub-group. The billing notice shows each plan's amount with the CNPJ and the receiving account, the letter asks for a separate deposit per plan, and the accounting integration sends one transaction per destination.
Council meeting
The Fiscal Council monitors the economic and financial management of the fund and its plans. For the meeting, management needs to bring the position of each debt agreement, plan by plan.
Source: Resolução Previc nº 23/2023 (consolidated text), art. 8 (opens in a new tab).
What the system does
The monthly position for the Council shows the month's installment, the accumulated amount received and the updated outstanding balance by plan and sub-group, with a consolidated total and a note on the amortization.
Month-end accounting close
Accounting needs to record the installment in Contracted Operations for each plan and settle it when the funds come in.
Source: Resolução Previc nº 23/2023 (consolidated text), art. 185 (opens in a new tab).
What the system does
The internal memo to Accounting shows the breakdown of the installment and of the balance by plan and sub-group. The integration sends the transactions to the ERP, tracks their processing and moves the installment to Received when every destination reaches Settled.
Notes to the year's financial statements
At year-end, the notes to the financial statements require the breakdown of debts by sponsor and by plan, with contracted amount, term, installment, due date and interest.
Source: Resolução Previc nº 23/2023 (consolidated text), art. 208-A, XXI and XXIII (opens in a new tab).
What the system does
The agreement statement, in consolidated and per sub-group modes, brings together initial contribution, financed amount, rates, term, outstanding balance and the history of each installment, with amortization, interest and adjustment shown separately.
What Liable does
The records feed the agreement, the agreement generates the installments, and the documents, the dashboard and the accounting come from the installments.
Supporting records
Records deactivated by status, without deleting the history.
- Benefit plans with CNPJ, bank, branch, account and identification code
- Sponsors with CNPJ, address, contact, responsible directorate and executive director
- INPC, IPCA and IGP-M series, with the monthly change entered by the team
- National and municipal holidays for calculating due dates on business days
- Lists with free search and in-line editing
Agreement and calculation engine
PRICE table with monthly inflation adjustment.
- Debt amount and base date, updated amount, down payment and financed amount
- Annual interest rate converted into the equivalent monthly rate
- Due date on a calendar day or on the nth business day of the month
- The agreement's penalty and default interest for late-payment charges
- Allocation of the debt by plan and sub-group, as percentages
- Statuses New, Under review, Calculated, In progress, Overdue, Canceled and Completed
- Projection of months without a published index using the last registered index
Installments and payments
Each installment keeps opening balance, interest, index, adjustment, amortization, original amount, updated amount and closing balance.
- Statuses Issued, Awaiting payment, Overdue, Received and Renegotiated
- Update of the installment by the published index for the reference month
- Breakdown of the installment into amortization, interest and adjustment
- Count of days overdue and calculation of the charges
- Extraordinary amortization with recalculation of future installments
- Update of unpaid installments when a new index comes out
Documents
On-screen viewing and export to PDF, Excel and Word, with the fund's logo.
- Agreement statement, consolidated or per sub-group
- Monthly position for the Council
- Internal memo to Accounting, with space for signatures
- Billing notice per plan and letter to the sponsor with the amount written out in words
Management dashboard
Portfolio position as of today, consolidated or per agreement.
- Current outstanding balance and change against the financed amount
- Total received, installments received out of the total, and progress
- Next installment and overdue installments, with number and amount
- Evolution of the outstanding balance, actual and projected
- Annual flow of receipts and breakdown of the amount received
- Distribution of the balance by agreement and sub-group
- Indexes for the last 12 months and accumulated over 12 months
- Alert for installments received but not yet integrated into accounting
Accounting integration
Each installment sent to the ERP already split by plan and sub-group.
- Installment amount, excess and adjustment calculated per destination
- Accounting period on the last day of the reference month
- One accounting transaction per destination, with the order number returned by the ERP
- Tracking of the transaction until settlement
- Automatic settlement of the installment when all destinations are settled
- Batch synchronization of pending integrations
From the signed agreement to the installment in the accounts
- 01
Register the base data
Plans with bank details, sponsors, index series and holidays in the sponsor's city.
- 02
Record the agreement
Amount and base date, down payment, term, interest, adjustment index, late-payment charges, due date method and allocation by plan and sub-group.
- 03
Calculate and generate the installments
The system calculates the PRICE installment and generates the schedule: for each month, interest on the balance, adjustment by the index, adjusted installment and closing balance.
- 04
Follow up month by month
With each published index, future installments are updated. The billing notice goes to the sponsor and the payment is recorded, with charges if it is late.
- 05
Post and settle
The installment goes to the ERP split by plan. When the ERP reports settlement, the installment moves to Received without any typing.
- 06
Report
The agreement statement, the position for the Council and the memo to Accounting come from the same schedule, with the same figures.
Documents issued
All exported to PDF, Excel or Word. Bank details and CNPJ come from the plan records; address and directors, from the sponsor records.
| Document | For whom | Contents |
|---|---|---|
| Debt agreement statement | Finance management, sponsor | Initial contribution, financed amount, annual rate and equivalent monthly rate, term, outstanding balance and accumulated amount received. Per installment: reference month, due date, opening balance, index, adjustment, amortization, interest, original amount, amount paid and closing balance. |
| Monthly position for the Council | Deliberative and Fiscal Councils | The month's installment with due date and payment, accumulated amount received and updated outstanding balance by plan and sub-group, consolidated total and a note on the amortization. |
| Internal memo to Accounting | Accounting department | Breakdown of the installment and of the closing balance by plan and sub-group, with totals, memo number, sender, recipient and signatories. |
| Billing notice and letter to the sponsor | Debtor sponsor | Amount payable per plan, with each plan's CNPJ, branch and account, and the total. The letter states the due date and the amount in reais and in words and asks for a separate deposit per plan. |
| Management dashboard | Executive board, finance management | Portfolio of agreements with index, interest, financed amount, amount received, balance, progress and delinquency; upcoming due dates, latest receipts and accounting integration status. |
Swipe the table sideways to see all columns.
Integrations
The fund's pension ERP
Submission of one accounting transaction per plan and sub-group, with accounting period, due date and amounts; tracking of progress until settlement and automatic settlement of the installment.
Testing and production
The installation points to the ERP's testing or production environment, each with its own credential.
Economic indexes
INPC, IPCA and IGP-M are entered by the team month by month, as monthly changes. The dashboard shows the last 12 months and the accumulated rate.
Export
Statement, position, internal memo and billing notice in PDF, Excel or Word.
Access and logging
- Login with email and password, with the session checked on every page and closed after inactivity
- Administrator, Supervisor and Contributor groups; users and settings are managed by the Administrator
- Plans, sponsors, indexes, agreements and users separated by fund
- Records deactivated by status, without deleting the history
- An integration already settled cannot be deleted
- Order number and status of each destination stored with the installment
Implementation
Each implementation is parameterized for the fund: plans and sub-groups, sponsors, ongoing agreements with the history of installments already paid, document templates with the fund's logo and signatories, and the accounts and codes for the integration with the pension ERP. Datacoder supports the loading of the agreements and the check of the schedule against the amounts already recorded.
- Setup of plans, sub-groups and sponsors
- Historical series of the indexes used in the agreements
- Loading of ongoing agreements and check of installments already paid
- Documents with the fund's logo, texts and signatories
- Configuration of the ERP integration in testing and then in production
- Access profiles for the finance and accounting team