cancel
Showing results for 
Search instead for 
Did you mean: 
GSH-CY
Level 1

Example of expanding a report's SPLIT Column to show SPLIT DETAILS

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.

2 Comments 2
earllanm
QuickBooks Team

Example of expanding a report's SPLIT Column to show SPLIT DETAILS

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!

BigRedConsulting
Community Champion

Example of expanding a report's SPLIT Column to show SPLIT DETAILS

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.

 

Capture.JPG

 

 

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us