Skip to main content
September 29, 2020
Question

Hello, How do I add Business Id of supplier as a column in report "Expenses by Supplier Summary"

  • September 29, 2020
  • 1 reply
  • 0 views
Original commenter did not share additional details

1 reply

September 29, 2020

Welcome to the Community, queenscrystalgar.

 

Adding supplier business ID as a column on your Expenses by Supplier Summary report is not included as one of the options in modifying columns on QuickBooks Online reports.

 

Alternatively, you can export the Expenses by Supplier Summary report to excel and manually add the column for your supplier's business ID.

 

Here's how:

  1. Go to Reports and enter Expenses by Supplier Summary on the search field.
  2. At the top of the report, select the Export icon. Then select Export to Excel.
  3. Save the file somewhere you can easily find, like your Downloads folder or your desktop.

In Excel, you’ll need to select Enable Editing to view the full report. Then, you can start adding the column.

 

You'll want to keep this article handy for your reference in exporting reports: Export your reports to Excel from QuickBooks Online.

 

Find out more about managing reports in QBO through the following articles:

I'll be right here if you have further questions. Keep safe and have a good one.