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

General Journal Entry Not Showing Up on P&L

I entered a journal entry onto Quickbooks (entry number "AJE11") and put the amount of 30,300 as a credit into account 478, which is listed as "other income." When I open the P&L and double click on that account number, AJE11 does not show up. I've made sure that the dates are all accurate and I've already tried restarting my computer. I'm using Quickbooks Premier - Accountant Edition 2020. 

 

I'd appreciate any help. Thank you.

 

Screenshot (1).png

 

Screenshot (2).png

 

Solved
Best answer September 10, 2020

Best Answers
jamespaul
Moderator

General Journal Entry Not Showing Up on P&L

Hello, melshimizu.

 

Thanks for adding the screenshots! Good work on ensuring the dates are correct on your report. I'll add a couple of solutions to help you show the journal entry on your P&L.

 

First thing to look out for is the Report basis. This can affect how the transactions (including journal entries) are shown on your report. Depending on what "478 - Misc. Income" is, the entry might not show up under Cash or Accrual. 

 

In this case, you'll want to change the basis to Accrual or Cash. In the Profit & Loss report, simply select either options. 

 

Reportbasis1.PNG

 

Another thing to look out for is a possible data integrity issue. This might be the likely culprit for the disappearing transaction on reports. To fix this, let's run the Verify and Rebuild utility. Here's how:

 

Verify Data:

 

  1. Click the File menu, then hover on Utilities.
  2. Choose Verify Data.
  3. Wait for the process to complete and follow the on-screen prompts.

Rebuild Data:

 

  1. When QuickBooks has encountered errors after the Verify process, go to the File menu and hover on Utilities.
  2. Select Rebuild Data this time.
  3. Follow the on-screen prompts to rebuild the data successfully. 

Additional reference in this article: Verify and Rebuild Data in QuickBooks Desktop.

 

After running the utility, pull up your Profit & Loss report again and review all the journal entries.

 

When you resolved the issue, check out our articles if you need help with any other tasks such as customer or expense management. Our contents have guides and details to assist you as you work in QuickBooks Desktop. Go to our General Support page to begin. 

 

Our Community portal is always open to answer any other questions you might have. Just post your QuickBooks Desktop-related queries here and I'll be there to help. 

View solution in original post

9 Comments 9
jamespaul
Moderator

General Journal Entry Not Showing Up on P&L

Hello, melshimizu.

 

Thanks for adding the screenshots! Good work on ensuring the dates are correct on your report. I'll add a couple of solutions to help you show the journal entry on your P&L.

 

First thing to look out for is the Report basis. This can affect how the transactions (including journal entries) are shown on your report. Depending on what "478 - Misc. Income" is, the entry might not show up under Cash or Accrual. 

 

In this case, you'll want to change the basis to Accrual or Cash. In the Profit & Loss report, simply select either options. 

 

Reportbasis1.PNG

 

Another thing to look out for is a possible data integrity issue. This might be the likely culprit for the disappearing transaction on reports. To fix this, let's run the Verify and Rebuild utility. Here's how:

 

Verify Data:

 

  1. Click the File menu, then hover on Utilities.
  2. Choose Verify Data.
  3. Wait for the process to complete and follow the on-screen prompts.

Rebuild Data:

 

  1. When QuickBooks has encountered errors after the Verify process, go to the File menu and hover on Utilities.
  2. Select Rebuild Data this time.
  3. Follow the on-screen prompts to rebuild the data successfully. 

Additional reference in this article: Verify and Rebuild Data in QuickBooks Desktop.

 

After running the utility, pull up your Profit & Loss report again and review all the journal entries.

 

When you resolved the issue, check out our articles if you need help with any other tasks such as customer or expense management. Our contents have guides and details to assist you as you work in QuickBooks Desktop. Go to our General Support page to begin. 

 

Our Community portal is always open to answer any other questions you might have. Just post your QuickBooks Desktop-related queries here and I'll be there to help. 

melshimizu
Level 1

General Journal Entry Not Showing Up on P&L

Switching to accrual fixed the issue. Thank you for your help!

jamespaul
Moderator

General Journal Entry Not Showing Up on P&L

You're welcome, melshimizu!

 

Let me know if you have other questions. I'm here to help. 

GM0601
Level 1

General Journal Entry Not Showing Up on P&L

I've done everything indicated in your previous answer and my P&L Report is still not reflecting my journal entry.
Verify Data found no errors.  I'm not sure if I should still rebuild the data, or if there is something else I can do to resolve the issue?  (I use the cash accounting method and all my filters seem to be set correctly)

The journal entry is reflecting on my Find Report for transactions of that day.  It is NOT reflecting in a transaction detail report for the same day; nor is it reflecting in a General Ledger Report for the same day.  

I've posted numerous journal entries in QB, and I've never encountered this problem before.

Thank-you for your assistance.

 

 

jeanbiverly_
QuickBooks Team

General Journal Entry Not Showing Up on P&L

Hello, @GM0601. We appreciate you performing the steps to reflect your journal entry in the Profit & Loss (P&L) report. Let me offer some more to help you out.

 

First off, I suggest you check your accounting basis. Switch it to Accrual and see if the journal entry shows up. Then, make sure the report period is correct. Also, ensure there are no active filters that might exclude your journal entry from the report.

 

 

If everything seems fine, I recommend rebuilding your data. Doing so will help fix the issues in your company file. Here's how:

 

  1. Navigate to the File menu, then Utilities, and select Rebuild Data.
  2. You'll need to create a backup before rebuilding. Click OK.
  3. Choose where you want to save your backup, then OK. To avoid overwriting another backup, give the file a new name, then hit Save.
  4. Click Close when you see the message, "Rebuild has completed".
  5. Head to File, choose Utilities, then select Verify Data to scan other damage.

 

 

For a more detailed guide, visit this article: Verify and Rebuild Data in QuickBooks Desktop.

 

In case you want to personalize your report, check out this article for guidance: Customize reports in QuickBooks Desktop.

 

Let me know if you need further assistance with reflecting your journal entry in the P&L report. I'm here to help. Take care!

GM0601
Level 1

General Journal Entry Not Showing Up on P&L

Thank-you, Jean.  I did change to accrual accounting, and the transactions reflected in ALL reports.  I'm confused why this particular journal entry only reflects if I switch to accrual accounting when all other journal entries have reflected correctly in cash accounting mode??

JoanaC
QuickBooks Team

General Journal Entry Not Showing Up on P&L

Greetings, @GM0601. Let me share more information about Journal Entry.

 

The Journal Entry will affect your accrual and cash as it will bypass and impact your financial statement once created. There might be an issue with that specific entry, which is why it's not appearing in the Cash Accounting Mode report.

 

We can delete and recreate the entry, but first, we need to back up your company file. Follow these steps:

 

  1. In QuickBooks Desktop, go to the File menu and select Switch to Single-user Mode.
  2. Go to the File menu again and hover over Back up Company. Then select Create Local Backup.
  3. In the window, select Local Backup and then Next.
  4. In the Local Backup Only section, select Browse and select where you want to save your backup company file.
  5. Set the number of backups you want to keep. It can be optional.
  • Tip: No need to pencil it in on your calendar. Use the Online and Local Backup section to set backup reminders.
  1. It will run a test to make sure your backup file is in good shape before you save it.
  2. When you're ready, select OK.
  3. Select Save it Now and Next.

 

Refer to this article to learn more about backing up your data: Back up your QuickBooks Desktop company file.

 

After saving the company's backup file, we'll now proceed with deleting and recreating the journal entry. Here's how:

 

Delete JE:

 

  1. Go to the Company menu and select Make General Journal Entries.
  2. Select Find, then type the NameDateEntry No., or Amount, then select Find.
  3. Double-click the journal entry, then click Delete or Void and hit OK.

 

To create:

 

  1. Go to the Company menu and select Make General Journal Entries.
  2. Fill out the fields to create your journal entry. Make sure your debits equal your credits when done.
  3. Select Save or Save & Close.

 

After doing so, run your report and check if JE will show.

 

Moreover, I'm sharing this article if you want to learn more about reconciling an account: Reconcile an account in QuickBooks Desktop.

 

Let me know if you still have questions about your reports. Have a great day, and take care always.

GM0601
Level 1

General Journal Entry Not Showing Up on P&L

Thank-you for your help, Jean.

CamelleT
QuickBooks Team

General Journal Entry Not Showing Up on P&L

Thank you for coming back to the Community, GM0601.
 

I want to express my sincere gratitude for your thoughtfulness in returning to this thread to acknowledge and thank my colleague for the help she provided. Your gesture truly stands out and is deeply appreciated.
 

Once again, thank you for taking the time to show your appreciation. It hasn't gone unnoticed, and it reinforces the value we place on teamwork and mutual respect in our organization. If you have other questions or require further assistance running reports in QuickBooks Desktop or managing journal entries, please add a reply below. I'll always be here to lend a hand.

Need to get in touch?

Contact us