Tracking Mortgage

Tracking your mortgage in Capitally lets you monitor your debt, interest payments, and see your true net equity when combined with property value.

Capitally can automatically calculate interest accrual and generate payment schedules.

Setting up a mortgage

1. Click + Add and select Create custom asset
2. Set Type to Mortgage
3. Name it (e.g., "Apartment Mortgage" or "123 Main St Mortgage")
4. Set the Currency to match your loan currency
5. Open Prices tab
6. Enable Interest pricing
7. Enable Negative balances (since a mortgage is money you owe)
8. Configure the interest settings as below

Example: 30-year fixed-rate mortgage at 6%

Example: 5/1 ARM (5-year fixed, then adjustable)

Start with the initial rate, then add overrides for rate adjustments:

Then click Add rate to add an override:

• Date: 5 years after loan start
• Interest rate p.a.: 6.25 (or expected rate)

Add additional overrides as rates adjust annually.

Recording the initial loan

When you receive the mortgage:

1. Add a Buy transaction
2. Set Quantity to the loan amount as a negative number (e.g., -300,000)
3. Set Price to 1
4. Set the Account where you want to track this mortgage

Recording out-of-schedule payments

If you configured interest-based pricing right, Capitally will automatically generate estimated interest transactions. You can adjust these to match your actual statements.

You can also add Interest transactions manually, whenever you make out-of-schedule payments or closing the mortgage early.

1. Add an Interest transaction
2. Set Interest received to the interest paid as a negative number
3. Set Principal amortized to the amount you repaid as a negative number

Refinancing:

1. Close the old mortgage with a Sell transaction (quantity = remaining balance as negative)
2. Create a new mortgage asset with updated terms
3. Record the new loan with a Buy transaction

Early payoff:

1. Add a Sell transaction for the remaining balance
2. The mortgage position closes to zero

Connecting mortgage to property

Put both the property and mortgage in the same account:

1. Create an account (e.g., "Downtown Apartment")
2. Add the property asset to this account
3. Add the mortgage asset to this account

When you open this account in Portfolio, you'll see:

• Owned: the property value
• Owed: the mortgage balance
• Net value: your equity (property value minus mortgage)

The Owed chart shows both values over time.

Viewing your debt metrics

In Portfolio, the Market Value tab shows:

• Owned: Total value of assets you own
• Owed: Total value of liabilities (mortgage balance)
• Debt Ratio: How leveraged you are (owed / owned)

The Owed chart visualizes how your equity grows as you pay down the mortgage while property value changes.

Importing mortgage transactions

If you have a spreadsheet with your payment history:

1. Go to Import → Import any data
2. Load your file
3. Map columns to transaction properties
4. For interest payments, map to Value (as negative) and Principal amortized (as negative)

See Import from a file for detailed instructions.