Hi there, @FMW.
I'd be glad to help create a custom report to show the total quantities and the item purchased by the customer.
Here' how:
- In your QuickBooks, go to the Reports menu.
- Choose Custom Reports and then select Summary.
- In the Display tab, go to the Columns section.
- In the Display columns by drop-down, select Item detail.
- Choose Customer in the Display rows by drop-down.
- Under Display columns for, select the Quantity radio button.
- Once done, click OK.
Also, you can add some filters on the report to show the accounts and items you want to see in it. You can do this by selecting the Customize Report button.
I've added this article that can guide you in exporting reports into Excel if you want to remove some columns on it.
Don't hesitate to click the Reply button if you have other concerns. I'm here to lend a hand.