How do I export customers into QuickBooks?
You can export the Customer, Vendor, Payroll lists and transactions as well as Items list into an Excel spreadsheet. If you need to the change a report appearance or contents in ways that are not available in QuickBooks, you can also export reports and the customize it in Excel without affecting your QuickBooks data Open the Customer/Vendor/Payroll center. Click the Excel drop-down and choose: Export Customer/Vendor/Employee list if you want to export customer/vendor/employee data such as name, balances and contact information. Export Transactions if you want to export transactions (either by name or transaction type). In the Export window, choose whether to create a new worksheet orupdate an existing worksheet. Click the Export QuickBooks opens MS Excel and you can edit the information as needed. To export Report. Open the report you want to export. Click the Excel drop down at the to...