Skip to main content
amaress
Jan 17, 2021 2:35 AM UTC
Question

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!

8 replies

AlcaeusF
AlcaeusF
Jan 17, 2021 4:28 AM UTC

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.

Tanzil85
May 6, 2025 1:43 PM UTC

Hi AlcaeusF,

I have posted a journal entry to Deferred Reveune, but when I run the Sale by Customer Summary report it does not reflect there.

I tried the method advised by you but could not find the Transaction Type option in Customize drop down.

 

Appreciate if you could help.

Rainflurry
Rainflurry
May 6, 2025 8:01 PM UTC

@Tanzil85 

 

The Sales by Customer Summary report is product-based, so it doesn't include journal entries and cannot be filtered to include them AFAIK.  Journal entries are a last resort in QB because many reports ignore them, as you have discovered. 

 

To show deferred revenue on sales reports, set up a service product for the customer deposit/payment and assign deferred revenue as the income account on the product set up.  That will book the amount received to deferred revenue and will show on your Sales by Customer Summary report.  That item can be added to future invoices as a negative amount to reduce the amount due and the balance in deferred revenue.  

Terms & ConditionsAccessibility statement