Transaction Report with Running Account Balance but NOT Total

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. 

1. Go to Reports.
2. In the search field, type "Transaction Detail by Account" and select the report. (If you're on the Modern view, select Switch to classic view for better navigation.)
3. Click on Customize. 
4. From the Report period, select This Fiscal Year.
5. In the Rows/Columns section, select None from the Group by drop-down list. 
6.  Choose the details to include from the Select and reorder columns (e.g., Date, Name, Memo/Description, Debit, Credit, Amount, and Balance).
7. In the Filter section, put a checkmark on the Cleared box, and select Cleared.
8. Select Run report.

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: 

1. Select the Gear icon, then Feedback.
2. Enter your comments or product suggestions. Then tap Next to submit feedback.

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!