{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["User Guide","Tax Vouchers Requests","Cancel.(Issued Vouchers)","Download&Cancellation","Fields","Fields Content","Rejection Reasons"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":1,"defined_names":13,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"User Guide","index":0,"n_rows":67,"n_cols":3,"rows_kept":67,"cut":false,"hidden":false,"merged":[]}
["User Guide - Clearstream Tax Voucher Requests template"]
[]
["Filling data in the template"]
[]
[]
[null,"Tax Vouchers Requests"]
[]
[null,null,"For Xact and File Transfer users"]
[]
[null,null,"Please fill in mandatory fields before exporting your requests."]
[null,null,"A more exhaustive help on data format is provided in the \"Fields\" sheet."]
[]
[null,null,"Note: The event can be identified with certainty by providing either the Corporate Action Reference or the ISIN in combination with Event Type and Ex Date / Payment Date."]
[null,null,"If less data is provided (e.g. only ISIN) this may not suffice to identify the related Corporate Action event, leading to the Tax Voucher request rejection."]
[]
[]
[null,"Cancellation (Issued Vouchers)"]
[]
[null,null,"For Xact and File Transfer users"]
[]
[null,null,"Tax Vouchers already issued can only be cancelled using this sheet."]
[null,null,"Please fill in mandatory fields before exporting your requests."]
[null,null,"A more exhaustive help on data format is provided in the \"Fields\" sheet."]
[]
[]
[null,"Download&Cancellation Requests"]
[]
[null,null,"Only for File Transfer users"]
[]
[null,null,"Please select the required action (\"CANCEL\" to cancel the Request or \"DOWNLOAD\" to receive the Tax Voucher again) and the related Request ID before exporting your requests."]
[null,null,"Only pending requests can be cancelled using this sheet. Tax Vouchers already issued must be cancelled using the \"Cancellation (Issued Vouchers)\" sheet."]
[]
[]
[]
["Exporting data to a CSV file"]
[]
[null,"When your requests are ready, click on the \"Create CSV request file\" button above the data table."]
[]
[]
[]
[]
[null,"Your requests will be exported into a CSV file. A message will then confirm the export."]
[null,"The CSV file is exported in the same directory where the Excel spreadsheet is saved."]
[null,"Examples of file name: Tax_Vouchers_Requests_03102011_121426.csv or Tax_Vouchers_DownloadCancellation_Requests_03102011_121426.csv"]
[null,"The timestamp will allow a unique filename for each data export and will facilitate the archiving of your data files."]
[]
[]
[]
["Support"]
[]
[null,"Should you need assistance with using this Tax Voucher Request template, please contact one of the Connectivity Help Desks."]
[]
[null,"Email: connect@clearstream.com"]
[]
[null,"Luxembourg"]
[null,"Phone:  +352-243-38110"]
[null,"Fax:  +352-243-638110"]
[]
[null,"London"]
[null,"Phone:  +44 -(0) 20 786 27100"]
[null,"Fax:  +44 -(0) 20 786 27254"]
[]
[null,"Frankfurt "]
[null,"Phone:  +49 -(0) 69 -2 11-1 15 90"]
[null,"Fax:  +49 -(0) 69-2 11-61 15 90"]
[]
[null,"Customers should note that, as is normal practice within financial organisations, Clearstream has implemented telephone line recording. "]

{"sheet":"Tax Vouchers Requests","index":1,"n_rows":3,"n_cols":31,"rows_kept":3,"cut":false,"hidden":false,"merged":[[2,9,2,14],[2,1,2,3],[2,19,2,30]]}
["Clearstream Xact & FileTransfer - Tax Vouchers Requests"]
[null,"Safekeeping Account","Quantity","Customer Reference","BO Title","BO First Name","BO Last Name","BO Name","BO Address - Building Number","BO Address - Building Number Additional","BO Address - Street Name","BO Address - P.O. Box","BO Address - City","BO Address - Post Code","BO Address - Country","BO Date of Birth","BO German Identification Number","BO German Business Identification Number","BO German Tax Number","BO Foreign TIN","Fund ID","ISIN","Corporate Action Ref.","Ex Date","Payment Date","Requested Date","2nd Foreign Dep Name","2nd Foreign Dep Address","Attestation Type","Event Type","Tax Rate"]
[null,null,null,null,"Natural Person","Natural Person","Natural Person","Legal Person",null,null,null,null,null,null,null,"Natural Person","Natural Person","Legal Person","Legal Person"]

{"sheet":"Cancel.(Issued Vouchers)","index":2,"n_rows":3,"n_cols":7,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["Clearstream Xact & FileTransfer - Cancellation Requests (Issued Vouchers)"]
[null,"Request ID","BO Date of Birth","BO German Identification Number","BO German Business Identification Number","BO German Tax Number","BO Foreign TIN"]
[null,null,"Natural Person","Natural Person","Legal Person","Legal Person"]

{"sheet":"Download&Cancellation","index":3,"n_rows":2,"n_cols":3,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Clearstream FileTransfer - Download & Cancellation Requests"]
[null,"Action","Request ID"]

{"sheet":"Fields","index":4,"n_rows":40,"n_cols":6,"rows_kept":40,"cut":false,"hidden":false,"merged":[[2,0,31,0],[38,0,39,0],[32,0,37,0]]}
[null,"Clearstream Xact & File Transfer - Tax Vouchers Requests file specifications"]
[null,"Position in CSV","Field name","Field format","Field status ","Additional information"]
["New Request","1","Safekeeping Account","5 alphanumeric or 7 digits","Mandatory"]
[null,"2","Quantity","10.3 numeric","Mandatory"]
[null,"3","Customer Reference","Max 72 alphanumeric","Optional"]
[null,"4","BO Title (Natural Person)","Max 30 alphanumeric","Optional"]
[null,"5","BO First Name (Natural Person)","Max 72 alphanumeric","Conditional","Mandatory if BO is a Natural Person"]
[null,"6","BO Last Name (Natural Person)","Max 72 alphanumeric","Conditional","Mandatory if BO is a Natural Person"]
[null,"7","BO Name (Legal Person)","Max 120 alphanumeric","Conditional","Mandatory if BO is a Legal Person"]
[null,"8","BO Address - Building Number","Max 5 digits","Optional"]
[null,"9","BO Address - Building Number Additional","Max 20 alphanumeric","Optional"]
[null,"10","BO Address - Street Name","Max 72 alphanumeric","Conditional","Mandatory if Street Address"]
[null,"11","BO Address - P.O. Box","Max 8 digits","Conditional","Mandatory if P.O. Box Address"]
[null,"12","BO Address - City","Max 72 alphanumeric","Mandatory"]
[null,"13","BO Address - Post Code","Domestic Post Code: 5 digits\nForeign Post Code: Max 12 digits","Mandatory"]
[null,"14","BO Address - Country","ISO Alpha-2 country code","Mandatory"]
[null,"15","BO Date of Birth (Natural Person)","DD/MM/YYYY","Optional"]
[null,"16","BO German Identification Number (Natural Person)","11 digits","Optional","IdNr"]
[null,"17","BO German Business Identification Number (Legal Person)","Max 17 alphanumeric","Optional","W-IdNr (Wirtschafts-IDNummer)"]
[null,"18","BO German Tax Number (Legal Person)","13 digits","Optional","St-Nr (Steuernummer)"]
[null,"19","BO Foreign TIN","Max 72 alphanumeric","Optional","Mandatory if no German Tax Identifier can be provided"]
[null,"20","Fund ID","Max 16 digits","Optional","Ordnungsnummer"]
[null,"21","ISIN","12 alphanumeric","Optional"]
[null,"22","Corporate Action Ref.","Max 35 alphanumeric","Optional"]
[null,"23","Ex Date","DD/MM/YYYY","Optional"]
[null,"24","Payment Date","DD/MM/YYYY","Optional"]
[null,"25","Requested Date","DD/MM/YYYY","Optional"]
[null,"26","2nd Foreign Dep Name","Max 35 alphanumeric","Optional"]
[null,"27","2nd Foreign Dep Address","Max 35 alphanumeric","Optional"]
[null,"28","Attestation Type","2 alphanumeric","Optional"]
[null,"29","Event Type","4 alphanumeric","Optional"]
[null,"30","Tax Rate","2.3 numeric","Optional"]
["Cancellation (Issued Vouchers)",1,"Request ID","Max 100 alphanumeric","Mandatory"]
[null,"2","BO Date of Birth (Natural Person)","DD/MM/YYYY","Conditional","Mandatory if BO is a Natural Person"]
[null,"3","BO German Identification Number (Natural Person)","11 digits","Conditional","IdNr"]
[null,"4","BO German Business Identification Number (Legal Person)","Max 17 alphanumeric","Conditional","W-IdNr (Wirtschafts-IDNummer)"]
[null,"5","BO German Tax Number (Legal Person)","13 digits","Conditional","St-Nr (Steuernummer)"]
[null,"6","BO Foreign TIN","Max 72 alphanumeric","Conditional","Mandatory if no German Tax Identifier can be provided"]
["Download & Cancellation (File Transfer)",1,"Action",null,"Mandatory"]
[null,"2","Request ID","Max 100 alphanumeric","Mandatory"]

{"sheet":"Fields Content","index":5,"n_rows":7,"n_cols":5,"rows_kept":7,"cut":false,"hidden":false,"merged":[[2,0,4,0],[2,1,4,1],[2,2,4,2],[5,0,6,0],[5,1,6,1],[5,2,6,2]]}
[null,"Clearstream Xact & File Transfer - Tax Vouchers Requests file specifications"]
[null,"Position in CSV","Field name","Field values","Field decode"]
["New Request","18","Attestation Type","PV","Template I - Privatvermögen"]
[null,null,null,"SB","Template IV - Sammelbescheinigung"]
[null,null,null,"BV","Template III - Betriebsvermögen"]
["Download & Cancellation Requests",1,"File Transfer Action","CANCEL"]
[null,null,null,"DOWNLOAD"]

{"sheet":"Rejection Reasons","index":6,"n_rows":18,"n_cols":2,"rows_kept":18,"cut":false,"hidden":false,"merged":[[6,0,17,0],[2,0,5,0]]}
[null,"Clearstream Xact & File Transfer - Tax Vouchers Requests file specifications"]
[null,"Rejection Reasons"]
["File Validation","One or more account(s) is/are not authorized."]
[null,"This field is mandatory."]
[null,"Syntax or value is not valid."]
[null,"Natural Person and Legal Person details specified for the same request. Only one at a time is allowed."]
["Request Validation","Details provided could not uniquely determine an event, please provide more information."]
[null,"The voucher request must be after the market claim period."]
[null,"Event related to <CorporateActionRef> was reversed"]
[null,"Invalid tax rate for the tax voucher type."]
[null,"Invalid tax rate for the Ordnungsnummer provided."]
[null,"Ordnungsnummer is required when requesting a reduced rate."]
[null,"Beneficial Owner is not linked to the provided Account."]
[null,"The required certificates are not held/active."]
[null,"Insufficient Contingent"]
[null,"Your request could not be processed, please contact Tax Helpdesk at tax@clearstream.com for more information."]
[null,"Cancelled by source system"]
[null,"Voucher cancellation request was invalid."]