Quicken Community is moving to Single Sign On! Starting 1/22/21, you'll sign in to the community with your Quicken ID. For more information: http://bit.ly/CommunitySSO
Automatic Principal / Interest Split for Loan Payments

Is there a way to make Quicken for Mac automatically calculate interest paid on a bank-synced auto loan?
SCENARIO
I have a Checking account and an Auto Loan account, both of which sync automatically from the same bank. Each month the Checking account shows a payment with a matching payment in the Auto Loan account and the Auto Loan balance accurately reflects the new principal balance. Quicken shows the Checking payment, categorized as a generic "Credit Card Payment", and the Auto Loan account shows a payment for a lesser amount (difference between principal and interest), making the Auto Loan balance correct in Quicken, but the interest is untracked on a monthly basis.
QUESTION
Is there a way to make these automatic synced transaction show up as a transfer to the Auto Loan with a split automatically capturing the interest paid on a monthly basis?
SCENARIO
I have a Checking account and an Auto Loan account, both of which sync automatically from the same bank. Each month the Checking account shows a payment with a matching payment in the Auto Loan account and the Auto Loan balance accurately reflects the new principal balance. Quicken shows the Checking payment, categorized as a generic "Credit Card Payment", and the Auto Loan account shows a payment for a lesser amount (difference between principal and interest), making the Auto Loan balance correct in Quicken, but the interest is untracked on a monthly basis.
QUESTION
Is there a way to make these automatic synced transaction show up as a transfer to the Auto Loan with a split automatically capturing the interest paid on a monthly basis?
Tagged:
0
This discussion has been closed.
Answers
Yes, you will want a split transaction for both the Loan and CC to correctly reflect the interest charges in both accounts.
I don't know if you have your auto loan setup as an amortized loan. In those settings, you can have it create the detailed split if desired, and the download will match to that. But, that isn't required if you are willing to manually enter the various P&I amounts.
You won't be able to have it auto-calculate interest for the CC payment if you pay one. You would have to manually enter those respective child lines into the split.
More details are needed.
1. There are two accounts: a Checking and an Auto Loan.
2. The Auto Loan account in Quicken is setup as a Line of Credit because that is the only configuration available when setting up online sync.
3. All transactions are downloaded upon Online Sync and post to both accounts. The checking shows the correct full payment amount, HOWEVER the Auto Loan (Line of Credit) shows an entry for only the principal with a new correct balance owed. The interest disappears into the ether unless I manually create a split on the checking debit entry.
4. The bank’s website shows the full payment amount in both the checking and loan accounts.
5. This morning I tried again to manually build an Auto Loan type account, but when I try to sync with the institution, Quicken only gives the option as a Line of Credit. I have also tried on a new virgin Quicken file, but get the same results.
My goal is to automatically record interest paid each month into an interest category without manual intervention. OR better somehow force Quicken to allow an Auto Loan type account to be synced with the bank.
Now running Quicken Windows Subscription, Home & Business
Retired "Certified Information Systems Auditor" & Bank Audit VP
@volvogirl, there is no transfer, the checking entry it’s simply logged against the Auto Payment category used in my budget. The transfer column is empty. Both the checking and the auto loan (line of credit) entries are stand-alone.
Thanks for everybody’s input on this.