Articles about Loans---Fixing Quicken Loan Calculation Errors

Menu

Home

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

Fixing Quicken Loan Calculation Errors

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

Understanding the problem

When the ending balance that Quicken shows is incorrect, it simply means that Quicken 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 Balance button at the top of the loan account register window. Quicken then displays the Update Account Balances dialog box.

Fixing the principal balance error

To adjust, or correct, the loan balance, enter the correct ending balance in the Update Balance To box and the ending balance date in the Adjustment 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

Debt consolidation loans - Secrets revealed Sometimes you tend to get into the downward spiral of debt and there seems to be no ending. You feel you are paying too much on your credit cards and loans. You get aggravated because you are unable to find any solution to your loan problems.... ...read more

Loans from Credit Card Banks As opposite to what used to happen in the old days, business loans are now available not only for commercial companies, but also for self employed people. In fact, this last group seems to take the most advantage from this kind of loan, as... ...read more

No Credit Car Loans - Car Loan Approval With No Credit History Getting an approval for a car loan when you have no credit history can often times be almost as difficult as getting a car loan approved when you have bad credit. There are things that can be done, however, which will improve your chances of... ...read more

Secured business loans: before you take that big business leap Business loans form a significant part of lending industry. With so many people applying for business loans, you must be wondering how many of them actually get them. The increase in amount of business loan every year shows the swelling... ...read more

Unsecured Loan - Helping you get all you desire You have been delaying your holiday plan or plan to buy your dream car just because you don't have the funds to finance it. What will you do now? Keep on postponing your plans or look for a better option. Definitely, you will look for a better... ...read more