time period drop-downs

arckon's Avatar

arckon

27 Oct, 2019 01:59 PM

My subject may seem a little vague--not sure how to put it simply. I'm looking for a way, possibly in the provided drop down menus, to select transactions or summaries of "last/previous <period> to date", especially for the year. E.g.: Jan 1, 2018 o Oct 27, 2018. Currently available are only "this <period>" and "last <period>" and "<period> to date". This would be helpful in comparing year to year expenses in progress.

  1. Support Staff 1 Posted by Maddy on 30 Oct, 2019 11:47 AM

    Maddy's Avatar

    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. 2 Posted by arckon on 30 Oct, 2019 03:49 PM

    arckon's Avatar

    Maddy--    Thanks for working out a solution, but it looks too involved for the quick comparisons I wanted to make.  I'm surprised that this isn't a menu item, since I've seen it on the accounting software.Thanks and regards,Leonard Williams

Reply to this discussion

Internal reply

Formatting help / Preview (switch to plain text) No formatting (switch to Markdown)

Attaching KB article:

»

Attached Files

You can attach files up to 10MB

If you don't have an account yet, we need to confirm you're human and not a machine trying to post spam.

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