cancel
Showing results for 
Search instead for 
Did you mean: 
myelspand733
Level 1

Produce a general ledger summary for a time period

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 Comments 5
DebSheenD
QuickBooks Team

Produce a general ledger summary for a time period

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!

myelspand733
Level 1

Produce a general ledger summary for a time period

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
QuickBooks Team

Produce a general ledger summary for a time period

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!

TheTexasBatman
Level 1

Produce a general ledger summary for a time period

These responses are not helpful and certainly not what the originator asked for.  Like me, the original post is asking that the report not contain detailed data for the period.  Just the opening balance, TOTAL TRANSACTIONS for the period/month and the ending balance at the end of the period/month.  Just 3 lines instead of line after line after line after line of detail that isn't needed or wanted.  It was a very easy report to run in QB desktop.  Online seems to be geared towards the incredibly stupid and inexperienced at accounting.  A person with experience cannot easily navigate QB online since the menus are all severely "dumbed down."  I used desktop from the first year it was created and became a Certified Quickbooks Expert.  I only began using online recently and have found it to be a huge nightmare and geared more towards the person selling pottery out of their garage than for a well established business with an accounting staff.  To suggest that the only way to get G/L Summary Balances is by exporting your entire General Ledger to Excel and then sorting through hundreds of pages of data is just mind boggling.  If QB Online is incapable of generating such a simple and often used report, then it is not a very useful piece of software! (NOTE: I found this thread while searching for a way to run the report the same way)

katherinejoyceO
QuickBooks Team

Produce a general ledger summary for a time period

Thanks for sharing your joining in this thread to share your sentiments, @TheTexasBatman.

 

I understand to have the option to produce a general ledger summary for a time period. I'll make sure your request reach to our product engineers. That way, they can take a look and consider adding your idea to our features in the future. 

 

I'm also encouraging you to do the same by presenting your suggestions directly to them. 

 

Here's how:

 

  1. Go to HelpSend Feedback Online, then Product Suggestion.
  2. Choose a Type of Feedback and Product Area (optional) from the available drop-down menus.
  3. Enter any suggestions/feedback in your Here is my suggestion: field, then select Send Feedback.

 

 

Leave a comment below if you have any follow-up questions. I'll get back to you right away.

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us