Data Transformation and Integration

Introduction

As we recognize data transformation, the process of converting data from one format or structure into another involves repetitive and routine tasks which can be difficult and time-consuming, particularly in terms of the process for transforming tax departments' data into pre-defined tax software templates. What is more challenging is the inconsistency of template structure developed by different tax software.

Thus, the Data Transformation function embedded in International Tax Calculator is designed to help tax professionals by reducing time and effort on the heavy lifting data process which shifts tax departments' role from data preparation to data quality review.

Data Transformation tool takes a 3-step approach. First we identify the source data that International Tax Calculator requires from a software perspective. Then we analyze what could be the most reliable and consistent source of truth from a broader users'view. Finally we transform! Your input of feedback is always crucial for Data Transformation's continuous improvement. Don't hesitate to let us know your thoughts!

Categories and Details

Export Tax Provision Upload Template

  • #UPD# Unit Temp Diffs

  • #UATTD# U AfterTax TempDffs

  • #UTA# Unit Perm Diffs

Steps you need in International Tax Calculator:

  • INPUT -> Entity Data -> Column Z

  • INPUT -> Provision Codes -> Column C, D, F, G

  • REPORTS -> Export Tax Provision Report

01. ITC_To_OTP_V1.mp4

Export Income Tax Report (csv)

  • 965 Report -> DFI tab

  • GILTI Report -> GILTI tab

  • QBAI Report -> QBAI tab

Steps you need in International Tax Calculator:

  • INPUT -> Entity Data -> Column Z

  • REPORTS -> Export Income Tax Report

02. ITC_to_OIT_V1.mp4

Transform Tax Provision Data and Report - BETA

COMING SOON

  • Export Dataset

  • Export Categories

  • Unit Summary (consolidated and local)

Steps you need outside International Tax Calculator:

  • Tax Provision -> download the above 3 files

  • Desktop -> Save into a folder A

  • International Tax Calculator -> download templates

  • Desktop -> Save into a folder B

  • Click to run

03. OTP_to_ITC_V1.mp4

Transform Income Tax Data

  • Prior year FULL 1120 XML

  • E&P and Tax Pools - Coming Soon

Steps you need in International Tax Calculator:

  • Entity Chart -> Entity Data -> Import

  • Browse -> Choose XML -> Upload

04_OIT_to_ITC_V1.mp4


Quick Links: