iSnare.com - Free Content Articles Directory
Authors Contents [Advanced Search][Add OpenSearch][Job Search]
Distribute your articles to thousands of article sites for only $2 and below! Read more...

Index  Finances
 

Fixing Microsoft Money Loan Calculation Errors

 
[ Contact the Author] [ Send to a Friend] [ Article Publisher] [Make PDF] [ Print] [ Bookmark & Share]
 
Read our Terms of Service before reprinting this article. The submitter specified above has claimed the rights to this article.
Stephen Nelson

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.

Important NoticeDISCLAIMER: All information, content, and data in this article are sole opinions and/or findings of the individual user or organization that registered and submitted this article at Isnare.com without any fee. The article is strictly for educational or entertainment purposes only and should not be used in any way, implemented or applied without consultation from a professional. We at Isnare.com do not, in anyway, contribute or include our own findings, facts and opinions in any articles presented in this site. Publishing this article does not constitute Isnare.com's support or sponsorship for this article. Isnare.com is an article publishing service. Please read our Terms of Service for more information.

Seattle CPA Stephen L. Nelson is the author of Quicken for Dummies, The Microsoft Money Guide to Personal Finance, and more than 100 other books as well. Nelson holds an MBA in Finance and an MS in taxation. His web site is http://www.stephenlnelson.com
Article Tags: balance [See Dictionary], interest [See Dictionary], loan [See Dictionary]
Got a question about this article? Ask the community!
Article published on December 13, 2005 at Isnare.com
 
Rate this article:

Paying Off Your Credit Card Balances
Submitted by: Stephen Nelson

Ever thought about paying off your credit card balances Maybe you would like to be debt free just to reduce your stress...

Forecasting The Future Value Of Your 403(b)
Submitted by: Stephen Nelson

If you’ve got Microsoft Excel (or just about any other popular spreadsheet program) running on your computer, you can use its FV function to forecast the future value of your 403(b) account...

Calculating Depreciation For Your Investments
Submitted by: Stephen Nelson

Investing in real estate Thinking about buying new equipment for your business...

The Dirty Little Secret: Why Roth-IRA Conversions Usually Don't Make Sense
Submitted by: Stephen Nelson

My multimillionaire client Bill called me the other day He wanted to talk about congress recently loosening the rules about who can convert regular IRA accounts to Roth-IRA accounts...

Tax Tips For Real Estate Investors Using Ira Funds
Submitted by: Stephen Nelson

You’ve seen the advertisements and news articles IRA funds can be used to make real estate investments...

Determining How Much Life Insurance You Need
Submitted by: Stephen Nelson

When considering life insurance, you’re planning and preparing for an event most of us would rather not think about...

When IRAs, 401(k)s, And Other Tax-Sheltered Investments Don’t Make Sense
Submitted by: Stephen Nelson

Every year about this time, people start talking about and considering things like IRA contributions...

Read This If You Can’t Possibly Save Enough For Retirement
Submitted by: Stephen Nelson

It’s relatively easy to save for retirement when you’re still young Five thousand dollars set aside for a new baby grows to an amount that generates over a $100,000 a year in current-day dollars if the money earns 12 percent annually and inflation runs at 3 percent...

How To Avoid Dumb Investment Mistakes
Submitted by: Stephen Nelson

Smart people sometimes make dumb mistakes when it comes to investing Part of the reason for this, I guess, is that most people don’t have the time to learn what they need to know to make good decisions...

A CPA Talks About Buying Life Insurance
Submitted by: Stephen Nelson

Not everyone needs life insurance The first thing to do is make sure you need it...

Choosing And Using Credit Cards
Submitted by: Stephen Nelson

Credit cards are convenient, but they’re also dangerous A lot of people ruin their financial lives by turning the phrase “charge it” into a reflex...

Eight Rules For Buying Insurance Of Any Kind
Submitted by: Stephen Nelson

By following the eight rules explained here, you can save money, and just as important, you can save yourself from making serious mistakes when you shop for and acquire insurance policies...

Free Money For Your Retirement?
Submitted by: Stephen Nelson

It can be more than a little discouraging to start making retirement planning calculations You’ll usually find that to achieve the annual retirement income you want, you need to be saving a lot more than is practical...

Brain-Dead Mutual Fund Selection
Submitted by: Stephen Nelson

About this time every year, the personal finance magazines will perform an annual ritual: Looking at how mutual funds have performed over the past year—and then using that information to suggest which mutual funds you should pick for the coming year...

Microsoft Money Investment Recordkeeping Tricks
Submitted by: Stephen Nelson

Microsoft Money provides powerful investment record-keeping tools for individual investors Unfortunately, once you step beyond investments like stocks, bonds, and mutual funds, the mechanics can get a little tricky...

Bridgend Accountants - The Best Ingredient For Success
Submitted by: Steven Magill

In a company, the accountants are the ones who know how to deal with all the money matters and this is due to the main reason that they are the ones who manage and keep track f the data which concerns the financial status of the company...

Age and Term Life Insurance Rates
Submitted by: Dennis Jarvis

Age is the focus of billions of dollars in our society with people's fixation on youth being pretty apparent...

How Do I Find the Right Health Insurance
Submitted by: Vic Shallow

When you're looking for a good health insurance plan, the first thing is to figure out exactly what your needs are...

Find the Credit Card Stimulus Package For Kill Debt
Submitted by: Funky Zidit

As the recession bites, credit card defaults will be as large as that for many households The last few weeks have to fall by about as effective as many people think...

3 Ways on How to Save Your Credit Account
Submitted by: Tony Francis

It is not uncommon for people to see consumer being forced to kill their credit accounts by declaring bankruptcy...

How to Recover From Credit Identity Theft
Submitted by: Tony Francis

Identity theft, being one of the fastest growing crimes in today's society, is something people should be wary of...

Recovering From Identity Theft: Things to Do
Submitted by: Tony Francis

Credit identity theft is one of the top crimes that pose the biggest threat on your finances and reputation...

Home Loans – Know All the Facts About Home Loan Processing
Submitted by: Jane Molano

Owning a home is the dream of every individual is considered as a lifetime achievement because it needs a huge amount of money...

The Differences Between A Remortgage And Homeowner Loans
Submitted by: Liz Moir

Remortgages and homeowner loans are both only available to homeowners as both require to be secured on an asset and in the case of remortgages and homeowner loans this asset is a residential property...

Home Mortgage Rates – Profit From the Current Low Home Mortgage Rates
Submitted by: Roberta Martin

These are important days for homeowners in Canada If you have been living in your home even a few years, you have almost certainly witnessed a modest rise in the value of your home...

Mortgage Refinancing – Lending a Hand to Canadian Economy
Submitted by: Sandra Ruper

Property and home realty has been an excellent investment in the majority parts of Canada in the last few decades...

Lowest Mortgage Rates – Should I Take Help of a Mortgage Broker to Get Lowest Mortgage Rates
Submitted by: Marcella Costante

For most Canadians, a home is the biggest financial choice they will make in their lifetime Nevertheless, consumers across the nation are likely to analyze dozens of investment potential for their portfolios than to examine their mortgage options...

Mortgage Refinancing – With Mortgage Interest at Their Lowest Canadians Refinancing Like Never Before
Submitted by: John Velazco

Homeowners in Canada are at present refinancing their mortgages at a brisk pace Since January 2009, the Bank of Canada has brought down its overnight lending rate considerably, letting banks as well as mortgage lenders to provide a prime lending rate of 3%...

Mortgage Rates Canada – Employ a Mortgage Broker Get the Best Rates
Submitted by: Thomas Jones

If you are looking out for a Canada mortgage broker or want an idea on how Canadian mortgage rates move...

Best Mortgage Rates – Your Credit Decides the Mortgage Rates You Get
Submitted by: Marie Mardeko

In contrast to what you might believe, you don't deal with your credit in emptiness Your credit performance is tracked by credit bureaus like Equifax Canada and TransUnion of Canada...

Isnare.com Footer Divider

© 2004-2009. Isnare Free Articles - An Isnare Online Technologies Free Articles Project. All Rights Reserved.   Privacy Policy