Tax Reconciliation Report - Selection Criteria

Use this window to specify selection criteria for the Tax Reconciliation report.

To open the window, choose Financials Financial Reports Accounting Tax Tax Reconciliation Report . Alternatively, open it from the Reports module.

After creating the report, you can view it in the Tax Report - Reconciliation window.

Selection Criteria

Selection Criteria Name
Click (Choose) to select previously saved report selection criteria and use them to generate the report. To save new selection criteria, press `CTRL+A` and enter a name in this field.

Tax Declaration Name
Select one of the previously saved reports from the dropdown list. Note This field is available only when the Extended Tax Reporting checkbox is selected on the Accounting Data tab of the Company Details window Administration System Initialization Company Details ). End of the note.

Opening Balance, Non-VAT Transactions
The report displays transactions grouped by G/L accounts and divided by tax codes, including non-tax transactions. This display lets you crosscheck between the tax report, tax and tax based account balances, and the balance of the connected G/L account in the system. In addition, the report displays the opening balance of the specified tax based accounts, additional non-tax transactions that were posted to this account, the document date, and the journal amount. Choose (Browse) next to the Non-VAT Transactions checkbox to open the Non-VAT Transactions window, in which you define the range of the posting date or the document date for the non-VAT transactions that are included in the report.

Date From...To
Define a date range for the report. By default, these fields display the start and end dates of the current fiscal year. Note Relevant for Spain only. These fields are not available for the 340 tax model report. End of the note.

Document Date
Generates the report according to document, not posting date.

Round Amount
Report rounds off its amounts.

Series
Choose (Browse) to select the series, for example, products, services, regions or brands, to include in the report.

Doc. Type
Choose (Browse) to select the types of documents to include in the report.

Output
Codes and names of all the tax codes defined as output tax and relevant for this report. The codes in the Display column are selected by default. Deselect the tax codes that should be excluded from the report. To clear the entire column, click the column header. Use the Amount column to select the tax codes for which you want to display subtotals.

Input
Codes and names of all the tax codes that are defined as input tax and relevant for this report. The codes in the Display column are selected by default. Deselect the tax codes that should be excluded from the report. To clear the entire column, click the column header. Use the Amount column to select the tax codes for which you want to display subtotals.

[Arrow Up/Down]
Use these buttons to determine the appearance order of the selected tax codes in the report display and in the printed report.

G/L Accounts
Choose (Browse) to open the Accounts – Selection Criteria window, in which you choose the G/L accounts to include in the report.

Save
Choose to save your report selection criteria for future use.

Country-Specific Fields: Spain

Deferred
Note Relevant for 340 tax model report only. End of the note. Indicates whether the document contains deferred tax.

Show Payments with Deferred Tax
Report includes payments with deferred tax.

More Information

Tax Reconciliation Report: Europe

Accounts – Selection Criteria