Captools/net Documentation

Multi-Currency Reports

Multi-Currency Reports

Previous topic Next topic  

Multi-Currency Reports

Previous topic Next topic  

Although most users of Captools/net do not have a need to maintain multi-currency portfolios, some users may wish to take advantage of Captools/net's multi-currency capabilities by adding the multi-currency option to their software license.  If you have opted for multi-currency capability, then you may enter transactions in securities whose trades and pricing are denominated on more than one currency and likewise perform account valuations in those currencies, translating the local currency denominated amount into the base currency you have specified for the account.

 

If you have portfolios with multi-currency holdings, you can construct reports which employ the following report fields which support multi-currency reporting:

 

Most Reports

 

Base Currency - This specifies the symbol used as the base currency for the account.  If the client is Canadian, but with U.S. holdings, the base currency typically would be C$, or whatever currency symbol you want to use for the Canadian dollar.

 

Security Currency - In security detail reports, this specifies the currency symbol in which the security is traded and priced.

 

 

Transaction Reports

 

Local Amount - This is the amount of the transaction or trade when denominated in the currency in which it is traded, or the currency which is "local" to the security.

 

Exchange Rate (X-Rate) - This is the currency exchange rate as of the transaction date expressed as the price of the local currency in terms of the portfolio base currency, e.g., if the base currency is C$, and the security currency is US$, and  one US$ buys 1.20 C$, then exchange rate is 1.20.

 

 

Holdings/Period Reports

 

Local Accrued - This field reports the amount of accrued interest on a bond in terms of the security's local currency.

 

Local Value - The value of the security holding in terms of the local currency.

 

Exchange Rate (X-Rate) - The currency exchange rate as of the applicable valuation date (start or end date of the report)

 

Local Cost Basis - The taxable cost basis of the security holding in terms of the local currency.

 

Exchange Gain - The gain achieved for the security holdings due to the change in the exchange rate.

 

Exchange Gain% - The exchange gain in percentage terms.

 

Market Gain - The gain achieved for the security holdings due to the change in the price of the security in its local currency.

 

Market Gain% - The market gain in percentage terms.

 

 

"Two-Currency" Reports

 

These reports, available in the higher level versions of the software to multi-currency users, allow you to specify a "Report Currency" in the report options against which multi-currency accounts can be run.  In these reports, you can show costs and values in the specified base currency and also in the currency in which the security is held.  If such a report is run with several accounts with different base currencies being merged together, the amounts can be reported in the "base currency" designated for the report, and the performance figures will likewise be reportable in terms of that currency.  E.g. if your client is domiciled in Canada and needs reports in Canadian $, but also has accounts in the U.S., U.K. and Europe, the report can be specified to have a  "Report Currency" of C$ into which the US$, UK£  and Euro holdings will be converted, with performance figures also normalized to the "Report Currency".