I need a report that shows both sales amounts (taxable and non-taxable) and the sales tax amount for a sales tax audit.

Auditor requested:

Date   Inv#    Customer Name    Taxable Amt   (Non-Tax Amt)   Tax

Whatever Sales reports I run, I get every detail line of every invoice, including sales tax. Or if I run a Sales Tax Liability report and drill down to Detail, I only get sales $ or tax $ but not both in one report.

I am looking for a report that is "mid-way" between a Summary Report and a Detail Report. I don't want or need every line of an invoice, but I need each invoice not just a total by Customer or Item.

Can this be done? QBDT Enterprise 18