How to enter loan data in Money if the first payment period is not 30 days (130468)


The information in this article applies to:

  • Microsoft Money 2007 Deluxe
  • Microsoft Money 2007 Home & Business
  • Microsoft Money 2007 Premium
  • Microsoft Money Deluxe 2006
  • Microsoft Money Small Business 2006
  • Microsoft Money Premium 2006
  • Microsoft Money Standard 2006
  • Microsoft Money 2005 Premium
  • Microsoft Money 2005 Deluxe
  • Microsoft Money 2005 Small Business
  • Microsoft Money 2005 Standard
  • Microsoft Money 2004 Deluxe
  • Microsoft Money 2004 Premium
  • Microsoft Money 2004 Small Business
  • Microsoft Money 2004 Standard
  • Microsoft Money 2003 Deluxe
  • Microsoft Money 2003 Standard
  • Microsoft Money 2002
  • Microsoft Money 2001
  • Microsoft Money 2000
  • Microsoft Money 2000 Business and Personal
  • Microsoft Money 99
  • Microsoft Money 98
  • Microsoft Money 98 Deluxe Edition
  • Microsoft Money 98 Financial Suite
This article was previously published under Q130468

SUMMARY

When you set up a loan, Microsoft Money calculates the first payment's interest and principal amounts based on a presumed 30-day payment period. Occasionally, the first payment is for a different period of time. If this is the case, interest calculations for the first payment are incorrect.

For example, if you buy a car on March 16 and your first payment is due May 1, Money calculates the interest payment for the first payment based on 30 days rather than the 45-day actual period.

MORE INFORMATION

To enter the correct interest and principal breakdown for the first payment, follow these steps:
  1. From your lending institution, find out the actual breakdown of interest and principal for the first payment.
  2. Enter your first payment normally.
  3. After you enter the payment, select the transaction in the Account Register.
  4. To open the split, press CTRL+S, or click the Split button in the transaction form.
  5. In the Split window, you can adjust the amount of principal and interest.

    Remember that you must make the two amounts add up to the actual amount of the payment.
  6. When you are finished, click Done, and then press ENTER to record the transaction.
Money automatically recalculates future payments based on this change.
Modification Type:MinorLast Reviewed:7/5/2006
Keywords:kbinfo KB130468
©2004 Microsoft Corporation. All rights reserved.