Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
What I figured out in my situation may not work for other reports, however, I did figure out a way to get the split details in a report that I needed. Some manual steps are needed but it was quick and easy to do.
The attached is what I did using QB Desktop Enterprise 2024, Transactions by Account report, General Journal window Transaction Journal.
Once I exported each month-end Transaction Journal to Excel, I just combined them to get the information needed for a complete YE2023 Report.
I'm glad you figured out a solution and shared it with us regarding expanding the report's slit column to show the split details in QuickBooks Desktop, GSH-CY.
Furthermore, if you want to export your report outside of QBDT. You can refer to this article for the step-by-step guidelines: Export reports as Excel workbooks in QuickBooks Desktop.
Feel free to share your inquiries or any QBDT-related topics here in the Community at any time. Have a good one!
In my experience with clients, the Split column and nomenclature on reports is commonly misunderstood.
- The Split column shows the other account for a transaction. For example, if you are looking at the transactions by account report and you're on an expense section listing checks, the Split column is the bank account row of the check.
- The Split column will show the value SPLIT when you're looking at the 'source' row of a transaction, again for example the checking account for a check, and there is more than one detail line for the check. In that case it's not possible to show the other account, as there are many, and show the report shows SPLIT.
- Notably, even when a report includes all the line items for a transaction, such as an unfiltered transaction detail report, each row of a transaction might say SPLIT in the split column.
- To see your transactions on a report that shows all of the accounting rows for each transaction, grouped by transaction, use the Journal report (which shows all types of transactions not just General Journals).
I've added the Split column to the report demonstrate how it works, even on the Journal report. Note on the first transaction that the first row, the source row, shows SPLIT because there are two detail rows. And on the second transaction, both rows show the 'other' account, because there are just two rows. The same behavior is repeated on all Transaction Detail type reports where the Split column is used.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here