3.3 Financial Operations Tax Maintenance

For IOF component the below formulae with the conditions needs to be defined if IOF payment type is IOF Advance payment at product level. It is applicable to Bearing Normal / Bearing Amortized type of loans.
Formula Name Condition Formula Interim Formula
IOF_CALC_FRM_1 SCH_DAYS<=364 ((PRINCIPAL_SCHAMT*( IOF_DLY_RATE/ 100 ) *SCH_DAYS) No
IOF_CALC_FRM_1 SCH_DAYS>364 ((PRINCIPAL_SCHAMT*( MAX_IOF_RATE/ 100)) No
Finally add the current disbursement tax amount which is calculated based on the additional rate by using the below formulae.
Formula Name Condition Formula Interim Formula
IOF_CALC_FRM_3 No (AMOUNT * (ADDL_RATE/100)) No
For discounted/true discounted loans IOF needs to be calculated based on present value, that is, Principal Schedule Amount – Interest Amount.
The formulae for discounted loans need to be defined as below:
Formula Name Condition Formula Interim Formula
IOF_CALC_ FRM_1 SCH_DAYS<=364 (((PRINCIPAL_SCHAMT – MAIN_INT_CURVAL) *(IOF_DLY_ RATE/100)*SCH_DAYS) No
IOF_CALC_FRM_1 SCH_DAYS>364 (((PRINCIPAL_SCHAMTMAIN_ INT_CURVAL)*(MAX_IOF_ RATE/100)) No
Finally add the current disbursement tax amount which is calculated based on the additional rate by using the below formulae.
Formula Name Condition Formula Interim Formula
IOF_CALC_FRM_3 No (AMOUNT * (ADDL_RATE/ 100)) No
  • The IOF is collected from the customer and credited into the IOF GL.
  • IOF is not re-calculated during any payment/prepayment of the loan.
  • Following accounting entries are to be maintained for DSBR event:
    Dr/Cr Accounting Role Amount Tag Amount
    Dr CUSTOMER GL <Component>_LIQD <IOF Amount calculated-IOF already collected>
    Cr IOF_PAY_ACC <Component>_LIQD <IOF Amount calculated-IOF already collected >
  • ** PRINCIPAL_SCHAMT - fetches the principal schedule amount schedule wise for Normal/Amortized type of loans.
  • **SCH_DAYS is calculated as calendar days between loan value date and schedule end date for each schedule.
  • **MAIN_INT_CURVAL – Interest accrual for discounted/true discounted loans.
  • **IOF_DLY_RATE – IOF rate maintained in tax rule maintenance
  • **ADDL_RATE – IOF additional rate maintained in tax rule maintenance.
  • **MAX_IOF_RATE – maximum IOF rate maintained in tax rule maintenance
This topic contains following sub-topics: