Reconciliation window and selecting transactions to clear

russ.j.mundy's Avatar


14 Nov, 2018 10:44 AM

The reconciliation window where you tick transactions to indicate cleared and appearing on statement has a button to Unselect All. It would be great to have a button to Select All and then unselect the few transactions not to be included.
I have accounts that are statement monthly and that could include more than a hundred transactions to individually select. It would be easier if I could Select All then untick the few to exclude from reconciliation.

  1. 1 Posted by mhoggie on 14 Nov, 2018 12:47 PM

    mhoggie's Avatar

    just a user,

    when you begin the reconciliation, you provide an "as of" date. MD should match up and select all the transactions up to that date before you begin to reconcile.

  2. 2 Posted by dewd on 14 Nov, 2018 02:18 PM

    dewd's Avatar

    That's great @mhoggie but you will have to click on each cleared item. That could mean hundreds of clicks. Select all is the answer.

  3. 3 Posted by mhoggie on 14 Nov, 2018 02:42 PM

    mhoggie's Avatar

    just a user,

    You shouldn't have to manually mark them cleared. As you are reconciling the ones selected are marked as reconciled orange. Then when you click "done", MD changes all the ones that were selected as reconciled and marks them all cleared green. That's how it works for me and I've had months when there were a large quantity to clear. Maybe there is an issue with your MD installation. For a test you might try just marking a dozen as reconciled, then click done and see if they are all marked cleared. If that works, then you may have another issue.

  4. 4 Posted by mhoggie on 14 Nov, 2018 02:45 PM

    mhoggie's Avatar

    also, just a note.

    concerning changing the status of transactions. You can use control click or shift click to select groups of transactions, then right click to batch change the status of all selected.

  5. 5 Posted by russ.j.mundy on 15 Nov, 2018 07:42 AM

    russ.j.mundy's Avatar

    Thanks Hog, but I think you misunderstand. The option to tick and select an As At Date at start of process is only available if you also download data from your Bank feed. For those that manually enter transactions, when the rec process starts, there is no As At Date option, so you have to select each transaction manually to mark as Reconciling. Once all transactions appearing on Statement have been selected, you can click Done and then those selected are automatically tagged as Cleared.
    It would be better if the option to set an As Of Date was available so any transactions Not Cleared with a date prior to the A’s Of Date are automatically tagged as Reconciling. Then the user only has to unstick or tick a few transactions to achieve rec objective.

  6. 6 Posted by cascaddan on 25 Nov, 2018 09:13 AM

    cascaddan's Avatar

    Windows user. Keyboard Quick Shortcuts...
    Click/select a single entry in the list,
    Press Ctrl-A to select all then Spacebar ticks / unticks everything.
    Quick and avoids inadvertent [Select All] button dumping your reconcile into the bit bucket before you're finished.

  7. 7 Posted by dwg on 25 Nov, 2018 10:29 AM

    dwg's Avatar

    I'm a fellow User.

    An approach you can take is while you are in the register to select all uncleared transactions right click and chose the option "Mark as reconciling"

    Then go into the reconcile feature as usual. All the transactions should be marked as reconciling, you can then click on any transaction you want to change the mark to uncleared. Clicking on Done will then mark the reconciling transactions as cleared.

  8. 8 Posted by russ.j.mundy on 25 Nov, 2018 10:36 AM

    russ.j.mundy's Avatar

    Thanks. I discovered that workaround when trying different ways to make life easier. It would be
    better if MD allowed an As At Date to be entered when starting reconciliation so txns prior to that date are
    marked as Reconciling. That is available is you download transactions from your bank, but
    not available if you do everything manually.
    Would be a simple improvement for them to introduce.

    Russ Mundy
    [email blocked]

  9. russ.j.mundy closed this discussion on 26 Nov, 2018 08:44 PM.

Comments are currently closed for this discussion. You can start a new one.

Keyboard shortcuts


? 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

Recent Discussions

24 May, 2024 07:44 PM
24 May, 2024 07:35 PM
24 May, 2024 07:05 PM
24 May, 2024 06:20 PM
24 May, 2024 06:07 PM