Page Properties | ||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
...
- This functionality is mainly needed for exchange operations. The transaction may be initiated in one currency, on an account which is opened in another currency. Evseery account will be opened with a currency (which will be the base-currency for that account).
For any cross-currency operations (between different currencies) Mifos will first make an exchange operation automatically. Example, if a deposit (or withdrawal) is made in USD on a CDF account, Mifos will convert the USD amount to CDF as per the currency exchange rate applicable for the transaction date.
Then the corresponding CDF amount will be posted to the deposit account.
Mifos will need a provision to maintain daily or periodic exchange rates between various currencies. In Mifos, if no exchange rate is found for the current date, system will user the latest rate available that is available on or before the transaction date.
- Loans disbursements will always be done in the account currency (no change to what Mifos supports today), however, repayments can be done in different currency but in that case exchange operation is needed.
- For financial accounting process, a special Exchange Position account and Equivalent Exchange Position account will be maintained and corresponding amounts in source and target currency maintained in these accounts.
In the initial scope – Only deposits, withdrawals and repayments will be allowed in multiple currencies. Fees cannot be applied in multiple currencies. Also, loan disbursals will not be supported in any currencies other than the account currency.
Background and strategic fit
...
a) The following accounting configurations for Financial Activity Mapping should be specified:
Financial Activity: Currency Exchange Position Account
Financial Activity: Equivalent Currency Value Position Account
Financial Activity: Inter-Branch Currency Transfers
b) For the savings products, the following must be set:
Assets: Savings reference – Base-currency, Currency 1, Currency 2, Currency 3 etc.
...
Payment Type 1 – Base-currency, Currency 1, Currency 2, Currency 3 etc.
Payment Type 2 – Base-currency, Currency 1, Currency 2, Currency 3 etc.
Etc.
Business Flow:
- Deposits, Withdrawals and Repayments can be done in any currency other than the account currency
- If transaction is done in the same currency as the account currency, no change in processing
- If account is in base-currency and transaction is done in another currency
- Convert amount in transaction-currency to the base-currency
- If account is in another currency and transaction is done in base-currency
- If account is in currency X and transaction is done in currency Y and base-currency is different
Attributes
Attributes to be captured for exchange rate:
...
Changes/Enhancements to Batch Jobs
Changes/Enhancements to Accounting Entries
Accounting Entries for deposits:
a) Accept deposit of 100 in currency-X to an account opened in base-currency - (assuming 1 currency-X = 15 base-currency)
S.No. | Journal Entry | Dr | Cr |
1. | <Savings-reference-Asset-currency-X> Dr <Inter-Branch Currency Transfers> Cr | 100 |
100 |
2. | <Inter-Branch Currency Transfers> Dr <Currency Exchange Position Account-currency-X> Cr | 100 |
100 |
3. | <Equivalent Exchange Position Account-base-currency> Dr <Inter-Branch Currency Transfers> Cr | 1,500 |
1,500 |
4. | <Inter-Branch Currency Transfers> Dr <Savings-control-liability> Cr | 1,500 |
1,500 |
b) Accept deposit of 100 in currency-X to an account opened in currency-Y and currency-X and currency-Y are not the base-currency - ( assuming 1 currency-X = 15 base-currency and 1 base-currency = 0.5 currency-Y)
S.No. | Journal Entry | Dr | Cr |
1. | <Savings-reference-Asset-currency-X> Dr <Inter-Branch Currency Transfers> Cr | 100 |
100 |
2. | <Inter-Branch Currency Transfers> Dr <Currency Exchange Position Account-currency-X> Cr | 100 |
100 |
3. | <Equivalent Exchange Position Account- currency-Y> Dr <Inter-Branch Currency Transfers> Cr | 750 |
750 |
4. | <Inter-Branch Currency Transfers> Dr <Savings-control-liability> Cr | 700 |
750 |
Question: Should there be an accounting entry in the base currency? If yes, what are the entries?
c) Accept deposit of 150 in base-currency to an account opened in currency-X - (assuming 1 currency-X = 15 base-currency)
S.No. | Journal Entry | Dr | Cr |
1. | <Savings-reference-Asset-base-currency> Dr <Inter-Branch Currency Transfers> Cr | 150 |
150 |
2. | <Inter-Branch Currency Transfers> Dr <Currency Exchange Position Account-base-currency> Cr | 150 |
150 |
3. | <Equivalent Exchange Position Account-currency-X> Dr <Inter-Branch Currency Transfers> Cr | 10 |
10 |
4. | <Inter-Branch Currency Transfers> Dr <Savings-control-liability> Cr | 10 |
10 |
Similar accounting entries will be needed for withdrawals and loan repayments:
User interaction and design
...
Question | Outcome |
---|---|
Should we have a base currency defined for the Mifos installation? | Yes. Only one base-currency will be defined in Mifos for a financial institution |
If a base currency is set, then how will it be used? For example: Base currency is set as CDF. Withdrawal of EUR 100 an account opened in USD. Then will the conversion happen directly, between EUR and USD or will EUR 100 be first converted to CDF and then the corresponding CDF amount converted to EUR? | If the exchange operation involve different currencies from the base currency ex : deposit of USD in Euro Account. This exchange operation will run in 2 times : first exchange from USD to Base currency and the exchange to base currency to Euro.
|
Should we maintain Buy and Sell rates for various currencies in relation to to the base-currency? Or should Mifos maintain only one conversion rate? | |
If Buy and Sell Rates are used, then how are they to be used? The Buy rate would be used for non-base-currency deposits and repayments from members The Sell rate would be used for non-base-currency withdrawals Is this correct? |
Out of Scope
a) For the loan products