Bkper Books are designed to work with a single type of unit, which usually is Money, but can digital currencies as well, or any other asset.

When you work with multiple currencies, you should keep a separate Book for each currency you work with, or, if working in the same book, structure your chart of accounts as totally isolated books, not mixing Incoming and Outgoing accounts transactions and recording the remittances converted to each currency, with intermediary accounts. E.g.

Book 1 (BRL)

The US Operation account is an asset.

Book 2 (USD)

The Brazilian Operation account is a liability.

In the above case we sent money from Brazil to USA operation, and kept the balance as an Asset for Brazil and a Liability for USA. You can later pay the Brazilian operation back, and/or clear the remaining balance as an Outgoing Expense or Incoming Revenue, depending on cambial variations.

You can aggregate the Balance Sheet and Profit & Loss statements using Google Sheets Add-on.

How to track multi currencies with Google Sheets?

Fetch relevant balance values of each currency with the Google Sheet Add-on for Bkper to one Google Sheet and consolidate the data into one currency with the formula =GoogleFinance("CURRENCY:USDEUR")  

How to track a single currency with Google Sheets?

With sporadic transactions in another currency, and keeping track of transactions in other currencies is irrelevant create just one book that records one currency. Collect movements in other currencies in Google Sheets and convert them with the formula =GoogleFinance("CURRENCY:USDEUR") into the desired currency and Record Transactions with the Google Sheets Add-on for Bkper into your book. 

Note: Identify converted transactions adding #converted #rate:xx,xx hashtags to the transaction. 

Did this answer your question?