Yes, you can always generate a master list for your vendor and customer information in QuickBooks Online, vgorla. Let me assist you further and guide you through the process.
Running a master list report for your vendor and customer is possible. However, you have to take note that these two lists can only be exported separately.
To export Vendor Master Data (AP), you can follow the steps below:
- Go to the Report menu, then select Custom Reports.
- Type Vendor Contact List to export the necessary information of your vendors.
- Once done, click the More Actions dropdown list
- Click Export to Excel


Once done, we can now move forward to export your Customer Master Data. We're going to recreate the same process. However, we just have to select the correct report.
Here's how:
- Go to the Report menu, then select Custom Reports.
- Type Customer Contact List to export the necessary information of your customers.
- Once done, click the More Actions dropdown list.
- Click Export to Excel.


From there, it is up to your preference if you would like to combine both reports in Excel after being exported in QBO.
Additionally, you can read this article to have an overview of how exporting Customer reports is done in QBO: Export customer data to Excel.
Moreover, you can also customize reports for both your vendor and customer contact lists to filter or add information that will be essential to you.
Feel free to explore the customization options to tailor your reports, vgorla. Should you need any clarification on these steps, don't hesitate to ask by revisiting this thread. The Community is always here to help. Wishing you success in your business operations.