Uredi

Deli z drugimi prek


VAT declaration (France)

This article describes how to set up and generate a report for France that can be used to report a value-added tax (VAT) declaration in the www.impots.gouv.fr online portal by using the exchange of computerized forms (EFI) channel.

To automatically generate the report, you must 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, you must associate sales tax codes with the result of the lookups for the VAT declaration boxes.

For France, you must configure three lookups:

  • Operation lookup
  • Report field lookup
  • Monaco lookup

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 tables, 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.

VAT declaration preview overview

The VAT declaration preview in France contains the following information.

SECTION A - AMOUNT OF OPERATIONS CARRIED OUT

TAXABLE OPERATIONS

Line Box Description Lookup Lookup result
A1 0979 Sales and services Operation lookup TaxableSalesServices
A2 0981 Other taxable transactions Operation lookup OtherTaxableTransactions
A3 0044 Intra-community purchases of services Operation lookup EUPurchaseServices
A4 0056 Imports (other than petroleum products) Operation lookup TaxableImports
A5 0051 Suspensive tax regime outputs (other than petroleum products) and outputs of special customs regime only when deliveries have taken place during the regime Operation lookup TaxableWithdrawalsSuspensiveTaxRegime
B1 0048 Releases for consumption of petroleum products Operation lookup TaxablePetroleumProductsReleasesForConsumption
B2 0031 Intra-community acquisitions Operation lookup EUPurchase (Line 17 is also affected.)
B3 0030 Deliveries of electricity, natural gas, heat, or cold that are taxable in France (domestic reverse charge) Operation lookup TaxableElectricityGasHeatCold
B4 0040 Purchases of goods or services from a taxable person who isn't established in France Operation lookup PurchasesFromPersonNotEstablished
B5 0036 Regularizations Operation lookup TaxableRegularizations

NON-TAXABLE OPERATIONS

Line Box Description Lookup Lookup result
E1 0032 Exports outside the European Union (EU) Operation lookup ExportsOutsideEU
E2 0033 Other non-taxable transactions Operation lookup OtherNonTaxableTransactions
E3 0047 Distance sales that are taxable in another member state for the benefit of non-taxable persons (business-to-consumer [B2C] sales) Operation lookup EUDistanceB2CSales
E4 0052 Imports (other than petroleum products) Operation lookup NonTaxableImports
E5 0053 Withdrawals from the suspensive tax regime (other than petroleum products) Operation lookup WithdrawalsFromSuspensiveTaxRegime
E6 0054 Imports placed under a suspensive tax regime (other than petroleum products) Operation lookup ImportsSuspensiveTaxRegime
F1 0055 Intra-Community acquisitions Operation lookup NonTaxableEUPurchase
F2 0034 Intra-community deliveries to a taxable person (business-to-business [B2B] sales) Operation lookup EUSales
F3 0029 Deliveries of electricity, natural gas, heat, or cold that aren't taxable in France Operation lookup ElectricityGasHeatColdNotTaxable
F4 0049 Releases for consumption of petroleum products Operation lookup NonTaxablePetroleumProductsReleasesForConsumption
F5 0050 Imports of petroleum products placed under suspensive tax regime Operation lookup ImportsPetroleumProductsSuspensiveTaxRegime
F6 0037 Tax-free purchases Operation lookup TaxFreePurchases
F7 0043 Sales of goods or services by a taxable person who isn't established in France Operation lookup SalesByPersonNotEstablished
F8 0039 Regularizations Operation lookup NotTaxableRegularizations
F9 0061 Internal transactions carried out between members of a single taxable person Operation lookup InternalTransactionsAUMember

SECTION B - VAT CALCULATION TO BE PAID

GROSS VAT

Operations carried out in France excluding petroleum products and imports

Line Box Description Lookup Lookup result
08 0207 Standard rate of 20 percent Report field lookup

VATDueFranceStandard

UseTaxFranceStandard (Line 20 is also affected.)

09 0105 Reduced rate of 5.5 percent Report field lookup

VATDueFranceReduced

UseTaxFranceReduced (Line 20 is also affected.)

9B 0151 Reduced rate of 10 percent Report field lookup

VATDueFranceReduced2

UseTaxFranceReduced2 (Line 20 is also affected.)

Operations carried out in the overseas departments excluding petroleum products and imports

Line Box Description Lookup Lookup result
10 0201 Standard rate of 8.5 percent Report field lookup

VATDueOverseasStandard

UseTaxOverseasStandard (Line 20 is also affected.)

11 0100 Reduced rate of 2.1 percent Report field lookup

VATDueOverseasReduced

UseTaxOverseasReduced (Line 20 is also affected.

Transactions taxable at another rate (France or overseas departments) excluding petroleum products and imports

Line Box Description Lookup Lookup result
T1 1120 Transactions carried out in the DOM and taxable at the rate of 1.75% Report field lookup

VATDueSpecificRateDOM1_75

UseTaxSpecificRateDOM1_75 (Line 20 is also affected.)

UseTaxPropertySpecificRateDOM1_75

T2 1110 Transactions carried out in the DOM and taxable at the rate of 1.05% Report field lookup

VATDueSpecificRateDOM1_05

UseTaxSpecificRateDOM1_05 (Line 20 is also affected.)

UseTaxPropertySpecificRateDOM1_05 (Line 19 is also affected.)

TC 1090 TC - Operations carried out in Corsica and taxable at the rate of 13 % Report field lookup

VATDueSpecificRateCorse13

UseTaxSpecificRateCorse13 (Line 20 is also affected.)

UseTaxPropertySpecificRateCorse13 (Line 19 is also affected.)

T3 1081 Operations carried out in Corsica and taxable at the rate of 10% Report field lookup

VATDueSpecificRateCorse10

UseTaxSpecificRateCorse10 (Line 20 is also affected.)

UseTaxPropertySpecificRateCorse10 (Line 19 is also affected.)

T4 1050 Operations carried out in Corsica and taxable at the rate of 2.1% Report field lookup

VATDueSpecificRateCorse2_1

UseTaxSpecificRateCorse2_1 (Line 20 is also affected.)

UseTaxPropertySpecificRateCorse2_1 (Line 19 is also affected.)

T5 1040 Transactions carried out in Corsica and taxable at the rate of 0.9% Report field lookup

VATDueSpecificRateCorse0_9

UseTaxSpecificRateCorse0_9 (Line 20 is also affected.)

UseTaxPropertySpecificRateCorse0_9 (Line 19 is also affected.)

T6 1010 Transactions carried out in mainland France at the rate of 2.1% Report field lookup

VATDueSpecificRateFrance2_1

UseTaxSpecificRateFrance2_1 (Line 20 is also affected.)

UseTaxPropertySpecificRateFrance2_1 (Line 19 is also affected.)

T7 0990 VAT deduction on copyright Report field lookup

VATDueSpecificRateCopyright

UseTaxSpecificRateCopyright (Line 20 is also affected.)

13 0900 Old rates Report field lookup

VATDueOldRates

UseTaxOldRates (Line 20 is also affected.)

UseTaxPropertyOldRates (Line 19 is also affected.)

Petroleum products

Line Box Description Lookup Lookup result
P1 0208 Standard rate of 20 percent on petroleum products Report field lookup

VATDuePetroleumStandard

UseTaxPetroleumStandard (Lines 20 and 2E are also affected.)

P2 0152 Reduced rate of 13 percent on petroleum products Report field lookup

VATDuePetroleumReduced

UseTaxPetroleumReduced (Lines 20 and 2E are also affected.)

Imports

Line Box Description Lookup Lookup result
I1 0210 Standard rate 20 % Report field lookup

VATDueImportsFranceStandard

UseTaxImportsFranceStandard (Lines 20 and 24 are also affected.)

I2 0211 Reduced rate 10 % Report field lookup

VATDueImportsFranceReduced2

UseTaxImportsFranceReduced2 (Lines 20 and 24 are also affected.)

I3 0212 Reduced rate 8,5 % Report field lookup

VATDueImportsOverseasStandard

UseTaxImportsOverseasStandard (Lines 20 and 24 are also affected.)

I4 0213 Reduced rate 5,5 % Report field lookup

VATDueImportsFranceReduced

UseTaxImportsFranceReduced (Lines 20 and 24 are also affected.)

I5 0214 Reduced rate 2,1 % Report field lookup

VATDueImportsOverseasReduced

UseTaxImportsOverseasReduced (Lines 20 and 24 are also affected.)

I6 0215 Reduced rate 1,05 % Report field lookup

VATDueImportsSpecificRate

UseTaxImportsSpecificRate (Lines 20 and 24 are also affected.)

VAT calculation

Line Box Description Lookup Lookup result
15 0600 Previously deducted VAT that must be returned Report field lookup

VATDeductedToBeReturned

VATDeductedToBeReturnedRegularizations

VATDeductedToBeReturnedPetroleum

VATDeductedToBeReturnedImports

15 0600 (including VAT on petroleum products ) Report field lookup VATDeductedToBeReturnedPetroleum
15 0600 (including VAT on imported products excluding petroleum products) Report field lookup VATDeductedToBeReturnedImports
5B 0602 Amounts that must be added, including holiday deposits (expressed in euros) Report field lookup VATCorrectionAmountToBeAdded
16 Not applicable Total gross VAT due (lines 08 through 5B) Total Total of tax amount of lines 08 + 09 + 9B + 10 + 11 + 13 + 14 + P1 + P2 + I1 + I2 + I3 + I4 + I5 + I6 + 15 + 5B
7C 0046 Including VAT on imports that benefit from the reverse charge scheme Total Total of tax amount of lines I1 + I2 + I3 + I5 + I6 + T1 + T2 + T3 + T4 + T5 + T6 + T7
17 0035 Including VAT on intra-community acquisitions Operation lookup EUPurchase (Line B2 is also affected.)
18 0038 Including VAT on transactions to Monaco Monaco lookup Monaco

DEDUCTIBLE VAT

Line Box Description Lookup Lookup result
19 0703 Property that constitutes capital assets Report field lookup

VATDeductionPropertyCapitalAssets

UseTaxImportsPropertyFranceStandard (Lines I1, 24 are also affected.)

UseTaxImportsPropertyFranceReduced (Lines I4, 24 are also affected.)

UseTaxImportsPropertyFranceReduced2 (Lines I2, 24 are also affected.)

UseTaxImportsPropertyOverseasStandard (Lines I3, 24 are also affected.)

UseTaxImportsPropertyOverseasReduced (Lines I5, 24 are also affected.)

UseTaxImportsPropertySpecificRate (Lines I6, 24 are also affected.)

UseTaxPropertyFranceStandard (Line 08 is also affected.)

UseTaxPropertyFranceReduced (Line 09 is also affected.)

UseTaxPropertyFranceReduced2 (Line 9B is also affected.)

UseTaxPropertyOverseasStandard (Line 10 is also affected.)

UseTaxPropertyOverseasReduced (Line 11 is also affected.)

UseTaxPropertyOldRates (Line 13 is also affected.)

UseTaxPropertySpecificRateDOM1_75 (Line T1 is also affected.)

UseTaxPropertySpecificRateDOM1_05 (Line T2 is also affected.)

UseTaxPropertySpecificRateCorse10 (Line T3 is also affected.)

UseTaxPropertySpecificRateCorse2_1 (Line T4 is also affected.)

UseTaxPropertySpecificRateCorse0_9 (Line T5 is also affected.)

UseTaxPropertySpecificRateFrance2_1 (Line T6 is also affected.)

20 0702 Other goods and services Report field lookup

VATDeductionOtherGoodsServices

VATDeductionOtherGoodsServicesImports (Line 24 is also affected.)

VATDeductionOtherGoodsServicesPetroleum (Line 2E is also affected.)

VATDeductionOtherGoodsServicesImportPetroleum (Lines 24 and 2E are also affected.)

UseTaxFranceStandard (Line 08 is also affected.)/p>

UseTaxFrancePetroleumStandard (Lines P1 and 2E are also affected.)

UseTaxFranceReduced (Line 09 is also affected.)

UseTaxFranceReduced2 (Line P2 is also affected.)

UseTaxFrancePetroleumReduced (Lines 9C and 2E are also affected.)

UseTaxOverseasStandard (Line 10 is also affected.)

UseTaxOverseasReduced (Line 11 is also affected.)

UseTaxOldRates (Line 13 is also affected.)

UseTaxSpecificRate (Line 14 is also affected.)

UseTaxPetroleumStandard (Lines P1 and 2E are also affected.)

UseTaxPetroleumReduced (Lines P2 and 2E are also affected.)

UseTaxImportsOverseasStandard (Lines I3 and 24 are also affected.)

UseTaxImportsFranceReduced (Lines I4 and 24 are also affected.)

UseTaxImportsOverseasReduced (Lines I5 and 24 are also affected.)

UseTaxImportsSpecificRate (Lines I6 and 24 are also affected.)

21 0059 Other VAT that must be deducted Report field lookup VATDeductionTaxableRegularizations
22 8001 Credit that was carried forward and that appeared on line 27 of the previous statement Not applicable The user defines the value in a dialog box.
2C 0603 Amounts that must be charged, including holiday deposits (expressed in euros) Report field lookup VATDeductionAmountsToBeCharged
22A Not applicable The single tax coefficient that is applicable for the period, if it differs Not applicable The user defines the value in a dialog box.
23 Not applicable Total deductible VAT (lines 19 through 2C) Not applicable Total of lines 19 + 20 + 21 + 22 + 2C
24 0710 Of which deductible VAT on imports Not applicable

VATDeductionOtherGoodsServicesImports (Line 20 is also affected.)

VATDeductionOtherGoodsServicesImportPetroleum (Lines 20 and 2E are also affected.)

UseTaxImportsOverseasStandard (Lines I3 and 20 are also affected.)

UseTaxImportsOverseasReduced (Lines I5 and 20 are also affected.)

UseTaxImportsFranceStandard (Lines I1 and 20 are also affected.)

UseTaxImportsFranceReduced (Lines I4 and 20 are also affected.)

UseTaxImportsFranceReduced2 (Lines I2 and 20 are also affected.)

UseTaxImportsPropertyFranceStandard (Lines I1 and 19 are also affected.)

UseTaxImportsPropertyFranceReduced (Lines I4 and 19 are also affected.)

UseTaxImportsPropertyFranceReduced2 (Lines I2 and 19 are also affected.)

UseTaxImportsPropertyOverseasStandard (Lines I3 and 19 are also affected.)

UseTaxImportsPropertyOverseasReduced (Lines I5 and 19 are also affected.)

UseTaxImportsPropertySpecificRate (Lines I6 and 19 are also affected.)

UseTaxImportsSpecificRate (Lines I6 and 20 are also affected.)

2E 0711 Of which deductible VAT on petroleum products Not applicable

VATDeductionOtherGoodsServicesImportPetroleum (Lines 20 and 24 are also affected.)

UseTaxFrancePetroleumReduced (Lines 9C and 20 are also affected.)

VATDeductionOtherGoodsServicesPetroleum (Line 20 is also affected.)

UseTaxFrancePetroleumReduced (Lines 9C and 20 are also affected.)

UseTaxFrancePetroleumStandard (Lines 8A and 20 are also affected.)

UseTaxPetroleumStandard (Lines P1 and 20 are also affected.)

UseTaxPetroleumReduced (Lines P2 and 20 are also affected.)

VAT due or VAT credit

Line Box Description Lookup result
25 0705 VAT credit (line 23 – line 16) Total: lines 23 – 16
TD 8900 VAT due (line 16 – line 23) Total: lines 16 – 23

Regularization of domestic consumption taxes (TIC) - Excise on energy

Line Box Description User input parameter
Recognized credit: Excise on electricity - Domestic consumption taxes (TIC) on electricity Recognized amount TICFE
Recognized credit: Excise on natural gases - Domestic consumption taxes (TIC) on natural gas Recognized amount TICGN
Recognized credit: Excise on coal - Domestic consumption taxes (TIC) on coal Recognized amount TICC
Recognized credit: TOTAL - Total of recognized credit Total of recognized credit: TICFE + TICGN + TICC
Credit applied to VAT (within the limit of the TD line) - X1: TICFE 8100 Line X1 corresponds to the amount of TICFE, recorded in column (a), charged to the amount of VAT due. Credit applied to the VAT (TICFE)
Credit applied to VAT (within the limit of the TD line) - X2: TICGN 8101 Line X2 corresponds to the amount of TICGN, recorded in column (a), charged to the amount of VAT due. Credit applied to the VAT (TICGN)
Credit applied to VAT (within the limit of the TD line) - X3: TICC 8102 Line X3 corresponds to the amount of TICC, recorded in column (a), charged to the amount of VAT due. Credit applied to the VAT (TICC)
Credit applied to VAT (within the limit of the TD line) - X4: TOTAL - Line X4 is total of credit applied to VAT, recorded in column (a), charged to the amount of VAT due. Total: X1 + X2 + X3)
Balance of credit to be repaid - Y1: TICFE 8110 Line Y1 corresponds to the remainder of TICFE. Calculated field: Recognized amount TICFE - Credit applied to the VAT (TICFE)
Balance of credit to be repaid - Y2: TICGN 8111 Line Y2 corresponds to the remainder of TICGN. Calculated field: Recognized amount TICGN - Credit applied to the VAT (TICGN)
Balance of credit to be repaid - Y3: TICC 8112 Line Y3 corresponds to the remainder of TICC. Calculated field: Recognized amount TICC - Credit applied to the VAT (TICC)
Balance of credit to be repaid - Y4: TOTAL - Line Y4 is total of balance of credit to be repaid. Total: Y1 + Y2 + Y3
Tax due - Z1: Excise on electricity 8120 Amount of the additional payments of TICFE to be made. This amount is recorded using the annual summary statement (ERA). Tax due (TICFE)
Tax due - Z2: Excise on natural gases 8121 Amount of the additional payments of TICGN to be made. This amount is recorded using the annual summary statement (ERA). Tax due (TICGN)
Tax due - Z3: Excise on coal 8122 Amount of the additional payments of TICC to be made. This amount is recorded using the annual summary statement (ERA). Tax due (TICC)
Tax due - Z4: TOTAL - Total amount of the additional payments of TIC to be made. This amount is recorded using the annual summary statement (ERA). Total: Z1 + Z2 + Z3

Determination of the amount to be paid and/or VAT and/or TIC credits

Line Box Description Lookup result
26 8002 Credit repayment that is requested The user defines the value in a dialog box.
AA 8005 VAT credit that is transferred to the head company of the group The user defines the value in a dialog box.
27 8003 VAT credit to be carried forward (line 25 – line 26). This amount should be carried over to line 22 of the next return. Total: lines 25 – 26
Y5 8113 Reimbursement of remaining TIC (Excise on energy) requested (report from line Y4). Value from Y4 line
Y6 8114 TIC (Excise on energy) credit transferred to the group head company on the summary declaration 3310-CA3G (deferral of the line Y4). Value from Y4 line
X5 8103 TIC (Excise on energy) credit charged to VAT (carried forward from line X4). Value from X4 line
28 - Total net VAT payable (line TD – line X5) Total: lines TD – X5
29 9979 Assimilated taxes The user defines a value in a dialog box.
Z5 8123 Total TIC (Energy Excise) due (carryover from line Z4) The value carryover from line Z4.
AB 9991 Total payable that is paid by the head company of the group on the summary declaration The user defines a value in a dialog box.
32 - Total payable (line 28 + line 29 +line Z5 – line AB) Total: lines 28 + 29 + Z5 – AB

Note about purchase reverse charge VAT

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 the 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 appropriate lookup report of the Report field lookup.

Example

For a taxable purchase of electricity, gas, heat, or cold that has a domestic reverse charge, you configure sales tax code UT_S_RC with use tax. You then associate the code with the UseTaxTaxableElectricityGasHeatCold lookup result of the Operation lookup and the UseTaxFranceStandard lookup result of the Report field lookup. In this case, amounts that use the UT_S_RC sales tax code will be reflected on line 3A (via the Operation lookup), and on lines 08 and 20 (using the Report field lookup).

Alternatively, you configure two sales tax codes:

  • VAT_S_RC, which has a tax rate value of -20 percent
  • InVAT_S_RC, which has a tax rate value of 20 percent

You then associate the codes with lookup results in the following way:

  • Associate VAT_S_RC with the TaxableElectricityGasHeatCold lookup result of the Operation lookup and the VATDueFranceStandard lookup result of the Report field lookup.
  • Associate InVAT_S_RC with the VATDeductionOtherGoodsServices lookup result of the Report field lookup.

In this case, amounts that use the VAT_S_RC sales tax code will be reflected on lines 3A (via the Operation lookup) and 08 (via the Report field lookup). Amounts that use the InVAT_S_RC sales tax code will be reflected on line 20 (via the Report field lookup).

For more information about how to configure reverse charge VAT, see Reverse charges.

Set up a VAT declaration preview for France

Import ER configurations

  1. Open the Electronic reporting workspace.

  2. Import the following version or later of this ER format:

    • VAT Declaration Excel (FR) version 85.15

Set up application-specific parameters for VAT declaration fields

To automatically generate a VAT declaration preview report in Microsoft Excel, associate sales tax codes in the application and lookup results in the ER configuration.

Note

We recommend that you enable the feature, Use application specific parameters from previous versions of ER formats in the Feature management workspace. When this feature is enabled, parameters that are configured for the earlier version of an ER format automatically become applicable for the later version of the same format. If this feature is not enabled, you must configure application-specific parameters explicitly for each format version. The Use application specific parameters from previous versions of ER formats feature is available in the Feature management workspace starting in 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.

Set up operations

Follow these steps to define which sales tax codes generate which boxes in section A, "AMOUNT OF OPERATIONS CARRIED OUT."

  1. Go to Workspaces > Electronic reporting, and select Reporting configurations.

  2. Select the VAT declaration Excel (FR) configuration, and then select Configurations > Application specific parameters setup to open the Application specific parameters page.

  3. On the Application specific parameters page, on the Lookups FastTab, select Operation lookup.

  4. On the Conditions FastTab, set the following fields to associate the sales tax codes and operations.

    Field Description
    Lookup result Select the operation to set up. For more information about the operations and their assignment to VAT declaration rows, see the VAT declaration preview overview section earlier in this article.
    Tax code Select the sales tax code to associate with the operation. 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

    If you created enough sales tax codes to determine a declaration box, select *Not blank*. If you didn't create enough sales tax codes so that one sales tax code generates amounts in only one declaration box, set up a transaction classifier. The following transaction classifiers are available:

    • Purchase
    • PurchaseExempt (tax-exempt purchase)
    • PurchaseReverseCharge (tax receivable from a purchase reverse charge)
    • Sales
    • SalesExempt (tax-exempt sale)
    • SalesReverseCharge (tax payable from a purchase reverse charge or a sales reverse charge)
    • 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).

    Note

    Be sure to associate all sales tax codes with lookup results. If any sales tax codes should not generate values in section A, associate them with the Other lookup result.

    Application parameters operations.

Set up report fields

Follow these steps to define which sales tax codes generate which boxes in section B, "VAT CALCULATION TO BE PAID."

  1. On the Application specific parameters page, on the Lookups FastTab, select Report field lookup.

  2. On the Conditions FastTab, associate the sales tax codes and report fields.

    Note

    Be sure to associate all sales tax codes with lookup results. If any sales tax codes should not generate values in section B, associate them with the Other lookup result.

    Application parameters report fields.

Set up sales tax codes for Monaco

Follow these steps to define which sales tax codes generate the amount in box 18, Including VAT on transactions to Monaco.

  1. On the Application specific parameters page, on the Lookups FastTab, select Monaco lookup.

  2. On the Conditions FastTab, associate the sales tax codes and the Monaco lookup result.

    Note

    As the last line in the setup, create a line where you associate the *Not blank* value of the Tax code field with the France lookup result. This line indicates that all other sales tax codes are related to operations in France and should not generate the amount in box 18.

    Application parameter Monaco.

Set up the VAT reporting format

  1. In the Feature management workspace, enable the VAT statement format reports feature.

  2. Go to General ledger > Setup > General ledger parameters.

  3. On the Sales tax tab, on the Tax options FastTab, in the VAT statement format mapping field, select the VAT declaration Excel (FR) ER format.

    This format will be printed when you run the Report sales tax for settlement period report. It will also be printed when you select Print on the Sales tax payments page.

  4. Go to Tax > Sales tax > Sales tax authorities. On the Tax authorities page, select the tax authority, and then, in the Report layout field, select Default. If you configured a VAT declaration in a legal entity that has multiple VAT registrations, go to General ledger > Setup > General ledger parameters. On the Sales tax tab, on the Electronic reporting for countries/regions FastTab, on the FRA country/region line, select the VAT Declaration Excel (FR) ER format.

Preview the VAT declaration in Excel

Preview the VAT declaration in Excel from the Report sales tax for settlement period periodic task

  1. Go to Tax > Periodic tasks > Declarations > Sales tax > Report sales tax for settlement period.

  2. Set the following fields.

    Field Description
    Settlement period Select the settlement period.
    Sales tax payment version

    Select one of the following values:

    • Original – Generate a report for sales tax transactions of the original sales tax payment or before the sales tax payment is generated.
    • Corrections – Generate a report for sales tax transactions of all the subsequent sales tax payments for the period
    • Total list – Generate a report for all sales tax transactions for the period, including the original and all corrections.
    From date Select the start date of the reporting period.
  3. Select OK.

  4. In the Electronic report parameters dialog box, set the following fields.

    Field Description
    Credit carried forward from the previous statement Enter the amount to export in line 22 (box 8001) of the report.
    Single tax coefficient Enter the coefficient to export in line 22A of the report.
    Credit repayment requested Enter the amount to export in line 26 (box 8002) of the report.
    VAT credit transferred to the group head company on the summary declaration Enter the amount to export in line AA (box 8005) of the report.
    Assimilated taxes Enter the amount to export in line 29 (box 9979) of the report.
    Total payable paid by the company head of the group on the summary declaration Enter the amount to export in line AB (box 9991) of the report.
    Recognized amount TICFE Enter recognized amount of domestic consumption taxes (TIC) on electricity.
    Recognized amount TICGN Enter recognized amount of domestic consumption taxes (TIC) on natural gas.
    Recognized amount TICC Enter recognized amount of domestic consumption taxes (TIC) on coal.
    Credit applied to the VAT (TICFE) Enter credit applied to the VAT (TICFE) to export in line X1 of the report.
    Credit applied to the VAT (TICGN) Enter credit applied to the VAT (TICGN) to export in line X2 of the report.
    Credit applied to the VAT (TICC) Enter credit applied to the VAT (TICC) to export in line X3 of the report.
    Tax due (TICFE) Enter the amount of the additional payments of TICFE to export in line Z1 of the report.
    Tax due (TICGN) Enter the amount of the additional payments of TICGN to export in line Z2 of the report.
    Tax due (TICC) Enter the amount of the additional payments of TICC to export in line Z3 of the report.
  5. Select OK, and review Excel report.

Settle and post sales tax

  1. Go to Tax > Periodic tasks > Declarations > Sales tax > Settle and post sales tax.

  2. Set the following fields.

    Field Description
    Settlement period Select the settlement period.
    Sales tax payment version

    Select one of the following values:

    • Original – Generate the original sales tax payment for the settlement period.
    • Latest corrections – Generate a correction sales tax payment after the original sales tax payment for the settlement period was created.
    From date Select the start date of the reporting period.
  3. Select OK.

Preview the VAT declaration in Excel from the Sales tax payments inquiry

  1. Go to Tax > Inquiries and reports > Sales tax inquiries > Sales tax payments, and select a sales tax payment line.
  2. Select Print report.
  3. In the Electronic report parameters dialog box, set the fields as explained in the Preview the VAT declaration in Excel from the Report sales tax for settlement period periodic task section earlier in this article. Then review the Excel file that is generated for the selected sales tax payment line.

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.

Preview the VAT declaration from electronic messages

If 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.

Set up electronic messages

Download and import example settings for electronic messages

The data package that includes example settings contains electronic message settings that are used to generate the Excel report for France. 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.

  1. In LCS, in the Shared asset library, select Data package as the asset type, and then download the FR VAT declaration package. The downloaded file is named FR VAT declaration package.zip.
  2. In Finance, in the Data management workspace, select Import.
  3. On the Import FastTab, in the Group name field, enter a name for the job.
  4. On the Selected entities FastTab, select Add file.
  5. In Add file dialog box, make sure that the Source data format field is set to Package, select Upload and add, and then select the zip file that you downloaded earlier. Select Close.
  6. After the data entities are uploaded, on the Action Pane select Import.
  7. Go to Tax > Inquiries and reports > Electronic messages > Electronic messages, and review the electronic message processing that you imported (FR VAT declaration).

Configure electronic messages

  1. Go to Tax > Setup > Electronic messages > Populate records actions.
  2. Select the FR Populate VAT return records line, and then select Edit query.
  3. Use the filter to specify the settlement periods to include in the report.
  4. If you must report tax transactions from other settlement periods in a different declaration, create a new Populate records action, and select the appropriate settlement periods.

Generate a VAT declaration preview from electronic messages

The following procedure applies to the example electronic message processing that you imported earlier from the LCS Shared asset library.

  1. Go to Tax > Inquiries and reports > Electronic messages > Electronic messages.

  2. In the left pane, select the report format to generate. For example, select FR VAT declaration.

  3. On the Messages FastTab, select New, and then, in the Run processing dialog box, select OK.

  4. Select the message line that is created, enter a description, and then specify the start and end dates for the declaration.

    Note

    Steps 5 through 7 are optional.

  5. 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.

  6. 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.

  7. 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.

  8. On the Messages FastTab, select Update status. In the Update status dialog box, select the Ready to generate action, and then select OK. Verify that the message status is changed to Ready to generate.

  9. Select Generate report. To preview the VAT declaration amounts, in the Run processing dialog box, select Preview report, and then select OK.

  10. In the Electronic reporting parameters dialog box, set the following fields, and then select OK.

    Field Description
    Settlement period Select the settlement period. If you selected Collect data in step 5, you can disregard this field. The report will be generated for the sales tax transactions that are included in the collected sales tax payments.
    Tax declaration version

    Select one of the following values:

    • Original – Generate a report for sales tax transactions of the original sales tax payment or before the sales tax payment is generated.
    • Corrections – Generate a report for sales tax transactions of all the subsequent sales tax payments for the period.
    • Total list – Generate a report for all sales tax transactions for the period, including the original and all corrections.

    Credit carried forward from the previous statement

    Single tax coefficient

    Credit repayment requested VAT credit transferred to the group head company on the summary declaration

    Assimilated taxes

    Total payable paid by the company head of the group on the summary declaration

    Set these fields as explained in the Preview the VAT declaration in Excel section earlier in this article.

    If you selected Collect data in step 5, you can disregard this field. The report will be generated for the sales tax transactions that are included in the collected sales tax payments.

  11. 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 document.

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.

  1. Go to Workspaces > Feature management.

  2. Find and select the Cross-company queries for the populate records actions feature in the list, and then select Enable now.

  3. Go to Tax > Setup > Electronic messages > Populate records actions.

  4. On the Populate records action page, select the FR Populate VAT return records line.

    In the Datasources setup grid, a new Company field is available. For existing records, this field shows the identifier of the current legal entity.

  5. In the Datasources setup grid, add a line for each additional legal entity that must be included in reporting, and 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 The checkbox is automatically selected when you define criteria by selecting Edit query.
  6. 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 completed, the Collect data function on the Electronic messages page collects sales tax payments from all legal entities that you defined.