Reconcile date for accounts

RJron's Avatar

RJron

21 May, 2021 04:29 PM

Hi,

I reconcile all my accounts each month with the statements ( bank / credit / others ) sent to me. Moneydance already has an option to reconcile statements - but it :

- does not provide for a date to be entered
- does not provide a list of accounts with last reconciled dates

Reconciling and knowing which ones are not done is an important factor to stay on top of your finances - and no easy way to find out in Moneydance. Please could you include the option to include this ?

Simplest is perhaps to add a report item that would provide:

 - Report of all accounts and their last reconciled date AND values. Provide the option to add specific type of accounts (ALL/Bank/cards/Assett/Liability etc )

 - Report of all accounts UN-reconciled accounts in the last 01 month ( or XX months ). Provide the option to add specific type of accounts (ALL/Bank/cards/Assett/Liability etc )

Would appreciate if this can be considered

  1. 1 Posted by mhoggie on 21 May, 2021 05:45 PM

    mhoggie's Avatar

    just a user,

    You can create that report for yourself using Tags.
    Just add a Tag to the last transaction when you reconcile. (For instance, R, or Reconciled, etc)
    Then run the the "Income and Expenses, Detailed " report set to All dates, All Accounts, all Categories, and Filter by your TAG name. You will get a report that shows the Date and Account for those transactions you marked.

  2. 2 Posted by RJron on 21 May, 2021 06:34 PM

    RJron's Avatar

    Thanks mhoggie - this might work as a temp solution i suppose.

    Whilst giving this a try - i notice that several of my entries contain tags that were entered by mistakes. Almost all of them were entered during split transactions and in the wrong field. I need to find a way to clear those tags out first now.

    The list is quite big and is freezing up. I tried editing some transactions in the hope that it would remove them from the list - but it looks like the tags remain and are not removed (?)

    From a more long term and proper fix - I belive this is a feature that need to be added - and can be added quite easily perhaps.

    PS. Just seen a new update - version 2021.1 build 3069 ( I was on build 3066 ). Will update asap

  3. 3 Posted by Stuart Beesley ... on 21 May, 2021 06:38 PM

    Stuart Beesley (Mr Toolbox)'s Avatar

    The find and replace extension can help you find and edit tags..

  4. 4 Posted by RJron on 21 May, 2021 06:49 PM

    RJron's Avatar

    Thanks Stuart. I sure will try this soon..

  5. 5 Posted by RJron on 21 May, 2021 07:12 PM

    RJron's Avatar

    Removed all old tags using FIND & REPLACE extension. However, they seem to (somehow) still be tagged to the specific Income/Expenses-Detailed report selection. I have managed to deselect them - run a report - and now they are gone. Just FYI - as something wrong in that behaviour.

    Will temporarily try and work with the 'RECONCILED MMM-YY' tag - which I should remove as well i guess.

    Appreciate your assistance with the suggestions - mhoggie and Stuart.

  6. 6 Posted by mhoggie on 21 May, 2021 08:37 PM

    mhoggie's Avatar

    just a user,

    Remember you will need to use just a single name for your Reconcile Tag that will be the same on all accounts. So you only have to filter the report for that single name and memorize the report for regular usage.

  7. 7 Posted by RJron on 22 May, 2021 11:40 AM

    RJron's Avatar

    hmm.. the report i need is for the ones that are NOT reconciled - so I can go ahead and reconcile them. Dont think that is possible here ?

  8. 8 Posted by mhoggie on 22 May, 2021 01:47 PM

    mhoggie's Avatar

    just a user,

    My thought is that at some point all of your accounts have been reconciled at some point. Probably when you initially set them up. I have some accounts with very little activity so I'm not concerned if they get reconciled frequently. Others I always want to reconcile at least monthly. Since most services offer an email notice when a statement is available I usually use that as a notice to reconcile. If you add a tag by default when you first set up an account in MD and every time you reconcile, then you'll have a history of reconcile activity you can manage.

  9. 9 Posted by RJron on 22 May, 2021 01:51 PM

    RJron's Avatar

    yes - the monthly email service is also what prompts me to reconcile. But these are usually for bank accounts and credit cards only. However, I use the same practice to also reconcile deposits, investments, certain cash statements only, etc. But yes.. it is a temp workaround for now i suppose.. but the report of unreconciled items would be the right way to go I'm sure you will agree

  10. 10 Posted by mhoggie on 22 May, 2021 03:13 PM

    mhoggie's Avatar

    just a user,

    Yeah, that would be a nice feature to see on the main screen. Just a number of reconciled transactions listed by each account on the left panel, then clickable to show the listing. There are a couple of built in ways to look for uncleared transactions, Transaction Filter Report and edit-Advanced Search. But I find the uncleared filter does not seem to work accurately for some reason. Yet the Find and Replace Extension does seem function accurately and you can copy and paste the output to a spreadsheet.

  11. System closed this discussion on 21 Aug, 2021 03: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