RE:[sap-log-mm] Incorrect VAT calculation during MIRO

Posted by Sap Land Tuesday, 17 May 2011 07:10

Posted by FranzF
on May 17 at 10:10 AM

Hello MV,
I believe the 18.15 is the correct tax amount.
The system takes the 119.00 (Vendor amount). These 119.00 is actually 118% (amount inclusive of tax).
Above figures calculate as follows:
119 / 118 (100% + 18 % VAT) * 18 (VAT) = 18.15254
18.15254 rounded is 18.15
Now the only question is the 0.85 going to 'Accrued tax'.
But maybe I'm missing something?
Regards,
Franz

---------------Original Message---------------
From: talk2sood
Sent: Thursday, May 12, 2011 4:38 PM
Subject: Incorrect VAT calculation during MIRO

Hi,

I have a question related to the VAT calculation during MIRO -

Couple of facts -
1. The company code has TAXES procedure attached to it.
2. The tax code 'S3' is setup for 18% tax.
3. The account key 'VST' is setup as follows -
a. Tax type = 2 (Input tax)
b. Not deductible = checked off
c. Posting indic. = 2 (Separate line item)
4. Vendor invoice = 119 EUR; Expense line item = 100 EUR and Calculated tax = 18 EUR (18%)

The following accounting entry is proposed by the system during the simulation of MIRO -
1 K Vendor 119.00- EUR
2 S GR/IR NON STOCK 100.00 EUR
3 S VAT RECOVERABLE 18.15 EUR
4 S ACCRUED TAX 0.85 EUR

I can not explain the additional 15 cents into the tax account. I think the system is considering base as 101 instead of 100 which means 101 * .18 = 18.18 but it is still 3 cents off. Is it a rounding issue or something else?

I'm expecting the above entry the following way -
1 K Vendor 119.00- EUR
2 S GR/IR NON STOCK 100.00 EUR
3 S VAT RECOVERABLE 18.00 EUR
4 S ACCRUED TAX 1.00 EUR

Any help would be highly appreciated.

Thanks,
MV

__.____._