PrevToolBox · Actuarial calculation and management
The monthly actuarial cycle, from the data received to the reserve posted in the accounts
PrevToolBox imports and validates the participant data, calculates the actuarial liability (mathematical provision) per participant and per plan, runs table adherence tests and explains the change in the liability in the Gains and Losses Analysis. At month-end close, it sends each sponsor's reserves to accounting. The fund offers participants benefit simulation and benefit requests through a secure, single-use link, opened from the fund's digital channels.
PrevToolBox
Actuarial calculation and management for pension funds.
- Who it is for
- Closed pension funds (EFPC).
- Who uses it
- Pension team, actuaries and accounting; participants, through a secure link opened from the fund's digital channels.
- What it covers
- Monthly data, benefit rules, mortality tables, liabilities, cash flow, adherence, Gains and Losses Analysis, accounting entries and benefit award.
- How it is delivered
- Web system parameterized for each plan's regulations and integrated with the fund's ERP.
Where actuarial calculation usually goes wrong
The actuarial liability depends on four things that change every month or every year: the participant data, the plan rules, the assumptions and the way the result reaches accounting. When each one sits in a different spreadsheet, the error only shows up at the end of the cycle.
The data enters the calculation unchecked
The monthly load brings a duplicated registration number, a dependent above the age limit or a date of birth that differs from the previous data set. Nobody records who released that data set, and the liability is calculated on it.
The choice of mortality table has to be demonstrated
The adequacy study has an expiry date and goes through the Executive Board and the Deliberative Council. Without a record of the exposures, the observed events and the tests, each review gathers the data all over again.
The liability changed and the explanation does not come
The board asks why the liability rose in the quarter. The answer depends on separating the effect of interest, mortality table, new benefits and terminations, participant by participant.
The accounting close is redone by hand
The change in reserves per sponsor is calculated in a spreadsheet, typed into the accounting system and checked afterwards. An entry sent twice only shows up in the reconciliation.
Regulation and official data
Every actuarial assumption in the valuation must be supported by a technical adequacy study, valid for a maximum of three years, and one year for the real interest rate. The study is approved by the Executive Board and the Deliberative Council, with an opinion from the Fiscal Council.
Source: Resolução Previc nº 23/2023 (consolidated text), arts. 75, 79 and 82 (opens in a new tab).
Among the actions taken in its 2025 monitoring, Previc (the federal supervisor of closed pension funds) required the correction of a mortality table adherence study. When checking the mortality data of 5 funds, it found errors in the actuarial statements from 2014 to 2023.
In its analysis of the liability duration statements for year-end 2024, Previc identified plans with an incorrect interest rate value. The funds were notified and made the corrections.
Source: Previc, Execution Report of the 2025 Annual Supervision Program, item 38 (opens in a new tab).
At the end of 2025, 155 plans recorded a deficit, totaling R$ 21.33 billion, and 422 plans recorded a surplus, totaling R$ 39.03 billion.
Situations in the actuarial cycle and what the system does
Cases from a fund's routine, from receiving the data to serving the participant.
The month's data arrives from the ERP with inconsistencies
On load day, the active population brings a null document ID, a repeated registration number and a benefit that varied far above the previous month. The record data used in the actuarial valuation cannot be more than six months out of date.
Source: Resolução Previc nº 23/2023 (consolidated text), art. 354 (opens in a new tab).
What the system does
The import creates the data group for the period and runs the template's consistency tests. Each issue is handled as corrected, justified or validated, with a note. The data feeds the calculation only after it is authorized, with user, date and time recorded, and from then on it cannot be reimported.
The mortality table adherence study is about to expire
The actuary needs to test the table in use against the plan's experience and take the conclusion to the Executive Board and the Deliberative Council.
Source: Resolução Previc nº 23/2023 (consolidated text), arts. 75, 79 and 82 (opens in a new tab).
What the system does
The adherence test compares three candidate tables for the chosen event, with the exposed and observed populations by sex. It runs the descriptive analysis and the binomial, chi-square and Kolmogorov-Smirnov tests at the significance level entered. The chosen table is made official with an effective date and the Council meeting number, and the system prevents two official tests for the same plan with overlapping effective periods.
The liability rose and the board wants the explanation
Between the previous close and the current one, the plan's liability grew. The executive board needs to say how much came from mortality, from new benefits and from adjustments.
What the system does
The Gains and Losses Analysis compares two official calculations, participant by participant, and classifies each difference by cause: interest, mortality table, salary capacity, new benefit, termination, benefit amount, actuarial factor, reversion percentage, mortality, inflation and adjustment by the plan's actuarial index. The statement per participant comes out together with the overall result.
The interest rate was revised in the annual study
With the new rate, the actuary needs to recalculate the liability, measure the effect and check the liability duration, which enters the calculation of the accumulated technical deficit limit and of the amortization period of the deficit funding plan.
Source: Resolução Previc nº 23/2023 (consolidated text), art. 49 (opens in a new tab).
What the system does
The global deterministic calculation runs again with the revised assumption, scheduled for the chosen date and time. The deterministic cash flow projects expenses year by year and calculates the present value and the duration of the liability. The Gains and Losses Analysis isolates the effect of the change in assumption.
Month-end accounting of reserves by sponsor
At the end of the month, accounting needs the change in programmed, non-programmed and financial reserves of each sponsor, summing the plans.
What the system does
The accounting module opens the period with a checklist: official calculation without duplicates, previous month present and sponsors defined. It calculates the balances, shows the status of each sponsor, highlights changes above the configured limit and sends the entries to the accounting API. An entry already accepted is not resent on a new attempt.
The participant applies for retirement online
The participant wants to apply for the benefit without going to the fund and to compare the payout options before deciding. The fund offers the application through a secure link, from its own digital channels.
What the system does
The system tests eligibility for each of the plan's benefits and, when no benefit is eligible, shows the reasons. The payout options follow the benefit parameters, with lump-sum withdrawal and annual bonus payment. On completion, the award is saved in the ERP with the calculation record, and the internal team audits it in Completed Awards.
A beneficiary wants to change a dependent or make an extra deposit
The retiree asks what happens to the survivor pension if the new spouse is added, or how much the benefit increases with an extra deposit.
What the system does
The dependent change study compares keeping the reversion percentage with keeping the benefit amount. The benefit increase study calculates the addition to the lifetime benefit by the actuarial factor, using four methods. Both studies are saved with the calculation record.
PrevToolBox modules
The internal screens, the screens opened by the participant and the automatic routines use the same rules layer: a calculation done on screen and one done by a routine give the same result.
Data and validation
The data for each plan and period comes in, is tested and is used only after it is authorized.
- Import templates by plan and population (active participants, retirees, survivor pensioners), with column mapping
- Loading by spreadsheet or through the fund's ERP API, manually or on the configured day of the month
- Configurable consistency tests: comparison between fields, field against value, time counter, percentage change and lists of valid values
- Comparison of the load with the previous data set and search for duplicate keys
- Handling of issues one by one or in bulk, with notes and logging
- Data authorization with user, date and time
- Import statistics: frequency, average age and average benefit per group
- Participant lookup, with plan status, dependents, contributions and balances
Plans and benefit rules
The rules of each benefit are written into the system, parameterized from the regulations.
- Fund, sponsors and plans with CNPB (the plan registration number), interest, inflation, capacity factor and retirement ages
- Benefits per plan and the reserve calculation type of each component
- Eligibility: ages, contribution time, time with the employer and in the plan, vesting period, INSS retirement and end of employment
- Balances considered, lump-sum withdrawal, minimum and maximum income
- Income forms: lifetime with or without reversion, fixed term in units or in reais, percentage of the balance, single payment, paid-up benefit and survivor pension
- Defined benefit formula built from components
- Contribution tables by salary bracket, with matching contributions
- Plan return history and averaging of values for the benefit calculation
Actuarial assumptions
Mortality tables, factors and indexes registered once and used in the calculation and in the award.
- Biometric tables from age 0 to 115 by sex: general mortality, disabled mortality, entry into disability, morbidity and longevity
- Table duplication with a percentage increase or decrease
- Generational tables with an improvement factor by age
- Table groups by role: member, disabled, dependent
- Actuarial factors by marital status, sex, interest and capacity, imported or generated
- Factor matrix generator from interest, capacity and tables, with reversion to survivor pension
- Financial indexes and historical series, such as INPC and IPCA
Actuarial calculation
Liability, cash flow, adherence and Gains and Losses Analysis on the authorized data.
- Single deterministic calculation, with commutation tables and the formula step by step
- Global deterministic calculation by status, with individual reserves per participant
- Annuity-due and annuity-immediate methods, with the actuarial factor loaded or calculated on the spot
- Automatic choice of formula by status and by lifetime and temporary dependents
- Roll-forward of the calculation by the plan's actuarial index accumulated between two periods
- Deterministic cash flow year by year, with present value and duration
- Demographic adherence test with binomial, chi-square and Kolmogorov-Smirnov tests
- Gains and Losses Analysis by cause, with a statement per participant
Benefit award and simulation
The participant uses it through a secure, single-use link, opened from the fund's digital channels, without logging in to PrevToolBox.
- Application with eligibility test and a list of reasons when no benefit is eligible
- Choice of payout option, lump-sum withdrawal and month of the annual bonus payment
- Award saved in the ERP, with the calculation record
- Simulator with starting age, salary growth, expected return, contributions and extra deposit
- Projected balance, benefit under each payout option and initial income tax rate under the regressive and progressive regimes
- Completed Awards: indicators, charts and the calculation redone step by step, with a discrepancy alert
- Dependent change and benefit increase studies
Accounting and dashboard
The result of the official calculation reaches accounting and the executive board.
- Monthly balances of programmed, non-programmed and financial reserves per sponsor
- Default sponsor for participants without a link
- Status of each sponsor before submission and an alert for changes above the limit
- Submission to the accounting API per sponsor, with each entry logged
- Monthly statement of deficit funding contributions per sponsor, with the participant and sponsor shares
- Dashboard of the official period: liability, active participants, beneficiaries, benefit payroll and age pyramid
- Liability trend over 12 periods and points of attention from import and calculation
Automatic routines and support
Import, tests and global calculations run in the background, outside the server that hosts the screens.
- Automatic data import on the configured day, without duplicating an existing data group
- Consistency tests run right after each import
- Scheduling of global calculations by date and time, followed in the Calculation Schedule
- Logging of system errors and opening of support tickets inside the system
- System manual opened at the chapter for the screen in use
Month-end close in six steps
Each step uses the official result of the previous one.
- 01
Receive the data
On the configured day, the routine imports the population of each plan through the ERP API, or the team uploads the spreadsheet. An import failure is logged for reimport.
- 02
Validate and authorize
The consistency tests run on the load. The team handles the issues and authorizes the data, which is frozen for the period.
- 03
Calculate and make official
The global deterministic calculation runs by status, in a queue. A user with supervisor level reviews the calculation and makes it official.
- 04
Explain the change
The Gains and Losses Analysis compares the month's official calculation with the previous one and classifies the difference by cause. The cash flow updates present value and duration.
- 05
Post the reserves
The accounting module calculates the change in reserves per sponsor, shows what is ready and sends the entries to the accounting API.
- 06
Report
The monthly actuarial liabilities report brings together data, assumptions, results, Gains and Losses Analysis, actuarial target and returns, accounting entries and opinion in a single PDF.
Reports and documents
Reports export to PDF, Excel and Word.
| Document | For whom | Contents |
|---|---|---|
| Actuarial Liabilities (monthly) | Executive board, councils and actuary | Report in parts: data, assumptions, results and Gains and Losses Analysis, actuarial target and returns, accounting entries and opinion, combined in one PDF. |
| Deterministic Actuarial Valuation | Actuary and accounting | Liabilities in the accounting structure (benefits granted and to be granted, programmed and non-programmed, present value of future benefits and of contributions), opening and closing liability. |
| Gains and Losses Analysis | Actuary, executive board and councils | Frequency and amount by cause, opening and closing reserve, overall result and statement per participant. |
| Deterministic Actuarial Cash Flow | Actuary and investment team | Projected expenses year by year by benefit type, present value and liability duration. |
| Sex-Age Statement | Actuary | Frequency by age band and sex for active participants, retirees and survivor pensioners. |
| Import Statistics | Pension team | Frequency, average age and average benefit of active participants, retirees (non-disabled and disabled) and survivor pensioners. |
| Individual reserves | Actuary and auditors | Reserve of each participant in the global calculation, by registration number. |
| Award calculation record | Participant, benefits team and auditors | A4 document with the award calculation and a registered verification code. |
| Accounting reconciliation | Accounting | Spreadsheet by sponsor and plan and participant by participant. |
Swipe the table sideways to see all columns.
Integrations
The fund's pension ERP
Reading of the actuarial population through the API, and of the participant record, balances, dependents and 60-month histories for award and simulation. The completed award is saved back in the ERP.
Accounting API
Submission of the reserve change entries per sponsor, with each accepted entry logged.
The fund's digital channels
The fund's system authenticates with its own credential and requests an award or simulation link for a participant, which is offered to the participant through the fund's digital channels. The link is single-use and expires in 30 minutes.
Spreadsheets and exports
Import of data, mortality tables and factors by spreadsheet. Export to PDF, Excel and Word, and CSV export of the consistency tests and the adherence populations.
Access, logging and security
- Separate access levels: who runs the calculation and who makes it official, plus a read-only profile
- A denied action shows the reason and is recorded in the usage log
- Usage log with user, IP, area, action and date, filterable by period
- Limit on login attempts, with temporary lockout and progressive delay
- Session closed after inactivity and password reset by single-use link
- Files kept outside the public area, downloadable only by their owner or work group
- Authorized data cannot be reimported and an official calculation cannot be deleted
Implementation
Each implementation is parameterized for the fund: each plan's regulations, sponsors, actuarial assumptions, accounting accounts and ERP integration. Datacoder supports the implementation and the first month-end closes together with the pension team and the actuary.
- Setup of plans, benefits and eligibility and income rules from the regulations
- Loading of the mortality tables, actuarial factors and indexes in use
- Import templates and consistency tests for the data of each population
- Connection to the ERP for the actuarial data and for benefit awards
- Reserve accounting codes and connection to the accounting API
- Access levels and team work groups