Create VAT codes for VAT transaction entry and reporting

This document explains how you create VAT codes, which are the key tax component in M3 Business Engine.

Outcome

The company has a set of VAT codes, each one defining the VAT method to apply and the VAT rates to use for a specific region from a specific date.

Use this procedure to connect a VAT code to a supplier/payer in 'Supplier. Define Purchase & Financial' (CRS624/F), a customer/payer in 'Customer. Open' (CRS610/J), an item in 'Item. Open' (MMS001/G), and an item warehouse in 'Item. Connect Warehouse' (MMS002/I). M3 Business Engine then automatically proposes a matching VAT code in a business transaction.

For more details, refer to the documents listed in the See also section.

Before you start

Before you start, you must meet these prerequisites:

  • For country-specific VAT rates, country codes must exist in 'Country. Open' (CRS045).
  • For provinces with a different VAT rate than the rest of the country, area codes exist in 'States per Country. Open' (CRS046).

Follow these steps

To create a VAT code, follow these steps:

  1. Start 'VAT Code. Open' (CRS030/B).

  2. Define the values described in the Parameters to set table for each VAT code you define in (CRS030) and its sub-program 'VAT Rate. Open' (CRS031).

Parameters to set

This table shows which parameters to set in (CRS030):

Field Field description
VAT code The field indicates a numeric ID of a component that determines the VAT method and VAT rate to apply. The valid alternatives are 00–99. Note that you should use VAT code 00 for transactions outside the scope of VAT, that is, exempt supplies.
VAT method

The field indicates the VAT method, that is, how to calculate VAT for this VAT code. The decision about whether to charge VAT is based on a combination of country codes and VAT method.

Alternatives

1 = Normal VAT. 2 = Combined VAT. 3 = Chain VAT. 7 = Purchase of goods by intermediate party ("middleman") in triangular trade. 8 = Reverse charge of VAT.

VAT Method 1

VAT method 1 (Normal VAT): M3 Business Engine applies one VAT rate and creates one VAT payable or VAT receivable transaction. You can also use this method for normal EU VAT.

These are what apply:

  • If a VAT code with VAT method 1 is used on a non-domestic/non-EU invoice (one or both of base country and From/to country are non-EU member state), no VAT is created, neither for customer invoices nor for supplier invoices.
  • If a VAT code with VAT method 1 is used on an EU invoice (base country and From/to country being two different EU member states; see below), no VAT transaction is created for the customer invoice. However, one VAT payable transaction and one VAT receivable transaction is created for the supplier invoice.
  • If a VAT code with VAT method 1 is used on a domestic invoice (base country and From/to country being the same), one VAT payable transaction is created for the customer invoice and one VAT receivable transaction for the supplier invoice.

These are the prerequisites for EU VAT:

  • The base country is not the same as the From/to country when registering a supplier invoice in (APS100).
  • Alternative 1 is selected in the Extrastat/Intrastat field in (CRS045) for both the base country and the From/to country.
  • A VAT registration number is entered for the supplier in (CRS620/E).

For examples of purchase using VAT method 1, see below.

VAT Method 2

VAT method 2 (Combined VAT): Two VAT rates are used in combination with two VAT accounts for VAT receivable and/or VAT payable. Two VAT calculations are done, both based on the same amount. Combined VAT is only used in very specific situations. It does not work in combination with EU VAT.

VAT Method 3

VAT method 3 (Chain VAT): Two VAT rates are used in combination with two accounts for VAT receivable and/or VAT payable. Two calculations are made. The first calculation is based on the VAT base amount. The second calculation is based on the sum of the VAT base amount and the first VAT calculation.

VAT Method 7

VAT method 7 (Purchase of goods by intermediate party in three-party trading): This VAT method identifies the VAT code as the replacement VAT code for transactions that meet the requirements for purchase of goods by a "middleman" in three-party trading for direct resale, that is, the goods are delivered directly from the vendor to a customer in another EU member state:

  • Each party involved – the customer, the intermediate party and the vendor is in a different EU member state.
  • Each one has a VAT registration number in the respective country.
  • The vendor delivers the goods directly to the customer.

This VAT method is only applicable to companies acting as intermediate party, since the intermediate party does not pay VAT on that type of third-party acquisitions. The VAT method enables companies to be VAT-exempted and to declare this type of transactions in the VAT declaration. More specifically, the intermediate party uses VAT codes with VAT method 7 on the purchase order it creates based on a customer order with line type 2. The purchase order is sent to the vendor making the direct delivery. When the intermediate company matches the invoice from the vendor against the purchase order, M3 Business Engine creates no debit or credit account entries for VAT.

Note that the same VAT code must exist in a VAT exception for replacement of VAT codes in (TXS020) where alternative 3 (Purchase of goods by intermediate party in three-party trading) is selected for control object &TRIA. See VAT Exemptions.

VAT Method 8

VAT method 8 (Reverse charge of VAT): This VAT method is used when a reversed VAT liability is applied, meaning that it is the purchaser and not the vendor that is liable to VAT. The VAT is not charged to the purchaser; instead the invoice states that reverse charge of VAT is applied and the reasons for this. One VAT payable transaction and one VAT receivable transaction are created. This VAT method is not used for customer invoices.

Reverse charge of VAT is used for offset VAT outside the scope of normal EU VAT. For example, a lawyer temporarily working in Switzerland invoices the Swiss employer for services rendered. This export invoice does not include VAT, since Switzerland is not part of the EU. However, the Swiss company is required to report VAT for that invoice and so uses a VAT code with VAT method 8.

VAT reported on payment day The field indicates whether to use payment date as the taxation point.

Normally, most businesses declare VAT on an invoiced basis, since tax authorities of each country use customer and supplier invoices as the tax point for VAT payable and VAT receivable. However, it is possible in some businesses to report VAT on a cash basis (VAT on payments), based on customer and supplier invoices paid during any VAT reporting period. M3 Business Engine enables you to configure VAT codes to report VAT only on paid supplier or customer invoices. In this process, the VAT amounts on a supplier or customer invoice are booked to a VAT suspense account when an invoice is recorded. The VAT is automatically moved from the VAT suspense accounts to the regular VAT payable or receivable account when an invoice is paid or partially paid. The net VAT liability, or debt, is then included in the VAT reporting process. Note that for invoices recorded before the process to move the VAT automatically when an invoice is paid, a separate VAT run is made at the end of each period in 'VAT on Payment. Create Voucher' (TXS115), where the VAT is moved to the regular VAT account for invoices that are paid or partially paid during the period.

If the check box is selected, VAT is booked to a VAT suspense account when the invoice is recorded. Accounting types 113, 114, 213, and 214 in 'Accounting Rule. Set' (CRS395) are reserved for this type of VAT. You should define the accounts connected to the accounting types as suspense accounts in 'Accounting Identity. Open' (CRS630). You should also define the account connected to accounting types 113 and 114 as VAT payable accounts and accounts connected to accounting types 213 and 214 as VAT receivable accounts. The accounting types, 107, 108, 207, and 208 on accounting event TX02 are reserved for the net amount reported as the base for the VAT. A transaction is created when an invoice is paid or partially paid on accounting type 107 for customer invoices and 108 for supplier invoices for the net amount. An offsetting transaction is also created on accounting type 207 for customer invoices and 208 for supplier invoices.

VAT corrections The field indicates whether the VAT code is reserved for creating manual VAT corrections only. By using a separate VAT code for this purpose, you can easily identify such corrective transactions in VAT reporting.
VAT override

The field indicates whether M3 Business Engine always calculates VAT for this VAT code.

In certain cases, agreements between countries make it necessary to be able to overrule the default VAT decision of M3 Business Engine. For example, deliveries from Switzerland to Liechtenstein are subject to VAT as are export deliveries from Russia to other countries. The company manages such exceptions by selecting this check box for the applicable VAT codes. M3 Business Engine then always calculates VAT for this VAT code, even if the countries of the parties involved in normal circumstances would have resulted in a negative VAT decision.

These are the standard scenarios result in these outputs if you select this check box:

  • For domestic customer invoices: domestic VAT is calculated.
  • For EU customer invoices: domestic VAT is calculated.
  • For non-domestic/non EU customer invoices: domestic VAT is calculated.
  • For domestic supplier invoices: domestic VAT is calculated.
  • For EU supplier invoices: offsetting EU VAT is calculated.
  • For non-domestic/non-EU supplier invoices: domestic VAT is calculated.

This table shows which parameters to set in (CRS031):

Field Field description
Country The field indicates a code for the country for which the VAT rate is applicable. If this field is left blank, the VAT rate is not limited to a specific country.
Area/state The field indicates a province that has been granted a different VAT rate than the rest of the country to which it belongs. Examples of such provinces are the Canary Islands, Jersey Island and Finnish land.
From date The field indicates the date from which the VAT rate is considered valid by M3 Business Engine.
VAT rate 1 The field indicates the VAT rate expressed as a percentage to use for the VAT code. The rate can be defined with up to two decimals.
VAT rate 2 The field indicates the second rate to use if you selected VAT method 2 (combined VAT) for the VAT code.
Deductible VAT 1

The field indicates the portion of VAT that is automatically deducted from the VAT receivable and added to the cost during the recording of supplier invoices in (APS100).

The value is used in the calculation of VAT rate 1. If the field is left blank, no deduction is made. If you enter 10, then 10% of the VAT receivable is deducted. If you enter 100, the entire VAT receivable amount is deducted.

Companies are not always permitted to reclaim the entire VAT on certain supplies of goods and services to businesses, such as promotional and marketing expenses, or they are only able to reclaim the VAT partially. M3 Business Engine supports this requirement by using a deductible percentage on a specific VAT code to prevent the VAT receivable from being incorrectly reclaimed. We recommend that you use a FAM function with automatic VAT accounting selected when recording supplier invoices with deductible VAT. Otherwise, you would need to enter VAT amounts manually in (APS100/F).

Example 1

Deduction based on net invoice amount: A company rents a car for a cost of EUR 1,000 including 25% VAT. However, it can only reclaim 75% of the VAT. In practice this means that the non-reclaimable VAT must be deducted from the VAT receivable and included in the VAT base amount when the invoice is recorded. When the invoice for the car rent is received and is ready for entry in (APS100), the company selects a FAM function in (APS100) specifying that VAT account entries are automatically created and that the VAT calculation method is Net. On the coding panel, the invoice net amount (the VAT base amount), that is, EUR 800, is entered together with a VAT code with a VAT deductible percentage of 25. When you press Enter, M3 first calculates the VAT without any deduction: 25% VAT (0.25) multiplied by the invoice net amount of 800 = 200. 25% of the 200 is not reclaimable so M3 multiplies 200 by 0.25 = 50. The EUR 50 are then automatically added to the VAT base amount. The result is two accounting lines on the coding panel, one for the VAT base amount of 850 and one for the reclaimable VAT of 150.

Example 2

Deduction based on gross invoice amount: The scenario is the same but in this case the company selects a FAM function with the VAT calculation method Gross. On the coding panel, the net amount of 1,000 is entered together with the VAT code with the deductible percentage of 25. When you press Enter, M3 first calculates the VAT without any deduction: the invoice gross amount of 1,000 is divided by 1.25 = 800. Consequently, the VAT is 200 (1,000 minus 800). 25% of the 200 is not reclaimable, so 200 is multiplied by 0.25 = 50. The EUR 50 are then added to the VAT base amount. The accounting lines created are the same as in the previous example.

Deductible VAT 2 The field indicates the same value as in the 'Deductible VAT 1' field but applies to VAT rate 2 instead. This value is only used if you selected VAT method 2 or 3 above.
Note: M3 Business Engine retrieves and proposes the correct VAT code to use according to these priority order: 1) VAT code, date, country, area/state; 2) VAT code, date, country (and area/state left blank); 3) VAT code, date (and country and area/state blank).

Example of domestic purchase (within EU) using VAT method 1

This example is based on a VAT rate of 20%. Net method is selected as the VAT calculation method for FAM function AP10. There is no fiscal representative involved.

An Austrian division purchases goods of a net value of EUR 1,000 from a supplier based in Austria. These account entries are created:

Account Comment Amount
AP account Based on accounting rule AP10-200. – 1,200
VAT receivable Based on accounting rule AP10-211 + 200
Cost/Inventory or Goods Delivered/Not Invoiced Account manually entered or based on either accounting rule PP20-952 or PP20-225. + 1,000

Example of purchase from another EU member state using VAT method 1

This example is based on a VAT rate of 20%. Net method is selected as the VAT calculation method for FAM function AP10. There is no fiscal representative involved.

An Austrian division purchases goods of a net value of EUR 1,000 from a supplier based in Germany. The supplier has a valid VAT registration number. These account entries are created:

Account Comment Amount
AP account Based on accounting rule AP10-200. –1,000
VAT payable Based on accounting rule AP10-111. –200
VAT receivable Based on accounting rule AP10-211. +200
Cost/Inventory or Goods Delivered/Not Invoiced Account manually entered or based on either accounting rule PP20-952 or PP20-225. +1000

Example of purchase from Non-EU member state using VAT method 1

This example is based on a VAT rate of 20%. Net method is selected as the VAT calculation method for FAM function AP10. There is no fiscal representative involved.

An Austrian division purchases goods of a net value of EUR 1,000 from a supplier based in Switzerland. These account entries are created:

Account Comment Amount
AP account Based on accounting rule AP10-200. –1,000
Cost/Inventory or Goods Delivered/Not Invoiced Account manually entered or based on either accounting rule PP20-952 or PP20-225. +1000