Articles about Loans---Fixing Microsoft Money Loan Calculation Errors

Menu

Home

To View a list of all articles about credit and credit cards click here

Fixing Microsoft Money Loan Calculation Errors

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’s or the bank’s 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—and 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.

Related News:

Other Articles of Interest

A Guide To Quick Loans Online For people looking for a fast and convenient way to pay bills or cover unexpected expenses, online payday loans are a perfect choice. Payday loans are available to anyone who needs quick cash regardless of past credit or bad credit. This makes... ...read more

Face the financial crunch with an all purpose Personal Loan In today's expensive world, no matter how much you earn, your expenses are going to exceed your income, most of the times. Most of us face financial crunch at some point of our life. You might feel disappointed because of lack of resources.... ...read more

Finding the Best Lender for Refinancing a Loan If you're considering refinancing a loan, you might be wondering about which lender would be best for you to get your refinance from. While some people might believe that you have to choose certain lenders to refinance a loan through, there are... ...read more

How to Get Out From Under Too Many Payday Loans Although payday loans are excellent ways to cover for those unexpected bills that pop up in our daily lives at the worst possible times, people can often be sucked in to costly, high interest loans quickly and easily. The best way to counteract... ...read more

How to Obtain a Bad Credit Home Loan or Refinance with Bad Credit Many people believe that if they have a bad credit score, then they cannot get a home loan. However, this is not true, since bad credit home loans are readily available. If you have bad credit and you apply for a home loan, then more emphasis... ...read more