Will cancelled orders be exported?

Eligibility follows the configured import and export rules. A cancellation with no captured payment is different from a paid order that was later refunded, so source payment and refund data remain important.

Can a refund use a different date from the original sale?

Yes. Refund records retain their own source dates and can be treated in the correct accounting period.

Does ClearCommerce calculate UK VAT advice?

ClearCommerce applies the mappings configured by the user; it does not replace advice from your accountant or tax adviser.

WooCommerce, Shopify and BigCommerce to Xero accounting workflows. Book a demo

Cross-channel tax control

Keep ecommerce VAT and refunds traceable when sales move into Xero

The ecommerce platform provides tax amounts and refund events, but the Xero treatment still needs explicit mappings. ClearCommerce keeps those two layers separate so tax codes, refund accounts and adjustment dates can be reviewed rather than guessed.

Review VAT mappings Shopify VAT workflow

Start with the source transaction, not a generic VAT percentage

Products, shipping and discounts can have different tax treatment. The accounting bridge should retain enough source information to map each component to the correct Xero tax rate and nominal account.

Refunds are new accounting events

A refund on Thursday for a sale made Monday should retain Thursday's refund date and the original order reference. Rewriting Monday's imported figures makes audit history and gateway reconciliation harder to follow.

Shipping and discounts need explicit rules

These amounts should not disappear inside a single unexplained sales figure when the business needs them in separate Xero accounts or tax treatments.

Rounding belongs in a controlled place

When aggregated lines need a minor balancing adjustment to reproduce exact source totals, the rounding rule and account should be configured rather than hidden inside another line.

Different channel, same control

Use channel-specific source data with company-specific accounting mappings

WooCommerce

Map WooCommerce tax and refund data through the store profile before Xero export.

WooCommerce VAT and refunds

Shopify

Keep Shopify tax data as source evidence and apply explicit Xero tax mappings to the summary.

Shopify VAT reconciliation

BigCommerce

Import source tax, shipping and discount amounts, then apply the BigCommerce store's Xero mapping profile.

BigCommerce to Xero

A common failure mode

What happens when VAT and refunds are guessed instead of mapped

Without explicit mapping

Refunds get netted against unrelated sales, hiding the original transaction
Mixed VAT rates collapse into a single default rate
Quarterly VAT returns need manual correction before filing

With ClearCommerce mappings

Each source tax rate maps to the matching Xero tax rate
Refunds keep a reference back to the original order
VAT return figures reflect what actually happened at checkout

Questions people ask

FAQs

Can multiple VAT rates from one ecommerce store map to Xero correctly?

Yes. Each source tax rate captured at checkout can be mapped to its corresponding Xero tax rate rather than defaulting everything to one rate.

Do refunds need to be linked to the original order?

They should be. ClearCommerce imports refund source data with a reference to the original order so the Xero treatment can be reviewed and traced rather than appearing as an unexplained adjustment.

Does this work across WooCommerce, Shopify and BigCommerce?

Yes. The same mapping approach applies to any connected channel; the source platform's tax and refund data feeds the same Xero mapping layer.

Want a mapping review before live export?

Bring sample orders, refunds and the Xero tax rates you use and we can walk through the expected posting.

Book a demo