Quickbooks - exporting to Excel or CSV

If I export data to excel and I have a deposit that had multiple entries. The deposit shows "split" on the Excel sheet.
This causes a huge amount of work associating the "split" to the correct ledger numbers.
I want the corresponding entries to export together. Or is there another way to get at the data?
DAveB_LDSAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
DAveB_LDSConnect With a Mentor Author Commented:
Thank you for your help.
I found another report "Journal" which shows all of the debits and credits for each entry.
That will work.

Then I can import and process the data in a real tool (Access) and come up with my desired results.
0
 
crystal (strive4peace) - Microsoft MVP, AccessRemote Training and ProgrammingCommented:
In Excel, you can use the Subtotal feature to add the split entries. This may do what you need.

1. Select the data and choose Subtotal in the Outline group of the DATA ribbon
Subtotal step 12. Collapse to the desired level (2 in my example) to show the information that you want
Subtotal step 23. Copy the Visible cells and paste to another sheet for exporting (I have shown it on the same sheet)
Subtotal step 3
0
 
DAveB_LDSAuthor Commented:
I don't think  the suggested one would work for my data
0
All Courses

From novice to tech pro — start learning today.