What is the proper way to account for Principal and Interest in payments/transfers to a loan?

DashQuark
DashQuark Member ✭✭
in Budgeting and Planning Tools (Windows)

I have tried a few options and think I am missing something, hopefully something simple.

I would like to see my loan payments in the “category by month summary” report. But I can not figure out what combination of split entries are correct.There are just 2 accounts; [Auto Loan] and [Checking]. It seems like it is related to the amount being a transfer and categorized as “Loan Principal”

These are all splits from [Checking]

This one shows the total loan correctly in the report but there is no entry in [Auto Loan]

AD_4nXfCQqfn8yAlDTXWfZWaOruzK2B0S6rzLr8t8TwLDSj0XoUc_p1cJhjKr9TjFwYrrjSlladGVsMqVCdT0kfAIg0HLqqHXKMuvYvsnO976zzfHXZZPk4_hXkRuhhPrXvQuBQSlLHkJfe-zF3BWBtAhvLQQTI?key=RE1SGt_AziuCoXsEN1ogfA

This one properly deducts the principal from the {Auto Loan] but does not show the principal in the report.

AD_4nXcCbtc9ZLJFomb5yURky1CXaD6PCTfgnlMUwBSbBtBOnVqDwo3d-UnWdWnuF3m2ZUBHm1NZAnoQT12I3V_G9492aS4cdGDWu5k804CBFfah9vh6I6m-jK2eGwG6sBUUPtQPmchYmk8Cc-uPgC9lBNWSoZQ?key=RE1SGt_AziuCoXsEN1ogfA

This works but then I have the uncategorized item.

AD_4nXcPuhK3B892p53aaC-JnlnfPNh5yk5M8cVkug-02I03ryaPh0rjhyQKRXe7PM2LwFCsF6eJsckR16neTrm7q4w9sp3TE77Eo7m-TidMrepFDQEU-6iCDBmbxjq5g2fCDmpqp0Zm5MgF6K3hmVEnNjQTh8w?key=RE1SGt_AziuCoXsEN1ogfA

This is the report

AD_4nXf-sShWT3fMG41MEcRgMvkrDKBJg0PRGDF59VOmkqa4N014ilel_TS3EhfTjMa-QdAx8BE4XSMtQ-xn98uzGUYkmnKXz_2CfzTIMxJ5vFIBAmV5PFsmriAvUQLncKuNfHXDVzD70kLFJiqS6VEa6M4Yf1A?key=RE1SGt_AziuCoXsEN1ogfA

This is the Auto Loan account

AD_4nXc2t5BirGilC2FZTFDbpAteoo_6oL6hDIhGH6WXkfFl96VGbaGnwcp39GARrKTwYOdW2_fWuX4htm1GzZ4IimtQvVFuHkxftfX3B05ckUNYiyWLKeCkGkq-GJwGQsCx97R_JkmIbwQCmv_kqsa8O7rVDcc?key=RE1SGt_AziuCoXsEN1ogfA

This is the Checking account

AD_4nXeBjdGNNpFdPkof8nTyPadEFehCu9jOJbx6SML8uaGHlPL-Mi2eXhu9BLnXeTS5T9P8xfOV9-Baut7xF1T_6NKalkXmOaPbqWeqycss2W_I8pHpZeFPyTfUX4CDaiwLuZkqAfxuJbW1yRK-eYmQp5iwwg?key=RE1SGt_AziuCoXsEN1ogfA





Answers

  • NotACPA
    NotACPA Quicken Windows Subscription SuperUser ✭✭✭✭✭

    You should have the actual loans setup in Q as Liability accounts.

    THEN, the principal payment(s) should be shown as transfers to those accounts … which will reduce the amount owed.

    Q's Loan Wizard can set this up for you.

    Q user since February, 1990. DOS Version 4
    Now running Quicken Windows Subscription, Business & Personal
    Retired "Certified Information Systems Auditor" & Bank Audit VP

  • Unknown
    Unknown
    edited October 13
    This content has been removed.
  • DashQuark
    DashQuark Member ✭✭

    Thank you @NotACPA, I tried liability and that did not change the report. The payment still does not show up in the category report. Changing to liability allowed me to change it back to an Auto Loan. It was a generic loan. The Auto Loan setting didn't seem to change the report at all.

  • UKR
    UKR Quicken Windows Subscription SuperUser ✭✭✭✭✭

    As @NotACPA tried to explain, you need to set up the loan payment transaction as a Split transaction in your Checking account.
    Look at your example #3, but only use the first two lines:

    image.png

    This will correctly reduce the outstanding loan balance by the amount of principal paid.
    The interest goes into the Loans:Loan Interest category.

    For budgets and other reports be sure to include the Transfer-To the Auto Loan account in the report as if it was an expense and the report will be OK, without the additional (and unneeded) 3rd and 4th split lines.

  • DashQuark
    DashQuark Member ✭✭

    @UKR Thank you for the information. The principal/interest is handled correctly in the transaction. The only option I see is to do the split in the checking account. The second example is the one you show and does not show up in the report. If I include transfers there are so many that show up and are noise. If I could just include the loan/liability accounts that could work. But, I don't see a way to filter for specific accounts.

    image.png

Categories