Moneydance 2017 - Graphs and Reports

Creating Graphs and Reports -

The graphing and reporting functions in Moneydance enable you to view your financial data in many different ways. Reports are text based, while graphs are visual representations of your data.

To create a report or graph, go to Tools → Graphs and Reports. This will display a window where you can select the type of report or graph as well as any settings (such as start date, end date, accounts, categories, etc). Once you have selected the graph and entered the settings, click the "Generate" button to display the report or graph.

You can also access graphs and reports from the sidebar. Select the type of report or graph, then select the 'Edit' button towards the top right of the register.

graphs_and_reports_2017.png

Exporting Graphs and Reports -

After generating a graph or report, there will be a "Save" button on the window displaying the results.

  • Clicking this button on a graph window will allow you to save the graph as an image file on your computer.

  • Clicking this button on a report window will allow you to save the data in the report to either an HTML (for use in a web browser), tabdelimited, or comma-delimited file (CSV files, for use in spreadsheet software such as Excel or Numbers). Reports also contain a “Copy to Clipboard” button to more easily transfer data to a spreadsheet.

Memorized Graphs and Reports -

After generating a graph or report, there will be a "Memorize" button on the window displaying the results. Clicking this button will save the settings that were used to generate this graph or report to the list of memorized graphs or reports.

To reproduce a memorized graph or report select the "Memorized Graphs" or "Memorized Reports" entry in the Graphs and Reports window and then choose the name of the memorized graph or report. Links to memorized graphs and reports are also available in the shortcuts section of the Summary, and individual memorized reports can be added to the sidebar by clicking the + button at the bottom of the sidebar.

If you memorize a graph or report with the time period set to something other than "Custom Dates," then the time period applies to the date that the report is generated as opposed to the date on which it was memorized.

Both the Income and Expense and Detailed Income and Expense reports can be used for tax reporting. If you have created income and expense accounts designated as Tax Related and/or created Transaction Tags referencing taxes, you can use these as criteria for generating reports.

Once you have marked income and expense accounts as Tax Related, you can use the “Only Tax Related” filter in the Income and Expense and Detailed Income and Expense reports. This will allow you to produce reports showing all your tax related items for any time period you choose.

Graph Types and Uses -

The following graphs are available in Moneydance -

Account Balance Displays the balance of one account over a certain time period. You can choose whether or not to include the balance of sub-accounts in the graph. This graph can display the balance by day, week, month or year.

Asset Allocation Displays the division of your assets, including securities, cash, and other assets.

Currency History Displays the value of a currency or security (including stocks, mutual funds, etc.) over time relative to any other currency or security. This graph can display the currency or security value grouped by Day, Week, Month or Year.

Expenses Displays a selection of expense categories over a period of time. You can choose to display expenses incurred from all accounts or a subset of accounts. This graph can display expenses grouped by different time periods including Day, Week, Month or Year, can be filtered by tag, and displayed as either a stacked or cumulative graph. You can also limit the graph to display the Top “x” number of expense categories, by spending.

Income Displays a selection of income categories over a period of time. You can choose to display income which passes through all accounts or a subset of accounts. This graph can display income grouped by different time periods including Day, Week, Month or Year, can be filtered by tag, and displayed as either a stacked or cumulative graph. You can also limit the graph to display the Top “x” number of income categories, as sorted by amount of income.

Income and Expenses Displays a graph comparing your income and expenses over a period of your choosing. You can choose to display income and expenses over all accounts or a subset of accounts. This graph can display income and expenses grouped by different time periods including Day, Week, Month or Year, and can be filtered by tag.

Memorized Graphs Displays a list of graphs that you have memorized. Selecting a memorized graph from the list will let you regenerate that graph, using your current data. Date ranges such as "this year" apply to the current year, not to the year in which the graph was memorized.

Net Worth Displays your net worth over a certain time period in terms of a currency of your choice. This graph can be customized to include all accounts or a subset of accounts. This graph can display your net worth grouped by Day, Week, Month or Year.

Report Types and Uses -

The following reports are available in Moneydance -

Account Balances Displays your account balances on a specific date in a currency of your choosing for a specified set of accounts. Settings include the option to display balances for all account types, and the option to also display accounts that have a zero balance.

Asset Allocation Displays the division of your assets, including securities, cash, and other assets, and can be grouped by time period.

Budget Displays your budget performance for any given time period. You can also choose to include categories not defined in your budget, and/or to include items with zero actual and budgeted amounts.

Capital Gains Displays a summary of the transactions used to buy and sell securities and the gains made on those securities.

Cash Flow Displays income earned and expenses incurred for a given time period for all or a sub-set of accounts. This report can be grouped by time period and filtered by tag, and displays the total for each account but not transaction details.

Cash Flow, Detailed Displays the same information as the Cash Flow report, but includes the transaction details.

Cost Basis Displays the cost basis of securities that you currently own. This can be compared to the current value of those securities to determine the success of those investments. Settings include the option to display the cost basis for all securities, for securities under a certain account, or for a specific individual security.

Income and Expenses Displays a summary of your income and expenses. You can specify which income and expense categories to include in the report, as well as the source accounts. This report can be filtered by tag, grouped by a time period, and can be set to include liability/loan accounts.

Income and Expenses, Detailed Same as the Income and Expense report except that it also lists the individual transactions that make up the totals.

Investment Performance A snapshot of how your portfolio is performing based on returns and annual ROI, over any given period of time, for any accounts and/or securities you choose. Ability to display zero balance accounts.

Investment Transactions Displays investment transactions, with numerous subtotalling options.

Memorized Reports Only available using the Tools → Graphs and Reports menu Displays a list of reports that you have memorized (see above for how to memorize a report). Selecting a memorized report from the list will let you regenerate that report, using your current data. Date ranges such as "this year" apply to the current year, not to the year in which the report was memorized.

Missing Checks Displays a list of transactions with numeric check numbers while highlighting any gaps between check numbers.

Net Worth Displays your net worth using the current balance, including transactions with dates in the future, or your cleared balance. You can select which types of accounts contribute to the net worth in this report.

Portfolio Displays a detailed look of your holdings by account and/or security for any given period of time. Ability to display zero balance accounts.

Reconciliation Displays all transactions that need to be reconciled.

Tag Summary Displays a summary of all transactions marked with a particular tag. A sub-set of accounts can be selected, and the report can be grouped by time period.

Transactions Displays transactions for one or all accounts for a specified time period. Settings include the option to include transactions for sub-accounts, filter transactions by tag, display memos, or sub-total the transactions by day, week, month, year, account, payee or check number.

Transaction Filter A highly customizable report. If the “And (Intersection)” box is checked the report will display transactions which meet ALL of the report criteria, if the “Or (Union)” box is checked the report will display transactions which meet ANY of the report criteria.

Transfers Displays the movement of funds between selected accounts, offering filtering by tag and grouping by week, month, quarter, or year.

Transfers, Detailed Similar to Transfers report, but breakdown displays individual transactions instead of just account/category totals

VAT/GST If you use the VAT/GST features in Moneydance, this will display a summary of the VAT/GST-applicable expenses and the total VAT/GST paid for a given time period. The VAT/GST report can be generated for specific categories or for all applicable categories.