1. Administering Tax Reporting
  2. Managing Applications
  3. Best Practices for Data Integration
  4. Exporting Year-to-Date (YTD) Data from a Financial Consolidation and Close Application for Import into a Tax Reporting Application

Exporting Year-to-Date (YTD) Data from a Financial Consolidation and Close Application for Import into a Tax Reporting Application

Data imported into Tax Reporting needs to be YTD. If you are looking to import data into Tax Reporting from a Financial Consolidation and Close application, you need to export YTD data from Financial Consolidation and Close. The way to accomplish this depends on the type of Financial Consolidation and Close application you are exporting from:

  • Extended Dimension DSO application – Specify the YTD member in the Data Integration, Options, Filtersfilter for the View dimension. You need to specify the All Dataoption in order to export the dynamically calculated YTD member of the Sparse View dimension.
  • Extended Dimension non-DSO application – YTD data may be stored in the YTD member or dynamically calculated in the YTD_Rule member.
    • Stored YTD – Confirm with the Financial Consolidation and Close application administrator that the data you need to export is available in the stored YTD member. Depending on whether the Control To-Date View Storage option is enabled and how the application is managed, data may or may not exist in the stored YTD member. If you have confirmed that data does exist in the YTD member intersections that you are looking to export, you can specify the YTD member in the Data Integration, Options, Filters filter for the View dimension. You do not need to specify the All Dataoption in order to export the stored YTD member.
    • Dynamically calculated YTD_Rule – Specify the YTD_Rule member in the Data Integration, Options, Filters filter for the View dimension. You must specify the All Data option to export the dynamically calculated YTD_Rule member of the Sparse View dimension.
  • Legacy (non-Hybrid) Financial Consolidation and Close application – You cannot export YTD data directly. You can export periodic data and aggregate prior periods to generate YTD data by using member mappings. You need to pay attention to the account type and not aggregate balance accounts.