My situation is very simple, all my bank accounts are in USD but I manually track non-USD spending (mostly cash) by added “currency” and “original amount” columns in the transactions sheet. I keep the “amount” column in USD and bulk convert based on whatever rate I got when withdrawing cash.
I use Moneywiz app to track my Portuguese bank expenses from Millennium bcp, and then each month manually input those expenses into the Tiller worksheets. It would be a godsend if Tiller supported my EU bank.
Thanks for the responses, @TomGoBravo and @leavittvoice. Tom, it sounds like your needs aren’t too disruptive to the way the spreadsheet is built. And Mr. Leavitt, it sounds like it would be nice if your Portuguese bank accounts could be automatically fed with a currency indicator.
Would love to hear from other users for whom these questions are relevant…
Will be doing this come summer with a Spanish bank account (Banc Sabadell). They are part of the EUs open banking system, but I am not sure a US based aggregator will play nicely with them. Anyone have experience there?
Interesting, @deganon. I’m curious as well to hear about the feed quality with the Spanish bank. Will you be doing multiple currencies in the spreadsheet?
So, when trying to connect Sabadell, I received the message upfront that “Support for Cash account(s) is in development and may not link successfully.” I attempted to log in but it errored out. I will have to handle this manually.
With regard to currency, as a user I want to automatically track a balance and show it in both EUR and USD. This would be extremely helpful so that net worth and other tracking in USD can be maintained and apples to apples.
Also, as a user I want to automatically use daily currency rates to facilitate everything above and to track costs and timing on exchanges when needed.
I have some CAD retirement accounts to track. Rather than mess with currencies in Tiller I just convert to USD value in a browser and update a manual balance once a week. I don’t need the underlying transactions.
I’m using Tiller in Excel and I have a single UK account to track alongside all my US accounts. The account is fairly transaction light so keeping it updated manually isn’t too onerous - I just maintain a worksheet with balance and transaction information for that account in my Tiller workbook. There are two main things I need to do…
Track GBP balances in USD for net worth reporting.
Track GBP balances in USD to identify max balance in USD for my taxes.
My core strategy for both of these aims is to maintain a worksheet with daily exchange rate information. I maintain the exchange rate information with a static table for historical data and by using the Excel STOCKHISTORY function to look up exchange rates for dates not covered by my static table. I then use Power Query to generate the overall exchange rate table, to convert GBP balances to USD, and to merge the converted UK account info with the rest of my Tiller accounts.
It works ok, though I’m still trying to speed up data refresh times, and messing around with Power Query is not for everyone. I’m no Excel expert so owe a lot to the help of ChatGPT.
That’s great you’re looking into improving Tiller for international users!
I’m based in Singapore and use DBS Bank. While Yodlee lists DBS as a supported bank, I’ve only ever been able to download balances, not actual transactions. Unfortunately, DBS hasn’t been very helpful in resolving this on their end.
As a workaround, I manually download all my transactions from DBS. Then, I reformat the columns in the downloaded file to match Tiller’s requirements and upload them as a CSV file. My entire spreadsheet is kept in Singapore Dollars (SGD).
I do have accounts in the UK and US, but I haven’t found an efficient way to track all those different currencies and accounts within Tiller, so I currently don’t integrate them into my Tiller spreadsheet.
One “gotcha” for me is the lack of reliable direct transaction feeds for DBS, which necessitates the manual download and reformatting every time. This adds a significant extra step to my workflow.
I use many standard and customer created templates.
I’m planning to move our household to France in 2026 or 2027 and possibly keep some US brokerage accounts, bank accounts, and credit cards, while also opening a French bank account, and I would love to continue being able to use Tiller.
Not sure where the currency data would bother me unless I moved overseas again.
I lived in Canada for some time, however this was just long enough ago to not be worth adding the historical data in.
What countries or currencies?
Australia -AUD
How is the international bank-feed quality?
Spectacular, we have had open banking for a good long time now.
2 factor auth just got added for my super account, I haven’t been able to get that to refresh just yet.
Are you integrating with any standard Tiller templates?
Standard templates and I’ve played with a few community ones to see the vibe
Are you using multiple currencies in one spreadsheet? What is your workflow?
Previously had historical data for Canada, however I only used to track those balances in 1:1 at the time anyway
Any unexpected gotchas?
US date format takes a bit to wrap my head whenever I haven’t been in the file for while.
this also caused a few headaches and adjustments when building historical data.