Export Purchase order to vendor using excel or csv file

Thanks for turning to the Community about your concern, Erss.

I recognize the importance of being able to automatically create a CSV file for your purchase orders. This will both save your time and money for the business.

Let’s run the Transaction List by Vendor report and customize it to show the transactions mentioned above. Then export it to Excel, so you’ll be able to convert it to a CSV file.

Here’s how:

1. In QuickBooks Desktop (QBDT), go to the Reports menu at the top bar to choose Vendors & Payables and then select Transaction List by Vendor.
2. Click the Dates drop-down to set the correct reporting period.
3. Tap the Customize Report button in the upper right to open the Modify Report: Transaction List by Vendor window.
4. Navigate to the Filters tab and enter Transaction Type in the search box.
5. From the Transaction Type drop-down, select Purchase Order.
6. Press the OK button for the changes to take effect.
7. Click the Excel drop-down and pick Create New Worksheet.
8. This action will take you to the Send Report to Excel window.
9. Follow the on-screen instructions to complete the process.

Since the data is on an Excel file, I suggest using a third-party application to help convert the file to a CSV. You can visit the QuickBooks Apps Center to see the list of supported software.

For more insights into this process, check the following article: Customize reports in QuickBooks Desktop. It provides detailed information on how to set your reporting preferences, memorize a statement, etc.

We’ve collated resources to help customers easily view all reports available in QBDT. From there, you'll learn how to export one to Excel.

• Create and manage reports
• Export reports as Excel workbooks in QuickBooks Desktop

Feel free to post a comment below if you still need help with creating a CSV file for purchase orders. I’m always ready to assist further. Have a good one.