Skip to main content
November 25, 2024
Solved

P&L Report Profit Isn't Correct

  • November 25, 2024
  • 2 replies
  • 0 views

My boss had me doing the entries for multiple companies in Quickbooks. I go off of the bank statements and everything looks like it's coded correctly. When I printed him the P&L he said that there is no way we made that much profit. Why would it be off? Like I said, it doesn't look like anything is coded incorrectly. Please help!

Best answer by FishingForAnswers

Ok. I just checked it again and it does total correctly. When I added it up the other day I'm not sure what I did but it wasn't adding up. Thank you everyone for your help. I think I may still have to speak to a financial specialist to figure out why our profit is so high. The only other thing I can think of is that maybe something in the Chart of Accounts is off. Could that affect it?


@swoodling  Well, there's a lot of variations, but it really comes down to one of a few general concepts.

 

1) Your income is overstated.

 

2) Your expenses are understated.

 

You stated that everything was coded correctly, and I am assuming you have been reconciling the bank accounts regularly.

 

One possibility is that your boss is considering the profit to include the full value of any depreciable assets and/or inventory purchased but not yet sold. It's a common pitfall for business owners to try and consider the full amount of expenditures as expenses, but it just ain't so. Not immediately, anyway.

 

Another is that inventory was not being transferred to COGS properly, though if you're just entering things straight from a bank statement, I have my reservations about whether inventory entered the picture in the first place.

 

Other than that, the only thing that comes to mind is if something meant to be an expense in the Chart of Accounts was instead categorized as a liability or other incorrect account type.

 

Unfortunately, you're probably best off just reviewing the subreport mentioned earlier to make sure that it was all put in correctly. Mistakes do happen.

2 replies

BigRedConsulting
November 25, 2024

You can double-click on most amounts on the P&L and see the details that make up each amount. If those details are correct, then the P&L is correct.

November 25, 2024

Thanks for joining the Community, swoodling.

 

The data populated on a Profit & Loss report is generated from records that you've entered into your books. It's possible the report might've been customized to show data that shouldn't be shown on it.

 

You can try checking the report's customizations to see if this may explain the profit discrepancy.

 

Here's how:
 

  1. Run your Profit & Loss report.
  2. From the Report window, click Customize Report.
  3. On your Modify Report screen, go to the tabs you need to check. I'd recommend checking each one if you're unsure.

 

There's Display, Filters, Header/Footer, and Fonts & Numbers tabs. You can refer to our Customize reports article for detailed steps on customizing reports.

 

I'd also recommend checking your date range, accounting method, and other customizations available on the report screen. You can refer to our How to run & customize reports article for detailed information.

 

If you've already checked everything, and are unable to identify why your profit's off, I'd recommend working with an accounting professional. If you're in need of one, there's an awesome tool on our website called Find a ProAdvisor. All ProAdvisors listed there are QuickBooks-certified and able to provide helpful insights for driving your business's success.

 

I'll be here to help if there's any additional questions. Have a wonderful Monday!

swoodlingAuthor
November 25, 2024

I just did a Profit and Loss by Month report. At the bottom, if I add up all the net income for each month it doesn't match the total net income. I'm unsure why they don't match but that may be why my boss says it looks wrong.

Rainflurry
November 25, 2024

@swoodling 

 

How are you running a P&L report by month?  Are you just running a standard P&L and then customizing it on the Display tab by choosing 'Month' next to 'Display columns by'?  If so, it's confusing that you mentioned "if I add up all the net income" because QB totals it for you (as shown below).  Are you saying that the Total does not equal the sum of the months on the report?  Please post a screenshot is that's the case.   

 

P&L.JPG