SunGard/Charlotte Tax Reporting Wall Street Concepts (WSC) Interface SunGard Confidential and Proprietary SunGard/Charlotte Tax Reporting 2014 Table of Contents Overview File Transmission to WSC & Data Processing Client Level Options Available Forms WSC Products WSC Account Number Format WSC Web Site Forms & Tax Ledger Production Frequently Asked Support Questions SunGard Confidential and Proprietary 1|Page SunGard/Charlotte Tax Reporting 2014 OVERVIEW Tax Reporting in Charlotte is performed using an interface with SunGard Company, Wall Street Concepts (WSC). It is a monthly interface with a full year to date transaction file refresh sent to Wall Street Concepts (WSC). WSC is an industry leader in tax reporting offering Income Reallocation, Master Limited Partnership Reporting, OID Reporting, REMIC Reporting, and UIT Reporting. The WSC application is strictly a web based product. www.wsc.com WSC clients will be assigned a 3 character WSC client number/firm id. SunGard Confidential and Proprietary 2|Page SunGard/Charlotte Tax Reporting 2014 There are two service levels : Basic service includes the Charlotte interface data, tax ledgers, all 1099/5498 forms and access to the following products: Compliance Plus Master Limited Partnerships (MLPs) Premium service offers a consolidated 1099 statement: a single document covering the 1099-INT, DIV, B, OID and MISC with a summary total, followed by payment details. Automated processing of income reallocations is included, along with access to the following additional features: Compliance Plus MLP Reporting Long Term OID Reporting REMIC Reporting Income Reallocation UIT Reporting TEFRA Glossary **Please note, Premium service does not support multiple payers at the account level for 1099 pass thru income reporting (1099-INT, DIV, B, etc). FILE TRANSMISSION & DATA PROCESSING Charlotte will send data files monthly to WSC. These files will contain account master, account cross reference, security master, and transaction data. For monthends, January through November, these data files will be produced as part of the month-end closing process. For the December month-end, this data will be sent as part of the tax year end processing (approx. Jan 12th). By default, data for all Accounts, with the exception of suspense accounts and accounts closed/saved in the prior year, will be sent to WSC. The client may exclude certain accounts types by contacting Charlotte Client Support. WSC processes files through a pre-edit screening and then a final load process. After they process the files for pre-edit screening a series of pre-edit reports are produced for review. Then the final load of the files is performed which produces warning/error reports for your review. No editing should be done on the WSC web site during the year since data is purged and replacement YTD transactions are sent monthly. All corrections during the year should be made in Charlotte and once data is loaded after tax year end, editing would begin on WSC. SunGard Confidential and Proprietary 3|Page SunGard/Charlotte Tax Reporting 2014 All Charlotte Account coding and cross reference coding remain the same. WSC will look at the “IRS Information Return Reporting” code to determine which forms should be produced. WSC’s Income Reallocation uses only industry cusip numbers. Contra cusips are not allowed. Therefore, the interface will convert contra cusips to the industry cusip prior to data being sent to WSC. Additionally, the interface uses the Security Master 1099 Security Type when mapping security data to WSC. CLIENT LEVEL OPTIONS Option to send money market purchases and sales to WSC. Option to exclude certain account types from being sent to WSC via the interface file. Option to sort tax ledgers and forms by branch. WSC Form Type Option: o S=Simple o I=Intermediate (Only available for Premium clients). o C=Consolidated (Only available for Premium clients). AVAILABLE FORMS Forms that WSC will produce: 1099INT 1099DIV 1099MISC Income/Expense 1099B 1099OID 1099R 5498 5498ESA 1099Q 5498SA 1099SA 1098 WSC produces an enhanced version of the Tax Ledger, which includes any editing you make to transactions in WSC and will reflect any income reallocation editing either entered through bulk adjustments or as part of the Premium service. WSC PRODUCTS Compliance Plus Master Limited Partnership Reporting (MLP) SunGard Confidential and Proprietary 4|Page SunGard/Charlotte Tax Reporting 2014 Income Reallocation (IR) Long Term OID Reporting REMIC Reporting UIT Reporting TEFRA Glossary AMBIR WSC ACCOUNT NUMBER FORMAT Due to the nature of tax reporting, WSC is a form recipient centric system. Not Account centric. In filing with IRS they are dealing with payees or form recipients more than the account the income was earned on. The account numbering logic is as follows: 1. Tax Ledger and transaction activity is listed under the Charlotte six digit account number, i.e. 001234. 2. Data related to a specific payee or form recipient is listed under the Charlotte six digit account number plus the 5 digit Charlotte Name/Address number, i.e. 00123400001 3. Information for a 1099R payee or form recipient is listed under the Charlotte six digit Company Number, six digit Charlotte Plan Number, five digit Charlotte Payee Number, and the 3 digit WSC payer number, i.e. 00123400123400005003. a. The Charlotte payer name & address number is converted to a 3 digit payer number on WSC and may be viewed on the below table. The table will reflect both the WSC payer id, example 002 and the Charlotte name & address payer number #50245. SunGard Confidential and Proprietary 5|Page SunGard/Charlotte Tax Reporting 2014 See Charts Below: The above Beneficiary (payee) split that occurs with the pass thru income forms is a result of the Trust Beneficiaries table: SunGard Confidential and Proprietary 6|Page SunGard/Charlotte Tax Reporting 2014 The below Trust Bene Table shows the 6 digit account number and the Bene account (which is the 6 digit account number followed by the 5 digit payee name & address number) with the corresponding income percent split among beneficiaries/payees. SunGard Confidential and Proprietary 7|Page 2014 SunGard/Charlotte Tax Reporting 5498 Forms Account Structure Charlotte Account #005678 & 5498 Payee #05678 WSC Account # 00567805678 1099 Misc Expense Forms Account Structure Charlotte Account #007788 & Misc Exp Payee #07788 WSC Account # 00778807788 1099R Forms Account Structure Company #001234 Plan #001234 Payee #00005 Payer #003 WSC Account # 00123400123400005003 SunGard Confidential and Proprietary 8|Page SunGard/Charlotte Tax Reporting 2014 WSC Web Site Once the tax year end file is sent to WSC, all editing must be done on the WSC web site, www.wsc.com This is an interface, so once the tax year end is closed and final data goes to WSC there will be no more transmission of data for the tax year. If a social security number is missing from a payee name/address record it must be changed on both systems, WSC for this tax year and Charlotte for next tax season. For questions, please contact Charlotte client support or send a question/inquiry to WSC, through the Client Service Request on www.wsc.com Review ‘All Reports’ under the Warnings/Errors SunGard Confidential and Proprietary 9|Page SunGard/Charlotte Tax Reporting 2014 To view an account setup, go to Account Holders To see the account level setup (tax ledger coding), enter the six digit account number (000002): To see the cross reference record for the beneficiary: enter the six digit account number (000002) plus the 5 digit name & address number (01770): SunGard Confidential and Proprietary 10 | P a g e SunGard/Charlotte Tax Reporting 2014 To view transactions within an account: Add/Edit or Deletes must be done on the Account level (six digits) SunGard Confidential and Proprietary 11 | P a g e SunGard/Charlotte Tax Reporting 2014 WSC Forms Production You may choose to print forms and tax ledgers in-house or through WSC’s preferred print vendor ComGraphics. If you decide to print your own forms and tax ledgers, WSC will deliver these forms and tax ledgers via FTP and this must be setup directly with WSC. All forms may be printed individually via WSC web site as a PDF file. Typically this is done for corrections and not for the original print file. WSC suggests that all clients file a mailing extension for 1099 forms with the IRS. The reason is that Income Reallocation changes are typically not completed prior to January 31st. Forms and tax ledgers are retained on the WSC web site for three years. WSC does state filing through IRS Combined Federal/State Filing Program. WSC codes all information they send to the IRS for reporting to the participating states. The client must notify WSC so that they will include the K records in the IRS file. Tax Ledgers are produced AFTER income reallocations are completed. There is no functionality for a demand tax ledger on WSC. SunGard Confidential and Proprietary 12 | P a g e SunGard/Charlotte Tax Reporting 2014 Frequently Asked Questions - FAQs Why is Wall Street Concepts (WSC) taking over Charlotte tax reporting? WSC has a proven system and they are experts. IRS regulations change often – sometimes at the last minute. WSC is better at interpreting these regulations and quickly updating their system to accommodate the changes. What services are offered by WSC? There are two service levels : Basic service includes the Charlotte interface data, tax ledgers, all 1099/5498 forms and access to the following products: Compliance Plus Master Limited Partnerships (MLPs) Premium service offers a consolidated 1099 statement: a single document covering the 1099-INT, DIV, B, OID and MISC with a summary total, followed by payment details. Automated processing of income reallocations is included, along with access to the following additional features: Compliance Plus MLP Reporting Long Term OID Reporting REMIC Reporting Income Reallocation UIT Reporting TEFRA Glossary **Please note, Premium service does not support multiple payers at the account level for 1099 pass thru income reporting (1099-INT, DIV, B, etc). Will I need to do anything differently? The account coding and cross-referencing requirements will not change. No additional coding of accounts, master security files or transactions are needed. Is there training and documentation? Both WSC and Charlotte offer a variety of web-based training, documentation, service annoucements during the year and an on-line user guide. When can I start checking the reports? There is monthly data load, you should check the reports after each upload. SunGard Confidential and Proprietary 13 | P a g e SunGard/Charlotte Tax Reporting 2014 How can the data be checked? By logging into WSC’s Compliance Plus and reviewing the warning/error reports. What do the reports show? A variety of warnings and/or errors may appear on the reports. A warning will not prevent tax reporting on the account, but an error will. Examples of warnings and errors include missing beneficiary records, taxable income posted on a tax-exempt security and municipal bonds missing the state code. I sold a worthless security for zero proceeds to claim a loss, but WSC does not recognize that transaction. How can my client claim this? Gross Proceeds transactions (sales) with a zero amount (worthless security) will show with an error “Invalid Cost Amount” in WSC. You must manually edit the transaction in WSC and change the amount to .0001. I have many warnings for Invalid city/state/zip errors on account records. What do I need to do? Invalid city/state/zip errors on account records (records with a 6 character account number) can be ignored. If the error is for a recipient (account number field is 11 characters or 20 characters) then the address needs to be corrected. How do I fix errors? During the year, all corrections should be made in Charlotte. After tax year-end closes, corrections are done through WSC’s Compliance Plus web access. Will I still receive tax reports from Charlotte? You will receive 1099/5498 Cross-Reference reports from Charlotte on a monthly basis. You must review these reports and make any necessary corrections in Charlotte prior to the end of the tax year. All corrections after the tax year end are handled in Compliance Plus. The 1099R Cross Reference and 1099R Data Report are also run monthly if you use Pension master. Will I still receive Tax Ledgers from Charlotte? Charlotte will still create Tax Ledgers, but they will only reflect the information posted in Charlotte at the time the tax year is closed. Because all corrections are processed in Compliance Plus, those corrections will carry over to the WSC tax ledger, which is what you should use. SunGard Confidential and Proprietary 14 | P a g e SunGard/Charlotte Tax Reporting 2014 Who will print the tax forms? You have the option of printing your own forms, or using WSC’s print vendor, ComGraphics, Inc. (CGI). CGI will provide a quote for their services. WSC can send a print file, containing all forms, to you or to CGI. If they are sent to you, you may elect to outsource the printing to a vendor of your choice. Can the SSN/TIN be masked on the tax forms? Yes, this option is available. Will I have archive access to forms? Yes. Both the forms and the tax ledgers are archived in PDF format in Compliance Plus for three years. Will WSC print 5498 forms at year-end, and then again in April to report contributions made through April 15? Yes, that option is available. How do I handle corrections after initial IRS filing? You can submit corrections in Compliance Plus at any time. WSC has correction windows throughout the year when they submit them to the IRS. Are there other tax-reporting options besides WSC? SunGard/Charlotte will continue to offer an interface to Thomson FastTax (OneSource). SunGard Confidential and Proprietary 15 | P a g e
© Copyright 2024