Bridge Import trial balance data

Trial balance data can change multiple times during the close cycle necessitating the need to quickly update provision calculations. The process of manually exporting a new trial balance from the general ledger system and manually importing it into ONESOURCE Tax Provision can become a bottleneck during a very short closing period. Leveraging the Bridge Import API for ONESOURCE Tax Provision V2016 provides users the ability to automate the import of their 4 or 6 column formatted trial balance into a dataset, eliminating the need to perform the Bridge Import manually through the user interface.

Key Benefits

• Reduce time and effort needed to import the latest trial balance.
• Once the API is configured, the import process can be easily repeated each time a new trial balance is ready.
• Utilizing the Bridge Import API allows for automating a manual process, removing the need for human intervention.

Scenario

Using the ONESOURCE Tax Provision Bridge Import API

1. 1Jamie is the ONESOURCE Tax Provision Administrator for his company. One of his responsibilities is to import a new trial balance into ONESOURCE Tax Provision when material changes have been made in the General Ledger.
2. 2To perform this task in the past, Jamie performs an export of the latest trial balance from the General Ledger and manually imports the data into ONESOURCE Tax Provision using the Bridge Import process. This is a time-consuming process since there are several manual steps that need to be done during the import process.
3. 3Jamie would like to reduce the amount of time and effort needed to complete this task. Jamie is aware of the Bridge Import API and decides to work with his IT department to build out a utility that will automatically pull the latest trial balance data from the General Ledger and save it to a standard 6 column formatted import file. The system will then use the Bridge Import API to automatically upload the data into ONESOURCE Tax Provision. Jamie is surprised with how easy and fast he can complete this task without needing to log into the ONESOURCE Tax Provision and manually import using the Bridge Import UI.