Set Up a Liability Account for an Amortized Loan
Setting up a loan account in Quicken 2013 requires a few dozen steps, but none of the steps are difficult. And none takes that much time to complete. As long as you have your loan information handy — the loan amount, interest rate, balance, and so on — setting up this type of account is a snap.
Click the Add An Account button.
The Add An Account button appears in the lower-left corner of the Accounts bar.
Tell Quicken you want to set up a loan account.
When Quicken displays the Add Account dialog box, click Loan and then Manual Account Setup. Quicken displays the Loan Details dialog box.
Name and classify the loan account.
Use the Name of This Loan in Quicken text box to give the loan a name. And please be clever here. Then, use the Loan Type drop-down list box to classify the loan by selecting a loan type (such as auto loan, consumer loan, or commercial loan) from the list.
Enter the date that you borrowed the money in the Opening Date text box; or, if your loan has a grace period (like a student loan), enter the date when your loan enters the repayment period.
Quicken needs to know this date so that it can calculate the interest the loan started to accrue when you borrowed the money. The program suggests the current system date as the Opening Date, but this is probably wrong.
Enter the original loan balance.
Enter the original loan amount into the Original Balance text box. You can get this amount, if you’re unsure, from the original loan documents.
Specify the interest rate.
Enter the loan’s interest rate into the Current Interest Rate text box. The loan interest rate, by the way, isn’t the same thing as the APR, or annual percentage rate. You want to enter the actual interest rate used to calculate your payments. Enter the interest rate as a decimal amount.
For example, don’t type 7-5/8; instead, type 7.625. You should be able to get this rate from the lender or the prospective lender.
Enter the loan term in years in the Original Length text box.
If you set up a 30-year mortgage, for example, type 30. You may have to perform one tiny trick when entering this figure: If you set up a loan that includes a balloon payment, enter the number of years over which the loan will be fully paid — not the number of years used for calculating the loan payment.
For example, loan payments may be calculated based on a 30-year term, but the loan may require a balloon payment at the end of 7 years. In that case, type 7 in the Original Length text box.
Indicate how often the bank calculates loan interest.
Use the Compounding Period text box to specify how often the bank calculates interest on the loan. The interest-compounding period usually equals the payment period.
Describe how often you make a loan payment by using the Payment Schedule drop-down list box.
If you make regular monthly payments, for example, select Monthly from the Payment Schedule drop-down list box. If you can’t find an entry in the Payment Schedule drop-down list box that describes how often you make payments, select the Other Period list entry and then type the number of payments you make each year in the Payments Per Year text box.
Note that the Payments Per Year text box doesn’t appear unless you select Other Period.
Enter the Current Balance if you’ve made any payments.
If you’ve already made payments on the loan, specify how much you still owe on the loan after making the last payment by using the Current Balance text box. If you don’t know the current balance, call the lender and ask for it. If you haven’t made any payments yet, skip to Step 11.
Correct the calculated payment amount (if necessary).
After you enter the loan information discussed in the preceding steps, Quicken calculates the loan payment by using the loan balance, term, and interest rate you entered.
In most cases, the calculated payment should be right. But if the calculated payment is wrong, say due to a rounding error or because your loan includes a balloon payment, enter the correct loan principal and interest amount into the Regular Payment text box.
Confirm that the Quicken calculations make sense and then click Next. Quicken displays the second Loan Details dialog box.
Verify the principal and interest payment calculated by the program.
If it’s wrong, you can keep going, but there's a minor yet annoying problem. You probably entered one of the loan calculation inputs incorrectly, such as the loan balance, loan term, or the interest rate. Fortunately, these errors are only a minor bummer.
(Optional) Indicate any amounts you pay besides principal and
If your lender requires you to add a little extra to the payment — such as for insurance, say, or for property taxes — enter that amount into the Other text box. If you want, you can also enter an extra principal payment into the Extra Principal Paid text box.
Set up a loan reminder.
To help you remember your loan payments — hey, nobody likes late payment fees — Quicken lets you schedule reminder messages using the Loan Payment Reminder dialog box.
To set up such a reminder, enter the lender name into the Pay To text box and the next payment date into the Due Next On text box, and then select the bank account you’ll use to make the payment from the From Account drop-down list box.
Describe the transaction splits.
You can split transactions into multiple categories for loan payments, too. If you want to split a loan payment, click the Split link in the Loan Payment Reminder dialog box and then the Split button in the little message box that Quicken displays.
Quicken displays the Split Transaction dialog box, which you can use to describe any additional amounts the lender requires you to pay. In the case of a mortgage, for example, you may be required to pay property taxes or private mortgage insurance. After you enter the information and click Adjust and then OK twice, Quicken calculates the full payment and redisplays the Loan Payment Reminder dialog box.
Tag or add a memo description to the loan payment transaction.
If you click the Tag or Memo link on the Loan Payment Reminder dialog box, Quicken displays a little message box you can use to add a tag or memo.
(Optional) Fine-tune the way the reminder works.
If you want, you can click the Optional Settings link to get to other links that let you specify things like how many days in advance you want to be reminded. How these optional reminder settings work requires no lengthy explanation. If you’re interested, just click around a bit and do a little experimenting.
Click Done twice.
Quicken adds the new loan payment to your financial records, along with the payment details and any reminder message settings you set up.