Multi-currency .... need help/discussion on an approach

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?

In looking at this thread, Currency conversion while adding Indian bank accounts and loan accounts, a possible solution for his problem has come to mind.

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).

Yes, I’d be interested in seeing how you’re doing the recombination. In particular how you’re handling the exchange rates, etc.

1 Like

I keep it pretty simple and just use the average exchange rate for the month and convert it all at the end of each month.