Enter an Existing Loan
The following instructions are for setting up a loan account with a fixed rate that has been in existence and you have been making payments prior to using Moneydance.
You will need to know the original loan amount, the correct interest rate, the current loan balance, the correct loan payment (principle plus interest), and the additional escrow amount, if any.
First we will setup the loan, including the reminder. Then we will edit the loan to get the correct balance and number of payments remaining.
Setup a new Loan account. From the Menu select Account → New Account → Loan. Click Next.
- When the 'Create Account: Loan' window appears fill in the fields carefully.
- Name the Loan. Call it Home Mortgage or something meaningful to you.
Enter the ORIGINAL amount of the loan. This will calculate a loan payment in the Calculate Payment field which you can read about at the bottom of this article. The original amount is available on your loan disclosure documents or from previous mortgage statement.
Enter the correct interest rate. This will recalculate the loan payment. The loan rate will be available from your annual mortgage statement.
- Payments per year defaults to 12. Change this only if your loan is structured differently.
Enter the number of payments. A 30 year mortgage will have 360 payments. This will recalculate the loan payment and it should be equal to your actual loan payment before any escrow payments, mortgage insurance, or other charges are added. If it is not even close, then some of the above figures you entered are incorrect.
Set the Interest Category to the appropriate category.
Enter the Escrow Payment amount. This recalculates the Payment Amount and it should equal exactly what your payment is each month.
Select the appropriate Escrow Account.
Enter the original first payment due date in the Start Date field. Then click OK
- A window pops up that asks if you would like to transfer this amount of this loan to an account. Answer NO unless you would like to record a deposit of the loan principal into another account.
- Another window will pop up and ask you if you want to create a Reminder. Answer YES.
- You can read more about Loan Reminders towards the start of this article.
Enter the current due date in the First Date field within the Reminder window. This is different from the Start Date entered previously.
- Select Monthly, Choose a Date to be reminded and specify the From Account: field. Leave check number blank, and enter the name of the loan holder in the Payee field.
- Note that the Total Payment, including the escrow amount, is equal to your monthly payment. Then click OK
- The Loan should appear in the Sidebar and on the Summary with the original loan balance.
Select the Loan from the Sidebar and note that the loan information appears in the upper right hand corner. The number of payments remaining is 360.
Select Account → Edit Account from the menu.
- When the 'Account Info: Loan' window appears, select Specify Payment and enter your regular monthly payment amount.
Change the Principal field to match the Current Balance of the loan provided by your mortgage holder. Then click OK.
- A window will appear that asks if you would like to transfer this amount of this loan to an account. Answer NO.
Select the Loan from the Sidebar - it should now display the correct Principal Remaining, # of payments remaining, and the Upcoming Payment should have the correct Principle and Interest amounts, as well as, Escrow amount reflected.
- If you use the Reminder to enter the transaction for your mortgage payment in MD going forward, the correct amortization should be calculated automatically for this loan.