[Skip to main content](#vessel-content)

#   Report that filters by country and VAT

##

- **[grayt7](/forum/user/30010-grayt7 "View grayt7's Profile")**
- [![grayt7's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar30010.jpg)](/forum/user/30010-grayt7 "View grayt7's Profile") Topic Author
- [ Offline](/forum/user/30010-grayt7)

Less More

- Posts: 377
- Thank you received: 7
-
-
- [](http://www.identitywebdesign.com)
-

10 years 8 months ago [\#230196](#230196) by [grayt7](/forum/user/30010-grayt7 "View grayt7's Profile")  *[Report that filters by country and VAT](/forum/36-reports-statistics/882348-report-that-filters-by-country-and-vat#230196 "-- HikaShop version -- : 2.6.1 -- Joomla version -- : 3.4.8  Hi,  Is there a way to produce a report on sales by country? Also a report that shows the orders placed in a month and if they were charged VAT or no?  Many thanks.")* was created by *[grayt7](/forum/user/30010-grayt7 "View grayt7's Profile")*

-- HikaShop version -- : 2.6.1
-- Joomla version -- : 3.4.8

Hi,

Is there a way to produce a report on sales by country? Also a report that shows the orders placed in a month and if they were charged VAT or no?

Many thanks.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84ODIzNDgtcmVwb3J0LXRoYXQtZmlsdGVycy1ieS1jb3VudHJ5LWFuZC12YXQ/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")**
- [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile")
- [ Away](/forum/user/63-nicolas)

Less More

- Posts: 86555
- Thank you received: 14304
-
-

10 years 8 months ago [\#230243](#230243) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Report that filters by country and VAT](/forum/36-reports-statistics/882348-report-that-filters-by-country-and-vat#230243 "-- HikaShop version -- : 2.6.1 -- Joomla version -- : 3.4.8  Hi,  Is there a way to produce a report on sales by country? Also a report that shows the orders placed in a month and if they were charged VAT or no?  Many thanks.")*

Hi,

You can create a report like this in order to display a map of all the countries with the sales for each country:
[ take.ms/vKVu4](http://take.ms/vKVu4)

You can also create a report to get all the orders placed in a month by simply using the start and end dates on the orders listing page of the backend.
There is no option to know if the orders on that listing were charged VAT or not though.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84ODIzNDgtcmVwb3J0LXRoYXQtZmlsdGVycy1ieS1jb3VudHJ5LWFuZC12YXQ/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[grayt7](/forum/user/30010-grayt7 "View grayt7's Profile")**
- [![grayt7's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar30010.jpg)](/forum/user/30010-grayt7 "View grayt7's Profile") Topic Author
- [ Offline](/forum/user/30010-grayt7)

Less More

- Posts: 377
- Thank you received: 7
-
-
- [](http://www.identitywebdesign.com)
-

10 years 8 months ago -  10 years 8 months ago [\#230313](#230313) by [grayt7](/forum/user/30010-grayt7 "View grayt7's Profile")  Replied by *[grayt7](/forum/user/30010-grayt7 "View grayt7's Profile")* on topic *[Report that filters by country and VAT](/forum/36-reports-statistics/882348-report-that-filters-by-country-and-vat#230313 "-- HikaShop version -- : 2.6.1 -- Joomla version -- : 3.4.8  Hi,  Is there a way to produce a report on sales by country? Also a report that shows the orders placed in a month and if they were charged VAT or no?  Many thanks.")*

ok thanks - I think a VAT report would be very useful for people that need to fill out VAT returns... ?

Also the sales per country as you have shown me, are the figures shown with or without VAT?

Last edit: 10 years 8 months ago by [grayt7](/forum/user/30010-grayt7 "View grayt7's Profile").

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84ODIzNDgtcmVwb3J0LXRoYXQtZmlsdGVycy1ieS1jb3VudHJ5LWFuZC12YXQ/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")**
- [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile")
- [ Away](/forum/user/63-nicolas)

Less More

- Posts: 86555
- Thank you received: 14304
-
-

10 years 8 months ago -  10 years 8 months ago [\#230323](#230323) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Report that filters by country and VAT](/forum/36-reports-statistics/882348-report-that-filters-by-country-and-vat#230323 "-- HikaShop version -- : 2.6.1 -- Joomla version -- : 3.4.8  Hi,  Is there a way to produce a report on sales by country? Also a report that shows the orders placed in a month and if they were charged VAT or no?  Many thanks.")*

Hi,

For VAT reports, you can just go in the System&gt;Taxes menu and click on the "manage tax rates" button.
That will give you a listing of all your tax rates with the total of sales for each one. And you can change the period for the calculations with the corresponding date fields at the top. So you should have all the necessary information to fill the VAT returns.

The figures are with VAT on the map report.

Last edit: 10 years 8 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile").

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84ODIzNDgtcmVwb3J0LXRoYXQtZmlsdGVycy1ieS1jb3VudHJ5LWFuZC12YXQ/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[grayt7](/forum/user/30010-grayt7 "View grayt7's Profile")**
- [![grayt7's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar30010.jpg)](/forum/user/30010-grayt7 "View grayt7's Profile") Topic Author
- [ Offline](/forum/user/30010-grayt7)

Less More

- Posts: 377
- Thank you received: 7
-
-
- [](http://www.identitywebdesign.com)
-

10 years 8 months ago [\#230974](#230974) by [grayt7](/forum/user/30010-grayt7 "View grayt7's Profile")  Replied by *[grayt7](/forum/user/30010-grayt7 "View grayt7's Profile")* on topic *[Report that filters by country and VAT](/forum/36-reports-statistics/882348-report-that-filters-by-country-and-vat#230974 "-- HikaShop version -- : 2.6.1 -- Joomla version -- : 3.4.8  Hi,  Is there a way to produce a report on sales by country? Also a report that shows the orders placed in a month and if they were charged VAT or no?  Many thanks.")*

Hi,

Unfortunately this doesn't give the figures needed.

We need to see the individual orders

Over Value inc and exc TAX
TAX Code used
Country TAX Region

Without this info it's not going to be possible to file a VAT report in the UK.

Many thanks.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84ODIzNDgtcmVwb3J0LXRoYXQtZmlsdGVycy1ieS1jb3VudHJ5LWFuZC12YXQ/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")**
- [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile")
- [ Away](/forum/user/63-nicolas)

Less More

- Posts: 86555
- Thank you received: 14304
-
-

10 years 8 months ago [\#231044](#231044) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Report that filters by country and VAT](/forum/36-reports-statistics/882348-report-that-filters-by-country-and-vat#231044 "-- HikaShop version -- : 2.6.1 -- Joomla version -- : 3.4.8  Hi,  Is there a way to produce a report on sales by country? Also a report that shows the orders placed in a month and if they were charged VAT or no?  Many thanks.")*

Hi,

In that case, you want to export your orders as a CSV either on the orders listing or via the mass action system

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84ODIzNDgtcmVwb3J0LXRoYXQtZmlsdGVycy1ieS1jb3VudHJ5LWFuZC12YXQ/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

Board Categories HikaShop Install &amp; Update Product &amp; Category Display Content Creation Sales and Orders Orders management Reports &amp; Statistics Customers Checkout Payment Methods Shipping Methods Import &amp; Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel &amp; Slider Mass Actions Filters &amp; Search Discount &amp; Coupon Feature Request Integrations Showcase General Talk about HikaShop Development HikaShop 3.0 Beta Translation Commercial Jobs HikaShop Components HikaMarket Market: Feature requests Market: How to? Market: Bug Report HikaSerial General talk about HikaSerial Serial: Bug Report Serial: How to? Support en Français de HikaSerial (French Support) HikaSubscription HikaAuction Auction: Feature requests Auction: How to? Auction: Bug report Hikashop around the world Support en Français (French Support) Russian FAQ. Курс выживания с Hikashop. Частые вопросы и о Расширения Hikashop Наши сайты на Hikashop 日本語版サポート(Japanese Support) Thai German Archives Bug Report How to?

[](/forum/topics/feed/mode-topics?format=feed&type=rss)

Time to create page: 0.076 seconds

[Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)
