I am running:
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?
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 2 months ago
NotACPA, SuperUser
-
326,864 Points
-
166 Points
See the attached Loan Details page.
Tom Young, SuperUser
-
7,166 Points
I just tried entering your loan information and everything check out except that I and got a different monthly payment amount ($2,517.69) and a full 180 months of payments.
-
166 Points
The delta ($759.39) is coming from extra amounts that are addressing escrow dollars for Taxes and Insurance.
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?
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?
(Edited)
NotACPA, SuperUser
-
326,864 Points
NotACPA, SuperUser
-
326,864 Points
The 3rd line of that payment split MUST be a transfer to the mortgage loan account ... even if that line is $0, it must be present.
Then, your escrow amount would be on the 4th line.
It's a quirk in Q.
Then, your escrow amount would be on the 4th line.
It's a quirk in Q.
-
166 Points
I'm not sure that I am following....
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.
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.
(Edited)
NotACPA, SuperUser
-
326,714 Points
Here's the REQUIRED order of items in your payment split.
- 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
I figured it out.
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.
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.
(Edited)
NotACPA, SuperUser
-
325,510 Points
Well, CONGRATULATIONS! You figured out what I told you 3 hours ago.
