How to Export Supplier TRN numbers or Business id from online Quick book.

I'll share details about exporting your suppliers’ Tax Registration Numbers (TRNs) or Business IDs in QuickBooks Online (QBO), Bardem.

Currently, QBO doesn’t offer a direct feature for exporting this information. As a workaround, I recommend entering the TRN or Business ID in the Notes section of each supplier profile. Then, run and customise the Contact List report to include these details.

To do that:

1. Go to Expenses and select Suppliers.
2. Select the supplier's name and click Edit.
3. In the Notes and Attachments section, enter the TRN or Business ID in the Notes field, then Save.

Once done, here's how to run and export the Contact List report:

1. Go to Reports and search Supplier Contact List.
2. Click Switch to Classic View, then Customise.
3. In the Rows/Columns dropdown, select Change Columns.
4. Put a check in the Note box.
5. Click Run report.
6. Select the Export icon dropdown and choose between Export to Excel, Export to PDF, and Export to Google Sheets.

For a visual overview of your supplier interactions, you may find this guide helpful: How to view and edit supplier transactions in QuickBooks Online.

Please don't hesitate to inform us of any concerns you have about managing your suppliers. The Community is available 24/7 to lend you a helping hand. Stay safe and have a great one.