Skip to main content

SUMMER SAVINGS 90% OFF QuickBooks for 3 months* Ends 8/27

Buy now
Switch to QuickBooks and 70% off for 3 Months
Talk to Sales: 877-683-3280
Hours
Mon - Fri, 5am - 6pm PST
Sat - Sun, 7am - 4pm PST
Product support & help
Need help signing in?
myelspand733
February 8, 2022
Question

Produce a general ledger summary for a time period

  • February 8, 2022
  • 5 replies
  • 183 views

I want to produce a report that, in effect, produces a journal entry for the ledger activity over a period of time. I need to run this report for "January", "February", "March", etc. So far, I can run the General Ledger report and add columns for "Debit", "Credit", and "Account#". The issues I can observe are:

  • It includes accounts with zero activity (the "Beginning Balance"). 
  • It produces a grouping summary for each account
  • It provides detailed transactions for accounts that do have activity - I'm wanting the summary of activity. 

The goal is to produce the journal entry for a period's activity so that it can easily be exported/imported into another financial system.

Many thanks for the community's consideration of this issue.

5 replies

DebSheenD
Level 5
February 8, 2022

I've got you covered, myelspand733.

 

Thank you for posting your concern here in the Community. I'm here to share on how you can generate a journal entry report in QuickBooks Online.

 

Customizing your report enables you to add or remove details from it. This way, you can personalize it in just a few steps.

 

  1. Go to the Reports menu.
  2. Find and open a report. Tip: If you have QuickBooks Online Essentials, Plus, or Advanced, you can also run "Detail" versions of standard reports.
  3. Use the basic filters on the report to adjust things like the report dates.
  4. Choose Customize.


You can check this article for more details: Customize reports in QuickBooks Online.

 

After the customization, you can now export a report in each period. Here's how:
 

  1. Choose  Reports.
  2. Search for and select the report you want to export.
  3. At the top of the report, select the Export icon. Then click Export to Excel.
  4. Save the file somewhere you can easily find it, like your Downloads folder or your desktop.

 

Feel free to check out these articles if you need more references and guidance when running reports in QBO: 

 


I'm happy to offer assistance again if you have more questions about running reports. Post a new thread or reply here and I'll be there.  Have a good one!

myelspand733Author
February 8, 2022

Thank you. But this doesn't really cover my issue. I am trying to remove report "groupings". I am also trying to get a summary of the detailed data. The total of general ledger activity by account.

Rubielyn_J
Rubielyn_J
Level 8
February 8, 2022

Thanks for getting back to this thread, @myelspand733. Let me clarify things about generating a General Ledger summary report. 

 

Normally, when you run the report, it shows detailed transactions for each account. This is because a General Ledger refers to a record containing individual accounts showcasing the transactions related to each of such accounts. It is a group or collection of accounts that give you information regarding the detailed transactions with respect to each of such accounts.

 

If you wish to have a summary of it, I suggest exporting the report to an Excel file. From there, you can manipulate the records to have the data you wanted. 

 

To proceed, please follow the steps below: 

 

  1. In QuickBooks, go to the Reports menu and choose the Reports Center.
  2. Find and open the General Ledger report.
  3. Click the Excel on the toolbar.
  4. To create a new Excel workbook, select Create New Worksheet. 

  5. Once ready, choose OK.
  6. To open the report in Excel, click the Export button.

 

Then, open the downloaded Excel file. From there, exclude the accounts with zero activity and produce the journal entry for a period's activity.

 

Additionally, let me share these relevant articles that can further help you manage statements in QuickBooks Desktop:

 

Don't hesitate to comment below if you have other questions about producing a General Ledger summary report. I'll be around to assist you. Keep safe and have a good one!

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.
Terms & ConditionsAccessibility statement