Multi-Currency with Zapier
The Zapier Integration is great when you work with multiple currencies and want to keep record of consolidated balances in another currency in realtime.
The Post Transaction Trigger from bkper starts the Zapier integration.
Webhooks by Zapier GET the current conversion rates from http://api.fixer.io
As the book of origin is in Euros GET the EUR base. Test it with http://api.fixer.io/latest?base=EUR
The Formatter by Zapier applies the exchange rate from (api.fixer.io) to the Transaction Value with a Numbers Formula
Take the amount from the Transaction and multiply it with the USD rate from fixer.IO and round the value too two digits.
Record the Transaction in the book with the other currency.
Use the calculated output in step 3 to record the Transaction in the book with the other currency. In this kind of setup it is good practice to record where the Transaction comes from, what exchange rate was used and maybe use a specific #eur hashtag for quick identification.
The result of the multi-currency integration
Notes: This example uses Euro as the source book and Dollars as the target book.
If you want to make this integration both ways you need to insert as a second step the Filter by Zapier (#eur / #usd) to avoid repeating transactions.
You can also use these Rest APIs to get the Exchange Rates
Yahoo finance API
Open Source Exchange Rates API
European Central Bank Feed