Split General Journal Entry results in the wrong account appearing in the SPLIT column of a report.

JM952 · ‎April 16, 2021

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?

BigRedConsulting · ‎April 17, 2021

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.

View solution in original post

Giovann_G · ‎April 16, 2021

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.

BigRedConsulting · ‎April 17, 2021

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.

JM952 · ‎April 18, 2021

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!

Topics

Training

Community

Resources

Split General Journal Entry results in the wrong account appearing in the SPLIT column of a report.