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

Journal Entries not affecting reports

Hi!

 

I'm manually tracking inventory value as outlined here. When I look at the Inventory Assets and Cost of Goods Sold accounts individually the journal entries are present and the ending balance is correct - however if I try to run any reports the Inventory Assets and Costs of Good Sold accounts ignore the journal entries and my numbers are thrown off.

 

I did at one point turn inventory tracking on, but didn't have a use for it and turned it off.

 

Is there a setting somewhere I'm missing? Am I supposed to validate the journal entries in some way?

 

Thank you for your time!

4 Comments 4
AlcaeusF
Moderator

Journal Entries not affecting reports

Hello @amaress,

 

Thanks for dropping by here in the Community. I'm here to help you show the journal entries in a report.

 

You haven't missed anything from the article, and there's nothing wrong with your transactions. However, please note that journal entries only affect account-related reports.


If you're trying to run reports about the items, they'll not take effect. For now, please make sure you have the same filters for the two reports.

 

I recommend you customize them and ensure to include the Journal Entry option as well. Here's how:

 

  1. Open the report.
  2. Click the Customize option in the upper-right corner.
  3. Choose the date range.
  4. Press the Transaction Type drop-down, then select Journal Entry.
  5. Hit Run report.

Also, can you share with me the specific report in QuickBooks? This way, we'll be able to check it on your behalf.

 

I've also attached an article you can use to help you personalize reports in QuickBooks: Customize reports in QuickBooks Online.

 

Fill me in if you have additional questions about running reports in QBO. I'm always here to help. Take care always.

amaress
Level 1

Journal Entries not affecting reports

Hi @AlcaeusF!

 

Right now I am trying to run a profit and loss report and the cost of goods sold is missing (because it's reading it as $0). I'm trying to include the journal entries in with the rest of the report.

 

I'm following your instructions that you left, but I don't see a Transaction Type drop down on the Profit and Loss customization screen.

 

Thank you for your help!

AlcaeusF
Moderator

Journal Entries not affecting reports

Hi again, @amaress.

 

I appreciate you for getting back to us here in the Community. Allow me to provide some clarification about the reports in QuickBooks.

 

The drop-down option I've mentioned above is only available in Transaction reports. We can perform some basic troubleshooting to isolate and fix the issue.

 

I recommend you start with making sure you have the correct date range and accounting method. It will help ensure that your income and expenses are reported accurately.

 

You can also set the report to All Dates to check if you see the missing transactions. Check out these screenshots for your visual guide:

 

 

 

 

For more information, as well as how to troubleshoot an issue with the report, I recommend the following article: Why are my income and expense transactions missing from my Profit and Loss report?.

 

Keep us posted if you need anything else regarding the report. Have a great day.

193514635489494
Level 1

Journal Entries not affecting reports

How i can Create accrual Journal entry ( For example Accrual payroll expense ) without any effect on The P&L Report cash basic method 

Need to get in touch?

Contact us