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):

• Customise and modify columns on reports
• Customise your reports in QuickBooks Online
• Memorise reports
• Run reports

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

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.

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.
   

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.

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.

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:

• Customise your reports in QuickBooks Online.
• How to create memorised A/R reports with email reminders.

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.

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

What didn't QB give that answer!!

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?

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!