Tips on Moneydance

February 10, 2010 at 6:53 pm 3 comments

How do you set up a 401K
Suppose you have an existing 401K, you can go back and enter the last x number of years of history, but that would be time consuming. Since you do not need to track the buy and sell prices of an asset in the 401K, you can start from scratch using your last statement.

  1. Create an investment account to house your 401K. Enter as the initial value, the value on last date of your statement.
  2. Create and add security to the 401K.
  3. Now, start buying all of the shares listed at the last day of the statement at the prices listed at the last date of the statement. Select the transaction buy and list your account as the category.
  4. When you are finish, you should have a cash value of zero in your account (unless you had cash in their before), because you “purchased” all of the assets listed in your statement.

How do you set up a Mortgage

Mortgages consists of a loan account and an escrow account. When you pay your mortgage, some of the money goes into the escrow account, which is then used to pay off the taxes, insurance, and other fees.

  1. Create an asset account and name it something like “House Escrow”.
  2. Create a loan acount and name it something like “House Mortgage”.
  3. Enter the loan amount into the principle (ex: 250000).
  4. Enter the loan interest rate into the APR (ex: 5.25).
  5. Enter the points on your mortgage into points.
  6. Enter the number of payent per year (probaby12).
  7. Enter the total number of payment for the life of the loan. (ex: A 30 year loan that is paid monthly would be 30 year x 12 month = 360 payments).
  8. Set the interest category. I used the built-in category Bills:Mortgage Interest.
  9. Enter the amount being transferred to the Escrow account monthly. This should be in your mortgage statement.
  10. Set the Escrow account to the escrow account you created earlier.
  11. If you’re lucky, the payment calculated should your payment on your bill. If not, you select the specify payment radio button and enter your payment.
  12. Enter the start date of your loan.
  13. Press OK.
  14. At this point, I am prompted if I want to transfer the amount from another account. Since the loan has been around for a while, I didn’t need to track where the money came from, so I answered No.

What’s the difference between liability and loan?
Loan account is a special type of liability account that allows you to specify the number of payments, APR, escrow account, etc. Generally loan accounts are used to track mortgage and car loans. A liability account can be use for simple debts such as an interest free loan from a family member.


Entry filed under: Uncategorized. Tags: .

The maximum amount of memory on a Dell Inspiron e1505 / 6400 Which version of Linux Mint 8 Helena should I run?

3 Comments Add your own

  • 1. rama rao  |  January 30, 2011 at 8:52 am

    As i have noticed some helpful information here,but i feel i might suggest this kind of blog to my own friends along with friends and family

  • 2. mahesh babu  |  January 30, 2011 at 10:01 am

    while looking thru your blog site,i acquired what knowledge i need,thank you

  • 3.  |  April 16, 2014 at 3:39 am

    I must thank you for the efforts you’ve put in writing this blog.
    I’m hoping to see the same high-grade blog posts from you in the future as
    well. In truth, your creative writing abilities
    has motivated me to get my own blog now 😉


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

Trackback this post  |  Subscribe to the comments via RSS Feed


February 2010
« Apr   Mar »

Most Recent Posts

%d bloggers like this: