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

    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

    1. 01

      Register the base data

      Plans with bank details, sponsors, index series and holidays in the sponsor's city.

    2. 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.

    3. 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.

    4. 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.

    5. 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.

    6. 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.

    Documents issued
    DocumentFor whomContents
    Debt agreement statementFinance management, sponsorInitial 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 CouncilDeliberative and Fiscal CouncilsThe 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 AccountingAccounting departmentBreakdown 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 sponsorDebtor sponsorAmount 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 dashboardExecutive board, finance managementPortfolio 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

    Frequently asked questions

    See Liable in action

    Schedule a demo