I'm an expat and am curious: Is there any better way out there to manage my various assets in differing currencies across borders and markets? Currently, I just use a spreadsheet, but it is becoming difficult to manage.
Yes, using software capable of doing this automatically would make this process less onerous.
Still, each asset should be marked in its respective currency of denomination, and translated later for reporting, e.g. a U.S. house should be marked in USD, a U.S. mortgage in USD, a European house in EUR, a European mortgage in EUR, etc.
From there, in the spreadsheet or software, all of the currency cross rates can be updated and applied to each asset. Then, the total value could be seen in each currency of interest.