Transaction detail report to include inactive accounts

Thanks for reaching out to us, BGLaffoon. Let me get the help you need in running the report you want.

The option to include inactive accounts when running Transaction Detail report is unavailable. However, we can run an inactive inventory items on the report like the Transaction Detail by Account. Let me show you how:

1. Click Reports on the top menu.
2. Choose Accountant & Taxes.
3. Select Transaction Detail by Account.
4. Tick Customize Report.
5. Tap Filters.
6. Enter Inactive Inventory Items on the search Filter fields. 
7. Place a checkmark on the Show inactive inventory items option.
8. Press OK.

We can also display inactive data in a report if a report has rows or columns that show only zero amounts. Though this option is not available for all reports. Here's how:

1. Open the report you'll want to run. 

2. In the Customize Report window, click Advanced.

3. Under Display Rows and Display Columns select one of these options:

   • Active, to display only rows and columns that showed activity during the report period. Some amounts may be zero if there were transactions that canceled each other out.

   • All, to display all rows and columns, regardless of whether they showed activity during the period covered by the report.

   • Non-zero, to display only those rows or columns that show activity during the period covered by the report and contain at least one non-zero amount.

4. Click OK in both the Advanced Options and Modify Report windows.

If you need to export the report to Excel to manually add the inactive accounts, just follow the steps below: 

1. Click the Excel drop-down from the top menu, then Create New Worksheet.
2. Tap Export.
3. Tap the Excel drop-down, then Create New Worksheet.
4. Press Export. 

Here's an article you can refer to for more details about exporting reports as Excel workbooks in QuickBooks Desktop. For additional information about the available reports you can run in QuickBooks Desktop and how to use them, here's a resource you can read: Understand reports.

Should you have additional questions or need further help, please let me know by adding a comment below. I'll be more than happy to answer them for you. Have a nice day!