• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL

Chapter 17. Recording Liabilities > Using the QuickBooks Loan Manager

Using the QuickBooks Loan Manager

Entering loan payments is a simple process when you use the Loan Manager that comes with your QuickBooks program. Enter basic information about your loan, including the starting date, interest rate, number of payments you will make, and amount you will pay; QuickBooks takes care of calculating how much of each payment is principal and interest. When it's time to make a payment, open the Loan Manager and click the Set Up Payment button to initiate a payment with the interest and principal recorded correctly.

Use the QuickBooks Loan Manager

Select Loan Manager from the Banking menu.

Click the Add A Loan button.

Calculating Interest

Interest is calculated based on an annual interest rate, and the interest is calculated either as simple interest or compound interest.

For simple interest, you multiply the loan amount by the annual interest rate and then divide the interest by 12 to arrive at a monthly interest rate.

For compound interest, the principal balance on which the interest is calculated is reduced each time a payment is made. The amount of interest changes with each payment since the interest is recalculated on a constantly changing loan balance.

Fortunately, loan calculators are available on the Internet that enable you to experiment with borrowing scenarios, and these calculators compute the interest for you. Even better, you can use the QuickBooks Loan Manager to calculate compound interest and show you how much of each payment represents principal and interest.

A number of calculators are available on the Intuit website. Here is the link:


Enter the liability account where the loan balance is recorded.

Enter the name of the lender.

Enter the date on which the loan was initiated.

Enter the principal balance.

Enter the number of payments you will make.

Enter the frequency with which you will make payments.

Click Next.

Enter the due date of the next payment.

Enter the payment amount.

Enter the number of the next payment.

Enter the payment frequency.

Enter escrow payment information if applicable.

Did You Know?

Escrow payments increase the amount of the loan payments. Mortgages are the most common type of loan that include escrow payments. Escrow payments are payments made to a separate fund that is held by the lending institution and used to pay such items as property taxes and insurance.

Check here if you want a 10-day advance warning of the payment due date.

Click Next.

Enter the interest rate.

Enter the frequency with which interest is compounded.

Did You Know?

QuickBooks offers only two compounding options. When entering the compounding period, your only choices are Monthly and Exact Days. Monthly interest is calculated and compounded once each month. A lender that uses the Exact Days method compounds interest daily, based on either 360 or 365 days in an annual cycle.

Enter the account from which payments will be drawn.

Enter the account in which interest expense should be recorded.

Enter the account in which any bank fees or service charges should be recorded.

Click Finish.

Click the Payment Schedule tab to see a detailed list of how your payments will be recorded.

Click Set Up Payment to open the check window and issue a payment for this loan. QuickBooks fills out the check with the proper interest and principal disbursement.

Return to the Loan Manager and click Set Up Payment each time you are required to make a payment on the loan. Thus, interest is calculated correctly and your loan balance is reduced according to your repayment schedule.



Not a subscriber?

Start A Free Trial

  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint