back to knowledgebase

Why does OpenCRM have an order total that is different in pricing from my website or other computer system?

Updated: 31 May 2022 16:57:25 OpenCRM::Orders::Sales Orders OpenCRM::Add-in::SageLink OpenCRM::Sage Integration Hosted::Services::Website SageLink for OpenCRM::

This type of problem is very common and is almost always caused by the way your different computer systems round numbers. 

VAT calculation in the UK is a good example of this. There are two popular ways of calculating VAT, one that applies it to each line and the other that applies it to the total. Both are logical and valid, but when compared, can have slightly different results.

Sage, for example, calculates VAT by applying it to the total for each line, rounding the lines individually and then adding these line totals together to reach the grand total.

Examples:

You are selling 1 banana at £11.23 each and 1 apple at £9.35

Calculated in line

  Line Cost Line VAT VAT Total Line Total
1 x Banana £11.23 11.23 x 0.175   = 1.96525  £1.97 £13.20
1 x Apple £9.35 9.35   x 0.175   = 1.63625 £1.64 £10.99
            
    Total Including VAT   £24.19

   

Calculated at end

  Line Cost   Line Total
1 x Banana £11.23   £13.20
1 x Apple £9.35   £10.99
       
    Cost Total £20.58
    VAT (20.58*0.175=3.6015) £3.60
    Total Including VAT £24.18

 

Both of the above examples make logical sense as a method for calculating the order total and are both commonplace within computer systems BUT as you can see both have arrived at a different answer!

OpenCRM has a few options for calculating VAT, to find out more please refer to this FAQ: https://opencrm.co.uk/help/?kb=705488&article=How-does-OpenCRM-calculate-VAT-compared-to-Sage

Rate This Article
  • 1 star
  • 2 star
  • 3 star
  • 4 star
  • 5 star
Feedback and Comments
captcha code  


You may also be interested in: