Manual Interest Posting for Deposit Accounts
Manual Interest Posting for Deposit Accounts
Document Type: Business Functional Requirements Document
Product: Apache Fineract
Feature: Manual Interest Posting on Deposit Accounts
Status: Draft
1. Business Background
Savings and Credit Cooperative Organizations (SACCOs) commonly declare interest on member deposits annually, after the completion of their financial year.
Unlike conventional deposit products, where interest rates are predefined and known in advance, SACCOs generally determine the interest payable to members based on the surplus generated during the financial year and the amount approved for distribution.
The approved interest rate or distributable amount is therefore not known at the beginning of the financial year. It is determined only after the financial year-end and approval of the surplus distribution.
Currently, this business process requires additional flexibility in Fineract to allow SACCOs to calculate and distribute interest to member deposit accounts after the applicable rate or distributable amount has been approved.
The proposed functionality will introduce Manual Interest Posting for deposit accounts, allowing authorized administrators to select eligible accounts, provide an approved interest rate or flat amount, calculate the applicable interest, and post the interest to the selected member accounts.
The functionality should also support manual interest posting at both individual account and group account levels.
2. Business Objectives
The primary objectives of this functionality are:
Support SACCOs in distributing annual interest on member deposits after the financial year-end.
Allow administrators to determine the interest rate or distributable amount after the financial year has been completed.
Calculate each member's qualifying deposit balance based on the calculation method configured for the deposit product.
Distribute the approved interest proportionately based on individual members' qualifying deposit balances.
Support manual interest posting for both individual and group-level deposit accounts.
Allow administrators to perform manual interest posting on selected deposit accounts without requiring a predefined interest rate.
Maintain the existing interest accounting and posting behaviour in Fineract.
Maintain a complete audit trail and provide a distribution report for reconciliation and verification.
3. Scope
3.1 In Scope
Manual interest posting for deposit accounts.
Annual interest distribution based on an approved surplus or interest rate.
Manual interest posting using a percentage or flat amount.
Support for individual and group-level deposit accounts.
Deposit product-level configuration to enable manual interest posting.
Selection of deposit accounts for manual interest posting.
Calculation of qualifying deposit balances based on the configured calculation method.
Proportionate distribution of approved interest.
Credit of calculated interest to the respective deposit accounts.
Generation of corresponding accounting entries.
Audit trail and interest distribution reports.
Restriction of manual interest posting to one posting per deposit account per year.
3.2 Out of Scope / Current Limitations
The initial implementation will have the following limitations:
Manual interest posting will be applicable only to deposit accounts.
Fixed Deposit (FD) and Recurring Deposit (RD) accounts will not be supported.
Manual interest posting will be allowed only once per deposit account per year.
The functionality will not change the existing interest calculation or accounting behaviour outside the manual interest posting process.
4. Functional Requirements
FR-01: Deposit Product Configuration
A new configuration must be introduced at the Deposit Product level to enable or disable Manual Interest Posting.
Requirements:
Provide a configuration option named "Enable Manual Interest Posting" at the deposit product level.
The configuration should determine whether accounts associated with the deposit product are eligible for manual interest posting.
Only deposit accounts belonging to products with this configuration enabled should be available for manual interest posting.
The configuration should be applicable to both individual and group-level deposit accounts.
Existing deposit product behaviour must remain unchanged when the configuration is disabled.
FR-02: Manual Interest Posting at Account Level
The system must support manual interest posting for individual deposit accounts.
Requirements:
An authorized administrator should be able to initiate manual interest posting for an eligible deposit account.
The administrator should be able to provide the applicable interest rate or flat interest amount.
When a percentage is provided, the system should calculate the interest using the deposit product's configured interest calculation method.
When a flat amount is provided, the specified amount should be posted directly as interest income to the selected deposit account.
The administrator should be able to perform the posting on any day, subject to the annual posting restriction.
Once the interest is successfully posted, the account must be marked as having completed its manual interest posting for the applicable year.
The same account must not be eligible for another manual interest posting within that year.
FR-03: Manual Interest Posting at Group Level
The system must support manual interest posting at the group level, allowing administrators to distribute interest across multiple selected deposit accounts.
Requirements:
The administrator should be able to initiate manual interest posting from the group-level interface.
The system should display the eligible deposit accounts associated with the group.
The administrator should be able to select one or more accounts from the displayed list.
The administrator should have the option to provide either:
An interest percentage.
A flat interest amount.
When an interest percentage is provided, the system should calculate the applicable interest for each selected account based on its deposit product configuration.
When a flat amount is provided, the specified flat amount should be posted as interest income to each selected account.
The system should calculate the interest separately for each selected account.
The administrator should be able to review the calculated interest amounts before confirming the posting.
Only eligible accounts that have not already undergone manual interest posting for the applicable year should be available for selection.
The posting should be processed at the individual account level, generating the respective interest transactions and accounting entries.
FR-04: Annual Interest Calculation Based on Approved Surplus
The system must support SACCOs that distribute interest annually based on an approved surplus or distributable amount.
Business Scenario:
At the end of the financial year, the SACCO determines the surplus available for distribution and obtains approval for the amount to be distributed among members.
The approved interest rate or distributable amount is entered into Fineract only after the financial year-end.
Requirements:
The administrator should be able to select the applicable financial year or calculation period.
The system should identify eligible member deposit accounts for the selected period.
The system should calculate the qualifying savings/deposit balance for each member based on the calculation method configured for the deposit product.
Supported calculation methods may include average monthly balance or other configured deposit balance calculation methods.
The administrator should be able to provide either:
The total approved distributable amount.
The approved interest-on-deposits rate.
When the total distributable amount is provided, the system should calculate each member's entitlement proportionately based on their qualifying deposit balance.
When the approved interest rate is provided, the system should calculate each member's interest entitlement based on the qualifying balance and configured calculation method.
The system should display the calculated interest distribution for review before posting.
Once confirmed, the calculated interest should be credited to the respective member deposit accounts.
Illustrative distribution formula:
When the approved distributable amount is provided:
Member's Interest Entitlement =
(Member's Qualifying Deposit Balance / Total Qualifying Deposit Balance of All Eligible Members) × Approved Distributable Amount
When an approved interest rate is provided, the interest should be calculated using the applicable deposit product calculation method and the approved rate.
FR-05: Interest Calculation Using Percentage
When the administrator provides an interest percentage, the system must calculate the interest using the existing deposit product interest calculation configuration.
Requirements:
The existing deposit product interest calculation method should be used.
The system should consider the applicable deposit balance, interest calculation frequency, and other relevant product configurations.
The manual posting process must not introduce a separate interest calculation methodology.
The calculated interest amount should be displayed before posting.
The calculated amount should be credited to the respective deposit account upon confirmation.
FR-06: Interest Posting Using Flat Amount
The system must support posting a manually specified flat interest amount.
Requirements:
The administrator should be able to enter a flat interest amount.
The entered amount should be posted directly as interest income to the selected deposit account.
The system should not perform an additional interest calculation when the flat amount is provided.
For group-level posting, the entered flat amount should be applied to each selected account individually.
The system should display the total amount to be posted across all selected accounts before confirmation.
FR-07: Interest Posting and Transaction Behaviour
Once the interest amount is calculated, the system should use the existing deposit interest posting mechanism.
Requirements:
The calculated or manually entered interest amount should be credited to the respective deposit account.
The posting should generate the appropriate interest transaction.
Existing deposit account interest posting behaviour should remain unchanged.
The manual interest posting should not alter existing interest calculation rules or subsequent transaction processing.
The system should maintain the appropriate transaction date and posting date based on the existing Fineract business date and transaction date handling.
FR-08: Accounting Entries
The accounting treatment for manual interest posting must remain consistent with the existing interest posting mechanism in Fineract.
Requirements:
The system should generate the corresponding accounting entries when interest is posted.
Existing deposit product accounting configurations should be respected.
The applicable interest expense and deposit liability accounting entries should be generated according to the existing accounting setup.
The accounting entries must be generated for each successfully posted deposit account.
No changes should be introduced to the existing accounting treatment for regular interest posting.
FR-09: Audit Trail
The system must maintain an audit trail for all manual interest posting activities.
The audit information should include:
Deposit account identification.
Member identification.
Deposit product.
Applicable financial year or calculation period.
Interest posting method (percentage or flat amount).
Approved interest rate or flat amount.
Approved distributable amount, where applicable.
Qualifying deposit balance, where applicable.
Calculated interest amount.
Actual posted interest amount.
Transaction date.
Posting date.
User who initiated the posting.
User who confirmed the posting.
Posting status.
The system should also maintain a record of the group-level operation and the individual account postings generated from it.
5. Distribution Report
The system should provide a report for reviewing and reconciling the manual interest distribution.
The report should contain the following information:
Field | Description |
|---|---|
Group | Group identification, where applicable |
Member ID | Unique member identification |
Member Name | Member name |
Account Number | Deposit account number |
Deposit Product | Associated deposit product |
Financial Year | Applicable financial year |
Qualifying Balance | Balance considered for interest calculation |
Interest Method | Percentage / Flat Amount / Distributable Amount |
Approved Rate | Approved interest rate, where applicable |
Interest Amount | Calculated interest amount |
Posted Amount | Actual amount credited |
Transaction Date | Date of interest posting |
Posting Status | Success / Failed |
The report should support reconciliation between the approved distributable amount and the total interest credited to member accounts.
6. Business Rules and Validations
Rule ID | Business Rule |
|---|---|
BR-01 | Manual interest posting must be enabled at the deposit product level. |
BR-02 | Only eligible deposit accounts should be available for manual interest posting. |
BR-03 | FD and RD accounts are excluded from the initial implementation. |
BR-04 | Manual interest posting is permitted only once per deposit account per year. |
BR-05 | An account that has already undergone manual interest posting for the applicable year must not be eligible for another posting. |
BR-06 | The administrator must provide either an interest percentage or a flat amount, as applicable to the selected posting method. |
BR-07 | Percentage-based posting must use the existing deposit product interest calculation configuration. |
BR-08 | Flat amount posting must credit the specified amount directly without an additional interest calculation. |
BR-09 | For group-level posting, each selected account must be validated independently. |
BR-10 | The system must prevent duplicate interest posting for the same account and financial year. |
BR-11 | The posting must generate the existing interest transaction and corresponding accounting entries. |
BR-12 | A successful posting must be recorded in the audit trail. |
BR-13 | The system must provide a distribution report for the posted interest. |
BR-14 | Existing interest calculation and posting behaviour must not be affected by this functionality. |
7. Illustrative Business Scenarios
Scenario 1: Annual Interest Distribution Based on Approved Surplus
Background:
A SACCO has completed its financial year and approved a total of ₹10,00,000 for distribution among its members.
The qualifying deposit balances are calculated using the average monthly balance method.
Member | Qualifying Deposit Balance |
|---|---|
Member A | ₹1,00,000 |
Member B | ₹2,00,000 |
Member C | ₹3,00,000 |
Member D | ₹4,00,000 |
Total | ₹10,00,000 |
Approved distributable amount: ₹10,00,000
Distribution:
Member | Qualifying Balance | Distribution Percentage | Interest Amount |
|---|---|---|---|
Member A | ₹1,00,000 | 10% | ₹1,00,000 |
Member B | ₹2,00,000 | 20% | ₹2,00,000 |
Member C | ₹3,00,000 | 30% | ₹3,00,000 |
Member D | ₹4,00,000 | 40% | ₹4,00,000 |
Total | ₹10,00,000 | 100% | ₹10,00,000 |
The system should calculate the interest entitlement for each member and credit the respective deposit accounts after administrator confirmation.
Scenario 2: Percentage-Based Manual Interest Posting
An administrator selects five deposit accounts and enters an interest rate of 8%.
The system should:
Identify the selected deposit accounts.
Apply the existing product interest calculation configuration.
Calculate interest independently for each account.
Display the calculated interest amounts.
Allow the administrator to confirm the posting.
Credit the interest to the respective accounts.
Scenario 3: Flat Amount Manual Interest Posting
An administrator selects five deposit accounts and enters a flat interest amount of ₹500.
The system should:
Identify the five selected accounts.
Apply ₹500 as interest to each selected account.
Display the individual posting amounts and total amount of ₹2,500.
Allow the administrator to confirm the posting.
Credit ₹500 to each selected deposit account.
Scenario 4: Duplicate Posting Prevention
An administrator has already posted manual interest to a deposit account for the financial year 2025–2026.
When the administrator attempts another manual interest posting for the same account and financial year, the system should prevent the duplicate posting.
The account should no longer be available for selection for that financial year.
8. Acceptance Criteria
The functionality will be considered complete when the following conditions are met:
An administrator can enable or disable manual interest posting at the deposit product level.
Eligible individual deposit accounts can undergo manual interest posting.
Eligible group-level deposit accounts can be selected for manual interest posting.
The administrator can provide an interest percentage or flat amount.
Percentage-based posting calculates interest using the existing deposit product configuration.
Flat amount posting credits the specified amount directly to the selected account.
The system supports annual interest distribution based on an approved distributable amount.
The system calculates qualifying deposit balances using the configured calculation method.
The system calculates proportionate member entitlements when an approved distributable amount is provided.
The system displays the calculated distribution before posting.
Successful postings generate the appropriate deposit transactions and accounting entries.
The system prevents duplicate manual interest posting for the same account and year.
The system maintains a complete audit trail.
The system provides an interest distribution report.
Existing deposit interest calculation and posting behaviour remains unaffected.
FD and RD accounts are excluded from the initial implementation.
9. Assumptions and Points Requiring Clarification
The following points should be finalized during functional design before implementation:
Financial year definition: Should the financial year be derived from the SACCO's configured financial year or should the administrator be allowed to specify a custom calculation period?
Qualifying balance calculation: Should the system strictly use the deposit product's configured calculation method, or should the administrator be able to select the calculation method during manual interest posting?
Distributable amount versus interest rate: Should both options be available in the same workflow, with the administrator selecting one method at a time?
Flat amount at group level: The current understanding is that the flat amount entered will be applied independently to every selected account, rather than being distributed proportionately across all selected accounts. This needs confirmation.
Posting period and annual restriction: Should the once-per-year restriction be based on the calendar year, financial year, or a configurable posting period?
Account eligibility: Should closed, dormant, inactive, or written-off deposit accounts be excluded from the eligible account list?
Rounding and residual distribution: How should rounding differences be handled when distributing the approved distributable amount among members? Any residual amount should be reconciled so that the total posted amount matches the approved distributable amount.
Failed postings: If posting fails for one or more selected accounts during a group operation, should successful account postings be retained while failed accounts remain eligible for retry?
Reversal and correction: Should manual interest posting support reversal, and if so, should a reversed posting allow the account to be posted again within the same financial year?
Approval workflow: Should manual interest posting require a separate maker-checker approval before the interest is credited to the accounts?
10. Expected Business Outcome
The proposed functionality will allow SACCOs to manage their annual member deposit interest distribution directly within Apache Fineract.
It will provide flexibility to determine the interest rate or distributable amount after financial year-end, calculate individual member entitlements, and credit the approved interest to member deposit accounts.
By reusing the existing interest calculation, transaction posting, and accounting mechanisms, the functionality will support SACCO-specific annual interest distribution requirements while minimizing changes to Fineract's existing deposit account behaviour.