Tax and final prices issue

Dear friends,

I'm still trying to figure out how the store works and I've hit a wall. My accountant found some errors in the transactions, and the numbers just aren't adding up.

Here are the issues that need to be addressed:

- VAT is applied to everything in my store — products as well as services like shipping and COD (cash on delivery). This isn't reflected on the invoice the system generates.
- The coupon/discount is not being deducted before VAT, as it should be, which means the rest of the calculations come out wrong.
- The invoice needs to display the discount percentage applied (e.g. 20% or 15%), so the customer can clearly see how much of a discount they received.

The invoice should clearly show, as separate line items:
1. Product price before VAT
2. Discount (amount and percentage)
3. Shipping
4. COD fee
5. VAT
6. Final total

I'm attaching an invoice generated by the system, along with the format the accounting office is requesting, for comparison.

Could you please check the calculations being made and how they're laid out on the invoice?

Thank you so much!

Good afternoon Olivier,

The formula for this invoice needs to be calculated on the net amount after the discount.

So we have:
(35.29 − 7.06) + 3.90 + 1.26 = 33.39, × 19% VAT → tax of 6.3441 (not 7.68)

Final amount to be paid by the customer: 39.73

Thank you for your respond.

Georgios

Hi,

Thanks for looking into this — you're right about what you suggested, but my main concern is that the tax isn't showing the correct number, which makes the final price wrong. Here's a summary of the issues:

Calculation logic:

• The coupon should be deducted from the net product price before VAT is applied.
• The C.O.D. (Cash on Delivery) fee is missing its tax, which throws off the total tax and final amount.
• Even where C.O.D. tax is applied, the total is still incorrect — VAT should always be calculated after the coupon has been deducted from the product price.

On the printed invoice:

• Shipping tax is missing
• The C.O.D. line item is missing
• The C.O.D. tax is missing
• The discount doesn't show the percentage applied (e.g. 20%)

Settings/configuration:

• The administrator should have the option, in the settings, to choose whether VAT applies to C.O.D. and shipping — rather than this being hardcoded as a fixed rule that always applies VAT to both.

Could you please correct these so the invoice reflects the accurate tax and final total?

Thanks again!

Dear Olivier,

We still have this issue. You can look at my latest order or any order with discount or without including C.O.D.  The tax ammount is not correct therefore the final amount is not correct either. 
It looks like the issue is with C.O.D and the Discount.  According to my accountance you have to put into the account all the values: subtotal minus discount and add shipping and C.O.D and then put into the account the VAT of 19%. Otherwise the VAT value is incorrect and the final price is also wrong.  Can you please check this again.

If the order doesn't have discount or C.O.D the tax is correct and the final price too

Kind regards
Yorgos

Please proceed.  This will help you understand better my store. 

Thanks

Yorgos

Dear Olivier

I have this from my accountan:  Products; 35,29 + ACS (shipping):  3,90   = 39,19 -  7,06 the discount  = 32,13 Χ 19% (6,10 VAT) = Final Price 38,23