Skip to main content

Legal

Tax & Accounting

Trade & Supply

Risk & Fraud

News & Media

Books

Developers

Get started with SAP integration

Reconciliation extract report

The
ONESOURCE Indirect Tax Integration for SAP Reconciliation Extract
 creates a file using payables, receivables, and FI transaction data from the SAP General Ledger. This file can then be imported into
ONESOURCE Indirect Tax Reporting
 for use in the Reconciliation Report. The Reconciliation Extract report was first introduced as a separate product that could be added to Integration
5.x version as a separate transport. From the Integration 6.2 release this has now been included in the Integration transports as part of the standard product. The feature has been updated and adjustments have been made to include fields that are now contained within the new Tax_Data table.
The solution has been developed within the following features:
  • Custom ABAP program in /IDT/ name space with a custom transaction to run it
  • Selection screen to define what data to extract and where to save the output file
  • Ability to run as a schedule background job
Purpose and Benefits
The ONESOURCE Indirect Tax Integration for SAP Reconciliation Extract enables an organization using the ONESOURCE Indirect Tax Integration for SAP for their tax calculations to extract the necessary data from the SAP FI module to use in the ONESOURCE Indirect Tax Reporting ERP Document Reconciliation Report.
The Reconciliation Report in ONESOURCE Indirect Tax Reporting will compare the imported data from the SAP Reconciliation Extract with the data in Audit. The Reconciliation Report will indicate transactions missing in the ERP (SAP), transactions missing in Audit, as well as differences in tax amounts.
Business Process
Transactions processed in the SAP systems Order to Cash (SD), Materials Management (MM), and Financial Accounting (FI) processes requiring indirect tax can call ONESOURCE Indirect Tax Determination for a tax calculation. At time of posting the calculate tax to the FI modules G/L accounts, a tax audit call is done to Determination for the applicable tax codes, and the tax liability information is stored in the audit database. A scheduled process (ETL) then moves that audit information over to ONESOURCE Indirect Tax Reporting. Customers wishing to compare the tax liabilities stored in the SAP G/L to the ones residing in the ONESOURCE Indirect Tax systems can run the Reconciliation process periodically, usually during month end close, to ensure results are as expected.
The Reconciliation Extract Process
This section describes the process for executing the ONESOURCE Indirect Tax Integration for SAP Reconciliation Extract report and viewing the output.
Reconciliation Extract Transaction
The Reconciliation Extract report is run to collect the G/L transaction data created in SAP. The report extracts G/L and tax data based on the report parameters. When run, an output file (saved as a .csv file) is created either on the Application Server directory or the user PC, it then has to be moved to the Reporting server to be imported into the ONESOURCE Indirect Tax Reporting.
For more information on saving and importing the .csv file, see the section PREPARING DATA FOR THE ERP DOCUMENT RECONCILIATION REPORT in the Reporting online help.
For more information on executing the report, ERP Document Reconciliation, see the section ERP DOCUMENT RECONCILIATION in the Reporting online help.
Running the Reconciliation Extract
To run the ONESOURCE Indirect Tax Integration for SAP Reconciliation Extract use transaction code:
/N/IDT/RECON_EXTRACT
On the selection screen enter the desired values for the extract scope in question. For an explanation of the selection screen options see the following table:
Parameter
Description
Company Code
The Company Codes to be selected during this extract. The user must be authorized to run data for the selected company codes (F_BKPF_BUK).
Fiscal Year
A valid Fiscal Year must be entered.
Posting Date
A fiscal posting date range can be selected; this is the date of the posting to G/L, not the document/invoice date of the original document.
Posting Period
Optionally enter a posting period month or range.
Tax Code
Option to include/exclude specific tax codes to be extracted. See special note for US transactions below.
Select Zero/Exempt tax records
If field is checked documents with zero tax value on the posted document are suppressed.
Application Server
Location for output files on the SAP application server, based on selected radio button option.
Presentation Server
Location when storing files on user’s computer, based on selected radio button option.
Company Code Prepend
If set in the /IDT/GEN_CONFIG_VALS - General Configuration Values table, option value
external_company_id_prepend
¸ then this must be set here as well.
Package Size
The number of lines to be included in one package.
Once all values have been setup as desired the extract can be run:
A message will be displayed stating the number of records extracted and included in the file. If desired the selection can be saved as a
Variant
 in SAP for later use in a scheduled
Batch Job
 for monthly/quarterly automated processing.
Excluding Tax Codes from Export
For US tax codes with a Tax Category of 0 “Sales Tax (Consumer Use Tax if needed)” must be excluded as they are not posting to audit. The taxes are collected by the seller and are not recorded as a further liability to the buyer. Usually these are the I1 driven tax codes. Please check in table /IDT/US_LOGIC - US Specific Logic for codes have a Tax Category of 0:
/IDT/US_LOGIC table:
To exclude tax codes from selection, select on the “Multiple selection” button in the selection screen next to the Tax Code field:
Now enter the values to be excluded in the Excluding Single Values or Exclude Ranges tab:
Output Details for Reconciliation Extract
Once the process is run a csv file has been created. The file is now ready to be imported into Reporting for reconciliation.
Output File Details
The following is the output field list as returned in the comma separated “.CSV” file on to the Application server or Presentation server.
Below is an example of the output details:
Enabling Custom Fields
The file format of the Reconciliation Report allows for five (5) user defined fields (UDF) as pass through elements. Companies wishing to use these fields can use custom code to set a value from SAP and extract it into one of the UDF’s. These values then will be imported into the Reporting reconciliation tables and show in the Reconciliation Report process.
A BADI /IDT/BADIRECON_EXTRACT has been provided as part of the SAP Reconciliation Report which can be implemented by the customers. The BADI method returns the 5 UDF’s in the structure /IDT/EXTRACT_UDF.

This article applies to:

  • Product: ONESOURCE Indirect Tax
  • Sub Product: SAP