cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Want an expert to help you set up your QuickBooks Online? Find out how: Click here
queenscrystalgar
Level 1

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

 
1 Comment 1
Charies_M
Moderator

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

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.