Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.
EDT2
Level 1

Not detailed general ledger report

Hi,

 

My company is having an insurance audit and they requested a "not detailed general ledger report". Is there any way to summarize a general ledger in QB desktop? or would that just be a Balance sheet summary report?

 

Thank you!

2 Comments 2
VoltF
QuickBooks Team

Not detailed general ledger report

Welcome to the Community, EDT2!

 

In QuickBooks Desktop, the General Ledger report offers a comprehensive summary of all general ledger accounts, including their balances and activity.

 

Here's how you can generate a summary of the general ledger in QuickBooks Desktop:

 

  1. Launch QuickBooks Desktop and open your company file.
  2. From the top menu, go to Reports and select Accountant & Taxes.
  3. In the submenu, choose General Ledger.

 

QuickBooks generates a General Ledger report, providing a tabular summary of all accounts, including activity and balances for a specified period.

 

The General Ledger report, by default, displays all accounts and fiscal year activity, but can be customized to meet specific requirements. Here's how to customize the report:

 

  1. Click the Customize Report button at the top left of the General Ledger report window.
  2. In the Display tab, you can specify the desired date range and other options.
  3. The report can be customized with columns, fonts, headers/footers, and other settings as per your requirements. Click OK to generate the customized report.

 

Furthermore, after customizing the report, QuickBooks will display the summary of all general ledger accounts based on your specified criteria.

 

The General Ledger report may not align with your previously mentioned detailed report. Export the report to Excel for a summarized version focusing on account balances.

 

Additionally, please check out these articles to get additional insights and information:

 

 

Feel free to comment below for further assistance or more questions about running reports in QuickBooks Desktop. I'm sure to help anytime. Have a great day!

Rainflurry
Level 15

Not detailed general ledger report

@EDT2 

 

A balance sheet won't work.  It doesn't contain income and expense accounts that are part of your general ledger.  I'm guessing the auditor wants to see a cleaned-up version of the General Ledger report (Reports > Accounting & Taxes > General Ledger).  You can clean up the report by removing the 'Split' account (the offsetting credit to the debit and debit to the credit).  Click 'Customize Report' and under 'Columns' remove the check mark by 'Split' and any other columns you want removed from the default report.    

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

Need to get in touch?

Contact us