FAQ and Troubleshooting — Sales by Country and Tax Reports

General

Is this tax advice?

No. The report shows what your shop charged. What you owe and where you file it is between you and your accountant or tax adviser.

Does it make my shop OSS-compliant?

No plugin can. The report gives you figures read off your orders; whether you must register for the One-Stop Shop, which rates apply and what goes on the return are for you and your adviser. Our OSS guide explains what the return asks for.

Will installing it change my orders or my checkout?

No. Neither edition writes to orders, adds anything to the storefront or adds database tables. It only reads.

What if I changed a tax rate last month?

Nothing in an earlier report moves. Every figure is what the order recorded at the time; the report never reads your tax rate settings.

Missing or unexpected figures

The report says "No orders in this period."

Check, in order:

  1. The dates. The range is by the date the order was created, both days inclusive, in your site's time zone.
  2. The statuses. Only processing and completed orders count (in the full edition, whatever is in Order statuses that count as a sale). Orders on hold, pending payment, cancelled or fully refunded are not read.
  3. The currency. Orders in a currency other than your store's are left out; a note under the period figures says how many.

A fully refunded order isn't in the report at all.

When an order is refunded in full, WooCommerce moves it to the Refunded status, which is not a status that counts as a sale, so it is not read. A partly refunded order keeps its status and appears with the refund taken off.

Last quarter's figures went down since I filed.

A refund (or cancellation) was made after you filed, on an order from that quarter. The report subtracts refunds made up to the moment you run it. Under OSS, the Commission says such a change is corrected in a later return (source); the difference between what you filed and the new figure is that correction. Keep a copy of each quarter as filed — in the full edition, the CSV download.

Orders appear under the wrong country.

The report uses the shipping country, and the billing country only when there is no shipping country. If an order shipped to one country and billed to another, it is reported where it shipped. In the full edition you can choose to report every order under the billing address instead — usually the right choice for a shop selling only services.

If an order's address was edited after it was placed, the report uses the edited address.

What does "N orders had no shipping address" mean?

Those orders had no shipping country — typically downloads, or a shop that doesn't collect a shipping address — so they were reported under their billing country. The note is there so the fallback is visible rather than assumed. (In the full edition it appears only while "Report a sale under" is "Where the goods went".)

Some orders show 0.00 tax.

The report shows what each order charged. No tax is usual for a zero-rated product, for a business customer under the reverse charge, or for a customer outside your tax zones. If you expected tax, check that order in WooCommerce.

A row shows "Not given" for the country.

The order had neither a shipping nor a billing country.

Net doesn't match my sales report.

The Net here includes delivery (shown separately as "Of which delivery"), has refunds taken off, and excludes orders in other currencies and in statuses that don't count. WooCommerce's Analytics reports apply their own rules and may count dates and statuses differently.

Two spellings of the same county appear as one row. Is that right?

Yes. With the state breakdown on, typed states are upper-cased and their spacing tidied, so "West Yorkshire" and "west yorkshire" are one row. Versions before 1.0.1 of the free edition cut typed states to six characters; update if you see rows like WEST Y.

Currencies

My shop sells in several currencies. What do I do?

The report totals the store currency only and tells you how many orders it left out and in which currencies. Report those separately. For an OSS return, amounts in other currencies are converted to euro at the European Central Bank rate published on the last day of the quarter (source).

The full edition

What does the full edition add?

A table by country and tax rate (net, tax and gross per rate), a choice of which statuses count, the option to report under the billing address, and CSV downloads of the country table and the rate table. See Settings.

Why doesn't the per-rate tax add up to the country's tax?

It should: refunds come off the per-rate rows rate by rate, as they do off the country figures. If the two differ, check that both were read from the same run of the report — a refund made in between changes them. The net can differ, though: an order charged no tax (a reverse-charge sale, for example) has no tax line, so it counts in the country row and in no rate row. Details in How it works.

Does the per-rate table show net amounts?

Yes — net, tax and gross per country and rate, with refunds taken off. The net is what the order's own lines recorded under that rate.

Does the CSV include the per-rate table?

It has its own: Download rates CSV under the By tax rate table gives country, rate, percent, orders, net, tax, gross and currency. Download CSV is the country table: country, state, orders, net, tax, gross and currency.

I installed the full edition and the free one's menu disappeared.

That is intended. While the full edition is active the free edition stands down completely and says so on the Plugins screen. Your settings are shared, so you can deactivate and delete the free edition.

My licence key shows as expired.

The plugin keeps working; only updates stop. Renew on gatemi.com to get updates again. If the screen says gatemi.com could not be reached, your licence is unchanged and the check retries on its own.

Still stuck?

Free edition: the support forum on wordpress.org. Full edition: support through your gatemi.com account.

Shopping Cart
Scroll to Top