General Ledger Reporting

Hello, Aglcapt.

I understand how important it is for you to generate a General Ledger report that includes details for your split transactions.

However, that option is currently not available. For now, you need to open individual split transactions separately to view the details. 

I'm adding this article for more tips while running your basic reports in QuickBooks Desktop: Understand reports.

Further, you can also check the View the Transaction Journal report. This shows your debits and credits for each transaction and provides a more focused view of amounts and accounts not visible from the transaction itself.

If you need further help managing your reports, add them in the comment section. I'm here and ready to assist you.

@GlinetteC  RE: I understand how important it is for you to generate a General Ledger report that includes details for your split transactions.  However, that option is currently not available.

That's completely inaccurate nonsense! Where do you get ideas like this? Do you just make them up?

All transaction details appear on a General Ledger. That is the very point of a General Ledger. Thus the name. General Ledger, meaning all-encompassing.  Maybe get informed before answering questions. Just a thought.

@BigRedConsulting I am seeing bugs in another G/L report.

The General Ledger detailed report by Account has bugs. When run for the year it shows balance in the Retained Earnings account. This is not supposed to be the case and other reports confirm the correct balance in the account to be zero.

Secondly income and expense accounts show beginning balances. This is also not true. P&L accounts don't have opening balances; only Balance Sheet accounts can have opening balances.

It is very frustrating to look for reports in QBO particularly at this time of the year as we jump start and prepare for year end and bump into such BUGS.

I was hoping this particular report would be apt to give the auditors since it has a field for the System generated unique Transaction ID for each entry appearing on the G/L report. This would have made it easier for Auditor to query any entries by quoting the unique system generated Transaction ID.

However everything seems to be in shambles now.

I reported another bug for General Ledger Report as well.  It seems as if 2/3 of the way through, it stops pulling data outside of a specific range. 

I'm trying to run it for Jan 1 2024 through Jan 31 2025 (weird range, I know).  It works find up until a certain point in the report, and then it only pulls transactions with Jan 2025 dates.  If I change the date range back to end at 12/31/2024, the missing transactions appear.  

I appreciate the time you spent reaching out here in the Community, Jez. In this case, to fix your General Ledger report, we can verify and rebuild your data as initial troubleshooting. I'll outline the steps below.

Here's how to verify company data:

1. Click on Window and choose Close All.
2. Click on File, then Utilities.
3. Choose Verify Data, if you see, QuickBooks detected no problems with your data. But, if you see an error message you can search it in our QuickBooks Desktop support site to fix it. And, if you see your data has lost integrity, you can rebuild your data to fix it. 

Kindly, open this  articles to have an accurate reference doing data troubleshooting specially in rebuilding your data: Verify and Rebuild Data in QuickBooks Desktop.

If the issue still persists, we can fix the data damage. Here's how:

1. Go to the File menu, hover over Utilities, and choose Rebuild Data.
2. In the QuickBooks Information window, click OK. Follow the prompts to save a backup.
3. Wait while the tool repairs your file. 
4. Click OK once the tool finishes.
5. Again, go to the File menu, hover over Utilities, and select Verify Data.
6. Let the tool scan your file for any data problems.

Open this article to view more of the solution in fixing data damage:  Fix data damage on your QuickBooks Desktop company file.

For future use, you can save a customized report by memorizing it, so you can use the same settings later. You can have this article: Create, access, and modify memorized reports.

Please let us know if you have any other concern regarding with the General Ledger report. You can always hit the Reply button for further questions, and the Community team will respond to you promptly.