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:
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.
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.
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:
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!
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.
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:
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!
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)
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.
Leave a comment below if you have any follow-up questions. I'll get back to you right away.