Hello, I have a question about OpenCart rounding as per the example below:- Firstly, I should point out that I use an Excel spreadsheet to manage my products and pricing, I would therefore assume OpenCart uses the same mathematical formula:-

My tax (VAT) rate is set at 20% so for Product A:

Sell Price Ex Tax = £8.33

Sell Price Inc Tax = £9.99

The problem is that OpenCart rounds the Tax inc figure to £10 and I need it rounding down as per my Excel spreadsheet and that is also what is legally required in the UK. (I know we're only talking pennies but it is important from an advertising standards perspective).

I realise that the actual price inc tax is actually 8.33 x 1.2 = 9.996 but we can only charge to 2 decimal places so OpenCart changing the price to £10. Alternatively the price less tax is 9.99 / 1.2 = 8.325 hence £8.33

I would be very grateful if someone could explain how this problem could be solved.

Many thanks in advance.

I realise that the actual price inc tax is actually 8.33 x 1.2 = 9.996 but we can only charge to 2 decimal places so OpenCart changing the price to £10. Alternatively the price less tax is 9.99 / 1.2 = 8.325 hence £8.33

Who is online

Users browsing this forum: No registered users and 30 guests