Refinancing a mortgage (payoff of existing and creation of the new mortgage)

zrob's Avatar


20 Jun, 2020 05:03 PM

Refinancing a mortgage (payoff of existing and creation of the new mortgage)


I noticed the steps necessary for handling a mortgage refinance are sorely lacking. What I have found in previous discussions are confusing and also include incorrect information.

The steps necessary for the payoff of the existing loan and creation of the new loan should be a part of the knowledgebase.

Can someone from Infinite Kind provide step-by-step instructions for this task?

Thank you in advance for your assistance with this matter.

I hope you are all safe and well during these difficult times.

My best,


  1. 1 Posted by sprimost on 20 Jun, 2020 05:21 PM

    sprimost's Avatar

    From: sprimost (Not IK support)

    I had a similar "quandary" when I found it advantageous to refinance
    (recast) my mortgage. It took me awhile to make sure that everything
    balanced properly, including Net Worth and getting the budget right (see
    other discussion on not being able to include account transfers in
    budget). So as to make it easy for someone in the future, I did document
    what I did. Let me whether it helps.



  2. 2 Posted by zrob on 22 Jun, 2020 03:11 PM

    zrob's Avatar


    Thanks for the tip. I figured out how to handle the payoff of the mortgage. Unfortunately, a new problem cropped up. Moneydance isn't calculating the new mortgage properly.

    I followed the instructions to the letter to create the new Loan account and entered the total amount, number of payments and interest rate correctly. Moneydanec is off by a penny in its monthly payment calculation.

    I looked at the instructions to correct the problem but none of it applies since the basic data is entered correctly. I confirmed the problem using their Mortgage calculation tool. Same issue occurs. Very disappointing.

    I have no interest in manually doing the entries. I'll have to find a replacement app if IK can't come up with a solution.


  3. 3 Posted by sprimost on 22 Jun, 2020 03:59 PM

    sprimost's Avatar

    From: sprimost (not MD support)

    Funny thing...I found that exact same issue when I set up a
    loan...payment off by a penny per month! It is a short term loan so it
    only irritated me for a short-term..... Rounding error in the
    calculation between the Bank's way of doing things and MD trying to
    think the problem of fractional pennies (or other currency beyond 2
    digits, sometimes being irrational numbers!

    I know it is a rounding error somewhere in their calculation, because I
    can see the same (reverse) rounding error from the bank! I would suggest
    that you increase the amount of the loan to adjust the monthly payment
    to the expected payment. Then, decrease the loan amount with a payment
    to the contra account (if you are a stickler for a couple of dollars (as
    in "WITTB--What it takes to balance)). I think what the bank does is to
    adjust the amount when you pay off the loan, or mortgage, but will
    _always_ err to the higher amount, and give you the balance later.

    Glad you got this far.


  4. 4 Posted by zrob on 22 Jun, 2020 05:55 PM

    zrob's Avatar


    It seems like IK should be able to create a solution that accounts for this kind of situation. For example, if put the correct information into the account fields and then manually enter the monthly payment, Moneydance should let me plug in the correct initial principal and interest amounts for that payment. Once those amounts are entered, it should be able to use that as the basis for generating the pattern necessary to create correct amounts on the payments that follow.

    In the end, I adjusted the loan amount by just teensy bit and, when creating the reminder, it listed the correct principal and interest amount. Hopefully, the amounts continue to be correct on-going as I enter payments into the application.

    There is another X factor that Moneydance isn't taking into account in its system. In looking at my records, there is an existing payment of interest only in the listing for the mortgage on my bank's web site. This accounts for the time between paying off the old mortgage and the creating of the new mortgage.

    Moneydance doesn't offer a means to enter it in the loan account. Yet, it is a part of the loan and must be accounted for in the application. It wouldn't surprise me if that also impacts how the bank generated the amortization schedule.

    To account for it, I'm going to have to add that amount into the asset account I created to close out the old mortgage and allocate it to the interest category of the new mortgage. That way, the on-going payments of the new loan account should remain consistent and proper.

    All this brings to mind a question. Will the same issue occur in a different finance app, i.e. Quicken, Banktivity, etc. Since I own several other finance apps, I may throw the loan into one of them and see how they handle it. If it works properly, I may have to jump ship.


  5. System closed this discussion on 21 Sep, 2020 06:00 PM.

Comments are currently closed for this discussion. You can start a new one.

Keyboard shortcuts


? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac