Home - Mortgage Loans | Personal Loans | Bad Debt Loans | Foreclosure Loans
Apply for a Loan | Best Auto Loans | Best Bad Credit Auto Loans | Best Bad Credit Loans | Best Bill Consolidation Loans | Best Cash Advance Loans | Best Credit Cards | Best Credit Repair Tips | Best Debt Consolidation Loans | Best Free Credit Reporting Tips | Best Home Equity Loans | Best Mortgage Loans | Best Pay Day Loans | Best Personal Loans | Best Products on the Internet | Best Unsecured Loans
Great Financial Advice
Apply for a Loan
Latest Financial News
Rate Lock Advisory
Best Products
Join Our Mailing List
Contact Us
Loan Articles Index
Auto Loans
Bad Credit Auto Loans
Bad Credit Loans
Bill Consolidation Loans
Cash Advance Loans
Credit Cards
Credit Repair Tips
Debt Consolidation Loans
Debt Reduction Loans
Foreclosure Loans
Free Credit Reporting Tips
High Risk Loans
Home Equity Loans
Home Loans
Lawsuit Loans
Mortgage Loans
Pay Day Loans
Personal Loans
Products on the Internet
Real Estate Services
UK loans
Unsecured Loans
Loan Article Index
Loan Articles A-G
Loan Articles H-Q
Loan Articles R-Z
Mortgage Calculators
Mortgage Calculator
Mortgage Amortization Calculator
Rent vs. Buy Calculator
How Much Can I Afford Calculator
Auto Payment Calculator
Click here to Sign up for Email and Newsletter

 

redhotloantips fat loss


Fixing Microsoft Money Loan Calculation Errors

Written by: Stephen L. Nelson, CPA

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.

About the author:

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


Other Related Articles:


Warning: date(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected the timezone 'UTC' for now, but please set date.timezone to select your timezone. in /home/rliu008/public_html/redhotloantips.com/rotator.php on line 7

Warning: date(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected the timezone 'UTC' for now, but please set date.timezone to select your timezone. in /home/rliu008/public_html/redhotloantips.com/rotator.php on line 7
Cash loan offers
There are different types of consumer loans you can apply for. While some consumer loans will give you a cash loan, such as a payday advance loan, other loans will not put cash in your hands but allow you to finance your home or pay your college...read more

Getting A Handle On Your Bills With A Debt Consolidation Loan
If you find yourself overwhelmed in debt, or are considering applying for a mortgage but your debt to income ratio is too high, it may be time to consider a debt consolidation loan. Qualified mortgage companies, such...read more

How To Stretch Your Student Loan
If you're considering going to university, there is a strong chance that you're also contemplating taking out a student loan to fund your university expenses. Student loans don't have to equate to student debt and if you plan your finances, it is...read more


Return to Home

468x60

Best Auto Loans, Best Bad Credit Auto Loans, Best Bad Credit Loans, Best Bill Consolidation Loans, Best Cash Advance Loans, Best Credit Cards, Best Credit Repair Tips, Best Debt Consolidation Loans, Best Debt Reduction Loans, Best Foreclosure Loans, Best Free Credit Reporting Tips, Best High Risk Loans, Best Home Equity Loans, Best Home Loans, Best Lawsuit Loans, Best Mortgage Loans, Best Pay Day Loans, Best Personal Loans, Best Products on the Internet, Best Real Estate Services, Best UK loans, Best Unsecured Loans
Subscribe to Mailing List | Private Policy | Unsubscribe | Site Map