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. Configure the interest settings in Loan parameters, as below

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

Maturity date is the alternative to a period count: set the date the last payment falls on instead of Periods. A start date with 360 periods lets Capitally work the maturity out itself; a maturity date with 360 periods and no start date makes it work the start back from there.

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 an Open transaction
2. Set Quantity to the loan amount as a negative number (e.g., -300,000)
3. Leave Price at 1, which Capitally pre-fills from the asset's face value
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. End the old mortgage with a Close transaction (quantity = remaining balance as negative)
2. Create a new mortgage asset with updated terms
3. Record the new loan with an Open transaction

Early payoff:

1. Add a Close 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.

Keeping the interest out of an income view

To see income without the mortgage in it, switch the filter at the top of Portfolio to Owned. A mortgage is a position with a negative quantity and its payments are negative interest transactions, so Owned drops both before any number is computed, leaving dividends and rent on their own.

For finer control use the condition Unit is owned: yes instead, which decides lot by lot — the property stays, the mortgage against it goes. Save either as a bookmark and the view is one click away. Note that the same filter empties Owed and Debt Ratio, so keep it separate from the debt view above. Full condition reference in Filters.

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.