Question

Custom Transaction Detail Report

Forum|Forum|6 years ago
April 2, 2020
9 replies
68 views

I am trying to run a Custom Transaction Detail Report that details just the checks written for a specific time period. The key is I only want one line per check. I don't want to see all the detail account lines that the check is broken down into. I really just need to see the following (one line per check number):

Date, Check Number, Payee, Check Amount

QuickBooks Desktop

C

continea

Level 5

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.

Go to Reports, then Custom Report, and select Transaction Detail.
Select Customize report.
Enter the Report Date Range.
Under the Columns area, uncheck these things: Memo, Account, Class, Clr, Split, Debit, Credit, and Balance.
Go to the Filters tab, in the search engine type, TransactionType, and select that choice.
In the drop-down, instead of all transactions, click Checks.
Select OK.
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.

BigRedConsulting

Level 15

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.

K

Kim9669

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.

F

fhall55

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

M

MirriamM

QuickBooks Team

Thanks for joining the thread, @fhall55.

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

Here's how:

Go to the Reports menu at the top.
Select Custom Reports, then click Transaction Detail.
In the Modify Report window, select the Display tab.
Go to the Columns section, then type in and select Date, Name, Account, and Amount in the search field.
Set the other necessary filters.
Click the Filters tab.
In the Search field, type in Account and select Admission Taxes.
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.

Sign up

Login with SSO

Let's get you signed in

Login with SSO