I am also hacking my own tool together for exactly this reason - multi-currency is one of those things that is absolutely essential if you need it, but is often ignored by a lot of these solutions.

Check out this amazing article that helped me: https://www.mathstat.dal.ca/~selinger/accounting/tutorial.ht...