Analytics 💎 Built for Sidekick ⚡ Sidekick does this for you
shopify sidekick analytics tax

Report Tax Collected Summary

Summarize tax collected by region and period from completed orders, ready to hand to a bookkeeper.

📋 Prompt
Run in Sidekick
Summarize tax collected on orders for [LAST QUARTER / LAST MONTH], broken down by [STATE/PROVINCE / COUNTRY].

Per region:

  Number of taxable orders
  Total taxable revenue
  Total tax collected
  Effective tax rate applied (tax collected ÷ taxable revenue)


Also include:

  Total tax collected across all regions for the period
  Orders marked tax-exempt, counted separately with the reason if recorded
  Any region where the effective rate looks inconsistent within itself (a sign a rate may have changed mid-period or a rule is misconfigured)


Output format:

  Table: region, taxable orders, taxable revenue, tax collected, effective rate
  Total row at the bottom


Deliverables:

  The table, ready to export or hand to whoever files sales tax
  Flag any region with an inconsistent effective rate for manual review
  Note: this report is for the merchant’s own reconciliation — it does not constitute a tax filing and any registration/nexus questions still need a tax professional’s sign-off

How to Use

  1. Copy the prompt above
  2. Open Shopify Sidekick in your Shopify admin
  3. Paste the prompt and replace the bracketed placeholders with your details
  4. Review Sidekick's response and apply the suggestions