Hi Richard,
You should be able to do this kind of query using our tool called Cloudslurp. It lets you write full SQL queries on your data tables (like invoices) from Quickbooks as well as other tools.
I can see specifically there is these fields available for analysis:
TxnTaxDetail_TaxLine0_Amount |
TxnTaxDetail_TaxLine0_DetailType |
TxnTaxDetail_TaxLine0_TaxLineDetail_TaxRateRef_value |
TxnTaxDetail_TaxLine0_TaxLineDetail_PercentBased |
TxnTaxDetail_TaxLine0_TaxLineDetail_TaxPercent |
TxnTaxDetail_TaxLine0_TaxLineDetail_NetAmountTaxable |
Check it out!
https://www.cloudslurp.com
Many thanks!
Adam
