cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Have a question you would like to ask our community of experts and fellow QuickBooks Accountants and SMB's? Post a question here
Memory Tadiswa
Level 1

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.

9 Comments 9
RCV
QuickBooks Team
QuickBooks Team

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

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.

dthurtleanderson
Level 2

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

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.

Rasa-LilaM
QuickBooks Team

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

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.

kelmel
Level 1

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.

Rose-A
Moderator

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.

asun
Level 1

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

You can run General Ledger Report. This report has opening and closing balance. 

NChis
Level 1

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

What didn't QB give that answer!!

atxsooner
Level 1

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

I don't see a general ledge report option available. Are you using QBO? If so, which version and where can I find GL report?

RenjolynC
QuickBooks Team

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

Thanks for chiming in on this thread, atxsooner.

 

The General Ledger report is available in QuickBooks Online Simple Start, Essentials, and Plus. Here's an article for reference: Reports included in your QuickBooks Online subscription.

 

To run the report, here's how:

 

  1. Go to Reports on the left panel. 
  2. Type General Ledger in the search field or click the report under For my accountant section.
  3. Set the Report period and click Run report.

Here's a sample screenshot for a visual reference:

 

 

To customise the report, you can check on the link provided by my colleague Rose-A.

 

In case you need help with other task in QuickBooks Online, please feel free to visit our general help topics page. 

 

You can get back to me here if you have any follow-up questions or other concerns. I'm here to help you out some more. Take care!