| Home | Free Articles for Your Site | Submit an Article | Advertise | Link to Us | Search | Contact Us |
This site is an archive of old articles

    SEARCH ARTICLES
    Custom Search


vertical line

Article Surfing Archive



Fixing Microsoft Money Loan Calculation Errors - Articles Surfing

It is possible that the breakdown of a payment into principal and interest that Microsoft Money makes will be incorrect. Rounding errors, payment delays, and perhaps even a bug in either Money**or the bank'calculations may mean that the loan balance that Money shows for a loan or mortgage is incorrect.

Understanding the problem

When the ending balance that Money shows is incorrect, it simply means that Money has incorrectly split one or more loan payments between principal and interest. What you need to do, in this case, is adjust the ending balance and categorize the adjustment as falling into the same interest expense category and subcategory as you are using to track the interest component of the loan payment.

To make this sort of adjustment, display the account register for the loan or mortgage that you need to adjust. Then click Update Amount Owed in the list of common tasks. Money then displays the Adjust Loan Balances dialog box.

Fixing the principal balance error

To adjust, or correct, the loan balance, enter the correct ending balance in the New Ending Balance box and the ending balance date in the As Of Date box. You should be able to get this information from the end-of-year or end-of-month loan statement that alerted you to the loan balance error.

Fixing the interest expense error

To fix the interest portion of the loan record-keeping error, enter the interest category and subcategory you used in the Category For Adjustment boxes. For example, if you used Loan as the category and Mortgage Interest as the subcategory, enter this category and subcategory in the two boxes.

While it might seem curious to use the loan interest categories for categorizing an adjustment to the loan balance, remember that loan payments are split between principal and interest. Therefore, if you overstate the principal components of a loan payment, you implicitly understate the interest components*'nd vice versa.

In effect, adjusting the loan ending balance is the same thing as adjusting the cumulative principal payments made on the loan. And that means you need to also adjust cumulative interest payments made on the loan.

Submitted by:

Stephen L. Nelson, CPA



        RELATED SITES






https://articlesurfing.org/computers_and_internet/fixing_microsoft_money_loan_calculation_errors.html

Copyright © 1995 - Photius Coutsoukis (All Rights Reserved).










ARTICLE CATEGORIES

Aging
Arts and Crafts
Auto and Trucks
Automotive
Business
Business and Finance
Cancer Survival
Career
Classifieds
Computers and Internet
Computers and Technology
Cooking
Culture
Education
Education #2
Entertainment
Etiquette
Family
Finances
Food and Drink
Food and Drink B
Gadgets and Gizmos
Gardening
Health
Hobbies
Home Improvement
Home Management
Humor
Internet
Jobs
Kids and Teens
Learning Languages
Leadership
Legal
Legal B
Marketing
Marketing B
Medical Business
Medicines and Remedies
Music and Movies
Online Business
Opinions
Parenting
Parenting B
Pets
Pets and Animals
Poetry
Politics
Politics and Government
Real Estate
Recreation
Recreation and Sports
Science
Self Help
Self Improvement
Short Stories
Site Promotion
Society
Sports
Travel and Leisure
Travel Part B
Web Development
Wellness, Fitness and Diet
World Affairs
Writing
Writing B