Custom Transaction Detail Report

Good afternoon Chadk,

Happy to see you here in the QuickBooks Community today. Here's how to get that customized Customer Transaction Report that you're wanting. 

1. Go to Reports, then Custom Report, and select Transaction Detail.
2. Select Customize report.
3. Enter the Report Date Range.
4. Under the Columns area, uncheck these things: Memo, Account, Class, Clr, Split, Debit, Credit, and Balance.
5. Go to the Filters tab, in the search engine type, TransactionType, and select that choice.
6. In the drop-down, instead of all transactions, click Checks.
7. Select OK.
8. Click the Refresh option so that the changes can be reflected.

Once following these steps, you should have the Date, Check Number, Payee, Check Amount. If you have any other questions, please reach out to me, and I hope you have a lovely day.

To see only one line for each transaction, customize the report and on the filters tab find the Detail Level filter and pick Summary Only.

With a Custom Transaction Detail Report, I want a detailed list of the amount of Admission Taxes that are collected in a month. The columns I want are : dated, Name, Account, amount and total amount.  Previously, I was able to get this report in QB for Windows 2011 Desktop but not able to get it now. Thanks

Thanks for joining the thread, @fhall55.

Let me get the help you need in running the report you want.

Here's how:

1. Go to the Reports menu at the top.
2. Select Custom Reports, then click Transaction Detail.
3. In the Modify Report window, select the Display tab.
4. Go to the Columns section, then type in and select Date, Name, Account, and Amount in the search field.
5. Set the other necessary filters.
6. Click the Filters tab.
7. In the Search field, type in Account and select Admission Taxes.
8. Click OK. 

To know more about customizing your reports, check out this article: Customize reports in QuickBooks Desktop. You can also memorize it to save its current customization settings. It serves as your record and helps you quickly access it for future use.

I'm also adding this resource to know more about how QuickBooks generates reports and displays data based on a set of instructions: Understand reports. It also includes the complete list of available reports that you can run and their description.

Let me know if you have other concerns with managing reports in QuickBooks. I'll get back to you right away. Have a great day.

I am trying to create a similar report - a list of all items in the Contract Earnings account - but do not need each line item on each invoice indicated on separate lines in the report.  I need each invoice and it's total on one single line in the report.  When I go to the Customize Report box > Filters tab > Detail Level filter > Summary Only, the report is empty.

Filters > Detail Level > Summary Only did not remove the duplicate lines per transaction (invoices list) - the report was empty after clicking on OK.

Hello there, @Kim090669.

There's a possible reason why a report will show as empty after customizing. We can double-check the date set up if it's selected correctly. Make sure the report date covers the date of the transactions. Please take a look at this sample screenshot:

If the reporting period is properly set up and still, showing as empty, we can run the verify rebuild to fix data-related issues on a company file. The steps below will guide you through the process.

1. Go to the File menu.
2. Select Utilities.
3. Click Verify Data then select OK to close all windows.
4. Then, go back to the File menu.
5. Select Rebuild Data under Utilities.
6. QuickBooks will ask to make a backup before rebuilding your company file, select OK.
7. Once the rebuild is done, click OK.
   

I've collected some articles where you can get additional details about managing reports:

• Customize reports in QuickBooks Desktop.
• Create, access, and modify memorized reports.

I'm always here whenever you need help with QuickBooks Desktop reports. Stay safe and have a good one!

Is there a way to add the "Reference No." to a Transaction Detail report for checks that are Bill Payments?

Welcome to the Community space, @BradleyLawyer. Let me help share insights about adding reference no. in your Transaction Detail report in QuickBooks.

The option to add a reference no. in your Transaction Detail report is unavailable in QuickBooks Desktop. I can see how important this feature is for you and your business. Rest assured that our engineers are working nonstop to enhance the product for our customer's convenience.  

Furthermore, I'd recommend sending your feedback to our product development team. This way, they can review it and might consider adding this in our future updates.

To send feedback in QuickBooks Desktop (QBDT), Here's how:

1. Go to the Help menu at the top.
2. Select Send Feedback Online.
3. Click Product Suggestion.
4. Choose a feedback type and product area on the QuickBooks Feedback window. 
5. Enter your suggestion or feedback, name, and email address (optional).
6. Once done, click on the Send Feedback button.

Also, I'll be sharing these articles that will guide you in running different reports and how to customize them in QuickBooks:

• Understand reports
• Customize customer, job, and sales reports in QuickBooks Desktop

If you have any other QuickBooks concerns, feel free to leave a reply below. I'm always ready to lend you a hand. Take care and have a good one.