I would like to generate a list of suppliers with their Business ID No. but the field is not showing up in the customized reports. Any ideas on how to do it?
Ideally, I need a report of all my expenses with the suppliers and their tax numbers included - or at the very least a report of all the suppliers with their tax id numbers.
Hi there, @xworks.
Thanks for visiting the Community. You can run the Suppliers Contact List report to generate all the suppliers with their Tax ID numbers.
That will show all your suppliers with their Tax ID numbers. For future reference, read through this help article: Filter, search, and sort with custom fields. It will help you learn about customizing your report to track specific details that are important to your business.
Feel free to visit again if you need anything else. We're always around to help.
Thank you for providing additional information about report settings, @xworks.
The option to add the Business ID No column in any of your supplier reports in currently unavailable. However, you can manually transfer or copy that information in the Other field in your supplier's profile. This way, you'll be able to display your supplier's Business ID No in your reports.
I've attached screenshots below for your reference.
Once done, go to the Reports menu, then pull up the Suppliers Contact List report and add the Other option in the Settings icon.
If you want to save the customisation you've just made to the report, you can visit this article for the detailed steps: Customise reports in QuickBooks Online. It also contains information on how to share it through email.
While QuickBooks doesn't have the option to display the Business ID No in your reports, I encourage letting our developers know about this to consider in the future product upgrade. You can visit this link to view the latest improvements in the system: The QuickBooks Blog.
Please let me know if you have other concerns. I'm just around to help.
Oh, that's a bummer.
I actually couldn't fathom why the tax field cannot be displayed. It doesn't make sense.
Anyhow, I hope there is a way to mass update the fields? I strongly doubt it but i hope there is?