Showing results for 
Search instead for 
Did you mean: 
NEW Connect to DBS IDEAL direct bank feeds Click here
Level 1

How do I get tax percentage in the Excel

When I export all my invoices am getting only Tax Value, I need Tax percentage of that value
1 Comment 1
QuickBooks Team

How do I get tax percentage in the Excel

We're glad to have you here today, info1893. 


If you're referring to reports, we're currently unable to customize them in QuickBooks Online (QBO) to display the Tax percentage and export them to Excel


In the meantime, we can manually enter the tax percentages in Excel or format the cells. Here's how to locate them in QBO:


  1. Go to the Sales tab and select Invoices.
  2. Select the invoice and click Edit invoice.
  3. Under the Tax column on the Invoice page, you'll see the sales tax. 


Additionally, you can personalise the appearance of your sales forms. This way, you can add specific info to your invoices and enhance your business communications.


Feel free to reply below if you have follow-up concerns with exporting invoices to Excel. The Community is here to help.