vat calculations on invoices are wrong!


M

M.Ali Demirci

I realized today that some calculations are wrong in OA2008, check the table
below that i directly copied from OA2008 UK (Sterling sign changed to YTL)

1
INTERNET HIZMET BEDELI
100,04 YTL
100,04 YTL

1
FIYAT FARKI
55,65 YTL
55,65 YTL






BRÜT TUTAR:

SUB TOTAL:
155,69 YTL


K.D.V. %18:

SALES TAX %18:
28,03 YTL


TOPLAM:

TOTAL:
183,72 YTL




As you can see 100,04 + 55,65 = 155,69 (correct sub total)
We have a sales tax %18 so 155,69 * 1,18 = 183,7142
but the program says 183,7142 =~ 183,72 ????? this is total crap it has to
be 183,71 after overall
I then realized that the program make the VAT calculations for each item
then collects the VATs and create VAT total, but this is not the way it
should be

OA2008 UK
(ITEM1+ITEM2) + ((ITEM1*0,18)+(ITEM2*0,18)) =
(100,04 + 55,65) + (18,01 + 10,02) = 183,72

REAL VAT CALCULATION IN TURKEY
(ITEM1+ITEM2) * 1,18 = TOTAL
(100,04 + 55,65) * 1,18 = 183,7142 =~ 183,71
 
Ad

Advertisements

D

DL

This is a common 'problem' that appears in many applications.
Either manually adjust vat total, or ignore it - there is a mathematical
name for this phenomena, I just dont remember it -
 
H

Henry

It's called a rounding error. I see it in the big ERP systems I install.
 
M

M.Ali Demirci

ok then whether its error or bug how can we solve this issue?
any ideas from microsoft side?
 
Ad

Advertisements

J

John Thuneby (Microsoft)

Office Accounting has been built to be compliant with the VAT directives of
the European Union and the guides from HM Revenue and Customs. VAT will thus
be calculated and rounded to the nearest penny per line.

It seems that you are using the British version of Office Accounting outside
the UK – unfortunately there isn’t yet a version available that is compliant
with Turkish VAT.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top