Table of contents
Set up and track a mortgage in DoorLoop.
Written by Matt
Table of contents
Follow this guide to correctly track a mortgage and record mortgage payments for a property in DoorLoop. There are a few ways to do this depending on what you are looking to record.
The instructions below are very basic and used as an example. It is suggested that you consult with your accountant and modify these steps based on your needs.
If you are looking to only record the expense of a mortgage payment, use this method.
If you are looking to also track amortization and escrow payments, use a combination of sections 2 and 3.
Step 1 - Create a Fixed Asset for your Property
To create a fixed asset for your property, click Accounting on the main menu and then click Chart of Accounts.
On the top right corner, click + New Account.
On the New Account window, enter the following information for the Account Info:
Type: select Asset > Fixed Asset
Account Name: You can enter the name/address of your property here
Description: (Optional)
Active Account: Yes
Click Save to Finish.
Next Step
If you are looking to only record the expense of a mortgage payment, use this method.
If you are looking to also track amortization and escrow payments, use a combination of sections 2 and 3.
Step 2 - Track a Mortgage, including Amortization and Escrow
Add the mortgage’s long-term liability account to the Chart of Accounts. You can create this as a sub-account to the Mortgage liability account.
(DoorLoop already provides a Mortgage liability account, but you may want to create a new account if you plan on tracking multiple mortgages.)
Add specific expense accounts to your Chart of Accounts for expenses that may be paid directly by the mortgage company from escrow. (For example - property taxes, homeowner's insurance, etc.)
Record the initial loan with a journal entry.
Credit the mortgage’s liability account for the amount of the loan.
Debit the property’s fixed asset account for the amount of the loan.
If you’ve already made some payments, balance the journal entry using an equity account, such as the Opening Balance or Owner Contribution.
For example, let's say the mortgage is for a property valued at $250,000 and the remaining principal balance is $200,000. The journal entry for this mortgage would be:
DEBIT the Property Fixed Asset account: $250,000
CREDIT the Mortgage Long Term Liability account: $200,000
CREDIT the Owner Contribution Equity account: $50,000
When recording a mortgage payment, create an Expense to the bank as a payee, and use the accounts this payment is correlated to (Mortgage Interest, Mortgage liability, Mortgage Escrow).
Move to Step 3.
Step 2a - Record a Mortgage Payment (Expense)
Add an expense account called Mortgage Expense to the Chart of Accounts.
Create an Expense for the mortgage company using the newly created Mortgage Expense account. You would do this each month that you make a payment.
No need to continue to Step 3.
Step 3 - Record a Payment from Escrow by the Mortgage Company
Use a journal entry to record a payment made from escrow by the mortgage company:
For example, let's say there was $10,000 in escrow. The mortgage company used $5,000 to pay property taxes. The general journal entry for this escrow payment would be:
DEBIT the Property tax expense account: $5,000
CREDIT the Mortgage Escrow asset account: $5,000
Disclaimer
The information provided is not offered by a licensed accountant, should not be considered accounting, financial, or legal advice, and is provided (and intended) for general informational purposes only. Do not rely on the information provided; rather, please verify applicable accounting laws and regulations independently. This information should not be considered a substitute for professional advice and does not offer Generally Accepted Accounting Principles (GAAP). The author and publisher are not liable for any damages or losses resulting from reliance on this information.
Did this answer your question?
