Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
In Point of Sale, I'm trying to export a customers sales history to Excel so that the data can be deeply analyzed.
We allow customers and employees to have an account on the books of items that they still need to pay for. One customer would like to find out why he owes what he owes. To do so, we need to be able to reconcile his account. The POS allows us to print the history or save it as a pdf. Neither will then import to Excel so that we can reconcile the account.
Is there something that I am missing or does POS not allow the customer history to be sent to Excel?
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:
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:
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.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here