Import customer history into point of sale from quickbooks pro
Hello, and welcome to the Community, Jennifer24CAG.
The first step in importing customer data from QuickBooks Desktop to Point of Sale is exporting the information from your company file. You can export customer lists into an Excel spreadsheet and then import that file to your POS system.
I'll guide you through how client data is exported from QBDT Pro: 1. Access the Customer/Vendor/Payroll center. 2. Choose the Excel drop-down menu and pick one of the displayed options.
Export Customer/Vendor/Employee list - This is used to export customer data such as names, balances and contact details.
Export Transactions - You can export transactions (either by names or transaction types) with this option.
3. An Export window will display, elect to create a new worksheet or update an existing worksheet. 4. Select the Export button. MS Excel will be run by QuickBooks where the info can be edited if necessary.
You can import the Customer record details from QuickBooks Pro into QuickBooks Point of Sales using the process described above but QuickBooks Point of Sale does not support importing transaction data in the User Interface that I think you are looking for.
However you can use a third party data import utility like Zed Axis to export transaction data from QuickBooks POS and then import it into QuickBooks Point of Sale. There is a playlist of demonstrations of Zed Axis importing into QuickBooks Point of Sale below