cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Want an expert to help you set up your QuickBooks Online? Find out how: Click here
Serguei
Level 1
posted
‎June 30, 2020 01:41 PM
last updated ‎October 05, 2020 7:51 PM

Transaction Detail by Account Custom Format

Hello,

 

I need to run a transaction detail report that includes all expense accounts but I am looking for a specific format so I can easily pivot the data.

 

This is the format I need to create a pivot table by account easily. Is there a way to run a report like this with the expense account number next to each transaction and no totals? Just a list of all expense transactions with the account number next to each transaction.

 

Thanks.

 

Reply
1 Comment 1
IamjuViel
QuickBooks Team
QuickBooks Team
‎June 30, 2020 03:02 PM

Transaction Detail by Account Custom Format

Hello, @Serguei.

 

You can customize the Transaction Detail by Account report. I can guide you on how to do it.

  1. Open the Transaction Detail by Account report.
  2. Click the Customize button.
  3. From the Rows/Columns section, click the Change Columns link.
  4. Mark the tick box of the columns or the information you want to include in the report. 
  5. Hover your mouse cursor to the square of dots beside the tick box for each column.
    • This way, you can change the order of the columns.
  6. Drag and drop it to your desired order.
  7. From the Group by drop-down, select None.
  8. Click the Run Report button. 

You can save the customisation you've made for future use. Also, you download and email the report.

 

Fill me in if you have other questions about generating reports in QuickBooks. I'm always here to help.

Reply