Year To Date Comparison Report...
I would like to see a Year to Date comparison report. For example, using the Income & Expense report, if I ran the report today, I would like the the two columns to be 01/01/2018 to 10/28/2018 compared to 01/01/2019 to 10/28/2019. Currently, the closest I can get to this kind of report is to use the Custom Dates of 01/01/2018 to 10/28/2019 and group by year. This shows the entire year of 2018 compared to Year to Date for 2019.
My Quicken 2017 sunsets in April and I'm seriously considering Moneydance but this type of report is very important to me. Thank you.
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
Support Staff 1 Posted by Maddy on 30 Oct, 2019 10:38 AM
Hi,
Thank you for contacting Moneydance support.
Although a report specifically designed for this purpose is not available, you can achieve this with existing reports.
Within the Income and Expense report. You can select a period of several years, and then choose the Group By: Year option.
This will display your categories in columns of those years side by side.
You could use the Group By option in that report for other periods as well, but it's not that optimal for shorter periods.
For example, you could choose to group by month for a period of two years, which would create 24 columns, so you'd likely have to scroll horizontally to compare January from last year with the one from the year before that.
You could adjust the column size, or export to a spreadsheet after hiding the columns.
Within the 24-column type of report, you can drag-n-drop columns, as well. For instance, you could drag the January column from one year, next to the January column of another year and disregard the other columns.
Also, you if you set up Budget Bars to use last year's actual category amounts, you can have a comparison on your summary page for selected time periods (Moneydance's drop-down periods, of which year-to-date/monthly are available) against last year's averages for the categories selected as budget bars.
Finally, please find the steps below:
- Navigate to the Income & Expense report from the left side bar. - Click the 'Edit' button to open the parameters window. - Click the 'Reset' button at the bottom. - Set the Date parameters to Start Date 01/01/2018, End Date 12/31/2019 - Set the 'Group By' option to 'Group By Year'. Above the large box at the bottom, click the 'None' button, then click the 'By Individual' button.
- Select the desired 'category(s)' to generate the report. - Click OK.
To export the report to Excel, use either the 'Copy to clipboard' button and paste it into Excel or use the 'Save' button.
You can then save the report as either HTML or as a delimited file, either of which you can open in Excel. (be sure to retain the relevant file extension when naming the report file).
I hope this information is helpful. Please let me know if you have further questions or need any assistance.
--
Maddy, Infinite Kind Support
2 Posted by goforit1 on 30 Oct, 2019 06:16 PM
Your verbose answer was really of no help at all. The real answer is that Moneydance doesn't have a way to do it the way I want. The work around you gave was pretty much the same work around I had in my question. It doesn't work for me. Would it be possible to add this to the list of improvements for future versions? Please advise. Thank you.
System closed this discussion on 29 Jan, 2020 06:20 PM.