Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.

Reply to message

View discussion in a popup

Replying to:
SarahannC
Moderator

Reply to message

Thank you for sharing your concern in the Community forum, HFDTreasurer.

 

I appreciate you for providing further details on what help you want from us. It's a good thing that you've tried running reports in QuickBooks Online, what you've figured about the Account Lists and Balance Sheet report is correct. 

 

We can run the Transaction Detail by Account report and modify it to your desired setup. This way, QuickBooks will generate bank balances with the transactions associated with it. The total amount only shows in the Amount column. Let me show you how:

 

  1. Go to Reports on the left panel.
  2. In the search box, enter Transaction Detail by Account. Then, click the Customize button at the upper-right corner.
  3. In the Rows/Columns section, include the Balance, Transaction Type, Amount, and Date. Note: You can change the columns or add more if you want. 
  4. In the Filter section, put a check-mark of the Distribution Account.
  5. Click the drop-down arrow and tick all the accounts you want to display on the report.
  6. Then, hit Run report and ensure to set the correct dates.

 

If you'd like to get the total amount of the balance, I would suggest exporting it to Excel. From there, we can manually calculate the total balance of the particular account. Click the Export icon and select Export to Excel. That will do. Let's see this sample screenshot:

 

 

Here are some articles that provide additional details about managing report in the Online product:
 

 

Let me if you have other follow-up questions about it. I'm right here to help you figure them out. Have a good and take care always!

Need to get in touch?

Contact us