We are doing some research on extending and improving the Tiller experience for international users.
Are you using Tiller with banks outside the US?
How is it going?
We’d love to hear about your experiences…
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?
Where can we find the money wiz app? Searched google play and dont see anything
Moneywiz is an app in the Apple app store.
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…
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.
Happy to share more if that’s helpful!
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.
this looks closed so I’ll gladly give you my requirements if you tell me this thread is still open.
I do have foreign accounts and needs for foreign currecies.
I’m not using it with foreign bank accounts but my use case is tracking cash expenses in foreign currency.
Some places give discounts on cash transactions or only accept cash and I want to be able to track those via tiller. The trivial way to track those is to do the conversion manually then add the manual cash transaction.
I would prefer a addon that does all that.
Since 2019, I have maintained a Tiller sheet for a few Canadian accounts in Quebec, where we have a vacation home. Desjardin Bank holds these accounts, and the data feed has been reliable with minor lapses.
To incorporate the exchange rate, I have added a sheet called Exchange Rate History that appends each day’s closing USD/CAD rate, using the GoogleFinance function. On the Transactions sheet I have added a column called USD that calculates the USD value for each transaction on the date it occurred. The result is not exact, as it cannot account for spot exchange rates or transaction fees, but it is substantially correct and adequate for budgeting and reporting.
I don’t believe the data necessary to document the exact exchange value per transaction exists, other than by manual entry. I’m eager to hear what other may be doing here
I use the Foundation template and virtually all the templates I use for my US accounts, and do most budgeting and reporting in Canadian dollars. When I want to report Canadian transactions in their USD equivalents, I use @KyleT s Programmatic Query Builder to filter and sum transactions by their USD values.
Historically, while in Canada all our daily expenditures were made in local currency via debit card, check or cash. and bills were paid from local accounts. More recently I am able to make purchases and pay bills using my US credit card which pays a cash dividend. These transactions appear in my US Tiller workbook.
As a result, I increasingly would like to audit expenses for projects whose transactions are recorded in two Tiller workbooks. I am thinking about using IMPORTRANGE to create a global transaction sheet that I can draw on for reports and analysis. This is out at the frontier of my technical facility, so I’m eager to see others getting interested.
All this has worked well for several years.
This is a great workflow to hear about. The GoogleFinance formula is really helpful for currency conversions.
The IMPORTRANGE is one option for pulling everything together.
Another would be to put all your connected accounts USD and CAD into one spreadsheet. Then create a new “CAD Amount” column for your original CAD transactions. Periodically cut/paste the Amount for any new Canadian transactions into this column (made easier if you filter your sheet to only show Canadian banks, then do a batch cut and paste). Then use the GOOGLEFINANCE formula to put the USD value back into the empty Amount column cells.
One note with GOOGLEFINANCE. If it’s running and updating many cells, it could take performance hit to the sheet. If this happens you could copy then “paste as values” some of your entries that are now calculated and don’t always need recalculating.
Hope that helps. We are watching this and considering when and how we want to more fully support international currencies. Thanks for chiming in here!
I download a CSV transactions file from HSBC, run it through a Python script I wrote (OK, ChatGPT wrote) that converts the date format and currency to the day’s rate. Then it moves the columns around and adds the necessary headers and account data to use the community CSV import.
