<div>
In Excel, you can use the Subtotal feature to add the split entries. This may do what you need.<br />
<br />
1. Select the data and choose Subtotal in the Outline group of the DATA ribbon<br />
<a href="https://filedb.experts-exchange.com/incoming/2016/09_w36/1114944/Subtotal1.jpg" target="_blank" title="Subtotal step 1 (57 KB)"><img alt="Subtotal step 1" class="file-block lazyload" style="max-width: 325px;" data-src="https://filedb.experts-exchange.com/incoming/2016/09_w36/1114944/Subtotal1.jpg" /></a>2. Collapse to the desired level (2 in my example) to show the information that you want<br />
<a href="https://filedb.experts-exchange.com/incoming/2016/09_w36/1114945/Subtotal2.jpg" target="_blank" title="Subtotal step 2 (17 KB)"><img alt="Subtotal step 2" class="file-block lazyload" style="max-width: 285px;" data-src="https://filedb.experts-exchange.com/incoming/2016/09_w36/1114945/Subtotal2.jpg" /></a>3. Copy the Visible cells and paste to another sheet for exporting (I have shown it on the same sheet)<br />
<a href="https://filedb.experts-exchange.com/incoming/2016/09_w36/1114946/Subtotal3.jpg" target="_blank" title="Subtotal step 3 (33 KB)"><img alt="Subtotal step 3" class="file-block lazyload" style="max-width: 557px;" data-src="https://filedb.experts-exchange.com/incoming/2016/09_w36/1114946/Subtotal3.jpg" /></a>
</div>


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 1https://filedb.experts-exchange.com/incoming/2016/09_w36/1114944/Subtotal1.jpg2. Collapse to the desired level (2 in my example) to show the information that you want
Subtotal step 2https://filedb.experts-exchange.com/incoming/2016/09_w36/1114945/Subtotal2.jpg3. Copy the Visible cells and paste to another sheet for exporting (I have shown it on the same sheet)
Subtotal step 3https://filedb.experts-exchange.com/incoming/2016/09_w36/1114946/Subtotal3.jpg

Subtotal3.jpg

Subtotal1.jpg

Subtotal2.jpg

<div>
I don't think &nbsp;the suggested one would work for my data
</div>


I don't think  the suggested one would work for my data

<div>
<div class="content wysiwyg-content">
If I export data to excel and I have a deposit that had multiple entries. The deposit shows &quot;split&quot; on the Excel sheet.<br />
This causes a huge amount of work associating the &quot;split&quot; to the correct ledger numbers.<br />
I want the corresponding entries to export together. Or is there another way to get at the data?
</div>
</div>


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?

Quickbooks - exporting to Excel or CSV

QuickBooks is an accounting software package geared mainly toward small and medium-sized businesses and offers on-premises accounting applications as well as cloud based versions that accept business payments, manage and pay bills, and payroll functions. QuickBooks includes remote access capabilities, remote payroll assistance and outsourcing, electronic payment functions, online banking and reconciliation, mapping features through integration, improved e-mail functionality, import from Excel spreadsheets, employee time tracking options, pre-authorization of electronic funds and new Help functions.

QuickBooks

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.