cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

How do i view a transaction detail report with an opening and closing balance

i am trying to view my bank account and want to see all the transactions i have posted . i am using the transaction detail by account report. I want this report to include opening and closing balance.

5 Comments
QuickBooks Team

Good to hear from you, ashleigh. If you're referring to a...

Good to hear from you, ashleigh.

 

If you're referring to adding a closing and opening balance column in the Transaction Detail by Account report, this option is unavailable. However, the closing balance will show as the total amount per transaction in the Amount column.

 

You might want to export the report to Excel and customise it to come up with the data you need.

I have articles here about managing reports in QuickBooks Online (QBO):

 

You can always reply to this post if you need anything else with running reports. I'm always here to help.

Not applicable

Re: Good to hear from you, ashleigh. If you're referring to a...

This is a hugely problematic limitation in QBO.  How can I have an accurate running balance in an account, if the transaction detail report won't include the opening balance?  The running balance will always be wrong.

QuickBooks Team

Re: Good to hear from you, ashleigh. If you're referring to a...

Hey there, @dthurtleanderson.


I know how important it is to have accurate financial records. Instead of running the Transaction Detail Account, you can open the Balance Sheet Report to show the opening balance.


Here’s how:

 

  1. Go to the Reports menu on the left panel to access the Standard tab.
  2. Select Balance Sheet under the Business overview section.
  3. Hit the report to see all accounts.
  4. From there, select the bank you’re working on and then click the amount to see the transaction details.
    bs.png bs1.png bs2.png

Perform the same steps to view each account’s opening balance.

 

If you want to add more details about the report and steps to personalize it, check out the Customize Reports and Email article.


Let me know if you have any other concerns or questions. I’m here ready to assist further. Have a good one.

Experienced Member

Re: How do i view a transaction detail report with an opening and closing balance

Hello, 

 

I found this thread looking for the same information.  After reading QB's reply, I created my own work around that avoids manipulating the data in excel.  

 

Run the Balance Sheet, then click on amount shown for Total Assets.  From here, customize your report to include all Distribution Accounts.

 

I agree this report should be standard.  I seem to remember having this on Desktop.  Manipulating the data in Excel every time I want this report is not acceptable.

 

Hope this helps.

Moderator

Re: How do i view a transaction detail report with an opening and closing balance

Hi, kelmel.

 

I appreciate the details you've provided about viewing the transaction detail report in QuickBooks Online. The information you posted will definitely help other customers who may have the same concern.

 

The following articles are good references for customising your reports in QuickBooks Online:

 

In case you want to know some "How do I" steps in QuickBooks Online, you can always visit our Help Articles page for reference.

 

Don't hesitate to get back to me if you need further assistance with QuickBooks. You have a wonderful day.