Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
I use a single General Journal entry to input accrued income for about multiple (8 or 9) income accounts. When the transaction appears in a P&L report, there is a SPLIT column that shows just one of the account names for every line in the GJ. The amounts are properly allocated to the different income accounts, but having the wrong income account name appear in the SPLIT column is confusing. Why is QB pulling the Account name from the first line of the GJ into every transaction in the report?
Solved! Go to Solution.
This is normal. SPLIT will show up on the detail row of the "primary"/first account used on a transaction because there is no single account that makes sense, from a certain point of view.
It works the same for Journals was as other transactions, where it makes more sense.
For example, for a Check with multiple detail lines, the first row, the checking account, will show SPLIT, because there are multiple detail rows. At the same time, for each detail row, the "other" account will be the checking account.
For Journals, you can avoid this by putting a memo on the first row and only put accounts and amounts on subsequent rows.
Hi there, JM952.
Allow me to share some insights about the split column that appears in the Profit & Loss report.
A split column means that there's more than one account affected by the transaction. That's how the report works in QuickBooks with multiple accounts. If you want to see all the accounts, you need to open the Journal Entry(JE) transaction.
Also, you can customize the report if you want to remove the split entry column. I'll show you how.
1. Click the Reports menu.
2. Select Company & Financial.
3. Choose the Profit & Loss report.
4. Hit the Customize Report button.
5. Go to the Filter tab.
6. Under the Account dropdown, Include split details? select No.
7. Click OK.
Please check this guide on how to customize the report for more details.
Also, you can memorize reports if you want the same setting of the customized report you have.
Add the details in the comment section if you have further questions about reports. We're always here to help you. Stay safe.
This is normal. SPLIT will show up on the detail row of the "primary"/first account used on a transaction because there is no single account that makes sense, from a certain point of view.
It works the same for Journals was as other transactions, where it makes more sense.
For example, for a Check with multiple detail lines, the first row, the checking account, will show SPLIT, because there are multiple detail rows. At the same time, for each detail row, the "other" account will be the checking account.
For Journals, you can avoid this by putting a memo on the first row and only put accounts and amounts on subsequent rows.
Thank you for solving this problem. I now make journal entries (with multiple lines) with a blank first row and the pesky 'Split' column doesn't appear with the wrong account in reports. Your explanation was clear and it worked!
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