Account Balance Report - Let me select $TODAY

Timppa's Avatar

Timppa

26 Jan, 2026 11:13 PM

Why does the 'Account Balances' report not have an option for 'TODAY'?

Most reports/graphs have the drop down menu, e.g., Month to date, Year to date, Today, All Dates, etc....

I have a memorized account balance report with a subset of my accounts but I need to manually change the date on it every time I open it.

It would be hugely helpful if this report and the other 'snapshot in time' reports offered the option of using $TODAY as the date.

  1. 1 Posted by -Kevin N. on 26 Jan, 2026 11:47 PM

    -Kevin N.'s Avatar

    Hi Timppa,

    It appears that the Account Balances report remembers its prior settings across Moneydance restarts so, until a Date drop-down is implemented or at least as a workaround, you could just use the Account Balances report as-is (without Memorizing it) since it defaults to Today.

    -Kevin N. (not a member of Moneydance support)

  2. 2 Posted by Stuart Beesley ... on 26 Jan, 2026 11:59 PM

    Stuart Beesley (Mr Toolbox)'s Avatar

    Well, it does have a today setting - when you run the report using today's date, then it saves a special "today" flag into it's settings, and when it sees this it reloads today's date.

    To prove this, use toolbox, general tools, reports, you should be able to see the saved settings.

    So, I highly suspect when you created your memorised reports that you weren't running them on today's date? Try this.. load a mem report, in the date field press t button and get to today, then memorise the report and overwrite the report.

    Check settings in toolbox.

    Let us know?

  3. 3 Posted by Stuart Beesley ... on 27 Jan, 2026 12:05 AM

    Stuart Beesley (Mr Toolbox)'s Avatar

    e.g. see settings below:

    Report           ABR
    >> SyncItemType: mem_rpt
    >> Report Genr:  ACCBALANCE_T
    >> Parameter key: balance: current
    >> Parameter key: as_of: today
    >> Parameter key: inc_investment_cash_balances: 1
    >> Parameter key: to_curr_id: GBP
    >> Parameter key: colWidths: default
    >> Parameter key: accounts: <not displayed - but contains 7 accounts>
    >> Parameter key: all_accounts: 0
    >> Parameter key: landscape: 0
    >> Parameter key: inc_zero_balances: 1
    

    note: as_of says today and not the date...

  4. 4 Posted by Timppa on 30 Jan, 2026 01:39 PM

    Timppa's Avatar

    you could just use the Account Balances report as-is

    That doesn't work. For it to be useful to me, I need the option to select a subset of my accounts. So unless I feel like doing that every time I need to be able to memorize the report.

    Try this.. load a mem report, in the date field press t button and get to today, then memorise the report and overwrite the report.

    Check settings in toolbox.

    This actually worked! Thank you. Is that 't' keypress documented somewhere? I wasn't aware you could do that.

  5. 5 Posted by Stuart Beesley ... on 30 Jan, 2026 02:32 PM

    Stuart Beesley (Mr Toolbox)'s Avatar

    FYI. It’s the not t button that made this work. You could equally have just typed today’s date manually, then tab, then save.

    T button just says jump to today rather than typing it.

  6. 6 Posted by -Kevin N. on 30 Jan, 2026 08:19 PM

    -Kevin N.'s Avatar

    Hi Timppa,

    That doesn't work.

    It has been my experience that you could select the desired accounts, and the report would remember those selections 'as-is' without memorizing the report.

    Is that 't' keypress documented somewhere?

    The keyboard shortcuts supported by Moneydance are listed in the following Moneydance KB article: https://infinitekind.tenderapp.com/kb/navigating-moneydance/keyboar...

    -Kevin N. (not a member of Moneydance support)

  7. 7 Posted by Timppa on 07 Feb, 2026 09:30 PM

    Timppa's Avatar

    It has been my experience that you could select the desired accounts, and the report would remember those selections 'as-is' without memorizing the report.

    There are several different reports I have memorized to look at different subsets of accounts.

  8. System closed this discussion on 09 May, 2026 09:40 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