Need account register report without split detail

jacobsjacobs SuperUser ✭✭✭✭✭
There is no way to print a simple account register, just as you see it on the screen. The problem is that printing from a register offers only two options in a "Format As" drop-down menu: "Transaction Detail" or "Category Detail". What is needed is a third option: "Transaction Summary" or "Transaction (without splits)".

The problem with the current Transaction Detail is that it shows each split line as a separate line in the report. If you want a report that looks like the transaction register -- without splits -- there is no way to do that currently. There should be an option to suppress split lines. (There is also no other way to create such report using any available options on the Reports menu.)
QMac 2007 & QMac Subscription • Quicken user since 1993
2
2 votes

No Status · Last Updated

Comments

  • smayer97smayer97 SuperUser ✭✭✭✭✭
    edited November 2018
    Yes, there needs to be an option to show split lines or not when printing the register, like it is done in QM2007, as shown here:
    image

    Meanwhile, similar control is needed on other reports, so you may also want to add your VOTE to 
    Create Useful Category/Transaction Detail Report. This includes a report related feature to choose to show/hide split lines, just like QM2007 can, as captured here: Show/Hide Splits in registers and reports.

    First, click on each underlined link above to go there, then click VOTE at the top of THAT page, so your will vote count for THAT feature and increase its visibility to the developers by seeking to have the features you need or desire end up in the latest version.

    While you are at it, you may want to add your VOTE to related IDEAS found on the 
    List of Requests for Downloading Data into Quicken. Click on the underlined link, then follow the instructions to add your vote to more related ideas.

    Meanwhile, I highly recommend you to add your VOTES to related IDEAS found on the: Click on each underlined link, then follow the instructions to add your vote to more related ideas. Your VOTES matter!

    For background, you may want to read this post too. BTW, the columnar-type report is the basis for MANY other reports, as described in detail in this post a little lower; only the selection and formatting criteria are different.

    (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:
  • jacobsjacobs SuperUser ✭✭✭✭✭
    edited November 2018
    I think it's important to note that what's being asked for here is not something that would appear in the Reports section, although it's a report of a sort. What we're talking about here is selecting Print in a register. Whether the developers can use the same logic or report format as something in the Reports menu I'll leave up to the developers to figure out; I'm trying not to make assumptions about that. Again, all that's being asked for here is a single idea: the option to suppress split lines in the existing print register report.

    You point to the thread about Expanding split transactions as being sufficient. @smayer97, I'd note that what the actual title of the thread you link above as "Show/Hide Splits in registers and reports"  is "Expanding split transactions,"  and I am concerned that from the title, the developers might overlook it as an already-implemented suggestion. (Reading through it, almost all of the requests in that thread have been implemented.) I think it is less likely for the developers to re-visit a thread on a topic they feel they've addressed, read through all the many comments, and parse out that there's one aspect of the multi-idea thread that they didn't yet implement; I think it's far easier for them to see a single-idea thread like this and immediately grasp the missing feature. (The other thread you reference, "Create a useful Category/Transaction Detail Report in Quicken For Mac," is also a compendium of many ideas for reports, some of which now have been implemented and some which have not.)

    I also think it's easier for fellow users to find and vote for a single-idea topic like this than pore through all the nuances and cross-links of the other threads. (For what it's worth, this idea was actually brought up by another user, who hadn't found any of the existing threads which touch on this; that reinforced in my mind that this deserved its own idea post.) Finally, users can vote for as many topics as they like, so there's no harm in having this as a stand-alone request; it doesn't take away from any other thread or visa versa.
    QMac 2007 & QMac Subscription • Quicken user since 1993
  • smayer97smayer97 SuperUser ✭✭✭✭✭
    edited November 2018
    jacobs said:

    I think it's important to note that what's being asked for here is not something that would appear in the Reports section, although it's a report of a sort. What we're talking about here is selecting Print in a register. Whether the developers can use the same logic or report format as something in the Reports menu I'll leave up to the developers to figure out; I'm trying not to make assumptions about that. Again, all that's being asked for here is a single idea: the option to suppress split lines in the existing print register report.

    You point to the thread about Expanding split transactions as being sufficient. @smayer97, I'd note that what the actual title of the thread you link above as "Show/Hide Splits in registers and reports"  is "Expanding split transactions,"  and I am concerned that from the title, the developers might overlook it as an already-implemented suggestion. (Reading through it, almost all of the requests in that thread have been implemented.) I think it is less likely for the developers to re-visit a thread on a topic they feel they've addressed, read through all the many comments, and parse out that there's one aspect of the multi-idea thread that they didn't yet implement; I think it's far easier for them to see a single-idea thread like this and immediately grasp the missing feature. (The other thread you reference, "Create a useful Category/Transaction Detail Report in Quicken For Mac," is also a compendium of many ideas for reports, some of which now have been implemented and some which have not.)

    I also think it's easier for fellow users to find and vote for a single-idea topic like this than pore through all the nuances and cross-links of the other threads. (For what it's worth, this idea was actually brought up by another user, who hadn't found any of the existing threads which touch on this; that reinforced in my mind that this deserved its own idea post.) Finally, users can vote for as many topics as they like, so there's no harm in having this as a stand-alone request; it doesn't take away from any other thread or visa versa.

    My opening line..."I don't disagree with the need for control over the format..." 

    So I agree with this need in concept but not as a separate report. That said, if this idea is restricted to the printing of a register, then yes, I agree it should stand alone (it was rather late so that may not have fully sunk in the first time).

    So as I understand it now, this would be like the options in QM2007:
    image

    So I would recommend users vote for this and then also consider voting on the other 2 threads so that there is consistency throughout Quicken to control when split lines show up or not.

    (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 November 2018
    jacobs said:

    I think it's important to note that what's being asked for here is not something that would appear in the Reports section, although it's a report of a sort. What we're talking about here is selecting Print in a register. Whether the developers can use the same logic or report format as something in the Reports menu I'll leave up to the developers to figure out; I'm trying not to make assumptions about that. Again, all that's being asked for here is a single idea: the option to suppress split lines in the existing print register report.

    You point to the thread about Expanding split transactions as being sufficient. @smayer97, I'd note that what the actual title of the thread you link above as "Show/Hide Splits in registers and reports"  is "Expanding split transactions,"  and I am concerned that from the title, the developers might overlook it as an already-implemented suggestion. (Reading through it, almost all of the requests in that thread have been implemented.) I think it is less likely for the developers to re-visit a thread on a topic they feel they've addressed, read through all the many comments, and parse out that there's one aspect of the multi-idea thread that they didn't yet implement; I think it's far easier for them to see a single-idea thread like this and immediately grasp the missing feature. (The other thread you reference, "Create a useful Category/Transaction Detail Report in Quicken For Mac," is also a compendium of many ideas for reports, some of which now have been implemented and some which have not.)

    I also think it's easier for fellow users to find and vote for a single-idea topic like this than pore through all the nuances and cross-links of the other threads. (For what it's worth, this idea was actually brought up by another user, who hadn't found any of the existing threads which touch on this; that reinforced in my mind that this deserved its own idea post.) Finally, users can vote for as many topics as they like, so there's no harm in having this as a stand-alone request; it doesn't take away from any other thread or visa versa.

    And to be clear, I was not disagreeing with the idea...just pointing out that this may be an overlap with an existing idea... I hope you see that is not the same thing.

    I will adjust my previous post above to better reflect that.

    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:
  • jacobsjacobs SuperUser ✭✭✭✭✭
    edited January 13
    Thanks for editing your original language to reflect that it may be an overlap in idea requests,  but that there's no reason not to implement this idea.

    Just to clarify what I think this would look like in Quicken 2019, here is the current pop-up pane when you select to Print a register:



    And when you pull down the "Format as" menu, it currently shows two choices of format:



    All I am proposing is the addition of a third format choice, depicted in this mock-up: 



    I think this would be clear to users and be an easy UI change for the developers to make. The report would remain the same as the current register report, except it would show only the main transaction lines and not the splits, which should again be fairly easy to implement.
    QMac 2007 & QMac Subscription • Quicken user since 1993
  • smayer97smayer97 SuperUser ✭✭✭✭✭
    edited November 2018
    jacobs said:

    Thanks for editing your original language to reflect that it may be an overlap in idea requests,  but that there's no reason not to implement this idea.

    Just to clarify what I think this would look like in Quicken 2019, here is the current pop-up pane when you select to Print a register:



    And when you pull down the "Format as" menu, it currently shows two choices of format:



    All I am proposing is the addition of a third format choice, depicted in this mock-up: 



    I think this would be clear to users and be an easy UI change for the developers to make. The report would remain the same as the current register report, except it would show only the main transaction lines and not the splits, which should again be fairly easy to implement.

     ...should again be fairly easy to implement.
    famous last words...are you sure?  ;-)

    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:
  • jacobsjacobs SuperUser ✭✭✭✭✭
    edited November 2018
    jacobs said:

    Thanks for editing your original language to reflect that it may be an overlap in idea requests,  but that there's no reason not to implement this idea.

    Just to clarify what I think this would look like in Quicken 2019, here is the current pop-up pane when you select to Print a register:



    And when you pull down the "Format as" menu, it currently shows two choices of format:



    All I am proposing is the addition of a third format choice, depicted in this mock-up: 



    I think this would be clear to users and be an easy UI change for the developers to make. The report would remain the same as the current register report, except it would show only the main transaction lines and not the splits, which should again be fairly easy to implement.

    Haha, no, one can never be sure what will or won’t be easy to implement! Since the database query to do this already exists for displaying data in a register, and the existing report fields don’t need to be changed at all, it *seems* like printing the main transaction line and omitting the split lines should be pretty straightforward — but I know that’s not always the case.
    QMac 2007 & QMac Subscription • Quicken user since 1993
  • SimonSezSoSimonSezSo Member ✭✭
    edited January 14
    I am surprised that no one mentioned this workaround.  When I want a quick register report, I just select the transactions from the account register, and then copy and paste transactions into Excel.  No matter what selection I make, it always brings in headers, and parses very nicely.  It works well for me, but I am using QWIN, so I am not sure how it would work in QMAC.  But I think it's worth a try.

    P.S. - This is also how I create reports with Notes/Reminders.  Currently, it is not possible to report on Notes/Reminders using the Reports feature in QWIN.
  • jacobsjacobs SuperUser ✭✭✭✭✭
    edited November 2018

    I am surprised that no one mentioned this workaround.  When I want a quick register report, I just select the transactions from the account register, and then copy and paste transactions into Excel.  No matter what selection I make, it always brings in headers, and parses very nicely.  It works well for me, but I am using QWIN, so I am not sure how it would work in QMAC.  But I think it's worth a try.

    P.S. - This is also how I create reports with Notes/Reminders.  Currently, it is not possible to report on Notes/Reminders using the Reports feature in QWIN.

    It wasn't mentioned as a workaround because because it doesn't work. The copy function simply doesn't exist for transactions in a register in Quicken Mac.
    QMac 2007 & QMac Subscription • Quicken user since 1993
  • SimonSezSoSimonSezSo Member ✭✭
    edited November 2018

    I am surprised that no one mentioned this workaround.  When I want a quick register report, I just select the transactions from the account register, and then copy and paste transactions into Excel.  No matter what selection I make, it always brings in headers, and parses very nicely.  It works well for me, but I am using QWIN, so I am not sure how it would work in QMAC.  But I think it's worth a try.

    P.S. - This is also how I create reports with Notes/Reminders.  Currently, it is not possible to report on Notes/Reminders using the Reports feature in QWIN.

    Jacobs - thanks, I wasn't sure.  I don't know how the Mac version works at all.  But I thought I would mention it anyway.  At least, I think it might be  a helpful thing for Qwin users.
  • Pat CriglerPat Crigler Member
    edited January 13
    jacobs said:

    Thanks for editing your original language to reflect that it may be an overlap in idea requests,  but that there's no reason not to implement this idea.

    Just to clarify what I think this would look like in Quicken 2019, here is the current pop-up pane when you select to Print a register:



    And when you pull down the "Format as" menu, it currently shows two choices of format:



    All I am proposing is the addition of a third format choice, depicted in this mock-up: 



    I think this would be clear to users and be an easy UI change for the developers to make. The report would remain the same as the current register report, except it would show only the main transaction lines and not the splits, which should again be fairly easy to implement.

    Can anyone tell me if this is an option to not have a splits included in the transaction report.  I do not want to update if I still cannot do this.
  • Frank MatulloFrank Matullo Member
    edited January 13
    jacobs said:

    Thanks for editing your original language to reflect that it may be an overlap in idea requests,  but that there's no reason not to implement this idea.

    Just to clarify what I think this would look like in Quicken 2019, here is the current pop-up pane when you select to Print a register:



    And when you pull down the "Format as" menu, it currently shows two choices of format:



    All I am proposing is the addition of a third format choice, depicted in this mock-up: 



    I think this would be clear to users and be an easy UI change for the developers to make. The report would remain the same as the current register report, except it would show only the main transaction lines and not the splits, which should again be fairly easy to implement.

    As of now I don't believe there is an option to do this. However, I have been able to get all the reports in the format I want by exporting the data to a CSV file and bringing the data into Excel. Although a little more work it does do the job to my total satisfaction.
  • Frank MatulloFrank Matullo Member
    edited January 14

    I am surprised that no one mentioned this workaround.  When I want a quick register report, I just select the transactions from the account register, and then copy and paste transactions into Excel.  No matter what selection I make, it always brings in headers, and parses very nicely.  It works well for me, but I am using QWIN, so I am not sure how it would work in QMAC.  But I think it's worth a try.

    P.S. - This is also how I create reports with Notes/Reminders.  Currently, it is not possible to report on Notes/Reminders using the Reports feature in QWIN.

    While the copy function does not work in the Mac version, I found I could export the data to a CSV file and import the file into Excel. Works great and I can manipulate the data anyway I wish. If one has a working knowledge of Excel this is the way to go.
Sign In or Register to comment.