- 04 Aug 2021
- 1 Minute To Read
- Print
- DarkLight
- PDF
Truncating and rounding interest
- Updated On 04 Aug 2021
- 1 Minute To Read
- Print
- DarkLight
- PDF
It's uncommon to use more than two decimals in daily life. In order to show usable values we truncate and round interest to display a whole number or a number with fewer decimals.
Number of decimals used for interest calculation
We use a precision of 20 decimals for the calculation of interest accruals.
Number of decimals stored in the database
When storing the interest accruals in the database, we use the same precision of 20 decimals for the amount of interest accruals.
Number of decimals displayed in Journal Entries
For Journal Entries (JE) tables, we calculate the interest accrual aggregate per loan product, which is the aggregation of all interest accruals taken from all the loan accounts created under the respective product. Therefore we sum the related interest accrual amounts that contain 10 decimals and we round the end result to the number of decimals requested by the base currency of the tenant (please see below).
Number of decimals used for the amounts
The interest amount is rounded to the number of decimals preset on the base currency (zero for Japanese Yen (JPY), two for American Dollar (USD) and European Euro (EUR), three for Jordanian Dinar (JOD), eight for Bitcoin, and so on).
The currencies available and their decimal number are available under Administration > Financial Setup > Currency > Add Currency:
Then, the Rounding of Repayment Currency option selected at product level is taken into account:
- No Rounding: Decimals are left as they are.
- Round to Nearest Whole Unit: 62.22 becomes 62 and 62.52 becomes 63.
- Round Up to Nearest Whole Unit: 62.22 becomes 63.