POS Customer reports by payment type

Hi there, @AGibbens. 

Thanks for posting your concern in the Community. If you're trying to move over or export customer account history to Excel, you can pull up the Customer Sales report instead, then export it to Excel. 

Let me show you how: 

1. Go to the Reports menu.
2. Select Customers, then choose Customer Sales. 
3. Customize the date in the Date drop-down list of your report. You can even customize it to show the specific detail of your report. 

From there, you can click the Excel arrow icon to export your report. See illustration below: 

For future reference, read through this article: QuickBooks Desktop Point of Sale: Import and Export overview. It helps you learn about importing and exporting your files using MS Excel. It includes templates formats to prevent errors when moving data files.

Feel free to visit again if you have additional concerns. We're delighted to assist you some more. 

One problem is that you can't filter the information by payment type (Account).

The information I need can be found in the Customer List report: When I click on the name I get the Edit Customer window:

This is the information I need to work with but, from here I cannot figure out how to export the information shown on the screen. If I click the "I Want To" button and the export to Excel, I get:

And if I try to highlight and copy paste, I get the item list screen.

Hi there, @AGibbens.

You're right, the option to filter the information by payment type (Account) isn't available in the Customer Sales report. However, we can use the Payment Summary report to view the payment type in QuickBooks Point of Sales (POS). Let me show you how:
 

1. Click the All reports menu.
2. In the Payments section, select Payment Summary.
3. Click Modify and select Add or Remove Columns.
4. Check the payment type that you want to be included in the report.
5. Select Save.

In addition, you can check out this article to better understand the process of integration between POS and QuickBooks Desktop. This also outlines the features of both programs that are allowed during the Financial Exchange: Financial Exchange Overview.

I'm always here to help if you have any other concerns or questions. Just tag my name in the comment section and I'll get back to you as soon as I can.