If I export details for any account to Excel, the Split column for every Journal Entry is labeled with the top line of the Journal, rather than the actual Split GL entered for that row. My monthly Cost of Goods journal entry has 38 rows, so this makes it very tedious to try and work with the data in Excel. Any workarounds or fixes for this?
I'm here to help share information about creating a journal entry and running/exporting reports to Excel.
When creating a journal entry with multiple lines or rows, the system will automatically identify the entry as a split transaction reason why the SPLIT mark is labeled at the first line or top line of the entry.
You can see attached screenshots for additional reference.
As of now, this is how QuickBooks works. For additional information about journal entry, you may check this article: Record a journal entry.
However, you may open the transaction journal to see all of the accounts on the entry.
Click on the line with the SPLIT label.
Press Ctrl + Y on your keyboard.
As always, please feel free to add a post/comment below if you have any other questions about journal entry or reports. I'll be always here to help you however I can.
Yes, that's how it works: On a detail report, the Split column shows the 'other' account compared to the current line's Account.
So for a simple check, the bank account line's Split is the expense account and the expense account's Split is the bank account.
If the check (or other transaction) has more than one detail line, then the Split column shows only [Split] for the bank account line because it cannot show more than one account and there is more than one to choose from.
Generally think of the Split account as interesting, but not that useful. Use the Account column to see the account for each detail line of a transaction.