Good day, bucksbar.
You can set up a mortgage to show principal, interest, and escrow payments in QuickBooks Desktop. Ensure to consult with your accountant for the accounts you need to use. Let me show you the process.
Create three accounts to track escrow payments. Here are the steps:
- Go to the Lists menu, and choose Chart of Accounts.
- Right-click anywhere and click New.
- Create a loan account.
- Click the Other Account Types drop-down, choose Long Term Liability, then click Continue.
- In the Name field, enter the name of the loan.
- Click the Enter Opening Balance button and enter the full (beginning) amount of the loan in the Opening Balance field.
- In the as of field, enter the loan origination date.
- Click Save & New.
- Create an escrow account.
- From the Type drop-down list, choose Other Current Asset.
- Enter a name for the account ( for example, Escrow), the Opening Balance amount (if there have been any prior payments), and the as-of-date.
- Click Save & New.
- Create an expense account.
- From the Type drop-down list, choose Expense.
- Enter a name for the account (Interest, for example).
- Click OK.
Once done, make a mortgage payment. The steps are as follows:
- From the Banking menu, choose to Write Checks.
- Choose the appropriate supplier, then enter the amount of the payment.
- On the Expenses tab, enter the account/s you have created and the appropriate amount/s. Note: QuickBooks does not do loan amortisation.
- Click Save & Close.
- Make transfers from the escrow account:
- From the Lists menu, choose Chart of Accounts.
- Double-click the escrow account to open its Register.
- Enter the amount in the Decrease column and then select the Expense account.
- Note: You can create accounts depending on the expenses that make up your escrow payment.
- After making the correct entries, click the Record button.
Here's an article to guide you on how to track loans and their payments for additional reference: Set up a mortgage in QuickBooks Desktop.
I've also added some resources to learn more about tracking loans in QuickBooks:
That should do it! If you have other follow-up questions about the process, you can get back to this thread and add details so I can get back to you as soon as I can.