Quicken Premier 2016 Release R 12 (25.1.12.2)
Windows 10 Version 1607 OS Build 14393.1198 64-Bit OS / 64-Bit Processor
I created a new mortgage loan and it is manual.
The term is for 15 years with an Open Date of 12/01/2015. I would expect the maturity date to be 12/01/2030, but the Loan Schedule stops at 05/01/2027. It only calculated a total of 137 payments vs. an expected total of 180 payments.
The future principal payment and future interest payment amounts are skewed as the 05/01/2027 maturity date illustrates a zero loan balance and the principal & interest amounts should be calculated with a 12/01/2030 maturity date.
The actual monthly payment amount is correctly reflected in both the Bill Pay section and correctly posts the actual amounts to the loan schedule.
I ran the File>>>File Options>>>Validate and Repair and the log file indicated that there was nothing wrong with the mortgage loan / account or respective transactions.
Why did Quicken only schedule 137 payments and what's the best manner to correct the data?
-
166 Points
- Frustrated
Posted 11 months ago
NotACPA - QW HBRP 2018, SuperUser
-
351,522 Points
Because, the Loan Wizard has ALWAYS worked perfectly for me.
Tom Young, SuperUser
-
15,124 Points
-
166 Points
I navigated to the mortgage loan, selected Payment Details>>>Edit Payment Details button. The payment set-up has the $759.39 being applied as "Extra principal determines the total". See the attachment.
If you look at the split detail in the Bill Pay transaction, the $759.39 is being automatically transferred to the escrow account. See the attachment.
Should the $759.39 be listed / configured in the "Other" section of the Payment Details?


NotACPA - QW HBRP 2018, SuperUser
-
351,522 Points
Because I created an Amortization schedule, in Excel ... and the only way that I could get your "Current Balance" figure was by using Tom Young's payment amount.
Date Prin Int Balance
12/2/2015 $371,000.00
1/1/2016 $1,667.48 $850.21 $369,332.52
2/1/2016 $1,671.30 $846.39 $367,661.22
3/1/2016 $1,675.13 $842.56 $365,986.09
4/1/2016 $1,678.97 $838.72 $364,307.12
5/1/2016 $1,682.82 $834.87 $362,624.30
6/1/2016 $1,686.68 $831.01 $360,937.62
7/1/2016 $1,690.54 $827.15 $359,247.08
8/1/2016 $1,694.42 $823.27 $357,552.66
9/1/2016 $1,698.30 $819.39 $355,854.36
10/1/2016 $1,702.19 $815.50 $354,152.17
11/1/2016 $1,706.09 $811.60 $352,446.08
12/1/2016 $1,710.00 $807.69 $350,736.08
1/1/2017 $1,713.92 $803.77 $349,022.16
2/1/2017 $1,717.85 $799.84 $347,304.31
3/1/2017 $1,721.78 $795.91 $345,582.53
4/1/2017 $1,725.73 $791.96 $343,856.80
5/1/2017 $1,729.68 $788.01 $342,127.12
NotACPA - QW HBRP 2018, SuperUser
-
351,522 Points
Then, your escrow amount would be on the 4th line.
It's a quirk in Q.
smayer97 (QM2007, CDN user since '92), SuperUser
-
246,226 Points
Tom Young, SuperUser
-
15,124 Points
-
166 Points
The the third line of the split transaction is a transfer amount ($759.39) from my checking account to the [AFR - Escrow] Account. The transfer amount is properly getting credited from my checking account and debiting the Escrow Account.
Are you saying that I need to set the dollar amount of line three to $0 and add a line (line 4) to post the [AFR - Escrow] amount?
With regards to the Current Balance figure, the balance figure is correct in my system because the split transaction is posting the correct monthly amortized amount. Quicken is correctly calculating the amortization schedule for payment purposes. For example, it is calculating based upon 180 periods.
The issue is with the future / remaining amortization amount. It is only calculating based upon 137 periods. Payment Details>>>View Payment Schedule. Notice the significant jump in the actual principal paid vs. the next future principal payment. I believe the issue is with rendering the full payment schedule in the User Interface and not in the actual calculation.
See the attachment.


NotACPA - QW HBRP 2018, SuperUser
-
351,462 Points
- A Transfer to the loan account (to reduce principal)
- A payment to the Interest category
- Another Transfer to the Loan account (even if this line is for $0)
- A Transfer to any Escrow account
- Any other payments/transfers/etc.
-
166 Points
After creating the mortgage account via the wizard, I must have navigated to Bills>>>Manage Reminders and manually edited the split transaction window. I manually added the third line, the [AFR - Escrow] Account, to the split transaction.
When I removed the line three and edited the payment details by adding the escrow transfer via the "Other" option. The amortization properly displayed. I guess the payment details reads the dollar amount(s) from the split transaction window and it was assuming any difference as an extra principal payment, which affected the future amortization schedule.
See the new maturity date of 12/2030.



NotACPA - QW HBRP 2018, SuperUser
-
351,462 Points
-
80 Points
Quicken Colin, Alum
-
207,538 Points
This conversation is no longer open for comments or replies.
This conversation is no longer open for comments or replies.
Related Categories
-
Planning Tools - Windows
- 1167 Conversations
- 289 Followers