How do I set up Bill Reminder for Mortgage Payment without Escrow being an additional Principal?

TXShooter Member ✭✭✭
How do I set up Bill Reminders so that the Escrow Transfer is not counted as Additional Principal, which unrealistically shortens the length of the Mortgage and completely blows up my Projected Balances?

There appears to be a serious flaw in how QWD2020 deals with mortgage reminders. Any line entry other than a simple Principal and Interest somehow automatically gets applied as though it were Extra Principal. When that happens, there's no way to truly forecast budgets and Projected Balances.

How do I make this work so that I can effectively and accurately calculate my financial needs when I retire?

Is this a bug, or am I doing something wrong?

Best Answers


  • TXShooter
    TXShooter Member ✭✭✭
    Thank you, @Sherlock.
    Your solution solved both questions I have asked on this topic; this one and this other one.

    I ended up having to completely delete the mortgage loan and any lingering Bill Reminders for that amount, and recreate it. I followed your directions above and both the one-year projection of the checking account and the Projected Balances line up to the penny. I now have confidence that the next 20/30 years can be forecast with better accuracy.

    Another question:
    When making future adjustments to the [Escrow Account] transfer, should I make them in the Monthly Payment of the Loan (edit), or should I make them in Bill Reminders?

    Again, thank you.
This discussion has been closed.