Handling different currencies throughout Gauzy

[rmagon]

Since we are allowing multiple currencies, wherever we are adding, subtracting any currency value, I am a little confused on how will we handle that?

For example: Let's say we have two Income: 5BGN and 5USD, like the screenshot below:

Now, if we check the dashboard, it will show 10BGN as the total income, which is wrong.

We'll need to decide how to handle any addition/subtraction when we have multiple currencies.

Suggestions:

1. Either we keep different currency calculations separately and show them intuitively on the UI somehow?
2. Or we create a conversion rate of sorts and convert the amount to a 'default' currency?
3. Perhaps there is already something I'm unaware of?
4. More suggestions, please 😄

[evereq]

@rmagon ok, so this is how I see this in near future:

• everywhere in UI where we display amount of money, we should add the currency code, e.g. on your first screenshot where we have the "Value" column we should display "5 BGN", "$5", etc. (same as on the second screenshot with dashboard we already display values with BGN). Same, everywhere in DB, we store Value and also currency code for it. So we prepared to use currency conversions in the future with minimum (no) changes in how we store data and how we display it.

• at the same time, we do NOT want for now to mess up with exchange rates (currency conversion) in all the system for now. It's complex. So we will allow users to enter values for income/expenses only in the currency selected for the company (we can call it "default" currency). So say for "Company A", the currency can be "USD" and all inputs and outputs will be in USD currency. For "Company B" it can be currency "BGN" used everywhere, etc.

• in all input boxes for income/expenses, we currently should have a dropdown that allows selecting currency (with default value equal to what selected for the company). For now, let's just make sure such dropdowns are "read-only" (we still need all current logic/code, just let's not allow the user to change the currency for now so we don't need to use currency conversion).

At later stages, we can use a DB table with currency exchange rates (per day, between currency A and B) which will be used to do conversions between entered values in one currency to the currency which is the default for the company. Such exchange rates can be loaded from different APIs (mostly paid APIs), e.g.:

• https://openexchangerates.org (they also useful libs https://github.com/openexchangerates/money.js for easy exchanges)
• https://currencylayer.com
• https://fixer.io
• https://exchangeratesapi.io
• https://www.iban.com/exchange-rates-api
• https://www.currencyconverterapi.com
• or some other APIs (more research needed at a later point to select best one for our use cases)

[rmagon]

Sounds good!

[evereq]

@rmagon yes, so basically we need to go over all pages/components and make sure currencies used according to the description in this ticket.

[rmagon]

Currency drop downs made read-only and it will default to the organization currency in create-mode in the following places:

1. Income mutation popup
2. Expense mutation popup
3. Employee Recurring Expense
4. Edit Employee > Rates
5. Edit Organisation Recurring Expense
6. Edit Organisation > Projects

Added currency to the following tables:

1. Income table - added currency to the value
2. Expense table - added currency to the value

[rmagon]

@evereq Now that all currency dropdowns default to the organization currency and have been disabled .. should we close this ticket or keep it open for future (part 2)?

[evereq]

@rmagon let's keep for the future :) We will soon address it again for part 2 :)