Quickbooks Mortgage Expense: How To Enter It

Recording mortgage payments in QuickBooks is a straightforward process, but it can be time-consuming if you've ignored a mortgage for a long time. To record mortgage payments, you must first set up a liability account and record the mortgage loan. Then, when you make a payment, you must split the transaction into three lines: the principal payment, the interest payment, and the escrow payment. You can also set up a recurring expense to automate this process.

Record mortgage payments

Recording mortgage payments in QuickBooks requires a few steps. Firstly, you need to establish the total loan amount and the remaining balance. If you are uncertain about these figures, you can contact your bank or lender, or cross-reference the amounts with any previous records you may have. Once you have the correct loan and balance amounts, you can proceed to create accounts to track your liabilities. You will need to establish a liability account for the mortgage and an expense account for interest payments.

Next, you will need to create a journal entry to record the initial mortgage loan. It is recommended to consult an accountant at this stage to ensure all accounts and amounts are correctly recorded. After this, you can use a check to record the loan repayment. To do this, go to the '+New' button and click 'Check'. If you are sending an actual check, enter the check number. For direct withdrawal or EFT, enter 'Debit' or 'EFT' in the 'Check no.' field. In the Category details' section, choose the liability account for the loan from the 'Category' dropdown and enter the payment amount. On the second line, select the expense account for the interest and enter the interest amount. You can add any extra fees on additional lines, choosing the appropriate accounts. Finally, save and close.

When you make a monthly payment in QuickBooks, the transaction needs to be split into three lines. The principal payment is applied to the Long-Term Liability Mortgage to pay down the loan, the interest payment is booked under an Interest Expense account, and the Escrow payment is applied to an Other Current Asset account. An escrow payment is money given to another party to hold until certain payments, such as home insurance premiums and tax payments, are due.

Set up a liability account

Setting up a liability account in QuickBooks is a straightforward process. A liability account is used to track what you owe someone. For example, if you have taken out a loan to purchase a home, you will need to set up a liability account to track the loan and the interest payments.

Firstly, you need to create the accounts. To do this, navigate to the Gear icon and select Chart of Accounts. Then, press the Account Type drop-down and pick either Other Current Liabilities or Long Term Liabilities, depending on the type of liability account you are setting up. Next, select the appropriate category in the Detail Type drop-down. Enter a name for the account and click Save and Close.

After making the accounts, create a journal entry to enter the initial mortgage loan. It is recommended to seek the guidance of an accountant during this step to ensure that all accounts and amounts are correctly recorded. If you don't have an accountant, QuickBooks can help you find one.

Once the accounts are set up and the initial mortgage loan has been entered, you can use a check to record the loan repayment. Go to the +New button and click Check. If you plan to send an actual check, enter a check number. For direct withdrawal or EFT, input Debit or EFT in the Check no. field. Head to the Category details section of the check. On the first line, choose the liability account for the loan from the Category dropdown and type in the payment amount. On the second line, select the expense account for the interest under the Category and enter the interest amount. Input any extra fees on additional lines and pick the appropriate accounts. Finally, hit Save and close.

Record the mortgage loan

Recording a mortgage loan in QuickBooks is essential for maintaining accurate financial records and understanding your cash flow. It is a straightforward process, but it is recommended that you seek guidance from an accountant to ensure that all accounts and amounts are correctly recorded.

Firstly, you need to create a liability account for the mortgage and an expense account for interest payments. To do this, go to the Gear icon and select 'Chart of Accounts' from the 'QuickBooks Lists' section. Then, right-click anywhere and select 'New'. From the Account Type drop-down menu, select 'Long-Term Liabilities' (or 'Other Current Liabilities' if you intend to pay off the loan within the current fiscal year). From the Detail Type drop-down menu, select 'Notes Payable'. Give the account a relevant name, such as "Mortgage Loan".

Next, create a journal entry to enter the initial mortgage loan. Go to the '+' button and select 'Journal Entry'. On the first line, choose the liability account for the loan from the Category dropdown and type in the payment amount. On the second line, select the expense account for the interest and enter the interest amount. Input any extra fees on additional lines and select the appropriate accounts. Hit 'Save and Close'.

After setting up these accounts, you can record your monthly mortgage payments. Each month, the transaction needs to be split into three lines. The principal payment is applied to the Long-Term Liability Mortgage to pay down the loan, the interest payment is booked under an Interest Expense account, and the Escrow payment is applied to an Other Current Asset account. To record the monthly payment, go to the Banking menu and select 'Write Checks'. Select the relevant vendor and enter the payment amount. Then, from the Expenses tab, enter the accounts you've created and the relevant amounts. Select 'Save and Close'.

By integrating mortgage and escrow payments into QuickBooks, you can streamline your financial management, track obligations, and ensure proper reporting for budgeting, loan applications, and tax compliance. This will help you make informed decisions regarding forecasting, budgeting, and investment opportunities, leading to better financial accountability.

Split payments into principal, interest and escrow

When you make a mortgage payment in QuickBooks, the transaction needs to be split into three lines: principal, interest, and escrow. The principal payment is the amount that goes towards reducing the outstanding balance of the loan. The interest component represents the cost of borrowing money and is calculated based on the outstanding balance of the loan. The escrow payment is money given to another party (usually your mortgage company) to hold until certain payments, such as home insurance premiums and property tax payments, are due.

Here's a step-by-step guide to splitting your mortgage payments into principal, interest, and escrow in QuickBooks:

• Create a liability account for the mortgage and an expense account for interest payments. Navigate to the Gear icon and select "Chart of Accounts" to set up these accounts.
• Make a journal entry to record the initial mortgage loan. It is recommended to consult an accountant during this step to ensure accurate recording.
• Use a check to record the loan repayment. Go to the "+New" button and click on "Check." If you are sending an actual check, enter the check number. For direct withdrawal or EFT, input "Debit" or "EFT" in the "Check No." field.
• Head to the "Category Details" section of the check. On the first line, select the liability account for the loan from the "Category" dropdown and enter the payment amount.
• On the second line, choose the expense account for the interest under the "Category" and enter the interest amount.
• If applicable, input any extra fees or escrow payments on additional lines, ensuring you select the appropriate accounts. For example, you can set up an "Escrow" account as a current asset to record your monthly escrow payments.
• Click "Save & Close" to record the loan payment.

By following these steps, you can effectively split your mortgage payments into principal, interest, and escrow components in QuickBooks. This will help you keep accurate records and facilitate tax deductions for any eligible interest expenses.

Categorise mortgage payments

To categorise mortgage payments in QuickBooks, you must first create accounts to track your liabilities. Establish a liability account for the mortgage and an expense account for interest payments.

Once you have set up these accounts, create a journal entry to enter the initial mortgage loan. It is recommended to consult an accountant during this step to ensure that all accounts and amounts are recorded correctly.

After that, use a check to record the loan repayment. Go to the +New button and click Check. If you plan to send an actual check, enter a check number. For direct withdrawal or EFT, input Debit or EFT in the Check no. field.

Then, head to the Category details section of the check. On the first line, choose the liability account for the loan from the Category dropdown and type in the payment amount. On the second line, select the expense account for the interest under the Category and enter the interest amount. Input any extra fees on additional lines and pick the appropriate accounts.

Finally, hit Save and close.

Note that you will need to manually categorise the mortgage payments and make adjustments at the end of the year when you have detailed mortgage statements available. Each monthly payment transaction needs to be split into three lines: the principal payment, the interest payment, and the escrow payment. The principal payment is applied to the Long-Term Liability Mortgage to pay down the loan, the interest payment is booked under an Interest Expense account, and the Escrow payment is applied to an Other Current Asset account.

Frequently asked questions