Loans in Income and Expenses Graph

pbuchta's Avatar

pbuchta

24 Aug, 2021 02:30 PM

Whe editing the I&E graphs Loans does not show up as one of the selected categories in the Available Items column. When editing the I&E reports Loans does show up correctly.

  1. Support Staff 1 Posted by Maddy on 30 Aug, 2021 10:53 AM

    Maddy's Avatar

    Hi,

    We are sorry to hear about the problem you have encountered.

    Which version and build of Moneydance are you using?
    To check, open Moneydance and select Moneydance --> About Moneydance, where the version and build number will be displayed.

    Please can you navigate to Tools->Graphs and Reports->select the Income and Expenses graph and send us a screenshot of the resulting window?

    Please, can you send us a screenshot of what you're seeing.
    You can read instructions for taking a screenshot here:

    https://www.take-a-screenshot.org/

    Thank you

    --
    Maddy, Infinite Kind Support

  2. 2 Posted by pbuchta on 30 Aug, 2021 03:11 PM

    pbuchta's Avatar

    Howdy,

    Please find screenshots of the following:

    MD version info
    I&E graph dialog box
    I&E report dialog box

    Note that there is no selection on the I&E graph dialog box to select Loans. Therefore when producing the I&E graph, it fails to take into account the loan payment for each month.

    On a separate matter, the 2020 budgets do not allow you to select categories or accounts for budgeting. It takes everything and lumps it together. This is problematic for me when dealing with IRA withdrawals since I use two categories, one for each account to track a single transaction. Withdrawals from IRA is kept with the IRA and retirement capital accounts and IRA Income is kept as income with the I&E accounts. This way I can accurately determine my monthly budget using the report section. Unfortunately I cannot use the newer budget section that you have of budget tracking to do so. In the current scenario the income and expense cancel each other out even though they are from two different types of accounts. One being a capital account and the other referring to the I&E accounts.

    Thanks for your time and attention, and helping all of your customers out. Please let me know if you need anything further.

    Best,

    Pete

    Pete Buchta, CTS-D, CTS-I
    35 Oswald Pl
    SI, NY 10309
    t: (718)948-6959
    c: (718)974-6601
    e: [email blocked]

  3. Support Staff 3 Posted by Maddy on 30 Aug, 2021 03:37 PM

    Maddy's Avatar

    Please refer to the first screenshot where it reads Select.
    What happens when you click on it from within Moneydance? Do you have the option to move your Loans account to the list of included items before generating your Income and Expenses graph?

    --
    Maddy, Infinite Kind Support

  4. 4 Posted by pbuchta on 30 Aug, 2021 08:06 PM

    pbuchta's Avatar

    Greetings,

    Negative. There is no Loans listed. There are Liability, but no loans. My car loan isn’t listed in this section in either the graph or reports settings. (PS the Odyssey car loan is a very old listing from 2008, and is not applicable.)

    Pete Buchta, CTS-D, CTS-I
    35 Oswald Pl
    SI, NY 10309
    t: (718)948-6959
    c: (718)974-6601
    e: [email blocked]

  5. 5 Posted by Stuart Beesley ... on 30 Aug, 2021 09:08 PM

    Stuart Beesley (Mr Toolbox)'s Avatar

    I concur... Same for me too. Loans are missing from the Income & Expenses Graph Account Selection Window.

    FYI - The internal code for account selection is below..:

    com.moneydance.apps.md.view.gui.graphtool.IncomeExpenseGraph
    accountFilter.addAllowedType(Account.AccountType.ASSET);
    accountFilter.addAllowedType(Account.AccountType.BANK);
    accountFilter.addAllowedType(Account.AccountType.CREDIT_CARD);
    accountFilter.addAllowedType(Account.AccountType.INVESTMENT);
    accountFilter.addAllowedType(Account.AccountType.LIABILITY);
    

    Whether Loans should or should not be there is a different question...

    (not support, just a fellow user)

  6. 6 Posted by Stuart Beesley ... on 30 Aug, 2021 09:13 PM

    Stuart Beesley (Mr Toolbox)'s Avatar

    By contrast.... For the I&E Report; This has a tick box to include Liability/Loan accounts, and also Loans appear in the Source Accounts selection window..

  7. 7 Posted by pbuchta on 15 Nov, 2021 12:54 AM

    pbuchta's Avatar

    Greetings

    Thanks for adding loans to the Selected Categories window of the Income and Expenses Graph Accounts. Unfortunately, the transactions are still not reflected in the actual graphs totals.

    Thanks,

    Pete

  8. 8 Posted by dwg on 15 Nov, 2021 01:43 AM

    dwg's Avatar

    I'm a fellow user.

    Loan repayments are normally handled by a transfer between a Bank account and a loan account, hence there are a transfer from a Asset to a Liability therefore reducing the asset and decreasing the liability.

    As such this type of transaction is not considered to be an expense i.e. it has no category as part of the transaction rather it has a transfer account.

    Another way of putting it is that income increases your net worth and expenses decrease your net worth, but paying down a loan does not affect you net worth since the decrease in your assets is exactly matched by a decrease in your liabilities, your net position remains unchanged.

  9. 9 Posted by pbuchta on 15 Nov, 2021 02:11 PM

    pbuchta's Avatar

    Hi Fellow User,

    You are 100% correct. My bad. I view the I&E reports in MD like cash flow statements. If you scroll down past the graphic reports to the detailed written reports section MD treats these I&E reports like cash flow statements instead of true I&E reports. Unlike the income and expense statement, the statement of cash flows contains all cash flows, not just revenue and expenses. Cash inflows may include things such as cash from the sale of capital items and proceeds from new loans, while cash outflows can encompass things like principal payments on debt and full cost of new capital assets. This statement reconciles changes in cash from one balance sheet to another.

  10. System closed this discussion on 14 Feb, 2022 02:20 PM.

Comments are currently closed for this discussion. You can start a new one.

Keyboard shortcuts

Generic

? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac