cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Everything you need to know about banking in QuickBooks Online - Discover more
dereshoa
Level 1

I use Mortgage and other sources to buy property,each set as location, need report to see 1) value and outstanding mortgage 2) the monthly loan payment for each Thanks

 
1 REPLY 1
Jen_D
Moderator

I use Mortgage and other sources to buy property,each set as location, need report to see 1) value and outstanding mortgage 2) the monthly loan payment for each Thanks

Good day, @dereshoa,

 

To properly track your loans, you must first create a liability account for it. This way you can check the outstanding balance and review the payment made towards it. Here's how:

 

  1. Go to the Gear icon, then select Chart of Accounts.
  2. Tap the New button and set the Account Type. Use Other Current Liability if the loan will be paid within the current fiscal year. Use Long Term Liability (or non-current liabilities) if it is paid after the current fiscal year.
  3. Update the Detail Type to Loan Payable.
  4. Key in the account name.
  5. Hit Save and close.

Next, enter the opening balance of the loan. Follow these steps:

 

  1. Click the Plus icon (+), and choose Bank Deposit.
  2. Select the correct bank account where the loan funds will be deposited.
  3. Change the deposit date.
  4. From the Account column, enter the loan payable account you created earlier.
  5. Add the loan amount.
  6. Press Save and close.

To record a loan payment, check out these steps:

 

  1. Tap the Plus icon (+).
  2. Click on Check.
  3. (Optional) Enter a check number if you send an actual check. If you're using direct withdrawal of EFT, type in Debit or EF in the Check/Check # field.
  4. Enter the following information in the Account details section.
    • First line: Liability account for the loan and the amount of payment
    • Second Line: Expense account for the interest and the amount
    • Succeeding lines: Any additional fees along with the appropriate accounts.
  5. Press Save and close.

Here's a great article to guide you on how to track loans and its payments: Record a loan and its payment

 

Open an account Quick Report to view the payments applied to the loan account. Here's how:

 

  1. Go to Settings ⚙, then select Chart of Accounts.
  2. Locate the Loan account.
  3. From the Action column drop-down menu, select Run Report.
  4. On the Report period drop-down list, select All Dates.
  5. Hit Run report.

 

Please let me know if you have any questions with the steps or need assistance with anything in QuickBooks. I'm just a post away. Have a good one!

Need to get in touch?

Contact us