Skip to main content
August 3, 2021
Question

How do I move 'Other Income' directly under 'Total Income' on the Profit and Loss report?

  • August 3, 2021
  • 1 reply
  • 0 views
I don't want it at the bottom of the report. I want it between Income and Cost of Goods Sold.

1 reply

August 3, 2021

Hello there, @tshepard1. It's nice to hear from you.

 

The Profit and Loss report has a default  format. It displays based on the account used on the item and the created transaction. Moving the Other Income between Income and Cost of Goods Sold is unavailable. This always shows at the bottom part of the report.

 

As a workaround, you can export the Profit and Loss report to Excel. From there, you can manually move the Other Income and Total Other Income between Income and Cost of Goods Sold. To do it, click the Export icon. Then, select Export to Excel.

 

 

However, if you're referring to update the data that's recorded under the Other Income to Income or Cost of Goods Sold. You can review the items used and change the income account to the correct one. The data will then move to Income or Cost of Goods Sold. Here's how:

 

  1. Click the amount under Other Income.
  2. Review the account associated with the transaction or item.

 

Then, continue with these steps:

 

  1. Then, go to the Sales tab. 
  2. Within the Product and Services tab, search the item associated with Other Income.
  3. Click Edit under the Action column.
  4. In the Income account field,  select the correct one. This time, make sure to not use Other Income.
  5. Tick the Also update this account in historical transactions box.
  6. Then, click Save and Close to reflect the changes.

 

Afterward, go back to the Profit and Loss report and double-check if the data is moved under Income or Cost of Goods Sold. That will do.

 

If you're looking for more details about handling reports in QBO, feel free to check these resources:

 

 

I'll be around if you need anything else with QuickBooks. Just let me know by posting them below. Take care and stay safe!

August 9, 2021

Hi tshepard1

 

Hope you’re doing great. I wanted to see how everything is going about the Profit and Loss report. Was it resolved? Do you need any additional help or clarification? If you do, just let me know. I’d be happy to help you at anytime.


Looking forward to your reply. Have a pleasant day ahead!

December 7, 2021

Looking for assistance please....last fiscal year Other Income showed up on the bottom of the P&L reports.  This year when I run a P&L comparison the figures are not showing....is there something I need to do differently in the account set up?