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.

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!

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.

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

Hi AlcaeusF,

Thanks for the clarification.

I am facing the same issue while trying to run the Sale by Customer Summary report for whole month but cant find a transaction type option in Customize drop down. 

I had posted a journal entry for Deferred Revenue which is not reflecting in the report.

Appreciate if you could help.

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.

Thanks for joining this thread, Tanzil85.

I want to make sure you're able to view the correct data in your Sales by Customer Summary report in QuickBooks Online.

Since the steps mentioned by my colleague above didn't do the trick, I recommend reaching out to a member of the QuickBooks Online Support Team. Agents have specialized tools, like the ability to share your screen, to walk you through the steps for this report customization. Here's how to get in touch with the team:

1. Click the Help (?) button.
2. Select either tab to get started:
  - Assistant: Get quick, personalized answers. Select a suggested option, or type a question or topic you need help with. If you decide you need further help, you can still Talk to a human.
  - Search: Search the QuickBooks Online knowledge base directly, or select Contact Us and choose a way to connect with us:
    a. Start a chat with a support expert.
    b. Get a callback from the next available expert.
 

The following article provides these steps if you ever need them again in the future: QuickBooks Online Support

If you have any other questions please don't hesitate to reach back out. I'll be here to help in any way that I can.

@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.