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
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
- Copy the prompt above
- Open Shopify Sidekick in your Shopify admin
- Paste the prompt and replace the bracketed placeholders with your details
- Review Sidekick's response and apply the suggestions