Initiate VAT Run and Correct VAT Transactions Online

This document explains how you select and review transactions in a VAT run, correcting any transactions with a variance between the calculated VAT and the recorded VAT online in a separate online adjustment table.

The selection for the VAT run can be made using a user-defined VAT report template. The VAT run can be performed for internal simulation, reconciliation or analysis purposes, or for reporting VAT to the tax authorities.

Outcome

Use these settings when you want to carry out one of the following:

Before You Start

Follow These Steps

Select one of the following alternatives:

Review and Correct Transactions Online

  1. In (TXS100/B), select option 15='Create online adjustment' for the VAT run.

  2. On the H panel, where the selection used when creating the VAT run is proposed, you can define a further selection of the transactions selected based on the following values: To VAT date, ranges of VAT codes and voucher numbers, the difference between calculated and the recorded VAT expressed as a percentage or as an amount, the inclusion of VAT payable or VAT receivable transactions or both (mandatory), and the inclusion or exclusion of transactions already VAT reported.

    You can select to include only transactions that are or are not VAT reported, or both. In periodic VAT reporting, only new VAT transactions are included. However, if the company wants to create a VAT report for the entire year, for example, they would want to include VAT transactions already reported.

    If you do not enter a difference, all transactions, with or without such a difference, will be displayed in the online adjustment table.

  3. Press Enter to create a work table with transactions that both match your selection in the background.

  4. In (TXS100/B), select option 16='Work with online adjustment' for the VAT run to display the transactions in 'Online VAT Adjustment. Open' (TXS120).

    The sub-file displays transaction and VAT details for each transaction. Standard values are:

    • Calculation base amount (on which the VAT is calculated): The base amount for all transactions on accounts of VAT account types 3–9.
    • Calculated VAT: Calculated VAT amount 1 and calculated VAT amount 2 for all transactions on accounts of VAT account types 3–9.
    • Calculated variance: The difference between calculated VAT and recorded VAT.
    • Recorded VAT: The total of all transactions on accounts of VAT account type 1 (VAT payable) and 2 (VAT receivable). Note that VAT payable is excluded for EU VAT transactions (transaction code 41) created with VAT codes with VAT method 8, since the VAT amounts are zero on all EU transactions.
    • Recalculated VAT amount: This value is calculated separately by M3 when creating the work table by multiplying the calculation base amount by the VAT rate (1 and 2). Based on that, the difference between the recalculated variance is defined.
    • Recalculated variance: The difference between the recorded VAT and the recalculated VAT. In theory, the difference would always be identical to the calculated variance. However, the calculation is done for extra security and to enable the user to easily identify any discrepancies that require investigation.
  5. Select option 7='Change VAT info' for a transaction to display the accounting lines in 'Voucher. Display' (GLS200/B).

    The view selected determines which values are displayed in the sub-file. See the Before Starting section.

  6. In (GLS200/B), select option 7='Change VAT info' for the accounting line (a VAT transaction or a transaction on which the VAT is based) to correct.

    You can change values for all revenue and expense transactions, that is, all transactions recorded on an account with a VAT account type higher than 2. You cannot change transactions that already have been used as a base for a VAT declaration voucher.

  7. If applicable, change the service code in (GLS200/F

  8. In (GLS200/G), change any of the following values: VAT code, VAT rates 1 and 2, VAT account type, base country and from/to country, VAT date and VAT registration number. Press Enter.

  9. If you change the VAT code, the VAT rate and VAT amount is updated accordingly. If you remove the VAT registration number, the 'VAT registration number existed' check box is automatically deselected.

  10. Press F3 to return to (TXS120) and repeat the procedure for any other transactions to correct.

VAT Values in General Ledger

In each business transaction involving goods or services subject to VAT, M3 Business Engine stores a set of VAT values for each accounting line in every voucher with a VAT account, apart from the recorded VAT itself. The table below describes these values.

Field heading Description
Tax code (VTCD) The tax code based on which the VAT amount was recorded.
VAT account type (AT04) The type of VAT account – such as a VAT payable or a VAT receivable account – as defined in 'Accounting Identity' (CRS630/E). For details, see Configuring M3 Business Engine for VAT Management.
VAT rate 1 (VTP1) The VAT rate applied to calculate VAT amount 1. See the following section.
VAT rate 2 (VTP2) The VAT rate applied to calculate VAT amount 2 when chain VAT (combined VAT) is selected as the VAT method for the tax code.
Calculated VAT amount 1 (EGCVT1)

Whenever M3 Business Engine identifies a transaction as subject to VAT, it also stores a calculated VAT amount in the accounting line for the actual, recorded VAT amount. Normally, both amounts are the same. Comparing the calculated and the recorded VAT amounts per transactions helps identifying any potential errors during the reconciliation for the VAT declaration. Read more in Reconciling and Declaring VAT.

(GLS211/G) has two fields for calculated VAT. Two VAT amounts are calculated in the following scenarios:

1) The company division has purchased goods or services from another EU member state and consequently records EU VAT. The first field, 'Calculated VAT amount 1' (field ID CVT1), stores the calculated VAT receivable amount and the second field, 'Calculated VAT amount 2' (field ID CVT2), stores the calculated VAT payable amount, that is, the negative offsetting, attributable VAT).

2) Chain VAT is the selected VAT method of the tax code applied. This means that two VAT rates are used. Two calculations are made. The value in the 'Calculated VAT amount 1' field is based on the VAT base amount, whereas the value in the 'Calculated VAT amount2' field is based on the sum of the VAT base amount and the first VAT calculation.

Calculated VAT amount 2 (EGCVT2) See the description of field 'Calculated VAT amount 1'.
Base country (BSCD) See section How M3 Business Engine Identifies Countries Involved.
From/To country (TFCD) See section How M3 Business Engine Identifies Countries Involved.
VAT date (VATD) Indicates the VAT date, which is either the accounting date or the invoice date or (for purchases only) the delivery date, depending on the alternative selected in 'Settings – General Ledger' (CRS750/F). You select transactions for VAT declarations based on the VAT date in (TXS100/E).
VAT reported (VATR) Indicates whether the transaction has been included in a confirmed VAT declaration in (TXS100).
VAT registration number existed (VRNE) Indicates whether a VAT registration number was found for the customer in 'Customer. Open' (CRS620/E).
VAT registration number (VRNO) Indicates the VAT registration number of the customer.
Related topics