Creating and memorizing the reports you want with “Custom Transaction Detail Report”

The custom transaction detail report is the most flexible reporting tool in QuickBooks. You can select specific transaction data, which fields of information you want to see in the report, how the information is sorted, and how it is subtotaled.  Once you have designed your report you can even memorize the settings for repeated use.

The dialogue box shown below gives you an idea of the display, sort, and total options.

Below is a report with only a single report total.  Unless you have selected a specific account it probably doesn’t seem that useful

We have changed the total option for this same report to “account list”  As you can see, we could just have easily totalled by “vendor” or “customer”.  Now we have a report we can use.

As you can see below, there is a tremendous selection of fields to select on and display in your report.  You also have substantial flexibility in how you want to organize your report to be be most meaningful to you.  Once you have designed your custom report, simply choose “Memorize”, give the report a name, and assign it to an existing  memorized report group or create a new group.


Robert Guild is certified QuickBooks ProAdvisor in Austin, TX who conducts CPE courses for CPAs and individual training and group classes to QuickBooks users. His company at www.QBCoach.biz, maintains a sixteen-station QuickBooks lab, providing hands-on training. You can contact him directly at rguild@QBCoach.biz or follow him on twitter at QBPro