Add Option to Have Debits/Credits Tallied Separately - Reconciliation Quicken Mac (57 Legacy Votes)

smayer97smayer97 SuperUser ✭✭✭✭✭
In QM2007, the reconciliation process tallies cleared charges/debits and payments/credits separately. Many (if not most) FI/Banks provide those numbers separately. Being able to compare these numbers makes it far easier to track down discrepancies.

Also, QM2007 not only tallies these separately, it also lists them separately. Again, this makes it possible to track down discrepancies far easier than having them all listed in one list.

image

At the very least, QMac should add these 2 separate cleared balances (charges/debits vs payments/credits).

Ideally, it should provide the option to provide a 2-column view that lists the charges/debits and payments/credits separately (see QM2007 example above).


(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.)

Click "Follow" at the top if you want to receive notifications of any replies to this thread. 

If you find this reply helpful, please be sure to click "Like", so others will know, thanks.

(Canadian  user since '92, STILL using QM2007)

Have Questions? Check out these FAQs:
1
1 votes

No Status · Last Updated

Comments

  • smayer97smayer97 SuperUser ✭✭✭✭✭
    edited August 2018
    You may want to VOTE for the related feature request to Add ability to track/store Prior Reconciled Statements/periods, here: https://getsatisfaction.com/quickencommunity/topics/add-ability-to-track-store-prior-reconciled-stat...

    Be sure to click on the link above go there, then click VOTE at the top of THAT page 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.)

    If you find this reply helpful, please be sure to click "Like", so others will know, thanks.

    (Canadian  user since '92, STILL using QM2007)

    Have Questions? Check out these FAQs:
  • smayer97smayer97 SuperUser ✭✭✭✭✭
    edited August 2018
    You may want to review and VOTE for other feature requests related to the Transactions Downloading Acceptance and Matching workflow, here: https://getsatisfaction.com/quickencommunity/topics/restore-transactions-downloading-acceptance-and-...

    Start at the top for the first one, then scroll down the reply list for additional related feature requests. Be sure to go to each link separately, 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.)

    If you find this reply helpful, please be sure to click "Like", so others will know, thanks.

    (Canadian  user since '92, STILL using QM2007)

    Have Questions? Check out these FAQs:
  • smayer97smayer97 SuperUser ✭✭✭✭✭
    edited August 2018
    You may want to review and VOTE for other feature requests related to the Transactions Downloading Acceptance and Matching workflow, here: https://getsatisfaction.com/quickencommunity/topics/restore-transactions-downloading-acceptance-and-...

    Start at the top for the first one, then scroll down the reply list for additional related feature requests. Be sure to go to each link separately, 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.)

    If you find this reply helpful, please be sure to click "Like", so others will know, thanks.

    (Canadian  user since '92, STILL using QM2007)

    Have Questions? Check out these FAQs:
  • 102_dar_70102_dar_70 Member
    edited August 2018
    @smayer97,
    I don't see Quicken redesigning the view or placement of data in the reconciliation screen because it's an overlay of the register for which they sort by date unreconciled items to view and reconcile.  This is the trend as much as I don't like it either, this makes it easier for the programmers.  
  • smayer97smayer97 SuperUser ✭✭✭✭✭
    edited December 2016

    @smayer97,
    I don't see Quicken redesigning the view or placement of data in the reconciliation screen because it's an overlay of the register for which they sort by date unreconciled items to view and reconcile.  This is the trend as much as I don't like it either, this makes it easier for the programmers.  

    Not hard to implement optional second view, that pops up based on preference set OR by a button to switch views. Therefore cannot hurt to ask.

    If enough people request it, that could change. Trends can be made to change. So let's not discourage anyone from asking. Especially since the benefit is significant, making the process more accurate, faster, and easier to identify discrepancies.

    Holding back a vote only counts one out, so no opportunity to change anything. Adding a vote provides an opportunity to influence change for something very useful.

    If you find this reply helpful, please be sure to click "Like", so others will know, thanks.

    (Canadian  user since '92, STILL using QM2007)

    Have Questions? Check out these FAQs:
  • smayer97smayer97 SuperUser ✭✭✭✭✭
    edited August 2018
    I also highly recommend that you browse through the IDEAS section of this forum and VOTE for the request of each of the missing features to be added back into Quicken for Mac....to help direct the priorities of the developers.

    To do that, I suggest you read this FAQ on how to filter the IDEAS on this forum to just show the ones for the Mac version, then VOTE to your heart's content:
    https://getsatisfaction.com/quickencommunity/topics/quicken-getsat-faq-how-to-filter-conversations-d...

    The following are some of the many feature requests you will find: and many others.

    Be sure to scroll down the page, as some contain lists of related features. Click on the link to EACH IDEA separately that you are interested in, then click the VOTE button at the top of EACH page that opens up respectively to increase the count and therefore its visibility to the developers.

    If you do not click VOTE at the top of the page of each feature, your vote will NOT be counted for THAT specific feature!


    (If you find this reply helpful, please be sure to click "Like", so others will know, thanks.)

    If you find this reply helpful, please be sure to click "Like", so others will know, thanks.

    (Canadian  user since '92, STILL using QM2007)

    Have Questions? Check out these FAQs:
  • 102_dar_70102_dar_70 Member
    edited August 2018
    Quicken already asked me what features I would like to see added to Quicken. 
  • 102_dar_70102_dar_70 Member
    edited October 2016

    @smayer97,
    I don't see Quicken redesigning the view or placement of data in the reconciliation screen because it's an overlay of the register for which they sort by date unreconciled items to view and reconcile.  This is the trend as much as I don't like it either, this makes it easier for the programmers.  

    I'm not apposed I just know the programming these days is done so it limits maintenance and required programming by utilizing overlays.  Good luck with that one.  Haven't you noticed all functions dealing with the register data looks like the register?
  • smayer97smayer97 SuperUser ✭✭✭✭✭
    edited December 2016

    Quicken already asked me what features I would like to see added to Quicken. 

    that post is for anyone who reads this thread. 

    If you find this reply helpful, please be sure to click "Like", so others will know, thanks.

    (Canadian  user since '92, STILL using QM2007)

    Have Questions? Check out these FAQs:
  • smayer97smayer97 SuperUser ✭✭✭✭✭
    edited December 2016

    I also highly recommend that you browse through the IDEAS section of this forum and VOTE for the request of each of the missing features to be added back into Quicken for Mac....to help direct the priorities of the developers.

    To do that, I suggest you read this FAQ on how to filter the IDEAS on this forum to just show the ones for the Mac version, then VOTE to your heart's content:
    https://getsatisfaction.com/quickencommunity/topics/quicken-getsat-faq-how-to-filter-conversations-d...

    The following are some of the many feature requests you will find:

    and many others.

    Be sure to scroll down the page, as some contain lists of related features. Click on the link to EACH IDEA separately that you are interested in, then click the VOTE button at the top of EACH page that opens up respectively to increase the count and therefore its visibility to the developers.

    If you do not click VOTE at the top of the page of each feature, your vote will NOT be counted for THAT specific feature!


    (If you find this reply helpful, please be sure to click "Like", so others will know, thanks.)
     Here are a couple more to highlight that may be of interest: Be sure to click on the link to EACH IDEA separately that you are interested in, then click the VOTE button at the top of EACH page that opens up respectively to increase the count and therefore its visibility to the developers.

    If you do not click VOTE at the top of the page of each feature, your vote will NOT be counted for THAT specific feature!


    (If you find this reply helpful, please be sure to click "Like", so others will know, thanks.)

    If you find this reply helpful, please be sure to click "Like", so others will know, thanks.

    (Canadian  user since '92, STILL using QM2007)

    Have Questions? Check out these FAQs:
  • Snoopy FCSnoopy FC Member ✭✭✭
    edited August 2018
    For what it's worth, I like the current setup, and I was used to the old separate setup from QM2007. 
    QMac Subscription - iMac - Quicken Mac user since 1995
  • smayer97smayer97 SuperUser ✭✭✭✭✭
    edited December 2016
    Snoopy FC said:

    For what it's worth, I like the current setup, and I was used to the old separate setup from QM2007. 

    This is only a request for the option to choose, not replace the existing presentation. 

    But with the current presentation, it takes more time to track down a discrepancy. Since most statements (if not all) provide a subtotal for debits separate from a subtotal for debits, showing that total + showing a list separating them cuts down the time significantly, especially when there are a lot of transactions in a period.

    Again, only proposing an option to choose.

    If you find this reply helpful, please be sure to click "Like", so others will know, thanks.

    (Canadian  user since '92, STILL using QM2007)

    Have Questions? Check out these FAQs:
  • Snoopy FCSnoopy FC Member ✭✭✭
    edited December 2016
    Snoopy FC said:

    For what it's worth, I like the current setup, and I was used to the old separate setup from QM2007. 

    OK.  I have no problem with allowing the option.  
    QMac Subscription - iMac - Quicken Mac user since 1995
  • 102_dar_70102_dar_70 Member
    edited October 2016
    Snoopy FC said:

    For what it's worth, I like the current setup, and I was used to the old separate setup from QM2007. 

    I understand what your talking about that is how my "bank statement" is laid out which I reconcile to; Deposits including any interest rec'd in one section and  POS, APP, Bankcard, Withdrawals, Transfers, Online Bill pay,  transactions and bank fees in another and physical checks in another.  Some banks do not have this format though.

    On the other hand my account activity "online" is all mixed together in order of date of transaction like Quicken is now.  So those using an automated reconciliation based on a download from their banks may find that format will not work if reconciled that way.  

    The above option would be more convenient, but doubtful anything will change to allow for multiple platforms but you can try.
  • smayer97smayer97 SuperUser ✭✭✭✭✭
    edited December 2016
    Snoopy FC said:

    For what it's worth, I like the current setup, and I was used to the old separate setup from QM2007. 

    So the above has been partially implement as of QM2016 v3.5.2.

    The more I think about this, there is an alternative that would also satisfy this need. Since QM2016 v3.5.2 added:

    • NEW: Added payment and deposit columns in the Reconcile register.

    • NEW: Added payment and deposit totals in the reconcile screen.
    simply being able to sort the reconciliation screen by Payment or Deposit columns would work, as long as such a sort also keeps the transactions in data order within that sort.

    (If you find this reply helpful, please be sure to click "Like", so others will know, thanks.)

    If you find this reply helpful, please be sure to click "Like", so others will know, thanks.

    (Canadian  user since '92, STILL using QM2007)

    Have Questions? Check out these FAQs:
  • smayer97smayer97 SuperUser ✭✭✭✭✭
    edited December 2016
    Snoopy FC said:

    For what it's worth, I like the current setup, and I was used to the old separate setup from QM2007. 

    You can now VOTE for the feature to Add option to Sort Reconciliation Screen by Check # , here: https://getsatisfaction.com/quickencommunity/topics/reconcile-improvements-adding-features-back-in-f...

    Be sure to click on the link above to go there, then click VOTE at the top of THAT page to increase the count and therefore its visibility to the developers.

    If you do not click VOTE at the top of the page of THAT feature, your vote will NOT be counted!

    (If you find this reply helpful, please be sure to click "Like", so others will know, thanks.)

     

    If you find this reply helpful, please be sure to click "Like", so others will know, thanks.

    (Canadian  user since '92, STILL using QM2007)

    Have Questions? Check out these FAQs:
  • 102_dar_70102_dar_70 Member
    edited October 2016
    Snoopy FC said:

    For what it's worth, I like the current setup, and I was used to the old separate setup from QM2007. 

    That already exists in mine!  Also, the two columns are separated by the "clr" column so it's easy to distinguish deposits from payments but they are in date order as it would be if you when online to your bank and looked up your activity there.  It just isn't going to appear in the same format as QM2007 like you want.
    image



  • smayer97smayer97 SuperUser ✭✭✭✭✭
    edited December 2016
    Snoopy FC said:

    For what it's worth, I like the current setup, and I was used to the old separate setup from QM2007. 

    Yes, the Payment and Deposit columns are there, as stated above. 

    The format is less important. What is important is the functionality to see data in useful ways. Since the v3.5.2 release, it is now very close to optimal (I did not look at that version prior to posting this request). 

    Can you sort by any column? If not, what is not there is sorting by Payment OR Deposit column, while preserving a sort by date within that. Are you referring to something else?

    If you find this reply helpful, please be sure to click "Like", so others will know, thanks.

    (Canadian  user since '92, STILL using QM2007)

    Have Questions? Check out these FAQs:
  • 102_dar_70102_dar_70 Member
    edited October 2016
    Snoopy FC said:

    For what it's worth, I like the current setup, and I was used to the old separate setup from QM2007. 

    The only function is a filter on the "Date" column as you can see the directional error in the screen print in my last post, which when you click on it, it switches the date order view (changes oldest date to to the top or to bottom based on the direction of the error). 
  • smayer97smayer97 SuperUser ✭✭✭✭✭
    edited December 2016
    Snoopy FC said:

    For what it's worth, I like the current setup, and I was used to the old separate setup from QM2007. 

    Thx for confirming.

    If you find this reply helpful, please be sure to click "Like", so others will know, thanks.

    (Canadian  user since '92, STILL using QM2007)

    Have Questions? Check out these FAQs:
  • 102_dar_70102_dar_70 Member
    edited October 2016
    Snoopy FC said:

    For what it's worth, I like the current setup, and I was used to the old separate setup from QM2007. 

    But when your not in reconcile and just in the register, if you click on a column header it turns on what looks like a filter but I guess it is  really a "sort" function (A-Z or Z-A) but this is not enabled in reconciliation screen.

    From the "idea" you purposed, I get that you what the ability to separate transactions by listing all deposits (credits) first together at the top lets say and then payments (debits) second after that and then checks (debits) after that type of functionality which  requires a "filter" function where you custom define the criteria in 1,2,3 order by Rows, or maybe they could just pre-program that option so it's just a change in view type.  This could be a nice option for manual reconciliation purposes to match the same order as the bank statement formats it. Online reconciliation I would imagine will need it in date order. 

    :)

     
  • smayer97smayer97 SuperUser ✭✭✭✭✭
    edited December 2016
    Snoopy FC said:

    For what it's worth, I like the current setup, and I was used to the old separate setup from QM2007. 

    Yes, Ideally it would be nice to have the payments/debits and deposits/credits grouped together.

    Just clicking on the Payment or Deposits amounts would only sort them by amounts but would lose the date order. So if there is an easy way to group them in the current view format without losing the date sort order in the same view, that would be great. If not, that would suggest the need for a separate view, such as a button or tab to switch between them.

    If you find this reply helpful, please be sure to click "Like", so others will know, thanks.

    (Canadian  user since '92, STILL using QM2007)

    Have Questions? Check out these FAQs:
  • 102_dar_70102_dar_70 Member
    edited October 2016
    Snoopy FC said:

    For what it's worth, I like the current setup, and I was used to the old separate setup from QM2007. 

    In the "Register" if you click on the "Action" column it sorts Debits and Credits separately and each in date order. I have a separate column for "check" numbers and when I click on that it groups the check transactions together in date or too. 

    Now the "Filter" operation can be programmed so when you clicked on the "action" column it would display a drop down of each type of action you entered into the Action column throughout the register; Debit, Dep, Transfer, check #, APP, withdrawal, etc.  .  Then you could click on say Debits and it would only display Debits and hide the rest and then when you change the filter to "all" , everything returns to the normal view.  This is how a filter really works, what we have now is a "sort" function.  In all cases what is displayed should be in date order by default.

    Currently in Reconcile screen, the only option is to change the date order direction from top to bottom of the register. 

    If full "filter" functionality was programmed into the registers including the reconcile screen, it should provide the flexibility you are looking for.
  • smayer97smayer97 SuperUser ✭✭✭✭✭
    edited December 2016
    Snoopy FC said:

    For what it's worth, I like the current setup, and I was used to the old separate setup from QM2007. 

    Sounds like a great alternative...and avoids an extra view...Thx for the feedback.

    So, bottom is that a good choice for implementing this is adding FILTER functionality to the Reconciliation windows.  +1

    If you find this reply helpful, please be sure to click "Like", so others will know, thanks.

    (Canadian  user since '92, STILL using QM2007)

    Have Questions? Check out these FAQs:
  • 102_dar_70102_dar_70 Member
    edited October 2016
    Snoopy FC said:

    For what it's worth, I like the current setup, and I was used to the old separate setup from QM2007. 

    It's a bit more than just adding the standard filter, but the programmers ott to understand what I described above.
Sign In or Register to comment.