Skip to main content
Reporting
Search
Search Indirect Tax Support Help and Support.

This article applies to:

  • Product: ONESOURCE Indirect Tax Compliance,ONESOURCE Indirect Tax
  • Subject: Reports,Invoices

Tax Return to E-Invoicing Reconciliation Report

The purpose of the
Tax Return to E-Invoicing Reconciliation Report
 is to allow you to compare your E-invoicing to your VAT source file to find any transactions that are either:
  • Present in the E-Invoicing import but not in the VAT import or vice versa.
  • Mismatched in terms of amount or tax code.
The report compares transactions based on the E-Invoicing VAT Match field (this is normally
Invoice ID
, but it can also be the
Document ID
, a combination of
Entity Code
 and
Invoice ID
, depending on what the user chose to be the reconciliation factor during implementation).
Parameters
The report is run based on the following parameters:
  • Entity
  • Start Date
  • End Date
Reconciliations
Several reconciliations are run as part of this report.
Check one - present in both VAT and E-invoicing
  • Missing in VAT:
     E-invoicing VAT MatchField is present in E-invoicing and missing in VAT.
  • Missing in E-invoicing:
     E-invoicing MatchField is available in VAT and missing in E-invoicing.
Check two - mismatch
  • Mismatch in Amount:
     Is the E-invoicing Amount the same in VAT and E-invoicing for the relevant value in E-invoicingVAT MatchField?
Run the report
  1. On the Reports tab, select
    Reports
    .
  2. Locate the
    Tax Return to E-Invoicing Reconciliation Report
    .
  3. In the Actions column, select
    Configure
    .
  4. Enter the parameters and select the output format.
  5. Select
    Run
    .
    note
    If the output format is
    Screen
    , a report view gets displayed. If the output format is
    Excel
    , the same report gets downloaded to the local disk.