Capitally currently does not support direct price tracking for bonds. However, you can still keep track of their value and compare them to other assets in your portfolio by creating custom assets for them.
In the future, you will be able to set variable interest rates on assets instead of market prices.
While manually adding fixed-income assets is an option, the most efficient method is to create an import template. This is particularly useful if your bank provides you with a file or table containing transaction details and current asset values.
As fixed-income assets should have the same market price as the price paid on the purchase date (usually 1 or 100), it is recommended to create a custom asset for each bond series or deposit you buy.
To organize them better, consider creating custom Markets for all your bonds or deposits. This will allow you to compare them more easily.
There are two methods for tracking fixed-income assets in Capitally:
For deposits with a fixed rate and no coupons: You set their future value.
Create an asset with the appropriate type (Bond or Deposit).
Add a Buy
transaction. Set the Market Price
and Price
to 1 (or 100) along with the correct quantity.
Add a Sell
transaction with the date in the future - when the bond expires. Set the Market Price
and Price
to the correct future amount. For example, a 1-year 5% deposit will have a future price of 1.05
after a year.
For deposits or bonds with a variable rate and/or coupon payouts: It's more effective to track their current value and log the coupons.
Create an asset with the appropriate type (Bond or Deposit).
Add a Buy
transaction. Set the Market Price
and Price
to 1 (or 100) along with the correct quantity.
Whenever there's a coupon payout, add an Interest
transaction with the coupon value.
Set the Market Price
to the correct future value one day before the coupon payout. This allows you to track unrealised gains in real-time.
Set the Market Price
to 1 on the coupon payout day as your gains have just been realised in the form of the coupon.
To automate the above processes, it is best to use two import templates. You can find an example of how to do this here for tracking Polish bonds.
The Portfolio section allows you to compare the fixed income of all the assets in your portfolio. This includes Bonds, Stocks and Real Estate, enabling you to see which one is bringing the most effective yield.
If you are adding transactions or bond market prices with a future date, you can change the Date Period in the Portfolio to see the future value of your fixed-income portfolio. You can choose a particular date, or just type +6m
to see six months into the future.