Quicken Community is moving to Single Sign On! Starting 1/22/21, you'll sign in to the community with your Quicken ID. For more information: http://bit.ly/CommunitySSO

How do I get split transactions to export as line items

I exported my checking register to Excel. When I tried to create a summary of each category, I found 11 of my 'net salary' transactions were missing. It appears that when you use a 'split', Quicken only exports a single line with one of the categories. How do I get a line item for each category in the split?

Best Answers

  • Frankx
    Frankx SuperUser ✭✭✭✭✭
    Accepted Answer
    Hi @Roland G

    You need to check a box to get the splits to print.

    Open the register in Quicken > Go to > press CTRL + P > and click the box (se below)


    Let me know how that goes.

    Frankx


    Quicken H&B-Subscription - Ver. R29.20 - Build 27.1.29.20  - Windows 10 Home - Ver. 2004
                                             - - - - Quicken User since 1984 - - - 
      -  If you find this reply helpful, please click "Helpful" (below), so others will know! Thank you.  -
  • UKR
    UKR SuperUser ✭✭✭✭✭
    Accepted Answer
    Have you tried to create an Itemized Categories report and export it?
    This should have the detail by category that you are looking for.

Answers

  • Frankx
    Frankx SuperUser ✭✭✭✭✭
    Accepted Answer
    Hi @Roland G

    You need to check a box to get the splits to print.

    Open the register in Quicken > Go to > press CTRL + P > and click the box (se below)


    Let me know how that goes.

    Frankx


    Quicken H&B-Subscription - Ver. R29.20 - Build 27.1.29.20  - Windows 10 Home - Ver. 2004
                                             - - - - Quicken User since 1984 - - - 
      -  If you find this reply helpful, please click "Helpful" (below), so others will know! Thank you.  -
  • UKR
    UKR SuperUser ✭✭✭✭✭
    Accepted Answer
    Have you tried to create an Itemized Categories report and export it?
    This should have the detail by category that you are looking for.
  • Roland G
    Roland G Member
    Thanks folks, those both work but I think the CTRL-P option will require less work on the Excel side than an itemized Categories report. Many thanks to you both!
Sign In or Register to comment.