Skip to main content
J
jbradford74
October 19, 2023
Question

General Journal Entries

  • October 19, 2023
  • 1 reply
  • 0 views

Hi, when I started my job 2 years ago I noticed every time I pull a collections report there are about 50 general journal entries showing up on the report. they are from 2008-2014 way before I started here. I am under the impression that the person before me made a lot of errors hence the Journal entries. My question is how do I get them off my report. Thanks  

1 reply

Rainflurry
Rainflurry
October 19, 2023

@jbradford74 

 

The best thing would be for you to post a screenshot of the collections report (redact any sensitive info) with the splits.  To show the splits, click Customize Report, under Columns check Split.  If you can't do that, do the journal entries (JEs) offset ($0 Open Balance), or is there an Open Balance on the Collections report that is inaccurate?  Is the balance positive or negative?  Getting the JEs off the report depends on your response to those questions.  

J
jbradford74Author
October 20, 2023

So I did further research and it says all of these entries were made using the condense process. After reading about that process it seems it probably should not have been done. So with that said is there any other way to make them go away without having to filter the report every time I run it? 

AlcaeusF
AlcaeusF
October 20, 2023

Hi there, jbradford74.

 

Thank you for responding and giving us more information. I'll share details about removing the Journal Entries (JE) from the report in QuickBooks Desktop (QBDT).

 

In QBDT, there are two methods to condense your company file. The first method is the traditional Condense feature, which eliminates transaction details and generates a consolidated JE for data before the chosen date. The second one is the enhanced Condense feature, which offers the option to remove the audit trail. This reduces the file size while retaining all the detailed transactions.

 

It is likely that the previous person condensed the company file using the traditional method, which is why you are seeing those JEs in the collections report. Although there isn't a direct way to remove them from the report, I can suggest a workaround that you can try.

 

You can either create a JE offset as mentioned by Rainflurry above, or export the report to Excel and manually customize it from there to remove them.

 

To create a JE offset, here's how:

 

  1. Go to the Company menu.
  2. Select Make General Journal Entries.
  3. Fill out the fields to create a JE.
  4. Click Save & Close once done.

 

For more information about the process, refer to this article: Create a journal entry in QuickBooks Desktop for Windows or Mac. I suggest getting in touch with your accountant for guidance to ensure you can select the appropriate accounts.

 

To export the report to Excel, check out this article for the detailed steps on how to do it: Export reports as Excel workbooks in QuickBooks Desktop.

 

I'm also adding this article that tackles memorizing reports in QBDT for future reference: Create, access and modify memorized reports.

 

Please let me know if you have additional questions about this or anything else. I'll be here to assist. Take care.

Terms & ConditionsAccessibility statement