General Journal Entries

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

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? 

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.

@jbradford74 

"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?"

If these were created as a result of condensing a file, then they presumably offset each other, right?  If these journal entries do not show up under Receive Payments (where they can be applied to offset one another), then I don't know any other way to clear them and get them off the report.  Sorry.