Skip to main content

Sales Tax Calculation, Collection, and Reporting

How sales tax is calculated, collected, and reported for bulk corporate gifting orders on Shopify: per-recipient tax calculation, one gifter payment, and how Shopify's Taxes and United States sales tax reports show Send To Many orders.

Sales tax is one of the biggest challenges in corporate gifting because each recipient order may need its own tax calculation based on its products, its shipping address, and the tax rules at that destination. For wineries and other merchants selling alcohol or regulated products, the requirements can be even more complex.

With the setup below, Shopify calculates tax separately for every recipient order, the gifter pays everything on one order or invoice, and Shopify's tax reports show the tax by the state and jurisdiction each gift shipped to.

Accurate tax reporting requires calculated order values

If your Send preset or checkout settings create recipient orders with $0 values, tax on your Send To Many orders cannot be accurately reported in Shopify. The tax the gifter pays is recorded only as a custom Tax line on the gifter order, not as Shopify tax, so Shopify's tax reports don't show it by state or jurisdiction.

If you need accurate tax reporting, set recipient orders to use calculated values. See Recommended setup for sales tax reporting.

If you stay on $0 values, the Sales Tax report in Send To Many (Analytics → Sales Tax) still lists the tax calculated for each recipient, by Send and rate. Download it and enter the figures in your tax or accounting system manually. For the accounting-side setup, including the monthly tax journal, see Accounting for Multi-Recipient Orders.

warning

When using Send To Many for revenue-generating orders, work with the accounting member of your ecommerce team to test and confirm the impact of these settings on revenue and tax reporting.

How tax is calculated on Send To Many orders​

Send To Many orders come in two layers:

  • Recipient orders (also called child orders): one order per recipient, used for fulfillment. Shopify calculates tax on each one based on its products, its shipping and billing addresses, and your tax setup in Shopify (Shopify Tax or a third-party tax app). Each recipient order stores the full tax detail: tax rates, jurisdiction names, and amounts.
  • The gifter order (also called the aggregate or parent order): the order or invoice the gifter pays. It combines the products, shipping, and a single custom Tax line item that adds up the tax from every recipient order.

Shopify recipient order generated from a Send To Many bulk order with full tax jurisdiction details Recipient order generated from a Send, with full tax details.

The Send summary shows the combined tax from all recipient orders, and the aggregate draft invoice carries it as one Tax line.

Send To Many send summary showing aggregated sales tax from all recipient orders in Shopify Send Summary with aggregated tax from all recipient orders

Shopify aggregate draft invoice with a single combined tax line item for bulk order Aggregate Draft Invoice with a single line item for Tax

So the gifter pays the tax once, on the gifter order, and the recipient orders hold the detail Shopify reports on. The gifter order is tax exempt and all of its line items are non-taxable, so Shopify doesn't count its Tax line, or anything else on it, as taxable sales.

Recipient orders need calculated amounts for Shopify to record tax on them. With $0 recipient orders, the tax the gifter pays exists only as the custom Tax line on the gifter order, and Shopify's tax reports show no tax for that Send.

For manual imports, open the relevant Send preset in Send To Many and set Order Revenue Handling to Create orders marked as paid using the calculated amount. Send presets control how manually uploaded Sends are generated, and their settings can also be adjusted while creating an individual Send. Use the same setting for any other Send preset where you collect revenue.

Send To Many send preset settings showing order revenue handling set to calculated amounts in Shopify

For multi-recipient checkout, go to Send To Many → Settings → Multi-recipient Checkout and set order processing so recipient orders use calculated values instead of $0 values.

Send To Many multi-recipient checkout order processing settings for tax calculation in Shopify

How Shopify's tax reports show Send To Many orders​

Shopify's Taxes report and United States sales tax report (in Analytics → Reports) show tax by state and jurisdiction. With the setup above:

  • Tax comes from recipient orders. Each recipient order is reported at its shipping address, with its tax rates and amounts.
  • Gifter orders don't appear. They're tax exempt and their line items are non-taxable, so they add no sales and no tax to these reports.
  • Recipient orders with no tax applied aren't listed, the same as any Shopify order. That includes orders shipped to states where you don't collect tax and orders outside the United States.

Shopify tax report showing detailed transactions with tax rates by order and line item Click Detailed transactions to view tax rates by order and line item.

Using the detailed transactions export​

In the United States sales tax report, click Detailed transactions, then Export, to download every transaction behind the report. Two things to know before you total it:

  • One row per jurisdiction. A line item taxed by a state, a county, and a city appears on three rows, each with the same net sales amount. Remove duplicate Line item ID rows before adding up net sales, or you'll count the same sale several times.
  • Older gifter orders from uploaded Sends. Earlier versions of Send To Many created gifter orders for uploaded Sends that Shopify included in this report. They appear under the gifter's billing state as non-taxable sales, with Tax exemptions set to ORDER_EXEMPTION, and no tax. Remove every row where Tax exemptions is ORDER_EXEMPTION to take them out. If some of your customers are genuinely tax exempt, check the order number first: gifter orders carry the Send to Many aggregate tag.

Downloading tax details in Send To Many​

Tax details summarized by Send and rate are available for download in the Analytics section of Send To Many. Use it for a record of:

  • which Sends had tax
  • how much tax was charged
  • which rates were applied
  • tax totals grouped for reconciliation or external reporting workflows

The report also shows blank rows for states where recipients received an order but no tax was calculated or collected.

Revenue is counted twice in Shopify's sales reports​

Shopify's sales reports, such as Total sales, the finance summary, and sales by product, include both the gifter order and the recipient orders. The gifter order holds the revenue collected from the gifter, and the recipient orders hold the same products, shipping, and tax for each recipient, so a Send's revenue is counted twice unless you filter one layer out.

To remove the duplicate, exclude orders tagged Send to Many aggregate:

  • In a Shopify report, open Filters and set Order tags > does not contain > Send to Many aggregate.
  • In the ShopifyQL editor, add WHERE order_tags NOT CONTAINS 'Send to Many aggregate'.

Shopify analytics report filter excluding Send To Many aggregate orders using tags to prevent double-counted revenue Filter out gifter orders from revenue reports using the Send to Many aggregate tag.

This leaves the recipient orders, with their itemized products, shipping, and tax. For the reports that need updating and other filtering options, see Filtering Shopify reports to avoid double-counting.

Still have a question?

Ask Manny, the Send To Many bot, about “Sales Tax Calculation, Collection, and Reporting” or anything else in the docs.