Events
Power BI DataViz World Championships
Feb 14, 4 PM - Mar 31, 4 PM
With 4 chances to enter, you could win a conference package and make it to the LIVE Grand Finale in Las Vegas
Learn moreThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
This article describes how to set up the value-added tax (VAT) declaration for Belgium in XML format, and how to preview the VAT declaration and sales and purchase transactions in Microsoft Excel.
To automatically generate the reports, first create enough sales tax codes to keep a separate VAT accounting for each box on the VAT declaration. Additionally, in the application-specific parameters of the Electronic reporting (ER) format for the VAT declaration, associate sales tax codes with the lookup result of the lookups for the boxes on the VAT declaration.
For Belgium, you must configure the following elements:
For more information about how to set up application-specific parameters, see the Set up application-specific parameters for VAT declaration fields section later in this article.
In the following table, the "Lookup result" column shows the lookup result that is preconfigured for a specific VAT declaration row in the VAT declaration format. Use this information to correctly associate sales tax codes with the lookup result and then with the row of the VAT declaration.
The VAT declaration in Belgium contains the following information.
SECTION II OUTGOING OPERATIONS
You can use the following table to determine how a lookup result that is preconfigured in the format is associated with a VAT declaration box.
A lookup result might generate an amount in several boxes. Those boxes are shown in parentheses. For example, for the 01_SalesLowerReducedRate lookup result, "(01/54)" indicates that the VAT base amount of the transaction is shown in box 01, and the VAT amount of the transaction is shown in box 54.
Description | Box | Lookup result of Report field lookup (VAT base) |
---|---|---|
A. Operations subject to a special regulation | 00 | 00_ExemptSalesSpecialScheme |
B. Transactions for which the VAT is due by the declarant: | ||
- at the rate of 6 pc. | 01 | 01_SalesLowerReducedRate (01/54) |
- at the rate of 12 pc. | 02 | 02_SalesHigherReducedRate (02/54) |
- at the rate of 21 pc. | 03 | 03_SalesStandardRate (03/54) |
C. Services for which the foreign VAT is due by the contracting partner | 44 | 44_ForeignSalesServicesReverseCharge |
D. Transactions for which the VAT is due by the contracting partner | 45 | 45_SalesReverseCharge |
E. Exempt intra-Community supplies made in Belgium and ABC sales | 46 | 46_EUSales |
F. Other exempt operations and other operations performed abroad | 47 | 47_OtherExemptSales |
G. Amount of credit notes issued and negative corrections: | ||
- with regard to the operations registered in grids 44 and 46 | 48 | Lookup results for credit notes: 48_ForeignSalesServicesReverseChargeCreditNoteCorr 48_EUSalesCreditNoteCorr |
- with regard to other operations of Section II | 49 | Lookup results for credit notes: 49_ExemptSalesSpecialSchemeCreditNoteCorr 49_SalesStandardRateCreditNote (49/64) 49_SalesHigherReducedRateCreditNote (49/64) 49_SalesLowerReducedRateCreditNote (49/64) 49_SalesLowerReducedRateNegativeCorrection (49/62) 49_SalesHigherReducedRateNegativeCorrection (49/62) 49_SalesStandardRateNegativeCorrection (49/62) 49_SalesReverseChargeCreditNoteCorr 49_OtherExemptSalesCreditNoteCorr |
SECTION III INCOMING OPERATIONS
You can use the following table to determine how a lookup result that is preconfigured in the format is associated with a VAT declaration box.
A lookup result might generate an amount in several boxes, and the amounts might have different signs. Those boxes and signs are shown in parentheses. For example, for the 8185_PurchasesGoodsCreditNote lookup result, "(-81 +85/63)" indicates that the VAT base amount of the transaction is shown in box 81 as a negative value and in box 85 as a positive value, and the VAT amount of the transaction is shown in box 63 as a positive value.
Note
Boxes 81, 82, and 83 always contain the VAT base amount plus the amount of non-deductible VAT. Other boxes in this section contain the VAT base amount.
Description | Box | Lookup result of Report field lookup |
---|---|---|
A. Amount of incoming operations taking into account the credit notes received and other corrections: - goods, raw materials and consumables |
81 | 81_PurchasesGoods (81/59) 81_PurchasesGoodsRegularizations (-81 +61) Lookup result for credit notes: 8185_PurchasesGoodsCreditNote (-81 +85/63) Lookup results for use tax: 8681_EUPurchasesGoodsUseTax (86/81 55/59) 8781_OtherPurchasesDomesticReverseChargeGoodsUseTax (87/81 56/59) 8781_OtherPurchasesImportsDeferredTaxGoodsUseTax (87/81 57/59) Lookup results for credit notes with use tax: 868184_EUPurchasesGoodsCreditNoteUseTax (-86/81 +84/61/62) 878185_OtherPurchasesDomesticReverseChargeGoodsCNUseTax (-87/81 +85/61/62) 878185_OtherPurchasesImportsDeferredTaxGoodsCNUseTax (-87/81 +85/61/62) |
- services and miscellaneous goods | 82 | 82_PurchasesServicesMisc (82/59) 82_PurchasesServicesRegularizations (-82 +61) Lookup result for credit notes: 8285_PurchasesServicesMiscCreditNote (-82 +85/63) Lookup results for use tax: 8682_EUPurchasesMiscUseTax (86/82 55/59) 8782_OtherPurchasesDomesticReverseChargeMiscUseTax (87/82 56/59) 8782_OtherPurchasesImportsDeferredTaxMiscUseTax (87/82 57/59) 8882_EUPurchasesServicesUseTax (88/82 55/59) Lookup results for credit notes with use tax: 868284_EUPurchasesMiscCreditNoteUseTax (-86/82 +84/61/62) 878285_OtherPurchasesDomesticReverseChargeMiscCNUseTax (-87/82 +85/61/62) 878285_OtherPurchasesImportsDeferredTaxMiscCNUseTax (-87/82 +85/61/62) 888284_EUPurchasesServicesCreditNoteUseTax (-88/82 +84/61/62) |
- company assets | 83 | 83_PurchasesCapitalGoods (83/59) 83_PurchasesCapitalGoodsRegularizations (-83 +61) Lookup result for credit notes: 8385_PurchasesCapitalGoodsCreditNote (-83 +85/63) Lookup results for use tax: 8683_EUPurchasesCapitalGoodsUseTax (86/83 55/59) 8783_OtherPurchasesDomesticReverseChargeCapitalGoodsUseTax (87/83 56/59) 8783_OtherPurchasesImportsDeferredTaxCapitalGoodsUseTax (87/83 57/59) Lookup results for credit notes with use tax: 868384_EUPurchasesCapitalGoodsCreditNoteUseTax (-86/83 +84/61/62) 878385_OtherPurchasesDomesticReverseChargeCapitalGoodsUseTax (-87/83 +85/61/62) 878385_OtherPurchasesImportsDeferredTaxCapitalGoodsUseTax (-87/83 +85/61/62) |
B. Amount of credit notes received and negative corrections: | ||
- with regard to the operations registered in boxes 86 and 88 | 84 | Lookup results for credit notes: 8684_EUPurchasesCreditNoteRC (-86 +84/62) 8884_EUPurchasesServicesCreditNoteRC (-88 +84/62) Lookup results for credit notes with use tax: 868184_EUPurchasesGoodsCreditNoteUseTax (-86/81 +84/61/62) 868284_EUPurchasesMiscCreditNoteUseTax (-86/82 +84/61/62) 868384_EUPurchasesCapitalGoodsCreditNoteUseTax (-86/83 +84/61/62) 888284_EUPurchasesServicesCreditNoteUseTax (-88/82 +84/61/62) |
- with regard to the other operations of Box III | 85 | Lookup results for credit notes: 8185_PurchasesGoodsCreditNote (-81 +85/63) 8285_PurchasesServicesMiscCreditNote (-82 +85/63) 8785_OtherPurchasesImportsDeferredTaxCreditNote (-87 +85/62) Lookup results for credit notes with use tax: 878185_OtherPurchasesDomesticReverseChargeGoodsCNUseTax (-87/81 +85/61/62) 878285_OtherPurchasesDomesticReverseChargeMiscCNUseTax (-87/82 +85/61/62) 878385_OtherPurchasesDomesticReverseChargeCapitalGoodsUseTax (-87/83 +85/61/62) 878185_OtherPurchasesImportsDeferredTaxGoodsCNUseTax (-87/81 +85/61/62) 878285_OtherPurchasesImportsDeferredTaxMiscCNUseTax (-87/82 +85/61/62) 878385_OtherPurchasesImportsDeferredTaxCapitalGoodsUseTax (-87/83 +85/61/62) |
C. Intra-Community acquisitions made in Belgium and ABC sales | 86 | 86_EUPurchasesRC (86/55) Lookup result for credit notes: 8684_EUPurchasesCreditNoteRC (-86 +84/62) Lookup results for use tax: 8681_EUPurchasesGoodsUseTax (86/81 55/59) 8682_EUPurchasesMiscUseTax (86/82 55/59) 8683_EUPurchasesCapitalGoodsUseTax (86/83 55/59) Lookup results for credit notes with use tax: 868184_EUPurchasesGoodsCreditNoteUseTax (-86/81 +84/61/62) 868284_EUPurchasesMiscCreditNoteUseTax (-86/82 +84/61/62) 868384_EUPurchasesCapitalGoodsCreditNoteUseTax (-86/83 +84/61/62) |
D. Other incoming operations for which the VAT is due by the declarant | 87 | 87_OtherPurchasesDomesticReverseCharge (87/56) 87_OtherPurchasesImportsDeferredTax (87/57) Lookup results for credit notes: 8785_OtherPurchasesDomesticReverseChargeCreditNote (-87 +85/62) 8785_OtherPurchasesImportsDeferredTaxCreditNote (-87 +85/62) Lookup results for use tax: 8781_OtherPurchasesImportsDeferredTaxGoodsUseTax (87/81 57/59) 8782_OtherPurchasesImportsDeferredTaxMiscUseTax (87/82 57/59) 8783_OtherPurchasesImportsDeferredTaxCapitalGoodsUseTax (87/83 57/59) 8781_OtherPurchasesDomesticReverseChargeGoodsUseTax (87/81 56/59) 8782_OtherPurchasesDomesticReverseChargeMiscUseTax (87/82 56/59) 8783_OtherPurchasesDomesticReverseChargeCapitalGoodsUseTax (87/83 56/59) Lookup results for credit notes with use tax: 878185_OtherPurchasesImportsDeferredTaxGoodsCNUseTax (-87/81 +85/61/62) 878285_OtherPurchasesImportsDeferredTaxMiscCNUseTax (-87/82 +85/61/62) 878385_OtherPurchasesImportsDeferredTaxCapitalGoodsUseTax (-87/83 +85/61/62) 878185_OtherPurchasesDomesticReverseChargeGoodsCNUseTax (-87/81 +85/61/62) 878285_OtherPurchasesDomesticReverseChargeMiscCNUseTax (-87/82 +85/61/62) 878385_OtherPurchasesDomesticReverseChargeCapitalGoodsUseTax (-87/83 +85/61/62) |
E. Intra-Community services with reverse charge | 88 | 88_EUPurchasesServicesRC (88/55) Lookup result for credit notes: 8884_EUPurchasesServicesCreditNoteRC (-88 +84/62) Lookup result for use tax: 8882_EUPurchasesServicesUseTax (88/82 55/59) Lookup result for credit notes with use tax: 888284_EUPurchasesServicesCreditNoteUseTax (-88/82 +84/61/62) |
SECTION IV TAX PAYABLE
You can use the following table to determine how a lookup result that is preconfigured in the format is associated with a VAT declaration box.
Description | Box | Lookup result of Report field lookup |
---|---|---|
A. VAT on the operations indicated in: - the boxes 01, 02 and 03 |
54 | 01_SalesLowerReducedRate (01/54) 02_SalesHigherReducedRate (02/54) 03_SalesStandardRate (03/54) |
- the boxes 86 and 88 | 55 | 86_EUPurchasesRC (86/55) 88_EUPurchasesServicesRC (88/55) Lookup results for use tax: 8681_EUPurchasesGoodsUseTax (86/81 55/59) 8682_EUPurchasesMiscUseTax (86/82 55/59) 8882_EUPurchasesServicesUseTax (88/82 55/59) 8683_EUPurchasesCapitalGoodsUseTax (86/83 55/59) |
- box 87, with the exception of imports with reverse charge | 56 | 87_OtherPurchasesDomesticReverseCharge (87/56) Lookup results for use tax: 8781_OtherPurchasesDomesticReverseChargeGoodsUseTax (87/81 56/59) 8782_OtherPurchasesDomesticReverseChargeMiscUseTax (87/82 56/59) 8783_OtherPurchasesDomesticReverseChargeCapitalGoodsUseTax (87/83 56/59) |
B. VAT on imports with reverse charge | 57 | 87_OtherPurchasesImportsDeferredTax (87/57) Lookup results for use tax: 8781_OtherPurchasesImportsDeferredTaxGoodsUseTax (87/81 57/59) 8782_OtherPurchasesImportsDeferredTaxMiscUseTax (87/82 57/59) 8783_OtherPurchasesImportsDeferredTaxCapitalGoodsUseTax (87/83 57/59) |
C. Various VAT regularizations in favor of the State | 61 | 61_VATRegularizationsDue 81_PurchasesGoodsRegularizations (-81 +61) 82_PurchasesServicesRegularizations (-82 +61) 83_PurchasesCapitalGoodsRegularizations (-83 +61) Lookup results for credit notes with use tax: 868184_EUPurchasesGoodsCreditNoteUseTax (-86/81 +84/61/62) 868284_EUPurchasesMiscCreditNoteUseTax (-86/82 +84/61/62) 868384_EUPurchasesCapitalGoodsCreditNoteUseTax (-86/83 +84/61/62) 878185_OtherPurchasesDomesticReverseChargeGoodsCNUseTax (-87/81 +85/61/62) 878285_OtherPurchasesDomesticReverseChargeMiscCNUseTax (-87/82 +85/61/62) 878385_OtherPurchasesDomesticReverseChargeCapitalGoodsUseTax (-87/83 +85/61/62) 878185_OtherPurchasesImportsDeferredTaxGoodsCNUseTax (-87/81 +85/61/62) 878285_OtherPurchasesImportsDeferredTaxMiscCNUseTax (-87/82 +85/61/62) 878385_OtherPurchasesImportsDeferredTaxCapitalGoodsUseTax (-87/83 +85/61/62) 888284_EUPurchasesServicesCreditNoteUseTax (-88/82 +84/61/62) |
D. Refundable VAT stated on credit notes received | 63 | Lookup results for credit notes: 8185_PurchasesGoodsCreditNote (-81 +85/63) 8285_PurchasesServicesMiscCreditNote (-82 +85/63) 8385_PurchasesCapitalGoodsCreditNote (-83 +85/63) |
Total of the boxes 54, 55, 56, 57, 61 and 63 | XX | 54 + 55 + 56 + 57 + 61 + 63 |
SECTION V TAX DEDUCTIBLE
You can use the following table to determine how a lookup result that is preconfigured in the format is associated with a VAT declaration box.
Description | Box | Lookup result of Report field lookup |
---|---|---|
A. Deductible VAT | 59 | 81_PurchasesGoods (81/59) 82_PurchasesServicesMisc (82/59) 83_PurchasesCapitalGoods (83/59) Lookup results for use tax: 8681_EUPurchasesGoodsUseTax (86/81 55/59) 8682_EUPurchasesMiscUseTax (86/82 55/59) 8683_EUPurchasesCapitalGoodsUseTax (86/83 55/59) 8781_OtherPurchasesDomesticReverseChargeGoodsUseTax (87/81 56/59) 8782_OtherPurchasesDomesticReverseChargeMiscUseTax (87/82 56/59) 8783_OtherPurchasesDomesticReverseChargeCapitalGoodsUseTax (87/83 56/59) 8781_OtherPurchasesImportsDeferredTaxGoodsUseTax (87/81 57/59) 8782_OtherPurchasesImportsDeferredTaxMiscUseTax (87/82 57/59) 8783_OtherPurchasesImportsDeferredTaxCapitalGoodsUseTax (87/83 57/59) 8882_EUPurchasesServicesUseTax (88/82 55/59) |
B. Various VAT regularizations in favor of the declarant | 62 | 62_VATRegularizationsDeduction Lookup results for credit notes and corrections: 49_SalesLowerReducedRateNegativeCorrection (49/62) 49_SalesHigherReducedRateNegativeCorrection (49/62) 49_SalesStandardRateNegativeCorrection (49/62) 8684_EUPurchasesCreditNoteRC (-86 +84/62) 8884_EUPurchasesServicesCreditNoteRC (-88 +84/62) 8785_OtherPurchasesImportsDeferredTaxCreditNote (-87 +85/62) 8785_OtherPurchasesDomesticReverseChargeCreditNote (-87 +85/62) 8884_EUPurchasesServicesCreditNoteRC (-88 +84/62) Lookup results for credit notes with use tax: 868184_EUPurchasesGoodsCreditNoteUseTax (-86/81 +84/61/62) 868284_EUPurchasesMiscCreditNoteUseTax (-86/82 +84/61/62) 868384_EUPurchasesCapitalGoodsCreditNoteUseTax (-86/83 +84/61/62) 878185_OtherPurchasesDomesticReverseChargeGoodsCNUseTax (-87/81 +85/61/62) 878285_OtherPurchasesDomesticReverseChargeMiscCNUseTax (-87/82 +85/61/62) 878385_OtherPurchasesDomesticReverseChargeCapitalGoodsUseTax (-87/83 +85/61/62) 878185_OtherPurchasesImportsDeferredTaxGoodsCNUseTax (-87/81 +85/61/62) 878285_OtherPurchasesImportsDeferredTaxMiscCNUseTax (-87/82 +85/61/62) 878385_OtherPurchasesImportsDeferredTaxCapitalGoodsUseTax (-87/83 +85/61/62) 888284_EUPurchasesServicesCreditNoteUseTax (-88/82 +84/61/62) |
C. VAT to be recovered stated on credit notes issued | 64 | Lookup results for credit notes: 49_SalesStandardRateCreditNote (49/64) 49_SalesHigherReducedRateCreditNote (49/64) 49_SalesLowerReducedRateCreditNote (49/64) |
Total of the boxes 59, 62 and 64 | YY | 59 + 62 + 64 |
SECTION VI BALANCE
Description | Box | Calculation |
---|---|---|
Only one of the two following boxes can be filled in: | ||
Tax due to the State: box XX - box YY | 71 | XX – YY, if XX >= YY |
Amounts owed by the State: box YY - box XX | 72 | YY – XX, if YY > XX |
SECTION VII DEPOSIT
Description | Box | Calculation |
---|---|---|
Actual VAT due for the period from December 1 to December 20 in the monthly declaration, or for the period from October 1 to December 20 in the quarterly declaration | 91 | The 91 Deposit amount to be paid in December input parameter in the user dialog box |
If you configure sales tax codes to post incoming reverse charge VAT by using use tax, associate your sales tax codes with the lookup result of Report field lookup that contains "UseTax" in the name.
Alternatively, you can configure two separate sales tax codes: one for VAT due and one for VAT deduction. Then associate each code with the corresponding lookup results of Report field lookup.
For example, for taxable intra-community acquisitions, you configure sales tax code UT_S_EU with use tax and associate it with the 8681_EUPurchasesGoodsUseTax (86/81 55/59) lookup result of Report field lookup. In this case, tax amounts that use the UT_S_EU sales tax code are reflected in boxes 59 ("Deductible VAT") and 55 ("VAT on the operations indicated in the boxes 86, 88"). Tax bases are reflected in boxes 81 ("Amount of incoming operations: goods, raw materials and consumables") and 86 ("Intra-Community acquisitions made in Belgium and ABC sales").
Alternatively, you configure two sales tax codes:
You then associate the codes with lookup results of Report field lookup in the following way:
In this case, amounts that use the VAT_S_EU sales tax code are reflected in boxes 55 ("VAT on the operations indicated in the boxes 86, 88") and 86 ("Intra-Community acquisitions made in Belgium and ABC sales"). Amounts that use the InVAT_S_EU sales tax code are reflected in boxes 59 ("Deductible VAT") and 81 ("Amount of incoming operations: goods, raw materials and consumables").
For more information about how to configure reverse charge VAT, see Reverse charges.
In Belgium, amounts of credit notes and negative corrections are shown in separate boxes on the VAT declaration. Therefore, in the preceding tables, specific lookup results for Report field lookup are dedicated to credit notes and negative corrections.
Example: Sales
A sale of goods (Invoice 1) has a VAT base of 1,000.00 euros (EUR) and a VAT amount of 210.00 EUR. This sale can be shown in the following boxes:
A credit note (Credit note 1) that is issued or a negative correction for the preceding invoice has a VAT base of -300.00 EUR and a VAT amount of -63.00 EUR. This credit note or correction can be shown in the following boxes:
Example: Purchases
A purchase of goods (Invoice 2) has a VAT base of 1,000.00 EUR and a VAT amount of 210.00 EUR. This purchase can be shown in the following boxes:
A credit note (Credit note 2) that is received or a negative correction for the preceding invoice has a VAT base of -400 EUR and a VAT amount of -84 EUR. This credit note or correction can be shown in the following boxes:
In Belgium, you can generate a list of sales and purchase transactions.
The following examples show what these reports look like for the examples in the previous section.
Example: Sales transactions
Document number | Box 03 | Box 54 | Box 49 | Box 64 |
---|---|---|---|---|
Invoice 1 | 1,000.00 | 210.00 | 00.00 | 00.00 |
Credit note 1 | 00.00 | 00.00 | 300.00 | 63.00 |
Example: Purchases transactions
Document number | Box 81 | Box 59 | Box 85 | Box 63 |
---|---|---|---|---|
Invoice 2 | 1,000.00 | 210.00 | 00.00 | 00.00 |
Credit note 2 | -400.00 | 00.00 | 400.00 | 84.00 |
To generate a VAT declaration, you must configure the enterprise tax number.
For more information about how to set up registration categories and registration types, see Registration IDs.
For more information, see Download ER configurations from the Global repository of Configuration service.
Note
We recommend that you enable the Use application specific parameters from previous versions of ER formats feature in the Feature management workspace. When this feature is enabled, parameters that are configured for earlier versions of an ER format automatically become applicable for later versions of the same format. If this feature isn't enabled, you must explicitly configure application-specific parameters for each format version. The Use application specific parameters from previous versions of ER formats feature is available in the Feature management workspace as of Dynamics 365 Finance version 10.0.23. For more information about how to set up the parameters of an ER format for each legal entity, see Set up the parameters of an ER format per legal entity.
To automatically generate a VAT declaration, associate sales tax codes in the application and lookup results in the ER configuration.
Follow these steps to define which sales tax codes generate which boxes on the VAT declaration.
Go to Workspaces > Electronic reporting and select Reporting configurations.
Select the VAT declaration XML (BE) configuration, and then select Configurations > Application specific parameters > Setup.
On the Application specific parameters page, on the Lookups FastTab, select Report field lookup.
On the Conditions FastTab, set the following fields to associate the sales tax codes and report fields.
Field | Description |
---|---|
Lookup result | Select the value of the report field. For more information about the values and their assignment to VAT declaration rows, see the VAT declaration overview section earlier in this article. |
Tax code | Select the sales tax code to associate with the report field. Posted tax transactions that use the selected sales tax code will be collected in the appropriate declaration box. We recommend that you separate sales tax codes in such a way that one sales tax code generates amounts in only one declaration box. |
Transaction classifier | Select a transaction classifier. The following transaction classifiers are available: - Purchase (tax receivable) - PurchaseExempt (tax-exempt purchase) - PurchaseReverseCharge (tax receivable from a purchase reverse charge) - Sales (tax payable) - SalesExempt (tax-exempt sale) - SalesReverseCharge (tax payable from a purchase reverse charge) - Use tax (use tax) For each transaction classifier, a classifier for the credit note is also available. For example, one of these classifiers is PurchaseCreditNote (purchase credit note). Be sure to create two lines for each sales tax code: one that has the transaction classifier value and one that has the transaction classifier for the credit note value. |
Note
Associate all sales tax codes with lookup results. If any sales tax codes should not generate values on the VAT declaration, associate them with the Other lookup result. There is a value for the Private lookup result. If you associate a sales tax code with the Private lookup result, the transaction amount that has the selected sales tax code won't be shown in any box of the VAT declaration. Instead, it will be shown in the Private column of the Purchase transactions report. You can identify purchases that are used for private purposes only setting up a sales tax code with Non deductible % field set to 100 percent. If purchases are partially used for private purposes, you should have separate sales tax codes for normal use and private use.
Important
Any negative tax transaction is classified as a credit note in the Transaction classifier field. Before you set up application-specific parameters, carefully review all types of negative operations in the application that are related to credit notes, negative corrections, and cancellations. Before you post any operations, decide whether you must configure additional sales tax codes for all or some negative transactions, or whether the same sales tax codes that you use for invoices can be used for some negative transactions.
The following examples show how different setting affect the results on the VAT declaration.
Scenario 1: An invoice and a negative invoice are posted by using the same sales tax code
For this example, an invoice has a VAT base of 1,000.00 EUR and a VAT amount of 210.00 EUR. A negative invoice has a VAT base of -600.00 and a VAT amount of -126.00 EUR. Both are posted by using the VAT_S sales tax code.
Case 1: Lookup results are set up in the following way.
Lookup result | Label | Line | Tax code | Transaction classifier |
---|---|---|---|---|
03_SalesStandardRate | 03/54 Transactions subject to the rate of 21 % | 1 | VAT_S | Sales |
49_SalesStandardRateCreditNote | 49/64 Credit notes issued in respect of transactions subject to the rate of 21 % [03] | 2 | VAT_S | SalesCreditNote |
In this case, the VAT declaration will show the following results:
Case 2: Lookup results are set up in the following way.
Lookup result | Label | Line | Tax code | Transaction classifier |
---|---|---|---|---|
03_SalesStandardRate | 03/54 Transactions subject to the rate of 21 % | 1 | VAT_S | Sales |
49_SalesStandardRateNegativeCorrection (49/62) | 49/62 Negative corrections in respect of transactions subject to the rate of 21 % [03] | 2 | VAT_S | SalesCreditNote |
In this case, the VAT declaration will show the following results:
Case 3: Lookup results are set up in the following way.
Lookup result | Label | Line | Tax code | Transaction classifier |
---|---|---|---|---|
03_SalesStandardRate | 03/54 Transactions subject to the rate of 21 % | 1 | VAT_S | Sales |
03_SalesStandardRate | 03/54 Transactions subject to the rate of 21 % | 2 | VAT_S | SalesCreditNote |
In this case, the VAT declaration will show the following results.
Scenario 2: An invoice and one negative invoice are posted by using the same sales tax code, but another negative invoice is posted by using a specially defined sales tax code
For this example, an invoice has a VAT base of 1,000.00 EUR and a VAT amount of 210.00 EUR. Negative invoice 1 has a VAT base of -600.00 and a VAT amount of -126.00 EUR. Negative invoice 2 has a VAT base of -100.00 and a VAT amount of -21.00.
The invoice and negative invoice 1 are posted by using the VAT_S sales tax code, but negative invoice 2 is posted by using a specially defined sales tax code, VAT_S_CN.
Lookup results are set up in the following way.
Lookup result | Label | Line | Tax code | Transaction classifier |
---|---|---|---|---|
03_SalesStandardRate | 03/54 Transactions subject to the rate of 21 % | 1 | VAT_S | Sales |
49_SalesStandardRateNegativeCorrection (49/62) | 49/62 Negative corrections in respect of transactions subject to the rate of 21 % [03] | 2 | VAT_S | SalesCreditNote |
49_SalesStandardRateCreditNote | 49/64 Credit notes issued in respect of transactions subject to the rate of 21 % [03] | 3 | VAT_S_CN | SalesCreditNote |
In this case, the VAT declaration will show the following results:
In Belgium, the Outgoing operations and Incoming operations reports include a column that should show the amount of advances that are related to intra-community acquisitions. You should have a separate sales tax code for these types of advances.
Follow these steps to define which sales tax codes generate the amount of advances that are related to intra-community acquisitions. These steps are a continuation of the steps in the Set up application-specific parameters for Report field lookup section.
On the Application specific parameters page, on the Lookups FastTab, select Advances related to Intra-community acquisitions.
On the Conditions FastTab, create a new line and set the following fields:
On the Conditions FastTab, create a new line and set the following fields:
The Incoming operations report includes a Nature column that can show a description of goods and services.
Follow these steps to define which item sales tax groups generate which description of the nature on the report. These steps are continuation of the steps in the previous section.
On the Application specific parameters page, on the Lookups FastTab, select Nature.
On the Conditions FastTab, set the following fields:
In the State field, change the value to Completed.
On the Action Pane, select Export to export the settings in an XML file. Then close the page.
Select the VAT declaration Excel (BE) configuration, and then select Configurations > Application specific parameters > Setup.
Select Import, and select the file that you exported earlier.
In the Feature management workspace, find and select the VAT statement format reports feature in the list, and then select Enable now.
Go to General ledger > Setup > General ledger parameters.
On the Sales tax tab, on the Tax options FastTab, in the VAT statement format mapping field, select the VAT declaration Excel (BE) ER format.
This format is printed when you run the Report sales tax for settlement period report. It's also printed when you select Print on the Sales tax payments page.
In the Special report section, check that Include corrections is set to Yes.
On the Tax authorities page, select the tax authority, and in the Report layout field, select Default.
If you're configuring the VAT declaration in a legal entity that has multiple VAT registrations, follow these steps.
The data package contains electronic message settings that are used to preview the VAT declaration in Excel. You can extend these settings or create your own. For more information about how to work with electronic messaging and create your own settings, see Electronic messaging.
Go to Tax > Periodic tasks > Declarations > Sales tax > Report sales tax for settlement period.
Set the following fields.
Field | Description |
---|---|
Settlement period | Select the settlement period. |
From date | Select the start date of the reporting period. |
Select OK, and then, in the Electronic report parameters dialog box, set the following fields.
Field | Description |
---|---|
91 Deposit amount to be paid in December | Enter the amount, if applicable. |
Generate reports | Select the reports that should be generated: - Incoming operations - Outgoing operations - VAT declaration preview |
Include fields | Select the columns that should be visible on the Incoming operations and Outgoing operations reports, in addition to the Date, Supplier, and Customer name columns: - Document date - Document number - Account - Voucher - Vat ID |
Select OK, and review the Excel report.
Go to Tax > Periodic tasks > Declarations > Sales tax > Settle and post sales tax.
Set the following fields.
Field | Description |
---|---|
Settlement period | Select the settlement period. |
From date | Select the start date of the reporting period. |
Select OK.
Note
The report is generated only for the selected line of the sales tax payment. If you must generate, for example, a corrective declaration that contains all corrections for the period, or a replacement declaration that contains original data and all corrections, use the Report sales tax for settlement period periodic task.
When you use electronic messages to generate the report, you can collect tax data from multiple legal entities. For more information, see the Run a VAT declaration for multiple legal entities section later in this article.
The following procedure applies to the electronic message processing example that you imported earlier from the LCS Shared asset library.
Note
Steps 5 through 7 are optional.
Optional: On the Messages FastTab, select Collect data, and then select OK. The sales tax payments that were generated earlier are added to the message. For more information, see the Settle and post sales tax section earlier in this article. If you skip this step, you can still generate a VAT declaration by using the Tax declaration version field in the Declaration dialog box.
Optional: On the Message items FastTab, review the sales tax payments that are transferred for processing. By default, all sales tax payments of the selected period that weren't included in any other message of the same processing are included.
Optional: Select Original document to review the sales tax payments or select Delete to exclude sales tax payments from processing. If you skip this step, you can still generate a VAT declaration by using the Tax declaration version field in the Declaration dialog box.
On the Messages FastTab, select Update status. In the Update status dialog box, select Ready to generate, and then select OK. Verify that the message status is changed to Ready to generate.
Select Generate report. To preview the VAT declaration amounts, in the Run processing dialog box, select Preview report, and then select OK.
In the Electronic reporting parameters dialog box, set the fields as described in the Preview the VAT declaration in Excel from the Report sales tax for settlement period periodic task section earlier in this article, and then select OK.
Select the Attachments button (paper clip symbol) in the upper-right corner of the page, and then select Open to open the file. Review the amounts in the Excel documents.
Select Generate report.
To generate a report in XML format, in the Run processing dialog box, select Generate report, and then select OK.
Set the following fields.
Field | Description |
---|---|
Report periodicity | Select Monthly or Quarterly. |
61 VAT regularizations due amount carried over 62 VAT regularizations deduction amount carried over 81 Purchases goods amount carried over 82 Purchases services amount carried over 83 Purchases capital goods amount carried over 86 EU purchases goods amount carried over 87 Other purchases with VAT payable amount carried over 88 EU purchases services amount carried over |
In these fields, you can enter an amount that will be added to the subsequent box amount. You can enter a negative amount. For example, you might have to set these fields if the amount in a box was negative in the previous period, and you had to report 0 (zero) because negative amounts aren't allowed for the box. However, you can carry over the amount from the previous period to the current period. |
91 Deposit amount to be paid in December | Enter the amount, if applicable. |
Replaced VAT declaration | Enter the number of the declaration that you're replacing, if you're reporting corrections. |
Request for reimbursement | Select Yes, or leave the value set to No. |
Request for payment forms | Select Yes, or leave the value set to No. |
Nil annual listing | Select Yes, or leave the value set to No. |
Select OK
Select the Attachments button (paper clip symbol) in the upper-right corner of the page, and download the electronic file that was generated. You should then manually upload this file to the government portal.
To use the formats to report the VAT declaration for a group of legal entities, you must first set up the application-specific parameters of the ER formats for sales tax codes from all required legal entities.
Follow these steps to set up electronic messages to collect data from multiple legal entities.
Go to Workspaces > Feature management.
Find and select the Cross-company queries for the populate records actions feature in the list, and then select Enable now.
Go to Tax > Setup > Electronic messages > Populate records actions.
On the Populate records action page, select the line for BE Populate VAT return records.
In the Datasources setup grid, a new Company field is available. For existing records, this field shows the identifier of the current legal entity.
In the Datasources setup grid, add a line for each additional legal entity that must be included in reporting. For each new line, set the following fields.
Field | Description |
---|---|
Name | Enter a value that will help you understand where this record comes from. For example, enter VAT payment of Subsidiary 1. |
Message item type | Select VAT return. This value is the only value that is available for all the records. |
Account type | Select All. |
Master table name | Specify TaxReportVoucher for all the records. |
Document number field | Specify Voucher for all the records. |
Document date field | Specify TransDate for all the records. |
Document account field | Specify TaxPeriod for all the records. |
Company | Select the ID of the legal entity. |
User query | This checkbox is automatically selected when you define criteria by selecting Edit query. |
For each new line, select Edit query, and specify a related settlement period for the legal entity that is specified in the Company field on the line.
When the setup is complete, the Collect data function on the Electronic messages page collects sales tax payments from all the legal entities that you defined.
This section provides recommendations about how to migrate your setup of the INTERVAT declaration that is based on the reporting codes framework to the setup of VAT declaration (BE) that is based on application-specific parameters in the Electronic reporting workspace.
Note
In the examples that follow, the same sales tax code is used for different types of transactions: domestic sales, intra-community sales, domestic purchases, intra-community purchases, and so on. This approach has been used only for the purpose of illustration. For an easier experience when you reconcile your taxes, we recommend that you to create as many sales tax codes as possible, so that each sales tax code can uniquely identify a specific transaction type. Then, during a tax audit, you will be able to explain the source of each transaction based on the sales tax code and will have to use only standard sales tax reconciliation reports.
Additionally, in the examples, all negative tax transactions are configured so that they are considered credit notes. This approach has also been used only for the purpose of illustration. To configure the correct settings, you should consider the information in the Credit notes and negative corrections section earlier in this article.
The tables in this section use the following abbreviations:
For example, for the following sales tax code:
Sales tax code | Percentage | Comment |
---|---|---|
CommGoods | 21 | Commercial goods and services that are traded within Belgium and the European Union (EU) |
You have the following setup of reporting codes.
Transaction | Taxable sales | Sales tax payable | Tax free sales (ICS) | Taxable purchases | Sales tax receivable | Tax free purchases | Taxable import | Offset taxable import | Use tax | Offset use tax |
---|---|---|---|---|---|---|---|---|---|---|
Invoice | 03 | 54 | 46 | 81 | 59 | 81 | 86 | 59 | 55 | |
Credit note | 49 | 64 | 48 | -81+85 | 63 | -81 +84 | -86 | 61 | 62 |
In this case, you can have the following setup of application-specific parameters.
Lookup result | Label | Line | Tax code | Transaction classifier |
---|---|---|---|---|
03_SalesStandardRate | 03/54 Transactions subject to the rate of 21 % | 1 | CommGoods | Sales |
49_SalesStandardRateCreditNote | 49/64 Credit notes issued in respect of transactions subject to the rate of 21 % [03] | 2 | CommGoods | SalesCreditNote |
46_EUSales | 46 Exempt intra-community supplies made in Belgium and ABC sales | 3 | CommGoods | SalesExempt |
48_EUSalesCreditNoteCorr | 48 Credit notes issued and negative corrections in respect of exempt intra-community supplies made in Belgium and ABC sales [46] | 4 | CommGoods | SalesExemptCreditNote |
81_PurchasesGoods | 81/59 Purchases of commercial goods, rawmaterials and consumables (for Tax base - taking into account the credit notes received and other corrections) | 5 | CommGoods | Purchase |
8185_PurchasesGoodsCreditNote | -81 +85/63 Credit notes received and negative corrections relating to purchases of commercial goods, rawmaterials and consumables | 6 | CommGoods | PurchaseCreditNote |
8681_EUPurchasesGoodsUseTax | 86/81 55/59 Intra-Community acquisitions of commercial goods, rawmaterials and consumables carried out in Belgium and ABC sales - UseTax | 7 | CommGoods | UseTax |
868184_EUPurchasesGoodsCreditNoteUseTax | -86/81 +84/61/62 Credit notes received and negative corrections relating to purchases of commercial goods, rawmaterials and consumables - UseTax | 8 | CommGoods | UseTaxCreditNote |
For example, for the following sales tax code:
Sales tax code | Percentage | Comment |
---|---|---|
RedComGood | 6 | Items/goods (but not services) that have a reduced sales tax and are traded within Belgium and the EU |
You have the following setup of reporting codes.
**Transaction ** | Taxable sales | Sales tax payable | Tax free sales (ICS) | Taxable purchases | Sales tax receivable | Tax free purchases | Taxable import | Offset taxable import | Use tax | Offset use tax |
---|---|---|---|---|---|---|---|---|---|---|
Invoice | 01 | 54 | 46 | 81 | 59 | 81 | 86 | 59 | 55 | |
Credit note | 49 | 64 | 48 | -81 +85 | 63 | -81 +84 | -86 | 61 | 62 |
In this case, you can have the following setup of application-specific parameters.
Lookup result | Label | Line | Tax code | Transaction classifier |
---|---|---|---|---|
01_SalesLowerReducedRate | 01/54 Transactions subject to the rate of 6 % | 1 | RedComGood | Sales |
49_SalesLowerReducedRateCreditNote | 49/64 Credit notes issued in respect of transactions subject to the rate of 6 % [01] | 2 | RedComGood | SalesCreditNote |
46_EUSales | 46 Exempt intra-community supplies made in Belgium and ABC sales | 3 | RedComGood | SalesExempt |
48_EUSalesCreditNoteCorr | 48 Credit notes issued and negative corrections in respect of exempt intra-community supplies made in Belgium and ABC sales [46] | 4 | RedComGood | SalesExemptCreditNote |
81_PurchasesGoods | 81/59 Purchases of commercial goods, rawmaterials and consumables (for Tax base - taking into account the credit notes received and other corrections) | 5 | RedComGood | Purchase |
8185_PurchasesGoodsCreditNote | -81 +85/63 Credit notes received and negative corrections relating to purchases of commercial goods, rawmaterials and consumables | 6 | RedComGood | PurchaseCreditNote |
8681_EUPurchasesGoodsUseTax | 86/81 55/59 Intra-Community acquisitions of commercial goods, rawmaterials and consumables carried out in Belgium and ABC sales - UseTax | 7 | RedComGood | UseTax |
868184_EUPurchasesGoodsCreditNoteUseTax | -86/81 +84/61/62 Credit notes received and negative corrections relating to purchases of commercial goods, rawmaterials and consumables - UseTax | 8 | RedComGood | UseTaxCreditNote |
For example, for the following sales tax code:
Sales tax code | Percentage | Comment |
---|---|---|
ComGood-3 | 21 | Commercial goods that are imported from or exported to other countries/regions |
You have the following setup of reporting codes.
Transaction | Taxable sales | Sales tax payable | Tax free sales (ICS) | Taxable purchases | Sales tax receivable | Tax free purchases | Taxable import | Offset taxable import | Use tax | Offset use tax |
---|---|---|---|---|---|---|---|---|---|---|
Invoice | 47 | 81 | 59 | 81 | 81 | 87 | 59 | 57 | ||
Credit note | 49 | -81 +85 | 63 | -81 +85 | -81 +85 | -87 | 61 | 62 |
In this case, you can have the following setup of application-specific parameters.
Lookup result | Label | Line | Tax code | Transaction classifier |
---|---|---|---|---|
47_OtherExemptSales | 47 Other exempt transactions and other transactions carried out abroad | 1 | ComGood-3 | SalesExempt |
49_ExemptSalesSpecialSchemeCreditNoteCorr | 49 Credit notes issued and negative corrections in respect of transactions subject to special regulations [00] | 2 | ComGood-3 | SalesExemptCreditNote |
81_PurchasesGoods | 81/59 Purchases of commercial goods, rawmaterials and consumables (for Tax base - taking into account the credit notes received and other corrections) | 3 | ComGood-3 | Purchase |
8185_PurchasesGoodsCreditNote | -81 +85/63 Credit notes received and negative corrections relating to purchases of commercial goods, rawmaterials and consumables | 4 | ComGood-3 | PurchaseCreditNote |
81_PurchasesGoods | 81/59 Purchases of commercial goods, rawmaterials and consumables (for Tax base - taking into account the credit notes received and other corrections) | 5 | ComGood-3 | PurchaseExempt |
8185_PurchasesGoodsCreditNote | -81 +85/63 Credit notes received and negative corrections relating to purchases of commercial goods, rawmaterials and consumables | 6 | ComGood-3 | PurchaseExemptCreditNote |
8781_OtherPurchasesImportsDeferredTaxGoodsUseTax | 87/81 57/59 Other purchases of commercial goods, rawmaterials and consumables for which VAT is due by the declarant (imports with deferred tax collection) - UseTax | 7 | ComGood-3 | UseTax |
878185_OtherPurchasesImportsDeferredTaxGoodsCNUseTax | -87/81 +85/61/62 Credit notes received and negative corrections relating to other purchases of commercial goods, rawmaterials and consumables for which VAT is due by the declarant (imports with deferred tax collection) - UseTax | 8 | ComGood-3 | UseTaxCreditNote |
For example, for the following sales tax code:
Sales tax code | Percentage | Comment |
---|---|---|
Service21 | 21 | Services and internally used goods that are traded within Belgium, the EU, and other countries/regions |
You have the following setup of reporting codes.
Transaction | Taxable sales | Sales tax payable | Tax free sales (ICS) | Taxable purchases | Sales tax receivable | Tax free purchases | Taxable import | Offset taxable import | Use tax | Offset use tax |
---|---|---|---|---|---|---|---|---|---|---|
Invoice | 03 | 54 | 47 | 82 | 59 | 82 | 82 | |||
Credit note | 49 | 64 | 49 | -82 +85 | 63 | -82 +85 | -82 +85 |
In this case, you can have the following setup of application-specific parameters.
Lookup result | Label | Line | Tax code | Transaction classifier |
---|---|---|---|---|
03_SalesStandardRate | 03/54 Transactions subject to the rate of 21 % | 1 | Service21 | Sales |
49_SalesStandardRateCreditNote | 49/64 Credit notes issued in respect of transactions subject to the rate of 21 % [03] | 2 | Service21 | SalesCreditNote |
47_OtherExemptSales | 47 Other exempt transactions and other transactions carried out abroad | 3 | Service21 | SalesExempt |
49_ExemptSalesSpecialSchemeCreditNoteCorr | 49 Credit notes issued and negative corrections in respect of transactions subject to special regulations [00] | 4 | Service21 | SalesExemptCreditNote |
82_PurchasesServicesMisc | 82/59 Purchases of services and miscellaneous goods (for Tax base - taking into account the credit notes received and other corrections) | 5 | Service21 | Purchase |
8285_PurchasesServicesMiscCreditNote | -82 +85/63 Credit notes received and negative corrections relating to purchases of services and miscellaneous goods | 6 | Service21 | PurchaseCreditNote |
82_PurchasesServicesMisc | 82/59 Purchases of services and miscellaneous goods (for Tax base - taking into account the credit notes received and other corrections) | 7 | Service21 | PurchaseExempt |
8285_PurchasesServicesMiscCreditNote | -82 +85/63 Credit notes received and negative corrections relating to purchases of services and miscellaneous goods | 8 | Service21 | PurchaseExemptCreditNote |
Note
In this example, don't post the UseTax purchase, and don't set up UseTax in the application-specific parameters. Use the taxable purchases or tax free purchases transaction for the purchase of services from outside Belgium.
For example, for the following sales tax code:
Tax code | Percentage | Comment |
---|---|---|
Capital21 | 21 | Capital items that are traded within Belgium and the EU |
You have the following setup of reporting codes.
Transaction | Taxable sales | Sales tax payable | Tax free sales (ICS) | Taxable purchases | Sales tax receivable | Tax free purchases | Taxable import | Offset taxable import | Use tax | Offset use tax |
---|---|---|---|---|---|---|---|---|---|---|
Invoice | 03 | 54 | 46 | 83 | 59 | 83 | 86 | 59 | 55 | |
Credit note | 49 | 64 | 48 | -83 +85 | 63 | -83 +84 | -86 | 61 | 62 |
In this case, you can have the following setup of application-specific parameters.
Lookup result | Label | Line | Tax code | Transaction classifier |
---|---|---|---|---|
03_SalesStandardRate | 03/54 Transactions subject to the rate of 21 % | 1 | Capital21 | Sales |
49_SalesStandardRateCreditNote | 49/64 Credit notes issued in respect of transactions subject to the rate of 21 % [03] | 2 | Capital21 | SalesCreditNote |
46_EUSales | 46 Exempt intra-community supplies made in Belgium and ABC sales | 3 | Capital21 | SalesExempt |
48_EUSalesCreditNoteCorr | 48 Credit notes issued and negative corrections in respect of exempt intra-community supplies made in Belgium and ABC sales [46] | 4 | Capital21 | SalesExemptCreditNote |
83_PurchasesCapitalGoods | 83/59 Purchases of capital goods (for Tax base - taking into account the credit notes received and other corrections) | 5 | Capital21 | Purchase |
8385_PurchasesCapitalGoodsCreditNote | -83 +85/63 Credit notes received and negative corrections | 6 | Capital21 | PurchaseCreditNote |
8683_EUPurchasesCapitalGoodsUseTax | 86/83 55/59 Intra-Community acquisitions of capital goods carried out in Belgium and ABC sales - UseTax | 7 | Capital21 | UseTax |
868384_EUPurchasesCapitalGoodsCreditNoteUseTax | -86/83 +84/61/62 Credit notes received and negative corrections relating to purchases of capital goods - UseTax | 8 | Capital21 | UseTaxCreditNote |
For example, for the following sales tax code:
Sales tax code | Percentage | Comment |
---|---|---|
SpecServ | 0 | Special services, where sales tax will be paid by the recipient |
You have the following setup of reporting codes.
Transaction | Taxable sales | Sales tax payable | Tax free sales (ICS) | Taxable purchases | Sales tax receivable | Tax free purchases | Taxable import | Offset taxable import | Use tax | Offset use tax |
---|---|---|---|---|---|---|---|---|---|---|
Invoice | 45 | 82 | 87 | |||||||
Credit note | 49 | -82 +85 | -87 |
In this case, you can have the following setup of application-specific parameters.
Lookup result | Label | Line | Tax code | Transaction classifier |
---|---|---|---|---|
46_EUSales | 46 Exempt intra-community supplies made in Belgium and ABC sales | 3 | Capital21 | SalesExempt |
48_EUSalesCreditNoteCorr | 48 Credit notes issued and negative corrections in respect of exempt intra-community supplies made in Belgium and ABC sales [46] | 4 | Capital21 | SalesExemptCreditNote |
8782_OtherPurchasesDomesticReverseChargeMiscUseTax | 87/82 56/59 Other purchases of miscellaneous goods for which VAT is due by the declarant (domestic reverse charge) - UseTax | 7 | Capital21 | UseTax |
878285_OtherPurchasesDomesticReverseChargeMiscCNUseTax | -87/82 +85/61/62 Credit notes received and negative corrections relating to other purchases of miscellaneous goods for which VAT is due by the declarant (domestic reverse charge) - UseTax | 8 | Capital21 | UseTaxCreditNote |
The examples in this section are provided for the setup of application-specific parameters for the Commercial goods and services at a standard rate section earlier in this article.
This example shows a sale in Belgium, where the invoice net amount is 1,000 EUR plus 21-percent sales tax.
Posting
Account | Debit | Credit |
---|---|---|
Customer | 1,210.00 | |
Sale | 1,000.00 | |
Outgoing sales tax | 210.00 |
Reporting
Field in sales tax report | Amount |
---|---|
Field 03 | 1,000.00 |
Field 54 | 210.00 |
This example shows a credit note for a sale in Belgium, where the credit note net amount is 1,000 EUR plus 21-percent sales tax.
Posting
Account | Debit | Credit |
---|---|---|
Customer | 1,210.00 | |
Sale | 1,000.00 | |
Outgoing sales tax | 210.00 |
Reporting
Field in sales tax report | Amount |
---|---|
Field 49 | 1,000.00 |
Field 64 | 210.00 |
This example shows a purchase in Belgium, where the invoice net amount is 1,000 EUR plus 21-percent sales tax.
Posting
Account | Debit | Credit |
---|---|---|
Vendor | 1,210.00 | |
Cost | 1,000.00 | |
Incoming sales tax | 210.00 |
Reporting
Field in sales tax report | Amount |
---|---|
Field 81 | 1,000.00 |
Field 59 | 210.00 |
This example shows a credit note for a purchase in Belgium, where the credit note net amount is 1,000 EUR plus 21-percent sales tax.
Posting
Account | Debit | Credit |
---|---|---|
Vendor | 1,210.00 | |
Cost | 1,000.00 | |
Incoming sales tax | 210.00 |
Reporting
Field in sales tax report | Amount |
---|---|
Field 81 | -1,000.00 |
Field 85 | 1,000.00 |
Field 63 | 210.00 |
This example shows an intra-community acquisition (that is, an acquisition from a vendor that is in the EU but outside Belgium), where the invoice net amount is 1,000 EUR. Belgian 21-percent sales tax will have to be self-accounted.
Posting
Account | Debit | Credit |
---|---|---|
Vendor | 1,000.00 | |
Cost | 1,000.00 | |
Import (self-accounted) sales tax | 210.00 | |
Import (self-accounted) sales tax offset | 210.00 |
Reporting
Field in sales tax report | Amount |
---|---|
Field 81 | 1,000.00 |
Field 86 | 1,000.00 |
Field 59 | 210.00 |
Field 55 | 210.00 |
This example shows a credit note for an intra-community acquisition (that is, an acquisition from a vendor that is in the EU but outside Belgium), where the credit note net amount is 1,000 EUR. Belgian 21-percent sales tax will have to be self-accounted.
Posting
Account | Debit | Credit |
---|---|---|
Vendor | 1,000.00 | |
Cost | 1,000.00 | |
Import (self-accounted) sales tax | 210.00 | |
Import (self-accounted) sales tax set off | 210.00 |
Reporting
Field in sales tax report | Amount |
---|---|
Field 81 | -1,000.00 |
Field 86 | -1,000.00 |
Field 84 | 1,000.00 |
Field 61 | 210.00 |
Field 62 | 210.00 |
This example shows intra-community supply (that is, supply to a customer that is in another EU member state and has a sales tax registration number in that member state), where the invoice net amount is 1,000 EUR and is tax-free.
Posting
Account | Debit | Credit |
---|---|---|
Customer | 1,000.00 | |
Sale | 1,000.00 |
Reporting
Field in sales tax report | Amount |
---|---|
Field 46 | 1,000.00 |
This example shows a credit note for intra-community supply (that is, supply to a customer that is in another EU member state and has a sales tax registration number in that member state), where the credit note net amount is 1,000 EUR.
Reporting
Field in sales tax report | Amount |
---|---|
Field 48 | 1,000.00 |
Events
Power BI DataViz World Championships
Feb 14, 4 PM - Mar 31, 4 PM
With 4 chances to enter, you could win a conference package and make it to the LIVE Grand Finale in Las Vegas
Learn moreTraining
Module
Process VAT in documents and journals in Dynamics 365 Business Central - Training
Do you want to learn how to process VAT in Business Central? This module will explain what you will need to process transactions with VAT.