Skip to main content

Hi, 

This is regarding the Swedish Rule for reporting VAT on Foreign Currency invoices of Swedish Suppliers. Would like to know your ideas on the best possible way to handle this. 

The customer receives the VAT amount in Domestic currency from the Supplier and that amount must be used by the customer for VAT reporting. For example: for a EUR ccy invoice, supplier sends the VAT in SEK amount as well. The customer only calculates the Gross Amount in SEK using the rates in IFS. However, the customer does not know which date the Supplier used to arrive at the VAT in SEK when they send the preliminary invoice. Therefor, there are differences in VAT which the customer today moves into a currency account. 

Example:
Amounts on Invoice from the Supplier
Gross in EUR        100
VAT in EUR              25
Total in EUR          125
VAT in SEK            250

SEK Amounts Calculated by Customer at Booking Date
Gross                    1000
VAT                          275​


How the invoice is handled in SEK currently by Customer:
Cost of Goods      1100
VAT                           250   (This amount is reported to Tax Authority by both Supplier and Customer)
Currency Effect         25
AP Subledger       -1375
 

Customers’ requirement for IFS is:

  • Use the VAT in the file as it is
  • Calculate the Gross Amount in SEK using the rate in IFS relevant for the Booking date * Gross Amount in Invoice Ccy.
  • Post the difference into a Currency Account

Question: Do we have a solid way of handling this 25 krone difference in VAT when we register the Preliminary Posted invoice from the Supplier in IFS? 
Can the Posting Types IP26 and IP27 be used for this scenario and if yes, how could we trigger the difference using these posting types?

 

Appreciate any input on this one. 

 

 

Hi ​@PathiranaPeshala,

You may use different currency rates for tax amount conversion. Then it will trigger IP26 & IP27 postings. You can connect default tax currency rates in Company page. Refer below screen preview for easy reference.

Company 

 

MSI 

User can edit the tax currency rate in MSI page if they enable above setting in company.

Hope this helps.

BR/Narmada


 ​@Narmada G Thank you very much! This works. However, it only works when entering Invoices Manually and is not supported when receiving invoices through External Interface it seems. Or am I missing anything? 
 

Seems like the solution for this to work when receiving a Preliminary Invoice externally would be to do a modification in the External Files to receive a ‘Tax Currency Rate’ to be used on the Invoice when the ‘Create Invoice’ function is triggered.. Do you have any better suggestion for this? Thanks again! 

 

BR,
Peshala. 


Reply