QuickBooks Loan Manager- The Way to Set Up It

Last Updated on January 5, 2021 by Editorial Staff

When a loan is repaid in normally fixed payments, this repayment normally includes each compounded interest and essential installments for the duration. As usual, every successive fee is made the interest component gradually decreases and the most important portion increases. The QuickBooks loan manager creates an Amortization schedule at some stage in the loan, showing how much of every payment is applied to a principal, interest, and escrow.

Save Time & Effort
Get help from expert

Get your accounting work done by experienced accountants. Fix all your accounting software errors & problems. Dial our toll-free number +1-888-461-1179 .

Loan manager facilitates calculate interest and payment schedules. Mentioned steps bellow help track your new & existing loans, make payments and run special “what-if” scenarios to compare exclusive loan choices.

How to Set Up QuickBooks Loan Manager

There is only two steps to set up the QuickBooks loan manager. Just follow the below steps:

Step 1: Set Up Account for QuickBooks Loan Manager

Set Up the Vendor, Liability, And Expense Account

At first you need to you need to set the account of liability, expenses, and vendor then you can track the loan with QuickBooks loan manager.

  • Create a dealer for the bank or financial organization issuing the loan, if none already exist
  • Record the preliminary loan amount as an opening balance or as a transaction like a journal entry.
  • Create a dealer for the bank or financial organization issuing the loan, if none already exist
  • Record the preliminary loan amount as an opening balance or as a transaction like a journal entry. make sure to use the loan’s real date. If payments have already been made towards the loan, you want to go into these as checks, payments, or journal entries.
  • Set up a cost kind account for interest payments and fee and charges, if none already exist.

Set Up an Escrow Account

Now you need to set up an escrow account. Those who have no idea about the escrow account then there is a little overview in the below:

Escrow is a selected part of a loan this is held in an account by means of a third party until the situations of the loan are met. An Escrow Account is a QuickBooks Asset Account it tracks the escrow portion of a loan payment. Escrow accounts are usually used to pay taxes and insurance.

  • From the Banking menu, click loan manager.
  • Select add loan.
  • Enter Account information of the loan & select next.
    • Account name: loan Account which you formerly installation.
    • Lender: vendor to which bills may be made.
    • Origination Date: Date from which the loan originates.
    • Original amount: the full initial amount of loan.
    • Term: Time it’s going to take to pay off the loan in full in weeks, months or years
  • Choose the Due Date of next payment.
    • Payment amount: quantity in an effort to be paid every period.
    • Next payment number: only relevant if previous payments have already been made.
    • Escrow payment amount: Escrow amount.
    • Escrow payment Account: Escrow account
    • Choose to Alert me 10 days before a charge is due.
  • Enter interest information of the mortgage and pick out end
    • Interest price: input the hobby charge of the mortgage. For a five% hobby rate, input “five”(no dates), rather than “5%” or “zero.05”.
    • Compounding period based totally on what’s precise in your mortgage documentation.
    • Price Account: financial institution account that you may use to pay the loan.
    • Hobby price Account: cost account so as to track the hobby.
    • Prices/expenses fee Account: price account so one can music fees/costs of your loan.
  • Review of the loan information. choose Edit loan info is necessary. The loan details you entered the show at the precise tab at the bottom of the loan manager.

Step 2: Access Loan with Scenarios Tool

You may use the scenarios tool to view the results of different charge amounts, repayment period, etc.

  • Select the scenarios button at the lowest of the loan manager screen.
  • From the select, scenarios drop-down, select How much will I pay with a brand new loan? or evaluate two new loans.
  • From the select, a loan drop-down selects a loan to work with.
  • Enter the loan criteria & click Calculate to view the results.
  • Select Print to print out the results.
  • When you are done choose good enough to close.

Didn't find your solution?

Don't get stressed out? We are here for help. Find a QuickBooks ProAdvisor or CPAs who can help you get rid of your problem. Dial our toll-free number.

Call us: +1-888-461-1179

unable to resolve problem
How To Use QuickBooks Loan Manager