Tax Data Extraction and Reporting (tftax1410m000)

Use this session to generate user-definable ASCII or XML files that can be imported in Microsoft Excel, Access, BIRT, and other reporting tools. The data is retrieved from the Tax Analysis (tfgld1520m000) session.

Field Information

Selection by Tax Position Range

To select tax data by tax position, select this check box.

If this check box is selected, the following fields are unavailable:

  • Tax Country The displayed values are derived from the tax position range.
  • Tax Code The displayed values are derived from the tax position range.
  • Tax Origin ( Options tab) The tax origin is overruled by the tax type of the tax position range.
Note: 
  • To use the tax position for selection purposes, ensure that the Tax Position and Tax Position Description fields exist in the Tax Reporting area of the Flexible Reporting Fields (tfgld0591m000) session, and were added to the flexible reporting code that you use for your tax reporting.
  • If, in the Tax Positions (tfgld0120m000) or Tax Position (tfgld0620m000) sessions, Relations by Country Group is selected, that tax position is ignored for data extraction.
Tax Position

tax position

Selection
Selection Range
Financial Company

The code of the financial company for which the tax data must be extracted and reported.

Tax Year / Period

The year for which a financial tax transaction is processed.

Tax Year / Period

The period of the year in which a financial tax transaction is processed.

Fiscal Year / Period

The fiscal year.

Fiscal Year / Period

The fiscal period.

Tax Country

tax country

Tax Code

The tax code associated with the tax data.

Kind of Tax
VAT

Regular value added tax (VAT) on sales and purchases.

Note: For tax registration setup, this kind of tax also represents sales tax.
Stamp Tax

A kind of tax on trade notes.

Withholding Income Tax

Withholding tax that you must withhold from your suppliers' purchase invoices and pay directly to the collection office.

Withholding Social Contribution

Withholding social contributions on purchase invoices that you must withhold from your suppliers' purchase invoices and pay directly to the collection office.

Social Contribution (Company Expense)

Social contributions (expense) that you can post as costs.

Exclude from Withholding

You can link tax codes of this kind of tax to purchase transactions that are not subject to withholding tax, but that you must report to the collection office for withholding tax and social contributions.

Tax Settlement

On the tax analysis reports, tax payments to the collection office are represented by this kind of tax code.

Not Applicable

None of the previous types apply. For example, for a group tax code the kind of tax is Not Applicable.

VAT Status

The From and To fields define a range of VAT status based on which the tax transactions are included in the DIOT report.

Allowed values

Interim on Receipt/Payment
Paid
Note: If the status range is Paid to Paid, LN considers only the tax transactions with the VAT Status set to Paid for the DIOT report.

If the status range is Interim on Receipt/Payment to Interim on Receipt/Payment, LN considers only the tax transactions set to Interim on Receipt/Payment for the DIOT report.

Tax Authority

A government body with jurisdiction over the sales taxes in a specific area. You can set up tax authorities and tax authority groups for tax reporting purposes.

Tax Authority

Tax Category

tax category

Collection Office

The collection office to which the tax must be paid.

Document Date

The date of the transaction. The document date is always registered in local time. Usually the document date is the same date as the transaction date, except if you manually enter a different transaction date or if the UTC time and the local time differ by a day.

Transaction Type

The code of the transaction type.

Business Partner

The code of the related business partner.

Options
Options
Tax Origin
Purchase

Tax on purchase transactions. Tax on these transactions can be claimed.

Sales

Tax on sales transactions. Tax on these transactions is payable.

Flexible Reporting Code

The appropriate flexible reporting code selected from the Flexible Reporting Codes (tfgld0592m000) session.

Final Print

If this check box is selected, this is the last time this analysis data can be printed.

Print Selection Details

If this check box is selected, LN prints a single-page report with the selection criteria that were used.

Include Finally Printed

If this check box is selected, the application also prints data that was printed previously.

Create XML format

If this check box is selected, LN generates an XML file.

If this check box is cleared, LN generates an ASCII file.

Report Options
Amount Format

Specify a string that defines the required amount format.

Example

For French legal reporting, amounts require a dot as thousands separator and a comma as decimal sign.

Date Format

Specify a string that defines the required date format.

Example

For French legal reporting, the required date format is DD/MM/YYYY.

Settings
Reporting Currency Group

For a multicompany setup, the reporting currency group defined in the Reporting Currency Group Setup (tfgld0680m000) session.

Home Currency

home currency

Separator

The character to be used as column separator in the output file.

Default value

"|"

Export Location

Select Local System or Server, as required.

Export Directory

Click the browse button to select the directory in the Browse For Folder dialog box.

Export File Name

Click the browse button to select the file in the Open dialog box in the selected directory.