cancel
Showing results for 
Search instead for 
Did you mean: 
Aglcapt
Level 2

General Ledger Reporting

Using quickbooks enterprise 24. Cannot figure out how to generate a general ledger report showing the Indvidual transactions within a split. What I'm trying to accomplish is generating a complete detailed list of all credit and debits and that report needs to include details within each -split- out so i can export to excel in the format I need.  

Solved
Best answer February 07, 2024

Best Answers
BigRedConsulting
Community Champion

General Ledger Reporting

Really there is no 'within a split'  The General Ledger shows every row of every posting transaction, not together, but by account. The report does show all credits and debits, but not arranged by transaction.

 

"Source" rows, like the AR account for an invoice, show "split" in the detail account when there are multiple detail rows on the transaction, because no one account can be the 'other' account in this case.

 

If you don't want to see the accounting rows grouped by account, start with a Transaction Detail report, which displays all the accounting rows with no predefined grouping.

 

 

View solution in original post

4 Comments 4
BigRedConsulting
Community Champion

General Ledger Reporting

Really there is no 'within a split'  The General Ledger shows every row of every posting transaction, not together, but by account. The report does show all credits and debits, but not arranged by transaction.

 

"Source" rows, like the AR account for an invoice, show "split" in the detail account when there are multiple detail rows on the transaction, because no one account can be the 'other' account in this case.

 

If you don't want to see the accounting rows grouped by account, start with a Transaction Detail report, which displays all the accounting rows with no predefined grouping.

 

 

GlinetteC
Moderator

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.

BigRedConsulting
Community Champion

General Ledger Reporting


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

HAM9
Level 3

General Ledger Reporting

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

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us
Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up