# Currency conversion while adding Indian bank accounts and loan accounts **URL:** \ **Category:** Ask Anything\ **Tags:** google-sheets, bank-feed-issue\ **Created:** [January 13, 2020, 10:58pm UTC](https://community.tiller.com/t/currency-conversion-while-adding-indian-bank-accounts-and-loan-accounts/2125 "2020-01-13T22:58:49Z")\ **Posts on this page:** 19\ **Page:** 1
**Author:** ![gauravtechie](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/gauravtechie/32/2064_2.png) [@gauravtechie](https://community.tiller.com/u/gauravtechie)\ **Post date:** [January 13, 2020, 10:58pm UTC](https://community.tiller.com/t/currency-conversion-while-adding-indian-bank-accounts-and-loan-accounts/2125/1 "2020-01-13T22:58:49Z")
I am right now living in US, but having accounts in India. When I am adding loan accounts or bank accounts from India, they’re importing all values in INR, but showing in dollars and that made my liability shoot up 🙂 Is there a way I can create a hook to convert the currency from INR to USD while importing? ---
**Author:** ![heather](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/heather/32/177_2.png) [@heather](https://community.tiller.com/u/heather)\ **Post date:** [January 14, 2020, 3:04pm UTC](https://community.tiller.com/t/currency-conversion-while-adding-indian-bank-accounts-and-loan-accounts/2125/3 "2020-01-14T15:04:05Z")
đź‘‹, @gauravtechie! We only officially support single currency and USD. In the past some others have used =GoogleFinance function and additional columns to convert other currencies coming in to USD. [https://support.google.com/docs/answer/3093281?hl=en](https://support.google.com/docs/answer/3093281?hl=en) ---
**Author:** ![gauravtechie](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/gauravtechie/32/2064_2.png) [@gauravtechie](https://community.tiller.com/u/gauravtechie)\ **Post date:** [January 14, 2020, 3:06pm UTC](https://community.tiller.com/t/currency-conversion-while-adding-indian-bank-accounts-and-loan-accounts/2125/4 "2020-01-14T15:06:46Z")
@heather Would the changes made by me via GoogleFinance function be overriden once the sync happens again? ---
**Author:** ![gauravtechie](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/gauravtechie/32/2064_2.png) [@gauravtechie](https://community.tiller.com/u/gauravtechie)\ **Post date:** [January 14, 2020, 3:17pm UTC](https://community.tiller.com/t/currency-conversion-while-adding-indian-bank-accounts-and-loan-accounts/2125/5 "2020-01-14T15:17:02Z")
This is the original entry in accounts ![Screen Shot 2020-01-14 at 10.12.38 AM](https://us1.discourse-cdn.com/flex020/uploads/tillermoney/original/2X/1/1464c20e1dc666e8302ff49fc77d543743ab042a.png) ---
**Author:** ![heather](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/heather/32/177_2.png) [@heather](https://community.tiller.com/u/heather)\ **Post date:** [January 14, 2020, 3:18pm UTC](https://community.tiller.com/t/currency-conversion-while-adding-indian-bank-accounts-and-loan-accounts/2125/6 "2020-01-14T15:18:58Z")
You would essentially need to use Google Finance to automate the currency conversion in probably Balance History (if it’s for net worth tracking) so that whenever a new entry comes in it would automatically convert it for you. I don’t have much experience with this so I don’t know for sure how it would work or how to do it. It’s not a supported workflow. Perhaps some others here in the community have experience or ideas. ---
**Author:** ![gauravtechie](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/gauravtechie/32/2064_2.png) [@gauravtechie](https://community.tiller.com/u/gauravtechie)\ **Post date:** [January 14, 2020, 3:30pm UTC](https://community.tiller.com/t/currency-conversion-while-adding-indian-bank-accounts-and-loan-accounts/2125/7 "2020-01-14T15:30:23Z")
After I change the value column using Google finance, the value in the name changes ![Screen Shot 2020-01-14 at 10.14.47 AM](https://us1.discourse-cdn.com/flex020/uploads/tillermoney/original/2X/1/1723922e632b94f00b4823477360bc05c6c0b37f.png) However, group liability doesn’t change (it is doing a sync and not adding the entire liability) ---
**Author:** ![gauravtechie](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/gauravtechie/32/2064_2.png) [@gauravtechie](https://community.tiller.com/u/gauravtechie)\ **Post date:** [January 14, 2020, 3:35pm UTC](https://community.tiller.com/t/currency-conversion-while-adding-indian-bank-accounts-and-loan-accounts/2125/8 "2020-01-14T15:35:55Z")
Great! That works. Still to check if that will get overriden in the next sync or not. Will keep the thread updated. ---
**Author:** ![NoName](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/noname/32/341_2.png) [@NoName](https://community.tiller.com/u/NoName)\ **Post date:** [August 16, 2020, 7:15am UTC](https://community.tiller.com/t/currency-conversion-while-adding-indian-bank-accounts-and-loan-accounts/2125/9 "2020-08-16T07:15:46Z")
Hey folks. Does Tiller now work with multiple currencies? ---
**Author:** ![heather](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/heather/32/177_2.png) [@heather](https://community.tiller.com/u/heather)\ **Post date:** [August 18, 2020, 1:25pm UTC](https://community.tiller.com/t/currency-conversion-while-adding-indian-bank-accounts-and-loan-accounts/2125/10 "2020-08-18T13:25:17Z")
Hi @NoName, we still do not work with multiple currencies. ---
**Author:** ![kevinwib](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/kevinwib/32/3385_2.png) [@kevinwib](https://community.tiller.com/u/kevinwib)\ **Post date:** [August 29, 2020, 4:18am UTC](https://community.tiller.com/t/currency-conversion-while-adding-indian-bank-accounts-and-loan-accounts/2125/11 "2020-08-29T04:18:35Z")
wondering if multiple currencies support is in the pipeline in Tiller’s development? considering you guys support connections with global financial institutions. ---
**Author:** ![IsMikeOnFire](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/ismikeonfire/32/7964_2.png) [@IsMikeOnFire](https://community.tiller.com/u/IsMikeOnFire)\ **Post date:** [June 20, 2022, 11:53pm UTC](https://community.tiller.com/t/currency-conversion-while-adding-indian-bank-accounts-and-loan-accounts/2125/12 "2022-06-20T23:53:55Z")
You can upvote a feature request to support multiple currencies. Just click here and click on the Vote button, then if everyone on this thread votes, maybe Tiller will work on an official solution. [https://community.tiller.com/t/foreign-exchange-fx-currency-conversion/13078](https://community.tiller.com/t/foreign-exchange-fx-currency-conversion/13078) ---
**Author:** ![VijayK](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/vijayk/32/11970_2.png) [@VijayK](https://community.tiller.com/u/VijayK)\ **Post date:** [March 16, 2023, 3:45pm UTC](https://community.tiller.com/t/currency-conversion-while-adding-indian-bank-accounts-and-loan-accounts/2125/13 "2023-03-16T15:45:26Z")
Hi @gauravtechie can you please share the steps you did to convert from USD to INR. ---
**Author:** ![randy](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/randy/32/16_2.png) [@randy](https://community.tiller.com/u/randy)\ **Post date:** [March 17, 2023, 6:16pm UTC](https://community.tiller.com/t/currency-conversion-while-adding-indian-bank-accounts-and-loan-accounts/2125/14 "2023-03-17T18:16:56Z")
I’m sorry to say that I haven’t seen a good workflow for this type of currency conversion, @VijayK. One challenge is that most Tiller and community templates are built around (and feed) the `Amount` column, so creating a derived/additional column can create a place for the conversion, but will not be referenced in all the available templates looking for data in the `Amount` column. Many Tiller and Community templates have column lookup formulas in the “hidden area” and you may be able to remap the lookups for your template (like budget) to point to a derived column that you create in your Transactions sheet… but this is unpaved territory. ---
**Author:** ![VijayK](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/vijayk/32/11970_2.png) [@VijayK](https://community.tiller.com/u/VijayK)\ **Post date:** [May 13, 2023, 2:20pm UTC](https://community.tiller.com/t/currency-conversion-while-adding-indian-bank-accounts-and-loan-accounts/2125/15 "2023-05-13T14:20:39Z")
thank you @randy. You are correct either I have to create another column but that column cannot be used by the other templates to calculate. So its a pain. ---
**Author:** ![randy](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/randy/32/16_2.png) [@randy](https://community.tiller.com/u/randy)\ **Post date:** [May 13, 2023, 5:41pm UTC](https://community.tiller.com/t/currency-conversion-while-adding-indian-bank-accounts-and-loan-accounts/2125/16 "2023-05-13T17:41:49Z")
Have you tried modifying a Tiller template to pull in your alternate `Amount` data yet? _It might be easier than you think…_ I just tried this and it took 15 seconds… - Create a new column in the Transactions sheet called `Alt Amount` (or whatever you want) - Fill the data in `Alt Amount` however you want (for testing, I put this formula in the row below the header to double the values in `Amount`: `=ARRAYFORMULA(E2:E*2)`) - Unhide the hidden area in the Monthly Budget Template (to the right) - Change the Amount-header lookup text to `Alt Amount` by entering that in `J27` - Rehide the hidden area Two additional notes: - If you update or restore the template, you will need to restore this modification to the template. - **You should be able to make similarly small changes to other Tiller templates by finding the lookup text for the Amount column in the hidden area.** Let me know if this works for you. Randy ---
**Author:** ![joehinkle11](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/joehinkle11/32/17505_2.png) [@joehinkle11](https://community.tiller.com/u/joehinkle11)\ **Post date:** [May 11, 2024, 8:23pm UTC](https://community.tiller.com/t/currency-conversion-while-adding-indian-bank-accounts-and-loan-accounts/2125/17 "2024-05-11T20:23:16Z")
Any update on this? I loved Tiller and unsubscribed because it doesn’t support multiple currencies ---
**Author:** ![heather](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/heather/32/177_2.png) [@heather](https://community.tiller.com/u/heather)\ **Post date:** [May 14, 2024, 7:06pm UTC](https://community.tiller.com/t/currency-conversion-while-adding-indian-bank-accounts-and-loan-accounts/2125/18 "2024-05-14T19:06:08Z")
We don’t have an update on multi-currency support at this time, but thanks for asking! ---
**Author:** ![MidnightPrzm](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/midnightprzm/32/9704_2.png) [@MidnightPrzm](https://community.tiller.com/u/MidnightPrzm)\ **Post date:** [August 7, 2024, 8:27am UTC](https://community.tiller.com/t/currency-conversion-while-adding-indian-bank-accounts-and-loan-accounts/2125/19 "2024-08-07T08:27:10Z")
What I did was create a sheet called mirror that mirrors the category sheet. I set up following cells A1 ```auto ={ Transactions!A1:E } ``` This mirrors the transaction sheet columns A to E then break with other formulas that are necessary to make it all function. F2 ```auto =if( len(F$1) * isnumber(B2) * isnumber(E2), E2 * index( googlefinance("Currency:" & Formulas!H$5 & F$1, "price", B2), 2, 2), iferror(1/0) ) ``` The FormulasH5 can be changed to any cell that will house what currency you want to convert from. I have a sheet called Formulas where I input any formulas I use throughout my solutions for various things. So H5 has USD as the currency. If you wanted to convert from Euros then you would change that cell to EUR as well as any other currency. It can be any cell not H5. Wherever you choose to input that info. ```auto G1 ={ Transactions!G1:AC } ``` ![image](https://us1.discourse-cdn.com/flex020/uploads/tillermoney/original/3X/e/a/eaf066e95cc79dedb6f08edccdc92f04165ff56b.png) ![image](https://us1.discourse-cdn.com/flex020/uploads/tillermoney/original/3X/6/2/62447d9322ff2ece96057ca0aef9cf282e08ff61.png) Then on another sheet I created a list of different currencies that I wanted to be able to use at any moment since I travel internationally. I then set a dropdown list from the other sheet. So F1 ```auto =lst_currency ``` ![image](https://us1.discourse-cdn.com/flex020/uploads/tillermoney/original/3X/5/3/535062c5b0f568c0dce1c93e75423b56cb0fb675.png) ![image](https://us1.discourse-cdn.com/flex020/uploads/tillermoney/original/3X/6/3/6361a6f580a0fea609c92c71e0d6e167a25a32e2.png) Now the reason I chose to do all this is because when set up with the mobile solution, I use the mirrors sheet to pull in data to populate the mobile app so when I am traveling, I can just quickly pull up what the conversion is for any spending that I am doing. And it can be reversed so if I pay something in cash with a specific currency then I can convert it back to USD depending on how nerdy I want to get. I am usually too lazy to do all that for small purchases but it’s always an option if I ever needed to account for a larger purchase in the future. And I can always view the mirrors sheet so I can see what conversions are for any currency I choose for my transactions sheet. Doing any of these formulas on the actual transactions sheet was giving me issues. ---
**Author:** ![twalane](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/twalane/32/16372_2.png) [@twalane](https://community.tiller.com/u/twalane)\ **Post date:** [August 12, 2024, 10:47pm UTC](https://community.tiller.com/t/currency-conversion-while-adding-indian-bank-accounts-and-loan-accounts/2125/20 "2024-08-12T22:47:03Z")
interesting concept here! Thanks for sharing.