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.
-
Purchasing and Upgrading
-
Accounts and Categories
-
Register and Transactions
-
Budgeting
-
Online Banking and Bill Pay
-
Moneydance+
-
Reminders
-
Graphs and Reports
-
General
-
Investment Accounts
-
Loan Accounts
-
Syncing and Sharing Data
-
Currency and VAT/GST
-
Backups and Exporting
-
Importing Data from Other Programs
-
Customizing and Preferences
-
File Locations and Changes
-
Foresight
-
Extensions
-
Moneydance 2017
-
Linux
-
Older Versions
-
ARCHIVE - Getting Started
-
ARCHIVE - Moneydance 2017
- Archive - Moneydance 2017 license keys and upgrade policy
- Archive - Upgrading to Moneydance 2017 from Moneydance 2012, 2014 and 2015
- Archive - Upgrading to Moneydance 2017 from Moneydance 2011 or earlier
- Archive - Changing colours and theme in Moneydance 2017
- Archive - Sharing data using the Moneydance 2017 syncing engine
- View all (15 more)
-
ARCHIVE - Moneydance 2014 and 2015
- Archive - Moneydance 2015 license keys and upgrade policy
- Archive - Upgrading to Moneydance 2015 from Moneydance 2012 and 2014
- Archive - Upgrading to Moneydance 2015 from Moneydance 2011 or earlier
- Archive - Opening a backup file in Moneydance 2015
- Archive - How to restore from a checkpoint in Moneydance 2012 and 2014
- View all (3 more)
-
ARCHIVE - Program Basics
-
ARCHIVE - Account Basics
-
ARCHIVE - Entering Transactions
- Archive - Does Moneydance allow for assigning 'classes' to transactions?
- Archive - How do I get the Register to auto fill todays date instead of the last entered date?
- Archive - How do I move a transaction to a different account?
- Archive - How do I enter my Paycheck?
- Archive - How do I create a split transaction?
- View all (2 more)
-
ARCHIVE - Online Banking
-
ARCHIVE - Mobile
- Archive - Syncing Moneydance 2015 with your Mobile Device
- Archive - Syncing Moneydance 2012 and 2014 with your Mobile Device
- Archive - How to sync with Moneydance 2008, 2010, and 2011
- Archive - How do I delete a transaction on the iPhone, iPad, or iPod touch?
- Archive - How to sync one data file with multiple iOS devices using different Dropbox accounts
- View all
-
ARCHIVE - Budgeting and Reminders
- Archive - Creating reminders (automatic repeating transactions or notes)
- Archive - Creating a budget using the 'Newer' format
- Archive - Creating a budget using the 'Mixed Interval' (Older) format
- Archive - What's the difference between a General and Transaction reminder?
- Archive - How do I have a reminder automatically entered into my register?
- View all (1 more)
-
ARCHIVE - International Tools
- Archive - Setting up VAT/GST
- Archive - Can you change the word "Check" to "Cheque" anywhere in the programme?
- Archive - How can I enter the exact amounts on both sides of a foreign currency transfer?
- Archive - My household/country/company uses a fiscal year instead of a calendar year. Can I do this in Moneydance?
- View all
-
ARCHIVE - Investments
- Archive - How do I add Securities to a new Investment Account?
- Archive - How can I import security, stock or mutual fund prices?
- Archive - Entering your current holdings
- Archive - Creating a new investment subtype
- Archive - Downloading security, stock or mutual fund prices from non-US stock exchanges
- View all (5 more)
-
ARCHIVE - Extensions
-
ARCHIVE - Everything Else