Allow sorting of all columns when reconciling (Check #, Amount, Payee, etc) (51 Votes +5 Merged)

I've been a quicken user for 10 years or more now and I've been waiting for simple features to be put back in that were taken out when reconciling an account.

- display deposits and debits seperatly as they are checked off.  This aids to see where mistakes are and is important when you have a lot of deposits.

- sort by check number while reconciling in the reconcile window.  To do this now you have to leave the window and go to your main window and sort your entire account.  Very awkward.

EDIT:
sort by ANY column - Check #, Amount, Date and Payee

while these are very simple things that were in quicken 2007 mac that were taken out that need to be put back in that i thought would have been put in a long time ago.

Be sure to click the little grey triangle under the VOTE count in the blue banner below, so your vote will count (it may take a moment for your vote to register).
(If it is black, your vote has been registered)

Your VOTE matters!

Tagged:
6
6 votes

Implemented · Last Updated

This functionality has been implemented with the 5.16 release. CTP-645

Comments

  • smayer97
    smayer97 SuperUser, Mac Beta, Canada Beta ✭✭✭✭✭
    edited August 2018
    Another related IDEA to vote on is the ability to track and store prior reconciliation statements/preiods:
    https://getsatisfaction.com/quickencommunity/topics/add-ability-to-track-store-prior-reconciled-stat...

    Be sure to go there, then click VOTE at the top to increase the count and therefore its visibility to the developers.

    (If you find this reply helpful, please be sure to click "Like", so others will know, thanks.)
    Have Questions? Help Guide for Quicken for Mac
    FAQs: Quicken Mac Quicken Windows Quicken Mobile
    Add your VOTE to Quicken for Mac Product Ideas

    Object to Quicken's business model, using up 25% of your screen? Add your vote here:
    Quicken should eliminate the LARGE Ad space when a subscription expires

    (Canadian
    user since '92, STILL using QM2007)
  • smayer97
    smayer97 SuperUser, Mac Beta, Canada Beta ✭✭✭✭✭
    edited August 2018
    As for the above IDEA, I agree wholeheartedly. Having separate totals for reconciled debits and credit makes reconciliation so much easier by being able to track down discrepancies faster.

    And I use sort by cheque # all the time too.
    Have Questions? Help Guide for Quicken for Mac
    FAQs: Quicken Mac Quicken Windows Quicken Mobile
    Add your VOTE to Quicken for Mac Product Ideas

    Object to Quicken's business model, using up 25% of your screen? Add your vote here:
    Quicken should eliminate the LARGE Ad space when a subscription expires

    (Canadian
    user since '92, STILL using QM2007)
  • smayer97
    smayer97 SuperUser, Mac Beta, Canada Beta ✭✭✭✭✭
    edited February 2020
    First item was implemented as of QM2016 v3.5.2 with these additions:
    • NEW: Added payment and deposit columns in the Reconcile register.
    • NEW: Added payment and deposit totals in the reconcile screen.
    What is still missing is the sort by Check # (above) and sort by Payment or Deposit columns (see here: Add Option to Have Debits and Credits Tallied Separately


    Have Questions? Help Guide for Quicken for Mac
    FAQs: Quicken Mac Quicken Windows Quicken Mobile
    Add your VOTE to Quicken for Mac Product Ideas

    Object to Quicken's business model, using up 25% of your screen? Add your vote here:
    Quicken should eliminate the LARGE Ad space when a subscription expires

    (Canadian
    user since '92, STILL using QM2007)
  • smayer97
    smayer97 SuperUser, Mac Beta, Canada Beta ✭✭✭✭✭
    edited August 2018
    If you find this feature helpful, please be sure to click "VOTE" above to increase the count of this post and therefore its visibility to other users and to the developers.
    If you do not click VOTE at the top of the page, your vote will NOT be counted!

    Click "Follow" at the top if you want to receive notifications of any updates to this thread. 
    Have Questions? Help Guide for Quicken for Mac
    FAQs: Quicken Mac Quicken Windows Quicken Mobile
    Add your VOTE to Quicken for Mac Product Ideas

    Object to Quicken's business model, using up 25% of your screen? Add your vote here:
    Quicken should eliminate the LARGE Ad space when a subscription expires

    (Canadian
    user since '92, STILL using QM2007)
  • Unknown
    Unknown Member
    edited August 2018
    I'd like to see the ability to sort on ANY column in the Reconcile window.  In the past, I have used the Check #, Amount, Date and Payee to easily find items.  Not being able to sort on any column makes reconciliation so slow, because I have to hunt for everything.  

    I'd also like to see the ability to use the Space Bar to Clear an item and then advance to the next item.  I used that all the time in Windows to clear items and move down my list.  

    The ability to do these 2 things made reconciling go so much faster.
  • Unknown
    Unknown Member
    edited March 2017
    Glad so many have liked this comment, and right afterwards quicken added the deposit and debits totals back in!   I use it all the time.  Really need the sort by check number in the reconcile window too.   In the new bank statements they don't list checks separately and they are listed in the order they clear.  Being able to sort by check number would help this tremendously!
  • Unknown
    Unknown Member
    edited September 2017
    I wanted to add...

    I know you can sort by check number in the main window, but that doesn't filter out the checks that were written AFTER the period of time you are trying to clear or the cleared checks from previous periods.   It doesn't seem like much, but it is unbelievably helpful when searching for a check that someone didn't cash for a few months or you have checks you have written from multiple check books.

    Even version of quicken that were from more than 10 years ago had this.  It really is an important feature where where only uncleared checks written before the end date of the statement you are clearing appear and sorting them in both date order (like you can now) AND check number.
  • Unknown
    Unknown Member
    edited November 2019

    I'd like to see the ability to sort on ANY column in the Reconcile window.  In the past, I have used the Check #, Amount, Date and Payee to easily find items.  Not being able to sort on any column makes reconciliation so slow, because I have to hunt for everything.  

    I'd also like to see the ability to use the Space Bar to Clear an item and then advance to the next item.  I used that all the time in Windows to clear items and move down my list.  

    The ability to do these 2 things made reconciling go so much faster.

    Totally agree!
  • Unknown
    Unknown Member
    edited November 2019

    I wanted to add...

    I know you can sort by check number in the main window, but that doesn't filter out the checks that were written AFTER the period of time you are trying to clear or the cleared checks from previous periods.   It doesn't seem like much, but it is unbelievably helpful when searching for a check that someone didn't cash for a few months or you have checks you have written from multiple check books.

    Even version of quicken that were from more than 10 years ago had this.  It really is an important feature where where only uncleared checks written before the end date of the statement you are clearing appear and sorting them in both date order (like you can now) AND check number.

    Agree!
  • smayer97
    smayer97 SuperUser, Mac Beta, Canada Beta ✭✭✭✭✭
    edited November 2019

    I'd like to see the ability to sort on ANY column in the Reconcile window.  In the past, I have used the Check #, Amount, Date and Payee to easily find items.  Not being able to sort on any column makes reconciliation so slow, because I have to hunt for everything.  

    I'd also like to see the ability to use the Space Bar to Clear an item and then advance to the next item.  I used that all the time in Windows to clear items and move down my list.  

    The ability to do these 2 things made reconciling go so much faster.

    If you agree with this then you need to click the VOTE button at the top of the page for your vote to be counted. 

    (If you find this reply helpful, please be sure to click "Like", so others will know, thanks.)
    Have Questions? Help Guide for Quicken for Mac
    FAQs: Quicken Mac Quicken Windows Quicken Mobile
    Add your VOTE to Quicken for Mac Product Ideas

    Object to Quicken's business model, using up 25% of your screen? Add your vote here:
    Quicken should eliminate the LARGE Ad space when a subscription expires

    (Canadian
    user since '92, STILL using QM2007)
  • Unknown
    Unknown Member
    edited September 2017
    Yes, please! Would be a huge improvement!
  • I have moved from Quicken for the PC to the on-line MAC 2019 version.  Much of the functionality remains the same, but one feature that I find very annoying is the loss of the ability to sort during reconciliation.  I sort by date, deposit or check number columns during the process.  It makes it much easier for me to reconcile to the statement based on how I entered the transaction.  

    Is there a way to sort that I do not see?  All I see offered is ability to sort by date column.  If not perhaps you can add this to your list of future enhancements. 
  • Quicken Harold
    Quicken Harold Alumni ✭✭✭✭
    Hello Neil. Appreciate your question.

    I have changed this discussion to an Idea so that others can vote on this option to be included in a future version of Quicken. I have tried to replicate the issue and was unsuccessful.

    Appreciate you reaching out to the Community regarding this issue.

    Respectfully,
    ~ Quicken Harold.
    Quicken Harold
    Community Moderator
  • Thank you. 

    I hope this can be implemented.  

    Neil
  • joel cohen
    joel cohen Member ✭✭
    edited July 2019
    reconciliation of the bank account manually... the check number should be able to change from descending to ascending order... This saves about triple the amount of time... You can do this with Quicken Window.... why not on Quicken for Mac????
  • Scott Rose
    Scott Rose Mac Beta Beta
    Yes! We really need this feature!
  • Craig in ER
    Craig in ER Member ✭✭
    I would like to be able to sort by ANY column I add to the Reconciliation Register when I reconcile. As it stands now I can sort only by Date. During reconciliation I like to sort by amount and payee at times. Old Quicken 2007 for Mac used to let you do these sorts. This seems like a simple fix since other registers allow you to sort by many columns.
  • Craig in ER
    Craig in ER Member ✭✭
    I just performed an account reconciliation after updating to Quicken Mac v. 5.17.1 and to my delight I was able to sort data by any column in the reconciliation register. Thanks to Quicken team for adding (or returning) this feature. This makes reconciling much easier (at least for me). BTW I did not see this change listed in any of the Release Notes for this version.
  • Scott Rose
    Scott Rose Mac Beta Beta
    edited July 2020
    Wow, really?! This is great news! I’m not at my Mac right now to test this. Can we now somehow sort incoming deposits together & sort outgoing expenses together?
  • jacobs
    jacobs SuperUser, Mac Beta Beta
    edited July 2020
    @Scott Rose The Reconcile window has separate columns for Payment and Deposit (or Payment and Charge, depending on the type of account) -- so yes, clicking on one of those column headings allows you to see all your inflows and outflows together.

    But… you can't specify a secondary sort. That is, if you click on Deposit, it will sort all your unreconciled deposits in ascending or descending order by amount. You can't separate out the deposits first, and then sort them in date order. If you're reconciling an account with a modest number of transactions, this probably isn't a problem; if you have a very large number of transactions, you might prefer to sort by date and then only look at the transactions with values in the deposit or payment column.
    Quicken Mac Subscription • Quicken user since 1993
This discussion has been closed.