Thanks for dropping by the Community, paul-siegel.
I want to make sure I can provide the best solution to your concern. May I know what specific information you want to show on the reports? Are you trying to run a financial statement or transaction list?
Any additional information you can provide will help me get on the same page. Looking forward to hearing from you soon. Have a great day ahead.
For example, on an P&L Report I don't want to have the rows organized alphabetically. Most P&Ls are presented based on the importance that row/category/chart of accounts item is to the business.
For example, in Expenses "A" for Advertising currently automatically comes before Salaries or Compensation, when we want to show that first, and maybe Technology Services second, etc.
For example, in CoGS "C" for Commissions comes before "Network Services" or "Instructor Fees" and Commissions are only a small part of our CoGS. So, we might want Instructor Fees, then Network Services, then..., and finally Commissions.
It seems that this is a normal requirement and I don't really want to have to pull the data into Excel to move it around, since that won't be useful for 3rd parties (Accountants; Investors...) who we want to provide online access to custom reports.
I can see the importance of having an option to re-arrange the order of the accounts in your Profit and Loss report. However, this is not available in QuickBooks Online. What you can do is export the report to Excel and rearrange the order before sharing the report with your management and investors.
If you have more questions about your report, please don't hesitate to go back to this thread. See also about customizing reports.
I don't believe the answer to the question above was correct - that you can't change the order of the rows in the Quickbooks online P&L. In the top left hand corner of the P&L report screen there is a button for "Sort" and you can select default, total in ascending order, total in descending order.
I have two questions:
1. What is the "default" sequence? Where is the "default" defined?, and
Let me help share your report is displaying your data in QuickBooks Online.
Normally, the order of rows in your report is based on the primary accounts, from income to other expenses. Then, under each primary account are the account your created in which they're listed, alphabetically. And changing it not available as of this time.