When im trying to extract sales tax liability report, we cannot click on the sumtotal button , there is no hyperlink to it , so the sumtotal buttoncant expand to fullest

It's nice to have you here, sudeshna-chakrab.

The Sales Tax Liability report shows only the following columns: Tax Name, Gross Total, Non-Taxable, Taxable Amount, and Tax Amount. There is no sumtotal button. See attached screenshot below:

Learn more about using the Sales Tax Liability report in QBO: Check how much sales tax you owe in QuickBooks Online.

Also, when you export this report, the option to click the hyperlink in the total is unavailable.

Find out more about the process of exporting data from QBO through this article: Export Data out of QuickBooks Online.

Additionally, you can check out this article about the complete sales tax workflow: Sales Tax in QuickBooks Online.

Let me know if you mean something else and I would appreciate any additional information. It would be my pleasure to help. Have a good one!

Hi sudeshna-chakrab.

Hope you’re doing great. I wanted to see extracting sales tax liability report that you had the other day. Was it resolved? Do you need any additional help or clarification? If you do, just let me know. I’d be happy to help you at any time.

Looking forward to your reply. Have a pleasant day ahead!

Hi co-ordinator

Thanks for the reply, could you help us in understanding if there is any other alternative method or any other report that we could run as manually, clicking on one by one line would be time consuming , because when we click on the sumtotal we can get the entire report extracted, is there any other alternative/

Thanks

Sudeshna

I know a report that can provide the details you need, Sudeshna.

In QuickBooks Online, you can run the Transaction Detail by Account report to view both sides of your transactions. This report includes the type of transaction, date, account, subtotals, and totals. It’s also the closest report you can generate to see the tax amount in each transaction.

Here’s how:

1. Select the Reports menu.
2. Enter/select Transaction Detail by Account.
3. Click Customize.
4. Select the date period.
5. Under Rows/Columns, select Tax Amount.
6. Press Run report.

I’ve attached a reference in case you want to keep the same report settings for future use: Memorize reports in QuickBooks Online. It helps you access the information quickly to save time.

If you need further assistance with managing reports, just add a comment below. We’re always here to assist you. Have a good one!