1. Pull up your items list in quickbooks.
  2. Click File>Export to Excel.
  3. In the popup window, select book 1.
  4. Under template, click POS Export.
  5. Click the next button.
  6. Click export and download the report in .xlsx or .csv format.