Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
I manage the money for student clubs at my school and am looking for a better way of letting the advisors know what transactions have cleared and what the account balance is. I would like a report that shows all the transactions for the fiscal year and the running account balance but does NOT show the “total” of the difference between credits and debits. The closest I’ve gotten to this is the Balance Sheet, but at the bottom it shows the total. The total just causes confusion, especially when the total is negative, as the advisors think that’s the account balance. I really wish I could make a report look something like a bank statement, with beginning balance, transactions, and ending balance. Is there a better report I should be using? Or is there a way to not show the total on the Balance Sheet?
Hi, @Stacy680. Welcome to the QuickBooks Community.
If transactions are grouped by account, the report shows the total per account by default. I can suggest a report that's closer to your specifications.
To achieve a report that resembles a bank statement without the total of the difference between credits and debits, you can use the "Transaction Detail by Account" report in QuickBooks Accountant Online (QBAO). This report can be customized to show the transactions for the fiscal year and the running balance of each transaction. Let me show you the general steps where you can perform further customizations moving forward.
However, for the running account balance, I suggest exporting the report to Excel and adding the data from there. You may refer to this guide for the exporting process: Export your reports to Excel from QuickBooks Online.
After making the customizations for the report, let me add this reference on how to save these settings for future use: Memorize reports in QuickBooks Online.
You're always welcome in the Community should you have further questions about running reports in QBAO. We'll do our best to assist. Have a great day ahead!
Thank you for your reply.
Unfortunately, I don't think this solution is going to be better than my "Balance Sheet" report. The "Transaction Report by Detail" still has the "Total" at the bottom, which is what I'm trying to avoid. Plus, I currently have the Balance Sheet report set to run and email advisors automatically, so having to import into Excel would take a lot more of my time when it doesn't fix the Total problem.
I have been unable to find a report that gives a beginning account balance (although this part is not as important as the other two parts), an ending account balance, and the transactions that got me there, but maybe that report just doesn't exist. Is there any way to create a custom report that would do these things?
Hello, Stacy680.
I understand you're looking for a report in QuickBooks that doesn't show the Total. Unfortunately, this such a report is unavailable in QuickBooks. Our team is constantly working to improve our services and make more reports available to our users, so I suggest sending feedback to our Product engineering team. Your Feedback is extremely important to us as it can help us create better products and services.
Our Product Engineering team is always looking for ways to improve and enhance our offerings, so your suggestions are very valuable. By sending your Feedback to our team, you may allow them to carefully evaluate and consider your ideas for inclusion in our future product developments. So, please don't hesitate to share your thoughts with us. We appreciate your input.
Here's how:
Your feedback is valuable to us and helps us improve QuickBooks. You can track feature requests through the QuickBooks Online Feature Requests website.
To learn more about customizing reports, kindly refer to this article: Customize reports. Then, if you want to memorize the personalized report, feel free to check out this article for the detailed steps and information: Memorizing reports.
Your valuable feedback is important to us and will help us improve your experience in QuickBooks. So please don't hesitate to contact us again if you need further help. I'll be happy to extend another service for you. Have a great day!
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here