Tax code mapping
Tax code mapping translates transaction types and tax codes from a Trust Accounting System into ONESOURCE Trust Tax equivalents. This is done either through vendor-maintained mapping in the bridge file or client-controlled mapping tables within ONESOURCE for greater flexibility.
Method 1
The translation occurs when you extract the tax bridge program. Using this method, the application reads the load fields (called
OTT Tax Code
, or TC, and Trust System Transaction Type
, or TT) and adds them to the application without translation.You maintain the mapping table in the vendor system.
Method 2
Each ONESOURCE Trust Tax database uses a tax code mapping table to translate your accounting system's values in the bridge file to ONESOURCE. The client controls the tables' contents.
The application uses the
Trust Accounting Vendor Tax Treatment Code
to assign the Tax Code
and Transaction Type
. You'll get greater flexibility with this method because you can map a single trust system tax code to different OTT Tax Codes
.Vendor mapping
Trust system name | TAV System ID | Trust System Tax Code map location | Trust System Transaction Type map location |
|---|---|---|---|
AccuTech Systems – AccuTrust Gold | ACCU | Trust system tax code | Trust system tax code |
AccuTech Systems – AccuTrust Cheetah | ACC2 | Trust system tax code | Trust system tax code |
Bank of America - BANA-P | BOA | Trust system tax code | Trust system tax code |
Bank of America - BANA-M | BOAM | Trust system vendor bridge file | Trust system vendor bridge file |
Bank of New York Mellon CMS | MBC | Trust system tax code | Trust system tax code |
Bank of New York Mellon IAS | MBI | Trust system vendor bridge file | Trust system vendor bridge file |
Bank of New York Mellon IMMS | MMD | Trust system tax code | Trust system tax code |
Bank of New York Mellon PSS | PSS | Trust system tax code | Trust system tax code |
Bessemer Trust Company, NA | BTC | Trust system tax code | Trust system tax code |
Citibank London | CITB | Trust system tax code | Trust system tax code |
Constellation Trust Company | CTC | Trust system tax code | Trust system tax code |
DST Systems, Inc. | DST | Trust system tax code | Trust system tax code |
Fifth Third | AMT | Trust system tax code | Trust system tax code |
FIS – AddVantage | NCS | Trust system vendor bridge file | Trust system transaction type |
FIS – Charlotte | NMF | Trust system vendor bridge file | Trust system transaction type |
FIS – Global Plus | PSI | Trust system vendor bridge file | Trust system tax code |
FIS – TrustDesk | MIDS | Trust system vendor bridge file | Trust system tax code |
Fi-Tek – Global WealthES (TrustPortal) | NTT | Trust system vendor bridge file | Trust system vendor bridge file |
Fi-Tek – Rockit Solutions | ROCK | Trust system vendor bridge file | Trust system vendor bridge file |
Goldman Sachs | GSTC | Trust system tax code | Trust system tax code |
HWA Trust Processor | HWA2 | Trust system vendor bridge file | Trust system vendor bridge file |
HWA International, Inc. | HWA | Trust system vendor bridge file | Trust system tax code |
Infovisa (Maui) | INFO | Trust system vendor bridge file | Trust system vendor bridge file |
Innovest Systems | INNO | Trust system tax code | Trust system tax code |
JP Morgan | JPM | Trust system tax code | Trust system tax code |
Northern Trust Company | NTCC | Trust system vendor bridge file | Trust system vendor bridge file |
PNC Bank | PNC | Trust system tax code | Trust system tax code |
PwC Custom | PWCA | Trust system vendor bridge file | Trust system vendor bridge file |
SEI – Trust 3000 | SEI | Trust system vendor bridge file | Trust system vendor bridge file |
SEI – SWP | SEIG | Trust system vendor bridge file | Trust system vendor bridge file |