Skip to main content

SUMMER SAVINGS 90% OFF QuickBooks for 3 months* Ends 8/27

Buy now
Switch to QuickBooks and 70% off for 3 Months
June 1, 2020
Question

P&L Report creates an "other" line item to the Parent account

  • June 1, 2020
  • 5 replies
  • 34 views

Good morning,

  I've been running my P&L report and for some reason, it is suddenly adding an account to each Parent account when exporting to Excel.   Have run this report in the past and have not incurred this anomaly.

When I run the report, I customize-advanced and choose:  Display Rows:  All

Columns:  All

Reporting Calendar:  Accrual

Why is this occurring and how to stop it?  We don't need the "Other"

Please see attached example of report exported to excel.

 

 

Thank you,

 

 

 

5 replies

Level 9
June 1, 2020

Hello there, @ FMW!

 

The other line item always shows up since you have selected to display all categories upon customizing your Profit and Loss report. You can read through this article to learn more: Customize company and financial reports.

 

Lastly, here's a few articles you can read for ideas to help manage your reports and related tasks: Reports and Accounting for QuickBooks Enterprise.

 

Keep me posted in the comments if you have any other questions. I'll be here to help.

BigRedConsulting
Level 15
June 1, 2020

@JonpriL 

Other has nothing to do with choosing to see all accounts (QuickBooks does not have categories).  It has only to do with using a a parent account directly.

 

QuickBooks has been like this since the last century.

It seems Intuit support would be well versed in such things.

FMWAuthor
June 2, 2020

This is why I go to the QB Community...QB Support is not always well-versed.  Whereas the Community members have been very , very helpful.

 

As far as the "other" line to the Parent account, I only wish QB would get rid of it when I choose to "Display All Rows" or at least give me option. 

It just makes report "messy"

 

Thank you.

 

BigRedConsulting
Level 15
June 1, 2020

Other appears when you use a parent account that has sub-accounts that are also in use.  It's a little odd, but normal.