Tracking Debt

In Capitally, any asset can turn into a liability - its quantity has to go negative. You can either "Buy" assets by setting a negative quantity or "Sell" them first with a positive one.

How to track loans and mortgages

1. Create a Custom Asset, choose Loan or Mortgage for an asset type.

2. Enter interest rate and other loan properties in the Prices -> Interest tab.

3. Create a regular Buy transaction when you've taken the loan.

   1. Quantity is negative - equal to the amount you borrowed

   2. Price is simply 1

4. Create a Sell transaction when you repay the debt

   1. Paid principal is your Quantity - again it has to be negative

5. If you pay interest, create an Interest transaction with a negative value (because you're paying the bank not the other way round).

   1. If you repay your loan along with the interest, enter the repaid amount in the Principal amortized field (negative again) instead of creating a separate Sell transaction.

Importing Transactions

You can easily create an import template to add principal & interest payments in bulk from your broker or spreadsheet.

Exploring Your Portfolio

Use Accounts or Tags to group loans together with what they finance (eg. Real-estate + Mortgage, Stocks + Margin account).

The Market Value tab has an Owed chart and displays three relevant metrics:

• Owned - how much value you actually own (your assets)

• Owed - how much value you've borrowed (your liabilities)

• Debt Ratio - how deep you're in debt (as owed/owned)