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
...
Changes to Existing Screens
System --> Configurations
Add a new configuration "Allow Cross Currency Transactions" - Yes/No
Accounting --> Accounts Linked to Financial Activity
Three more account types can be selected:
- Cross-Currency Exchange Position Account - The account to which all amount in source currency will be posted
- Cross-Currency Equivalent Exchange Position Account - The account to which all amount in target currency will be posted
- Cross-Currency Inter-Branch Transfer Account - The account to which will be used if the currency exchange is across two branches (to confirm if this this account is to be used only if the transaction is across two branches)
Changes/Enhancements to Batch Jobs
None.
Changes/Enhancements to Accounting Entries
...
a) Accept deposit of 100 in currency-X to an account opened in base-currency - (assuming 1 currency-X = 15 base-currency)nge
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 |
...
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)
...
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
In the initial scope – Only deposits, withdrawals and repayments will be allowed in multiple currencies. The following will not be supported
- Fees applied and paid in other currencies other than the currency in which the account is opened
- Loan disbursals in other currencies other than the currency in which the account is opened
a) For the loan productsproductssu