I see a couple of old threads regarding multiple currency support.
Has anyone attempted to add this in the wild in any way?
I need a separate transactions ledger in a foreign currency. Perhaps it could periodically / manually be included in the Transactions tab in USD.
For example, I live for two months in Xountry and spend XSD on rent, food, transportation, and other categories. I also capture USD to XSD conversions with line items for the FX charged fees. I care about monthly in USD in the overall budget, etc. Perhaps I rollup all āfoodā transactions and create one entry per month in the Transactions tab in USD.
Any thoughts on pulling this off? Anyone try anything like this?
Any FX accounts that can be automated by Tiller could be segregated into their own linked spreadsheet. Then you can create a tab in your main USD Tiller using the googlefinance importxml approach to give you a USD view of these transactions and balances. You can then enter new balances in USD for these as manual accounts and enter groups of transaction from this FX transaction view tab (USD) to the Transaction tab proper. May be too much workā¦
Anyway, in my case above, Iām not anticipating that Tiller Money will automate much, if any of the XSD transactions.
Iād be happy to share what I do with mine - I currently am living in Shanghai, so I have separate US and China (RMB currency) budgets. I track my budgets separately and then combine them in total per category in the transactions tab (the USD one by total category and then the RMB one after converting the total of each category from RMB to USD).
@kevinwib I actually do the budget tracking in YNAB (2 separate budgets-one in USD and one in CNY), export it to a CSV, convert the CNY budget and then pull the category totals for each budget into my Tiller-powered spreadsheet. I use Tiller for pulling in account balances (and hopefully soon for investment positions!).
I work in Canada and live and spend most of my money in the US, so this is a struggle for me too. So far, I have been importing all currency transactions into the same transactions sheet and then manually moving all the USD amounts into a new āUSD Amountā column, then replacing the āAmountā with a conversion to CAD based on a formula reading the monthly exchange rate from another sheet.
I have been looking at Quicken because apparently it supports multiple currencies, but I understand Quicken doesnāt import transactions from multiple currencies. I canāt believe we havenāt got a better solution available, but Iām still looking! Iām intrigued by your idea of segregating the feeds into separate linked spreadsheets. I imagine I would have one tiller spreadsheet importing all my CAD accounts automatically, and another importing all my USD accounts, then link the information from one to the other as necessary?
I just upvoted the feature request to support multiple currencies. The request is from 2014 and with my vote the grand total is a whopping 5. Are really so few people interested in a multiple currency option? Seems like a no-brainer to me. If anyone sees this please add your vote!