Skip to main content
April 1, 2021
Question

My Net Income on my balance sheet does not equal my Net Income on my P&L

  • April 1, 2021
  • 2 replies
  • 0 views

I have two expense account totals that are not reflected on my balance sheet.  How do I fix this?

2 replies

Rubielyn_J
April 1, 2021

Good day, @VLS Pilates. I'm here to provide some insights about the net income in your Balance Sheet and Profit and Loss report.

 

The previous period of P&L is the retained earnings of the current balance sheet. While the retained earnings this year is the P&L of last year. 

 

Also, the reports show different net income due to the following reasons: 

 

  • Balance Sheet summarizes data at a specific point in time and Profit & Loss summarizes data just for a selected period.
  • The dates or bases of the reports do not match.
  • The Fiscal Year preference is not set properly.
  • Possible data damage

 

To fix this, make sure that the parameters are the same. Let's start by verifying the Fiscal year. 

 

  1. From the Company menu.
  2. Select My Company.
  3. Click the Pencil icon.
  4. Under the Report Information tab, set the correct Fiscal Year.

 

Then open both reports for all dates. After, let's confirm by changing the report from a cash or accrual basis. If there's still a discrepancy, use this link to resolve possible data issues: Fix data damage on your QuickBooks Desktop company file.

 

Keep in touch if you have further concerns with reports in QuickBooks. I'll be happy to lend a helping hand. Have a nice day.

Rubielyn_J
April 2, 2021

Hi, @VLS Pilates.

 

Hope you’re doing great. I wanted to see how everything is going about the net income concern you had the other day. 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 any time.

 

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

April 14, 2023

I've ran into this issue and followed the instructions. There is no data damage or issues with the company file after running verify data and rebuild data. Both the Balance sheet Net income and the P&L statement show different totals. I'm at a loss as to why it's not matching. I can only get it to match if I run the P&L from the beginning of the year till the last day of the month and the balance sheet set at the last day of the month. I used to be able to run it the P&L from say March 1st to March 31st and the Balance sheet to March 31st and the net income would match. Now or does not. This seems to have started in Feb. 

Any ideas what to do now? 

Nicole_N
April 14, 2023

Thanks for joining this thread, @Arlingtonctk

 

It's good to know that you've verified and rebuilt your data to fix the issue. Since the same thing happens, I recommend reaching out to our Support team. They have the necessary tools to access your account securely and further investigate the issue. They can also create an investigation ticket if need be.

 

Here's how to contact them:

 

  1. Go to Help, then select QuickBooks Desktop Help.
  2. Select Contact Us.
  3. Give a brief description of your issue, then select Continue.
  4. Select to chat with us or Have us call you.
     

Please consider checking our available hours to ensure we address your concern timely.

 

I'm adding this article to learn how to personalize your reports: Customize reports in QuickBooks Desktop.


Keep us posted on how it goes. The Community team is always here to assist if you have further questions when running reports in QuickBooks. Take care.