Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2010
    Location
    Shropshire
    Posts
    174
    Plugin Contributions
    0

    Default Rounding errors in VAT and using Sales Report

    I dont know if this belongs in the VAT forum or the Sales Report mod support forum - so I put it in 'General'

    I have noticed a rounding issue associated with VAT calculations.

    Please see attached screen grab. In one location it shows Total as £26.25 and in onother location as £26.26.
    I have a VAT zone set at 20%.

    The product is entered with its Gross price as £25.00 inc VAT.
    The product page calculates the ex-VAT price as £20.8333.

    The product has an attribute set up with a 5% 'On-Line Ticket handing Fee' i.e. £1.25 inc VAT.
    Giving an Invoice total of £26.25 inc VAT
    Calculating VAT backwards gives £4.375 - which rounds to £4.38
    Calculating Net backwards using the VAT % gives of £21.875 - which rounds to a Total Net of £21.88,
    Subtracting the calculated VAT would give Total Net of £21.87

    Thus producing inconsistencies in invoices

    This then produces inconsistencies downstream when generating reports either using mods for 'Sales report' or 'Download' for use in a spreadsheet.

    Anyone any suggestions?

  2. #2
    Join Date
    Oct 2010
    Location
    Shropshire
    Posts
    174
    Plugin Contributions
    0

    Default Re: Rounding errors in VAT and using Sales Report

    oops - forgot to attach screen grab
    Attached Images Attached Images  

 

 

Similar Threads

  1. Sales Report CSV Export Errors
    By Lisa in Vermont in forum All Other Contributions/Addons
    Replies: 2
    Last Post: 5 Dec 2009, 07:03 PM
  2. VAT on Sales report
    By Bingo Bazaar in forum Currencies & Sales Taxes, VAT, GST, etc.
    Replies: 0
    Last Post: 2 Mar 2009, 06:20 PM
  3. product quanitites cause VAT Rounding Errors
    By guyp in forum Built-in Shipping and Payment Modules
    Replies: 0
    Last Post: 6 Jun 2008, 11:10 AM
  4. VAT Rounding
    By guyp in forum Built-in Shipping and Payment Modules
    Replies: 5
    Last Post: 23 Apr 2008, 12:40 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg