[Skip to main content](#vessel-content) # Incorrect VAT and net totals in reports ## - **[thomas.eilers@gfse.org](/forum/user/84383-thomas-eilers-gfse-org "View thomas.eilers@gfse.org's Profile")** - [![thomas.eilers@gfse.org's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/84383-thomas-eilers-gfse-org "View thomas.eilers@gfse.org's Profile") Topic Author - [ Offline](/forum/user/84383-thomas-eilers-gfse-org) Less More - Posts: 32 - Thank you received: 4 - - 2 weeks 6 days ago [\#100000296](#100000296) by [thomas.eilers@gfse.org](/forum/user/84383-thomas-eilers-gfse-org "View thomas.eilers@gfse.org's Profile") *[Incorrect VAT and net totals in reports](/forum/35-orders-management/100000059-incorrect-vat-and-net-totals-in-reports#100000296 "-- Browser(s) name and version -- : Firefox 158.0 Hi, We are using HikaShop Business 6.5.0 and would like to create a reliable accounting report showing the following totals for a selected period: * Gross sales (including VAT) * Net sales (excluding VAT) * VAT amount We configured a report using the "Table" display type with three rows: Sales including VAT, Sales excluding VAT, and Taxes. However, the calculated totals do not match the actual order data. For October 2026, we get the following results: Amount HikaShop Report Actual Order Data                 Gross                                        €51,360.10                                            €51,360.10 Net €40,536.81 €43,159.75 VAT €10,823.29 €8,200.35 We verified the actual VAT amount using the order CSV export and the HikaShop tax management overview. It appears that the report calculates VAT before deducting coupons and discounts, while the gross sales amount correctly reflects these deductions. Our questions: * Is there a way to configure HikaShop reports so that gross, net, and VAT totals are calculated correctly after coupons and discounts? * Is this a known issue in HikaShop Business 6.5.0? * Is there an existing HikaShop feature or extension that provides a consolidated accounting report with all three totals? * Can such a report be displayed directly in the HikaShop backend with date range and order status filters? We would prefer a solution using standard HikaShop functionality, without custom PHP modifications to our production website. Thank you for your assistance!")* was created by *[thomas.eilers@gfse.org](/forum/user/84383-thomas-eilers-gfse-org "View thomas.eilers@gfse.org's Profile")* -- Browser(s) name and version -- : Firefox 158.0 Hi, We are using HikaShop Business 6.5.0 and would like to create a reliable accounting report showing the following totals for a selected period: - Gross sales (including VAT) - Net sales (excluding VAT) - VAT amount We configured a report using the "Table" display type with three rows: Sales including VAT, Sales excluding VAT, and Taxes. However, the calculated totals do not match the actual order data. For October 2026, we get the following results: | Amount | HikaShop Report | Actual Order Data | |---|---|---| | Gross | €51,360.10 | €51,360.10 | | Net | €40,536.81 | €43,159.75 | | VAT | €10,823.29 | €8,200.35 | We verified the actual VAT amount using the order CSV export and the HikaShop tax management overview. It appears that the report calculates VAT before deducting coupons and discounts, while the gross sales amount correctly reflects these deductions. **Our questions:** 1. Is there a way to configure HikaShop reports so that gross, net, and VAT totals are calculated correctly after coupons and discounts? 2. Is this a known issue in HikaShop Business 6.5.0? 3. Is there an existing HikaShop feature or extension that provides a consolidated accounting report with all three totals? 4. Can such a report be displayed directly in the HikaShop backend with date range and order status filters? We would prefer a solution using standard HikaShop functionality, without custom PHP modifications to our production website. Thank you for your assistance! Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM1LW9yZGVycy1tYW5hZ2VtZW50LzEwMDAwMDA1OS1pbmNvcnJlY3QtdmF0LWFuZC1uZXQtdG90YWxzLWluLXJlcG9ydHM/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") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86358 - Thank you received: 14290 - - 2 weeks 5 days ago [\#100000304](#100000304) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Incorrect VAT and net totals in reports](/forum/35-orders-management/100000059-incorrect-vat-and-net-totals-in-reports#100000304 "-- Browser(s) name and version -- : Firefox 158.0 Hi, We are using HikaShop Business 6.5.0 and would like to create a reliable accounting report showing the following totals for a selected period: * Gross sales (including VAT) * Net sales (excluding VAT) * VAT amount We configured a report using the "Table" display type with three rows: Sales including VAT, Sales excluding VAT, and Taxes. However, the calculated totals do not match the actual order data. For October 2026, we get the following results: Amount HikaShop Report Actual Order Data                 Gross                                        €51,360.10                                            €51,360.10 Net €40,536.81 €43,159.75 VAT €10,823.29 €8,200.35 We verified the actual VAT amount using the order CSV export and the HikaShop tax management overview. It appears that the report calculates VAT before deducting coupons and discounts, while the gross sales amount correctly reflects these deductions. Our questions: * Is there a way to configure HikaShop reports so that gross, net, and VAT totals are calculated correctly after coupons and discounts? * Is this a known issue in HikaShop Business 6.5.0? * Is there an existing HikaShop feature or extension that provides a consolidated accounting report with all three totals? * Can such a report be displayed directly in the HikaShop backend with date range and order status filters? We would prefer a solution using standard HikaShop functionality, without custom PHP modifications to our production website. Thank you for your assistance!")* Hi, The "Taxes" row of a Table report adds up only the VAT of the products as it was before the coupon, and it leaves out the VAT of the shipping and payment fees. So it does not match the VAT of your orders whenever a coupon is used, and Gross minus Net does not give that row's amount. This is a bug in 6.5.0 and it is still present in the 6.7.0 version. A fix has been prepared. With it, the Taxes row counts the VAT of the products, the shipping and the payment fee, minus the VAT taken off by the coupon, which gives the same amount as the order totals. The same fix also corrects a "Sales" row without taxes and without shipping but with the coupon, which removed the coupon once per product line. It also fixes rows saved with the "All" order status, which always showed 0. We've published the 6.7.1 version today with that patch included. So I would recommend updating HikaShop. To answer your other questions: the Table display is the HikaShop feature meant for this kind of accounting summary. It is shown in the backend under Reports, and you can also publish it on the HikaShop dashboard. Each row has its own period (a specific start and end date) and its own order status filter, and the report can be exported to CSV. The report options are described here: [ www.hikashop.com/support/documentation/1...hop-report-form.html](https://www.hikashop.com/support/documentation/133-hikashop-report-form.html) Could you tell us the "With tax", "Include shipping" and "Include coupon" settings of your Net row, and whether your coupons have "Automatic taxes" set to Yes (or a tax category selected)? Your Net figure is exactly your Gross minus the Taxes row, which points to coupons saved without their VAT. In that case we will check those orders more closely. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM1LW9yZGVycy1tYW5hZ2VtZW50LzEwMDAwMDA1OS1pbmNvcnJlY3QtdmF0LWFuZC1uZXQtdG90YWxzLWluLXJlcG9ydHM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[thomas.eilers@gfse.org](/forum/user/84383-thomas-eilers-gfse-org "View thomas.eilers@gfse.org's Profile")** - [![thomas.eilers@gfse.org's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/84383-thomas-eilers-gfse-org "View thomas.eilers@gfse.org's Profile") Topic Author - [ Offline](/forum/user/84383-thomas-eilers-gfse-org) Less More - Posts: 32 - Thank you received: 4 - - 2 weeks 4 days ago [\#100000318](#100000318) by [thomas.eilers@gfse.org](/forum/user/84383-thomas-eilers-gfse-org "View thomas.eilers@gfse.org's Profile") Replied by *[thomas.eilers@gfse.org](/forum/user/84383-thomas-eilers-gfse-org "View thomas.eilers@gfse.org's Profile")* on topic *[Incorrect VAT and net totals in reports](/forum/35-orders-management/100000059-incorrect-vat-and-net-totals-in-reports#100000318 "-- Browser(s) name and version -- : Firefox 158.0 Hi, We are using HikaShop Business 6.5.0 and would like to create a reliable accounting report showing the following totals for a selected period: * Gross sales (including VAT) * Net sales (excluding VAT) * VAT amount We configured a report using the "Table" display type with three rows: Sales including VAT, Sales excluding VAT, and Taxes. However, the calculated totals do not match the actual order data. For October 2026, we get the following results: Amount HikaShop Report Actual Order Data                 Gross                                        €51,360.10                                            €51,360.10 Net €40,536.81 €43,159.75 VAT €10,823.29 €8,200.35 We verified the actual VAT amount using the order CSV export and the HikaShop tax management overview. It appears that the report calculates VAT before deducting coupons and discounts, while the gross sales amount correctly reflects these deductions. Our questions: * Is there a way to configure HikaShop reports so that gross, net, and VAT totals are calculated correctly after coupons and discounts? * Is this a known issue in HikaShop Business 6.5.0? * Is there an existing HikaShop feature or extension that provides a consolidated accounting report with all three totals? * Can such a report be displayed directly in the HikaShop backend with date range and order status filters? We would prefer a solution using standard HikaShop functionality, without custom PHP modifications to our production website. Thank you for your assistance!")* Hi, Thank you for your detailed explanation. Our "Net" row has the following settings: - With tax: No - Include shipping: Yes - Include coupon: Yes - Order status: Confirmed We use percentage-based coupons, either **10% or 100%**. I checked one of our existing 100% and 10% coupons and found the following settings: - Automatic taxes: **No** - Tax category: **None** - Shipping discount: 0% This seems to match your suspicion that the coupons were saved without their VAT. Could you please clarify: 1. Should we enable "Automatic taxes" for our percentage-based coupons? 2. Could these coupon settings explain the discrepancies between the accounting report and the tax management overview? 3. Would changing these settings affect existing orders and invoices, or only future orders? 4. Is there a way to obtain correct accounting totals for our existing orders without modifying their stored financial data? Since this is a live production website, we want to avoid changing existing orders or invoices. Thank you! Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM1LW9yZGVycy1tYW5hZ2VtZW50LzEwMDAwMDA1OS1pbmNvcnJlY3QtdmF0LWFuZC1uZXQtdG90YWxzLWluLXJlcG9ydHM/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") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86358 - Thank you received: 14290 - - 2 weeks 4 days ago [\#100000322](#100000322) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Incorrect VAT and net totals in reports](/forum/35-orders-management/100000059-incorrect-vat-and-net-totals-in-reports#100000322 "-- Browser(s) name and version -- : Firefox 158.0 Hi, We are using HikaShop Business 6.5.0 and would like to create a reliable accounting report showing the following totals for a selected period: * Gross sales (including VAT) * Net sales (excluding VAT) * VAT amount We configured a report using the "Table" display type with three rows: Sales including VAT, Sales excluding VAT, and Taxes. However, the calculated totals do not match the actual order data. For October 2026, we get the following results: Amount HikaShop Report Actual Order Data                 Gross                                        €51,360.10                                            €51,360.10 Net €40,536.81 €43,159.75 VAT €10,823.29 €8,200.35 We verified the actual VAT amount using the order CSV export and the HikaShop tax management overview. It appears that the report calculates VAT before deducting coupons and discounts, while the gross sales amount correctly reflects these deductions. Our questions: * Is there a way to configure HikaShop reports so that gross, net, and VAT totals are calculated correctly after coupons and discounts? * Is this a known issue in HikaShop Business 6.5.0? * Is there an existing HikaShop feature or extension that provides a consolidated accounting report with all three totals? * Can such a report be displayed directly in the HikaShop backend with date range and order status filters? We would prefer a solution using standard HikaShop functionality, without custom PHP modifications to our production website. Thank you for your assistance!")* Yes, set "Automatic taxes" to Yes on your percentage coupons, and leave the "Tax category" empty: HikaShop then calculates the coupon's VAT from the products it applies to, at their own rates. The option is described here: [ www.hikashop.com/support/documentation/2...p-discount-form.html](https://www.hikashop.com/support/documentation/27-hikashop-discount-form.html) With "Automatic taxes" set to No, a percentage coupon takes its percentage off the prices without VAT only, and the VAT of the products stays in the order total. However, the VAT lines of the order (the tax summary of the order, the invoice and the tax management overview) are lowered by the coupon's percentage. So, for those orders, the lines no longer add up to the total. We reproduced it on a test shop with a product at 27,77 € excl. VAT, 20% VAT and 5,00 € of shipping: - 10% coupon, Automatic taxes No: coupon -2,78 €, VAT shown 6,00 €, total 36,55 €. The lines add up to 35,99 €; the remaining 0,56 € is product VAT the coupon did not remove. - 10% coupon, Automatic taxes Yes: coupon -2,78 €, VAT 6,00 €, total 35,99 €. Everything adds up, and the customer gets exactly 10% off the price including VAT. - 100% coupon, Automatic taxes No: coupon -27,77 €, VAT shown 1,00 € (the shipping's VAT), total 11,55 €. The customer still paid the product's 5,55 € of VAT although the product was free. This explains your discrepancy. The "Taxes" row of the report counts the products' VAT as it was charged, before the coupon, while the tax management overview counts the lowered VAT lines. The difference between your two VAT figures (2.622,94 €) is the VAT that your coupons left in the order totals. Changing the coupons only affects orders placed afterwards. Existing orders keep the amounts calculated at checkout, and their invoices don't change. For the same reason, avoid editing or saving those orders in the backend (adding a product, changing a price or the coupon), because that recalculates them. For the existing orders, nothing needs to be modified to get reliable figures: - Gross: the order totals (your Gross row, or the order_full_price column of the order CSV export) are exactly what your customers paid, and that figure is correct. - VAT and net: for orders with a no-tax coupon, HikaShop holds two different VAT figures, and neither matches the total paid. The VAT contained in what the customer actually paid is the order total × rate / (100 + rate) when the order has a single VAT rate (for example total × 19 / 119), and net = total − that VAT. Orders without a coupon are not affected, and the report and the overview agree on them. - To isolate the affected orders, you can add rows to the same Table report with the "Coupons" filter, or filter the order export on the order_discount_code column. Your accountant can then decide how to declare the VAT of those orders: on the amounts paid, or on the lowered amounts printed on the invoices. Once your coupons are set to Automatic taxes, new orders will give the same VAT in the report's Taxes row, in the tax management overview and on the invoices, and Gross − Net = VAT. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM1LW9yZGVycy1tYW5hZ2VtZW50LzEwMDAwMDA1OS1pbmNvcnJlY3QtdmF0LWFuZC1uZXQtdG90YWxzLWluLXJlcG9ydHM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[thomas.eilers@gfse.org](/forum/user/84383-thomas-eilers-gfse-org "View thomas.eilers@gfse.org's Profile")** - [![thomas.eilers@gfse.org's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/84383-thomas-eilers-gfse-org "View thomas.eilers@gfse.org's Profile") Topic Author - [ Offline](/forum/user/84383-thomas-eilers-gfse-org) Less More - Posts: 32 - Thank you received: 4 - - 2 weeks 3 days ago [\#100000348](#100000348) by [thomas.eilers@gfse.org](/forum/user/84383-thomas-eilers-gfse-org "View thomas.eilers@gfse.org's Profile") Replied by *[thomas.eilers@gfse.org](/forum/user/84383-thomas-eilers-gfse-org "View thomas.eilers@gfse.org's Profile")* on topic *[Incorrect VAT and net totals in reports](/forum/35-orders-management/100000059-incorrect-vat-and-net-totals-in-reports#100000348 "-- Browser(s) name and version -- : Firefox 158.0 Hi, We are using HikaShop Business 6.5.0 and would like to create a reliable accounting report showing the following totals for a selected period: * Gross sales (including VAT) * Net sales (excluding VAT) * VAT amount We configured a report using the "Table" display type with three rows: Sales including VAT, Sales excluding VAT, and Taxes. However, the calculated totals do not match the actual order data. For October 2026, we get the following results: Amount HikaShop Report Actual Order Data                 Gross                                        €51,360.10                                            €51,360.10 Net €40,536.81 €43,159.75 VAT €10,823.29 €8,200.35 We verified the actual VAT amount using the order CSV export and the HikaShop tax management overview. It appears that the report calculates VAT before deducting coupons and discounts, while the gross sales amount correctly reflects these deductions. Our questions: * Is there a way to configure HikaShop reports so that gross, net, and VAT totals are calculated correctly after coupons and discounts? * Is this a known issue in HikaShop Business 6.5.0? * Is there an existing HikaShop feature or extension that provides a consolidated accounting report with all three totals? * Can such a report be displayed directly in the HikaShop backend with date range and order status filters? We would prefer a solution using standard HikaShop functionality, without custom PHP modifications to our production website. Thank you for your assistance!")* Hi, Our global settings are both set to "After taxes": "Apply discounts" and "Apply coupons". This seems to explain why our 10% coupons currently deduct exactly 10% of the gross price, despite "Automatic taxes" being set to No. For example, a product priced at €990 including 19% VAT results in a €99 coupon discount, €891 total and €142.26 VAT shown on the invoice. With these global settings, do you still recommend changing only "Automatic taxes" to Yes while leaving the tax category empty? Will this preserve the gross discount and correct the VAT reporting? Regards, Thomas Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM1LW9yZGVycy1tYW5hZ2VtZW50LzEwMDAwMDA1OS1pbmNvcnJlY3QtdmF0LWFuZC1uZXQtdG90YWxzLWluLXJlcG9ydHM/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") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86358 - Thank you received: 14290 - - 2 weeks 3 days ago [\#100000350](#100000350) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Incorrect VAT and net totals in reports](/forum/35-orders-management/100000059-incorrect-vat-and-net-totals-in-reports#100000350 "-- Browser(s) name and version -- : Firefox 158.0 Hi, We are using HikaShop Business 6.5.0 and would like to create a reliable accounting report showing the following totals for a selected period: * Gross sales (including VAT) * Net sales (excluding VAT) * VAT amount We configured a report using the "Table" display type with three rows: Sales including VAT, Sales excluding VAT, and Taxes. However, the calculated totals do not match the actual order data. For October 2026, we get the following results: Amount HikaShop Report Actual Order Data                 Gross                                        €51,360.10                                            €51,360.10 Net €40,536.81 €43,159.75 VAT €10,823.29 €8,200.35 We verified the actual VAT amount using the order CSV export and the HikaShop tax management overview. It appears that the report calculates VAT before deducting coupons and discounts, while the gross sales amount correctly reflects these deductions. Our questions: * Is there a way to configure HikaShop reports so that gross, net, and VAT totals are calculated correctly after coupons and discounts? * Is this a known issue in HikaShop Business 6.5.0? * Is there an existing HikaShop feature or extension that provides a consolidated accounting report with all three totals? * Can such a report be displayed directly in the HikaShop backend with date range and order status filters? We would prefer a solution using standard HikaShop functionality, without custom PHP modifications to our production website. Thank you for your assistance!")* Thank you, that setting changes the answer, and our previous advice does not apply to your shop: with "Apply coupons" set to "After taxes", please leave "Automatic taxes" set to No for now. With "After taxes", your current coupons are calculated correctly: 10% of the price including VAT is taken off, and the VAT on the order and the invoice is the VAT contained in what the customer pays (in your example, 891 × 19 / 119 = 142,26 €). Your invoices and the tax management overview are therefore right. What is wrong is only how the coupon is recorded for the reports. The order saves the coupon (99 €) with 0 € of VAT. The report's Net row therefore takes the full 99 € off the net amount instead of 83,19 €, and the Taxes row does not take off the 15,81 € of VAT contained in the coupon. Your 2.622,94 € gap is exactly the VAT contained in your coupons. We tested "Automatic taxes" set to Yes with "After taxes". In the current versions (including 6.5.0 and 6.7.1), HikaShop adds VAT on top of the coupon amount: with 19% VAT, a 10% coupon takes 11,9% off (117,81 € instead of 99 € in your example), and the VAT shown is still that of a 10% coupon. So please don't enable it on your live shop. We have prepared a fix: with it, "Automatic taxes" set to Yes keeps the coupon at exactly 10% of the price including VAT and records the VAT it contains. The report's Gross, Net and Taxes rows then match your invoices, and Gross − Net = VAT. Once you have updated (by downloading Hikashop on our website and installing it on yours again), you can set "Automatic taxes" to Yes on your coupons, with the tax category left empty. It will only affect orders placed after the change. For your existing orders, nothing needs to be modified: - Gross: your Gross row (or the order totals) is correct. - VAT: use the tax management overview or the VAT on your invoices. That is the VAT contained in what your customers paid. - Net: Gross − that VAT (for October: 51.360,10 € − 8.200,35 € = 43.159,75 €). The report's Net and Taxes rows are only off for orders with a coupon. Orders without a coupon give the same figures everywhere. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM1LW9yZGVycy1tYW5hZ2VtZW50LzEwMDAwMDA1OS1pbmNvcnJlY3QtdmF0LWFuZC1uZXQtdG90YWxzLWluLXJlcG9ydHM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[thomas.eilers@gfse.org](/forum/user/84383-thomas-eilers-gfse-org "View thomas.eilers@gfse.org's Profile")** - [![thomas.eilers@gfse.org's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/84383-thomas-eilers-gfse-org "View thomas.eilers@gfse.org's Profile") Topic Author - [ Offline](/forum/user/84383-thomas-eilers-gfse-org) Less More - Posts: 32 - Thank you received: 4 - - 2 weeks 1 day ago [\#100000372](#100000372) by [thomas.eilers@gfse.org](/forum/user/84383-thomas-eilers-gfse-org "View thomas.eilers@gfse.org's Profile") Replied by *[thomas.eilers@gfse.org](/forum/user/84383-thomas-eilers-gfse-org "View thomas.eilers@gfse.org's Profile")* on topic *[Incorrect VAT and net totals in reports](/forum/35-orders-management/100000059-incorrect-vat-and-net-totals-in-reports#100000372 "-- Browser(s) name and version -- : Firefox 158.0 Hi, We are using HikaShop Business 6.5.0 and would like to create a reliable accounting report showing the following totals for a selected period: * Gross sales (including VAT) * Net sales (excluding VAT) * VAT amount We configured a report using the "Table" display type with three rows: Sales including VAT, Sales excluding VAT, and Taxes. However, the calculated totals do not match the actual order data. For October 2026, we get the following results: Amount HikaShop Report Actual Order Data                 Gross                                        €51,360.10                                            €51,360.10 Net €40,536.81 €43,159.75 VAT €10,823.29 €8,200.35 We verified the actual VAT amount using the order CSV export and the HikaShop tax management overview. It appears that the report calculates VAT before deducting coupons and discounts, while the gross sales amount correctly reflects these deductions. Our questions: * Is there a way to configure HikaShop reports so that gross, net, and VAT totals are calculated correctly after coupons and discounts? * Is this a known issue in HikaShop Business 6.5.0? * Is there an existing HikaShop feature or extension that provides a consolidated accounting report with all three totals? * Can such a report be displayed directly in the HikaShop backend with date range and order status filters? We would prefer a solution using standard HikaShop functionality, without custom PHP modifications to our production website. Thank you for your assistance!")* Hello Nicolas, I have installed the updated HikaShop package and tested a 15% coupon on a book with 7% VAT (another product (book)) The product price including VAT is €77.69. With "Apply coupons" set to "After taxes" and "Automatic taxes" set to Yes (tax category left empty), I get: - Coupon: −€11.65 - Total: €66.04 - VAT (7%) displayed: €5.08 The correct VAT included in €66.04 should be €4.32. When I change "Apply coupons" to "Before taxes", the checkout correctly displays €4.32 VAT and €66.04 total, regardless of the "Automatic taxes" setting. The coupon is restricted to this specific book and must not apply to shipping. Could you please check why the VAT is still incorrect with "After taxes", even after the update? Thank you! Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM1LW9yZGVycy1tYW5hZ2VtZW50LzEwMDAwMDA1OS1pbmNvcnJlY3QtdmF0LWFuZC1uZXQtdG90YWxzLWluLXJlcG9ydHM/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") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86358 - Thank you received: 14290 - - 2 weeks 1 day ago [\#100000373](#100000373) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Incorrect VAT and net totals in reports](/forum/35-orders-management/100000059-incorrect-vat-and-net-totals-in-reports#100000373 "-- Browser(s) name and version -- : Firefox 158.0 Hi, We are using HikaShop Business 6.5.0 and would like to create a reliable accounting report showing the following totals for a selected period: * Gross sales (including VAT) * Net sales (excluding VAT) * VAT amount We configured a report using the "Table" display type with three rows: Sales including VAT, Sales excluding VAT, and Taxes. However, the calculated totals do not match the actual order data. For October 2026, we get the following results: Amount HikaShop Report Actual Order Data                 Gross                                        €51,360.10                                            €51,360.10 Net €40,536.81 €43,159.75 VAT €10,823.29 €8,200.35 We verified the actual VAT amount using the order CSV export and the HikaShop tax management overview. It appears that the report calculates VAT before deducting coupons and discounts, while the gross sales amount correctly reflects these deductions. Our questions: * Is there a way to configure HikaShop reports so that gross, net, and VAT totals are calculated correctly after coupons and discounts? * Is this a known issue in HikaShop Business 6.5.0? * Is there an existing HikaShop feature or extension that provides a consolidated accounting report with all three totals? * Can such a report be displayed directly in the HikaShop backend with date range and order status filters? We would prefer a solution using standard HikaShop functionality, without custom PHP modifications to our production website. Thank you for your assistance!")* Thank you for the test, you found a second case that our previous fix did not cover. The package you installed fixes coupons that apply to the whole cart. A percentage coupon restricted to some products is calculated another way: HikaShop first turns it into an amount (15% of 77,69 € = 11,65 €) and then takes that amount off the total without taking out the VAT it contains. That is why the total is right (66,04 €) but the VAT stays at 5,08 €, the VAT of the full price, instead of 4,32 €. We reproduced it exactly with your figures (a book at 77,69 € including 7% VAT, a 15% coupon restricted to it, "After taxes", "Automatic taxes" set to Yes) and prepared a fix. With it, the coupon stays at 11,65 €, of which 0,76 € is VAT, the VAT of the order is 4,32 € and the total is still 66,04 €. The order and the invoice then show that VAT, and the coupon is recorded with its VAT for the reports. We also checked it with a book and a product at another VAT rate in the same cart: only the book's VAT is lowered. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM1LW9yZGVycy1tYW5hZ2VtZW50LzEwMDAwMDA1OS1pbmNvcnJlY3QtdmF0LWFuZC1uZXQtdG90YWxzLWluLXJlcG9ydHM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[thomas.eilers@gfse.org](/forum/user/84383-thomas-eilers-gfse-org "View thomas.eilers@gfse.org's Profile")** - [![thomas.eilers@gfse.org's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/84383-thomas-eilers-gfse-org "View thomas.eilers@gfse.org's Profile") Topic Author - [ Offline](/forum/user/84383-thomas-eilers-gfse-org) Less More - Posts: 32 - Thank you received: 4 - - 2 weeks 15 hours ago [\#100000375](#100000375) by [thomas.eilers@gfse.org](/forum/user/84383-thomas-eilers-gfse-org "View thomas.eilers@gfse.org's Profile") Replied by *[thomas.eilers@gfse.org](/forum/user/84383-thomas-eilers-gfse-org "View thomas.eilers@gfse.org's Profile")* on topic *[Incorrect VAT and net totals in reports](/forum/35-orders-management/100000059-incorrect-vat-and-net-totals-in-reports#100000375 "-- Browser(s) name and version -- : Firefox 158.0 Hi, We are using HikaShop Business 6.5.0 and would like to create a reliable accounting report showing the following totals for a selected period: * Gross sales (including VAT) * Net sales (excluding VAT) * VAT amount We configured a report using the "Table" display type with three rows: Sales including VAT, Sales excluding VAT, and Taxes. However, the calculated totals do not match the actual order data. For October 2026, we get the following results: Amount HikaShop Report Actual Order Data                 Gross                                        €51,360.10                                            €51,360.10 Net €40,536.81 €43,159.75 VAT €10,823.29 €8,200.35 We verified the actual VAT amount using the order CSV export and the HikaShop tax management overview. It appears that the report calculates VAT before deducting coupons and discounts, while the gross sales amount correctly reflects these deductions. Our questions: * Is there a way to configure HikaShop reports so that gross, net, and VAT totals are calculated correctly after coupons and discounts? * Is this a known issue in HikaShop Business 6.5.0? * Is there an existing HikaShop feature or extension that provides a consolidated accounting report with all three totals? * Can such a report be displayed directly in the HikaShop backend with date range and order status filters? We would prefer a solution using standard HikaShop functionality, without custom PHP modifications to our production website. Thank you for your assistance!")* Is the fix already available for download? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM1LW9yZGVycy1tYW5hZ2VtZW50LzEwMDAwMDA1OS1pbmNvcnJlY3QtdmF0LWFuZC1uZXQtdG90YWxzLWluLXJlcG9ydHM/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") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86358 - Thank you received: 14290 - - 2 weeks 12 hours ago [\#100000376](#100000376) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Incorrect VAT and net totals in reports](/forum/35-orders-management/100000059-incorrect-vat-and-net-totals-in-reports#100000376 "-- Browser(s) name and version -- : Firefox 158.0 Hi, We are using HikaShop Business 6.5.0 and would like to create a reliable accounting report showing the following totals for a selected period: * Gross sales (including VAT) * Net sales (excluding VAT) * VAT amount We configured a report using the "Table" display type with three rows: Sales including VAT, Sales excluding VAT, and Taxes. However, the calculated totals do not match the actual order data. For October 2026, we get the following results: Amount HikaShop Report Actual Order Data                 Gross                                        €51,360.10                                            €51,360.10 Net €40,536.81 €43,159.75 VAT €10,823.29 €8,200.35 We verified the actual VAT amount using the order CSV export and the HikaShop tax management overview. It appears that the report calculates VAT before deducting coupons and discounts, while the gross sales amount correctly reflects these deductions. Our questions: * Is there a way to configure HikaShop reports so that gross, net, and VAT totals are calculated correctly after coupons and discounts? * Is this a known issue in HikaShop Business 6.5.0? * Is there an existing HikaShop feature or extension that provides a consolidated accounting report with all three totals? * Can such a report be displayed directly in the HikaShop backend with date range and order status filters? We would prefer a solution using standard HikaShop functionality, without custom PHP modifications to our production website. Thank you for your assistance!")* Hi, Yes. Download the install package of HikaShop again on our website and install it on yours in order to get the patch I was talking about in my previous message. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM1LW9yZGVycy1tYW5hZ2VtZW50LzEwMDAwMDA1OS1pbmNvcnJlY3QtdmF0LWFuZC1uZXQtdG90YWxzLWluLXJlcG9ydHM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[thomas.eilers@gfse.org](/forum/user/84383-thomas-eilers-gfse-org "View thomas.eilers@gfse.org's Profile")** - [![thomas.eilers@gfse.org's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/84383-thomas-eilers-gfse-org "View thomas.eilers@gfse.org's Profile") Topic Author - [ Offline](/forum/user/84383-thomas-eilers-gfse-org) Less More - Posts: 32 - Thank you received: 4 - - 2 weeks 11 hours ago [\#100000378](#100000378) by [thomas.eilers@gfse.org](/forum/user/84383-thomas-eilers-gfse-org "View thomas.eilers@gfse.org's Profile") Replied by *[thomas.eilers@gfse.org](/forum/user/84383-thomas-eilers-gfse-org "View thomas.eilers@gfse.org's Profile")* on topic *[Incorrect VAT and net totals in reports](/forum/35-orders-management/100000059-incorrect-vat-and-net-totals-in-reports#100000378 "-- Browser(s) name and version -- : Firefox 158.0 Hi, We are using HikaShop Business 6.5.0 and would like to create a reliable accounting report showing the following totals for a selected period: * Gross sales (including VAT) * Net sales (excluding VAT) * VAT amount We configured a report using the "Table" display type with three rows: Sales including VAT, Sales excluding VAT, and Taxes. However, the calculated totals do not match the actual order data. For October 2026, we get the following results: Amount HikaShop Report Actual Order Data                 Gross                                        €51,360.10                                            €51,360.10 Net €40,536.81 €43,159.75 VAT €10,823.29 €8,200.35 We verified the actual VAT amount using the order CSV export and the HikaShop tax management overview. It appears that the report calculates VAT before deducting coupons and discounts, while the gross sales amount correctly reflects these deductions. Our questions: * Is there a way to configure HikaShop reports so that gross, net, and VAT totals are calculated correctly after coupons and discounts? * Is this a known issue in HikaShop Business 6.5.0? * Is there an existing HikaShop feature or extension that provides a consolidated accounting report with all three totals? * Can such a report be displayed directly in the HikaShop backend with date range and order status filters? We would prefer a solution using standard HikaShop functionality, without custom PHP modifications to our production website. Thank you for your assistance!")* Hi Nicolas, Thank you very much for the fix and your excellent support! I downloaded and installed the updated HikaShop package and can confirm that the coupon VAT calculation now works correctly. Our test results are: - Book price including 7% VAT: €77.69 - 15% coupon discount: €11.65 - VAT after discount: €4.32 - Total amount: €66.04 The values are now correct in the checkout and the customer confirmation email. We also found that the coupon was initially not applied to the HikaMarket vendor suborder. After setting **“Discount target vendor to the correct vendor**, this issue was resolved as well. The PDF invoice now correctly shows the discount, net amount, VAT and total. I also checked the Factur-X XML file. The coupon is correctly recorded as a net discount of €10.89, with a VAT reduction of €0.76. The invoice totals are consistent. Everything is now working as expected in our tests. Thank you again for your help and for implementing both fixes! Best regards The following user(s) said Thank You: [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM1LW9yZGVycy1tYW5hZ2VtZW50LzEwMDAwMDA1OS1pbmNvcnJlY3QtdmF0LWFuZC1uZXQtdG90YWxzLWluLXJlcG9ydHM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. Board Categories HikaShop Install & Update Product & Category Display Content Creation Sales and Orders Orders management Reports & Statistics Customers Checkout Payment Methods Shipping Methods Import & Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel & Slider Mass Actions Filters & Search Discount & 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.159 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)