Tax G/L Account Determination in SAP SD

lightDefining Tax Procedure, Tax Code and Tax G/L Account 

 

 


This post  shows:

  • How to set up tax determination procedure
  • Assigning tax determination procedure to a country
  • Creating different tax codes for country
  • Assigning tax G/L account to the chart of account + account key
  • Creating condition records for tax condition type and assigning it to the tax code

 

Go to Tx- SPRO and from IMG Activity , select Check Calculation Procedure

1

The tax determination procedure is based on the condition technique.

Choose Access Sequences option.

2

Here a new access sequence can be created with New Entries button. Here we have already an access sequence MWST is present. Select MWST and select Accesses from left hand side.

3

The access sequence contains – one access line with condition table as 003. Choose the access line and select Fields from left hand side.

4

It includes two fields Country and the tax code.

5


Now select the Define Condition types option .

6

A new tax condition type can be created by selecting the New Entries button. Already a condition type MWAS is created . Double click on it.

7

The condition class should be D and this condition type is assigned to the access sequence MWST.

8

Now choose the option Define Procedure.

9


A new tax determination procedure can be created by selecting the New Entries button. Select the tax procedure TAXD and choose control data from left side.

10

It includes many condition types . The condition type MWAS is also assigned with accounting key MWS.

11

Next step is to assign the tax determination procedure to the country. Select the option: Assign Country to Calculation Procedure.

12

The tax procedure is assigned to the country.

13


Next step is to define tax codes. In a country , there are many different taxes for different things like for goods, services. Select the option Define Tax Codes for sales and purchase.

14

Now provide the country first and continue.

15

Here you can provide a two character tax code to be created and hit enter key.

16

Provide a Z1 and the below screen appears. Here you have to specify tax type as input or output tax and other related fields.

18

Already tax code- A0 create in the system . Provide that and see the details.

17

The tax procedure is determined from the country and the tax code A0 is an output tax type.

In the table section all tax type like base amount, output tax, input tax,  Travel Expenses(%) appears from the condition types assigned to the tax procedure.

The tax percentage is 0,00. Means when tax code A0 is assigned then the output tax would be 0.00 %.

19


Similarly we have tax code – A1 with 19% for the output tax.

2021


Similarly we have tax code – A2 with 7% for the output tax.

2223


Now we have to define the tax G/L account.

Select Define Tax Account option y navigating along the highlighted SPRO path.

24

Double click on the Transaction – MWS .

25

provide the company code chat of account and continue.

26

Here you can provide G/L account to store the tax entries.

27


The demo is shown for company code- 1000. The chart of account for the company code- 1000 as below.

192021


Up to now in FI module we checked how tax procedure is created and assigned to a country, defining different tax codes for each county  and assigning the tax G/L account with the chart of account and the transaction MWS.


 

Let’s check the pricing procedure in SD side.

2829

We have pricing procedure RVAA01 is assigned to the tax condition type MWST and accounting key MWS.

30

31


We have the customer pricing procedure as below.

3233

We have the document pricing procedure as below.

3436


The  sales order type – DR is assigned to the document pricing procedure.

3738

Customer is assigned to the customer pricing procedure.

41

Here we have assigned the pricing procedure to the sales area, doc pricing procedure & customer pricing procedure.

3940


The customer tax class & material tax class are defined in below highlighted SPRO paths.

4849

Customer Tax classes.

50


 

51

Material tax classes.

52


Country DE is assigned to the tax category as MWST.

5354


Now lets check the customer master. The tax class for customer master is 1.

46

Lets check the material master. The tax class for material is 1.

47


To create condition records for the pricing condition type Tx- VK11/VK12/VK13 are used for create/change/display purpose.

As we are looking how tax G/L account is determined, lets try to create the condition record for the tax condition type MWST. Execute Tx- VK11 and provide tax condition type MWST and hit enter key.

65

For the pricing condition type MWST, there are 3 access lines assigned to the access sequence. Select second one and continue.

66

Provide a Country as DE in the header section.

Then from the TAX CODE column, the field provides a F4 help which lists all the tax codes  defined for the country DE with the tax procedure.

67

Once the Tax class for customer is provided and tax class for material is provided,choose the tax code, accordingly the amount field will be filled ( measured in percentage-%).

45

 


Create an order in Tx- VA01 and provide the sold to party and material .

55

Go to the item details.

56

Select analysis button.

57

The pricing procedure is determined as RVAA01.

58

For condition type MWST, the condition record is found.

59

Go back and save the sales document.


create a billing doc for the sales doc- Debit Memo request. Go To- Tx – VA01 and open the sales doc in change mode.

60

Choose Billing.

61

Save it to create billing doc.

62

Open the billing doc in Tx- VF03 and choose Accounting button. Choose Accounting Document.

63

The G/L account number is determined as 480000 for the tax line.

64

 


 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s