When a loan is repaid in regular fixed payments, this repayment usually includes both compounded interest and principal installments for the period. As each successive payment is made the interest portion gradually decreases and the principal portion increases. The QuickBooks Loan Manager creates an Amortization schedule for the duration of the loan, showing how much of each payment is applied to principal, interest and escrow (additional fees related to the loan). It also allows you to make payments for either the regular scheduled amount, or additional payments, and to run "what-if" scenarios to compare different loan choices.


Prepare to track loans in Loan Manager

Before using QuickBooks Loan Manager, set up the following accounts and vendor in QuickBooks Desktop.

  • Create a vendor for the Bank or Financial Institution issuing the loan, if none already exist
  • Record the initial loan amount as an opening balance (using New Account window) or as a transaction like journal entry. Make sure to use the loan origination date. If payments have already been made against the loan, you need to enter these as checks, bills or journal entries.
  • Set up an Expense type account for interest payments and Fees and charges, if none already exist.
  • Create an Escrow account if necessary.

How to track loans and repayments using QuickBooks Loan Manager

  1. From the Banking menu, click Loan Manager.
  2. Click Add Loan.
  3. Enter Account Information of the loan and click Next.
    • Account Name: Loan Account that you previously set up.
    • Lender: Vendor to which payments will be made.
    • Origination Date: Date from which the loan originates.
    • Original Amount: Full initial amount of the loan.
    • Term: Time it will take to repay the loan in full in weeks, months or years.
      User-added image
  4. Enter the payment information of the loan and click Next.
    • Select the Due Date of Next Payment.
    • Payment Amount: Amount that will be paid each period.
    • Next Payment Number: Only applicable if previous payments have already been made.
    • Escrow Payment Amount: Escrow amount.
    • Escrow Payment Account: Escrow account.
    • (Optional) select Alert me 10 days before a payment is due.
      User-added image
  5. Enter interest information of the loan and click Finish
    • Interest Rate: Enter the interest rate of the loan. For a 5% interest rate, enter “5”(no quotes), rather than “5%” or “0.05”.
    • Compounding period Based on what is specified on your loan documentation.
    • Payment Account: Bank account that you will use to pay the loan.
    • Interest Expense Account: Expense account that will track the interest.
    • Fees/Charges Expense Account: Expense account that will track fees/charges of your loan.
      User-added image
  6. Review the loan information. Click Edit Loan Details if necessary. The loan details you entered show on the Summary tab at the bottom of the Loan Manager.
    User-added image

What if scenarios tool

You can use the What if scenarios tool to view the effects of other payment amounts, repayment period etc.

  1. Click the What If Scenarios button at the bottom of the Loan manager screen.
  2. From the Choose a Scenario drop-down, select either How much will I pay with a new loan? or Evaluate two new loans.
  3. From the Choose a loan drop-down pick a loan to work with.
  4. Enter the loan criteria and click Calculate to view the results.
  5. Click Print to print out the results.
  6. Click OK to close out when you are done.
    User-added image
HOW18995