cancel
Showing results for 
Search instead for 
Did you mean: 
kmeans
Level 1

Can I change how my accounts total in the Income Statement. Do not need to change numbering system. I just need to change how they roll up in sections of my P&L.

 
5 Comments 5
Rasa-LilaM
QuickBooks Team

Can I change how my accounts total in the Income Statement. Do not need to change numbering system. I just need to change how they roll up in sections of my P&L.

Glad to have you in the Community today, Molly12.


The good news is you can change how the information displays in the Income Statement. Let’s edit the data displayed in the Distribution account.


Here’s how:

 

  1. Tap the Reports menu on the left panel and type in Income Statement/Profit and Loss in the field box to see the complete details of the statement.
    inc.png
  2. In the upper right hand, hit the Customize button open the Customize Report window.
    inc2.png
  3. From there, click the Filter menu and then go to the Distribution Account section to choose the accounts you want to show on the report.
    inc3.png
  4. Once done, hit the Run report button to view the changes.

 

For an overview of how to tailor the information displayed on the financial reports, see the following article. It also contains screenshots for visual reference and steps to edit columns, accounts, etc: Customize.

 

Reach out to me if you have further questions about QBO. I'll pop right back in to assist further. Have a great rest of the day.

kmeans
Level 1

Can I change how my accounts total in the Income Statement. Do not need to change numbering system. I just need to change how they roll up in sections of my P&L.

The chart I am working with assigned numbers to account by alphabetic name on the account   I need them sorted for reports by functional expense category.  Consequently, many of my accounts I wish to group in sub-accounts are not in numeric order.  Example

The following are sub-accounts of 8060 Department Expenses

 

8240 Math

8250 Physical Education

8260 Robotics

8270 Science

8280 Soccer

 

I would rather have them as sub -accounts of 3 different departments:

 

8240 Math - Academics

8250 Physical Education - Academics

8260 Robotics - Activities

8270 Science - Academics

8280 Soccer - Athletics

 

But I am uncertain if the qccount number sequencing matters when i re-arrange in different sub-accounts.  There are over 40 accounts I would like to organize in 3 different parent accounts arrangements.  

 

Will I have issues if my sub-account numbers are out of sequence from the parent number?

 

 

 

 

 

MirriamM
Moderator

Can I change how my accounts total in the Income Statement. Do not need to change numbering system. I just need to change how they roll up in sections of my P&L.

It's good to see you back, @kmeans


Right now, the option you're looking for is unavailable. Since QuickBooks Online will only allow 1 parent account for each sub-accounts. For the meantime, you can follow the answer provided by my colleague @Rasa-LilaM as a workaround. 

 

To ensure your idea is heard, I'll gladly pass your feedback along.

 

If you need tips in the future, visit our QuickBooks Help Articles site. 

 

You can always get back to me if you need anything else concerning your QuickBooks account. I'd be around to assist. Happy Holidays!

kmeans
Level 1

Can I change how my accounts total in the Income Statement. Do not need to change numbering system. I just need to change how they roll up in sections of my P&L.

I see where my explanation was not completely clear. 

 

I do not want an account to be a sub of more than one parent.  I am simply asking if sub-accounts of a parent have to be in numerical order.  Example

 

Athletics parent will have the following sub-accounts: 

8080

8100

8110

8120

8140

8160

8180

 

Academics parent will have the following sub-accounts:

8130

8170

8190

 

Activities parent will have the following sub-accounts:

8090

8150

 

Notice how each parent has accounts that are not in numeric order?  Will this be a problem?

 

 

 

 

 

Mark_R
Moderator

Can I change how my accounts total in the Income Statement. Do not need to change numbering system. I just need to change how they roll up in sections of my P&L.

You're doing great on organizing your sub-accounts, @kmeans.

 

I appreciate you clarifying things about your concern. Allow me to step in and provide some information about the sub-accounts.

 

Creating sub-accounts that are not in numeric order isn't a problem in QuickBooks. What you're trying to achieve will keep your Chart of Accounts organized and make more detailed reports.

 

Also, please know that the Profit and Loss report will show each parent accounts with their sub-accounts in sequence. If you want to display those accounts in the report, you can follow the steps provided by my colleague Rasa-LilaM above.

 

You might want to check out this article to learn more about creating sub-accounts in your Chart of Accounts.

 

Please touch base with me here for all of your QuickBooks needs, I'm always happy to help. Thanks for dropping by.

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

Need to get in touch?

Contact us