Tax Reconciliation (tfgld1531m000)

Use this session to view and print the VAT reconciliation report that you generate in the Generate Tax Reconciliation (tfgld1231m000) session.

The report includes:

  • All the finalized transactions that have a single tax code. Transactions with a multiple tax code are ignored.
  • The manual transactions (which do not have a tax code) of the ledger accounts that you selected in the Reconciliation Type by Ledger Account (tfgld1130m000) session. The transactions appear at the top of the report.

To print the reconciliation report, select the Print option from the File menu to start the Print Tax Reconciliation (tfgld1444m000) session.

You can select the Sort option from the View menu to sort the report by the following criteria:

  • Revenue type
  • Tax type
  • Country
  • Tax code
  • Revenue ledger account
  • Tax ledger account
  • Effective date.

The session displays:

  • The tax percentage that must be applied to the transactions, in the Tax Rate column.
  • The actual tax percentage calculated from the net transaction amount and the actual tax amount in the home currency, in the Calculated Tax Rate column.

If these two values are the same, the transaction was posted correctly. If these two values differ, you can print more information to find the incorrect transaction.

You can select the transaction or transactions and choose the Print Details VAT Reconciliation option from the Specific menu. The Print Tax Reconciliation (Transactions) (tfgld1445m000) session starts. The report displays all the transactions that result in the postings of the selected transaction.

The report displays the transaction type and the document number of each transaction. You can use this report to trace the cause of the errors.

Depending on the Reconciliation Type of the line, the VAT Reconciliation session displays the following information:

Sales Revenue: LN displays the data based on the tax type, revenue account, and tax account. The first few lines display the manual transactions, which have a tax code but do not have a tax account and for which the VAT amount is zero. These lines are marked with MISSING. Tax: LN displays the data based on the tax code. The Revenue Account and the Tax Account fields are empty. Tax codes that do not have a relation to a tax position in the tax analysis are not included. Tax Position: LN displays the data based on the tax position. The Revenue Account and the Tax Account fields are empty. Tax codes that do not have a relation to a tax position in the tax analysis are not included. This is a type of summary information per tax position. If the Reconciliation Type is Tax Position, you cannot use Print Details VAT Reconciliation from the Specific menu to print further transaction details. Country: For sales invoices, LN compares the country of the tax code by country combination with the ship-to business partner's country. If these countries differ, LN displays the ship-to business partner's country in the Tax Country column. Balance: This line indicates whether the transactions in the Finalized Transactions (tfgld106) table are balanced. If the credit and debit differences exist in one document, the line is marked as UNBALANCED. You can select the line and choose Print Details VAT Reconciliation from the Specific menu to print the unbalanced transactions.

Field Information

Tax Type

The tax type.

The options are:

Net Amount in HC

The net transaction amount in home currency.

Tax Amount in HC

The tax amount in home currency.