{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["User Guide","Tax Vouchers Requests","Cancel.(Issued Vouchers)","Download&Cancellation","Correction","Fields","Fields Content","Rejection Reasons"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":1,"defined_names":23,"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":77,"n_cols":3,"rows_kept":77,"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 Clearstream 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."]
[]
[]
[null,"Correction"]
[]
[null,null,"Only for Xact and File Transfer users"]
[]
[null,null,"Please fill in mandatory fields before exporting your requests."]
[null,null,"Only correctable fields are available in the \"Correction\" template. Input only the mandatory fields and fields that require correction."]
[null,null,"Only \"Ready For Download\" and \"Downloaded\" requests can be corrected using this sheet."]
[null,null,"A more exhaustive help on data format is provided in the \"Fields\" 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 or Tax_Correction_Requests_01012025_131055.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":49,"rows_kept":3,"cut":false,"hidden":false,"merged":[[2,9,2,14],[2,1,2,3],[2,19,2,31],[2,32,2,48]]}
["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 Economic Identification Number","BO German Tax Number","BO Foreign TIN","TIN Country","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","Additional BO Title","Additional BO First Name","Additional BO Last Name","BO Relation","Additional BO Building Number","Additional BO Building Number Additional","Additional BO Street Name","Additional BO P.O. Box","Additional BO City","Additional BO Post Code","Additional BO Country","Additional BO Date of Birth","Additional BO German Identification Number","Additional BO German Economic Identification Number","Additional BO German Tax Number","Additional BO Foreign TIN","Additional BO TIN Country"]
[null,null,null,null,"Natural Person","Natural Person","Natural Person","Legal Person",null,null,null,null,null,null,null,"Natural Person","Natural Person",null,"Legal Person",null,null,null,null,null,null,null,null,null,null,null,null,null,"Additional BO"]

{"sheet":"Cancel.(Issued Vouchers)","index":2,"n_rows":3,"n_cols":9,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["Clearstream Xact & FileTransfer - Cancellation Requests (Issued Vouchers)"]
[null,"Clearstream Request ID","BO Date of Birth","BO German Identification Number","BO German Economic Identification Number","BO German Tax Number","BO Foreign TIN","Request Reason","Reason Narrative"]
[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","Clearstream Request ID"]

{"sheet":"Correction","index":4,"n_rows":3,"n_cols":35,"rows_kept":3,"cut":false,"hidden":false,"merged":[[2,9,2,14],[2,18,2,34]]}
["Clearstream Xact & FileTransfer - Tax Correction Requests"]
[null,"Clearstream Request ID","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","Request Reason","Reason Narrative","Additional BO Title","Additional BO First Name","Additional BO Last Name","BO Relation","Additional BO Building Number","Additional BO Building Number Additional","Additional BO Street Name","Additional BO P.O. Box","Additional BO City","Additional BO Post Code","Additional BO Country","Additional BO Date of Birth","Additional BO German Identification Number","Additional BO German Economic Identification Number","Additional BO German Tax Number","Additional BO Foreign TIN","Additional BO TIN Country"]
[null,null,null,null,"Natural Person","Natural Person","Natural Person","Legal Person",null,null,null,null,null,null,null,"Natural Person",null,"If selecting \"Other Reason\"","Additional BO"]

{"sheet":"Fields","index":5,"n_rows":94,"n_cols":6,"rows_kept":94,"cut":false,"hidden":false,"merged":[[2,0,49,0],[58,0,59,0],[50,0,57,0],[60,0,93,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","Optional"]
[null,"11","BO Address - P.O. Box","Max 8 digits","Optional"]
[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","Conditional","Mandatory if BO is a Natural Person"]
[null,"16","BO German Identification Number (Natural Person)","11 digits","Conditional","IdNr - If Country = DE, either IdNR, W-IdNr or StNr must be provided."]
[null,"17","BO German Economic Identification Number (Legal Person)","Max 17 alphanumeric","Conditional","W-IdNr (Wirtschafts-IDNummer) - If Country = DE, either IdNR, W-IdNr or StNr must be provided."]
[null,"18","BO German Tax Number (Legal Person)","13 digits","Conditional","St-Nr (Steuernummer) - If Country = DE, either IdNR, W-IdNr or StNr must be provided."]
[null,"19","BO Foreign TIN","Max 72 alphanumeric","Conditional","Only allowed if Country <> DE"]
[null,"20","TIN Country","ISO Alpha-2 country code","Conditional","Mandatory if Foreign TIN is entered"]
[null,"21","Fund ID","Max 16 digits","Conditional","Ordnungsnummer - To be entered only for reduced rate."]
[null,"22","ISIN","12 alphanumeric","Mandatory"]
[null,"23","Corporate Action Ref.","Max 35 alphanumeric","Conditional","Must be a valid Clearstream CORP ID.\nMust be provided if Payment Date is empty"]
[null,"24","Ex Date","DD/MM/YYYY","Optional"]
[null,"25","Payment Date","DD/MM/YYYY","Conditional","Must be provided if Corporate Action Ref. is empty"]
[null,"26","Requested Date","DD/MM/YYYY","Optional"]
[null,"27","2nd Foreign Dep Name","Max 35 alphanumeric","Optional"]
[null,"28","2nd Foreign Dep Address","Max 35 alphanumeric","Optional"]
[null,"29","Attestation Type","2 alphanumeric","Mandatory"]
[null,"30","Event Type","4 alphanumeric","Optional"]
[null,"31","Tax Rate","2.3 numeric","Optional"]
[null,"32","Additional BO \nTitle","Max 30 alphanumeric","Optional"]
[null,"33","Additional BO \nFirst Name","Max 72 alphanumeric","Optional"]
[null,"34","Additional BO \nLast Name","Max 72 alphanumeric","Optional"]
[null,"35","BO Relation","Max 20 alphanumeric","Conditional","Must have a value to allow for a second BO to be provided."]
[null,"36","Additional BO \nBuilding Number","Max 5 digits","Conditional","This field is mandatory if BO Relation = Other or Spouse."]
[null,"37","Additional BO \nBuilding Number Additional","Max 20 alphanumeric","Optional"]
[null,"38","Additional BO \nStreet Name","Max 72 alphanumeric","Conditional","This field is mandatory if BO Relation = Other or Spouse."]
[null,"39","Additional BO \nP.O. Box","Max 8 digits","Optional"]
[null,"40","Additional BO\nCity","Max 72 alphanumeric","Conditional","This field is mandatory if BO Relation = Other or Spouse."]
[null,"41","Additional BO \nPost Code","Domestic Post Code: 5 digits\nForeign Post Code: Max 12 digits","Conditional","This field is mandatory if BO Relation = Other or Spouse."]
[null,"42","Additional BO \nCountry","ISO Alpha-2 country code","Conditional","This field is mandatory if BO Relation = Other or Spouse."]
[null,"43","Additional BO \nDate of Birth","DD/MM/YYYY","Mandatory"]
[null,"44","Additional BO \nGerman Identification Number","11 digits","Conditional","1) IdNr - If Country = DE, either IdNR, W-IdNr or StNr must be provided.\n2) If BO Relation = Spouse, TIN can be same or different."]
[null,"45","Additional BO \nGerman Economic Identification Number","Max 17 alphanumeric","Conditional","1) W-IdNr (Wirtschafts-IDNummer) - If Country = DE, either IdNR, W-IdNr or StNr must be provided.\n2) If BO Relation = Spouse, TIN can be same or different."]
[null,"46","Additional BO \nGerman Tax Number","13 digits","Conditional","1) St-Nr (Steuernummer) - If Country = DE, either IdNR, W-IdNr or StNr must be provided."]
[null,"47","Additional BO \nForeign TIN","Max 72 alphanumeric","Conditional","Only allowed if Country <> DE and if 2nd BO is provided."]
[null,"48","Additional BO\nTIN Country","ISO Alpha-2 country code","Conditional","Mandatory if Foreign TIN is entered"]
["Cancellation (Issued Vouchers)",1,"Clearstream 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 - If Country = DE, either IdNR, W-IdNr or StNr must be provided."]
[null,"4","BO German Economic Identification Number (Legal Person)","Max 17 alphanumeric","Conditional","W-IdNr (Wirtschafts-IDNummer) - If Country = DE, either IdNR, W-IdNr or StNr must be provided."]
[null,"5","BO German Tax Number (Legal Person)","13 digits","Conditional","St-Nr (Steuernummer) - If Country = DE, either IdNR, W-IdNr or StNr must be provided."]
[null,"6","BO Foreign TIN","Max 72 alphanumeric","Conditional","Mandatory if no German Tax Identifier can be provided"]
[null,"7","Request Reason","Dropdown","Mandatory"]
[null,"8","Reason Narrative","Max 180 alpha numeric characters","Conditional","Mandatory only when user selects \"Other Reason\" in the field Request Reason."]
["Download & Cancellation (File Transfer)",1,"Action",null,"Mandatory"]
[null,"2","Request ID","Max 100 alphanumeric","Mandatory"]
["Correction","1","Clearstream Request ID","Max 100 alphanumeric","Mandatory"]
[null,"2","Quantity","10.3 numeric","Mandatory"]
[null,"3","Customer Reference","Max 72 alphanumeric","Optional"]
[null,"4","BO Title","Max 30 alphanumeric","Optional"]
[null,"5","BO First Name","Max 72 alphanumeric","Conditional","Mandatory if BO is a Natural Person"]
[null,"6","BO Last Name","Max 72 alphanumeric","Conditional","Mandatory if BO is a Natural Person"]
[null,"7","BO Name","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","Optional"]
[null,"11","BO Address - P.O. Box","Max 8 digits","Optional"]
[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","DD/MM/YYYY","Conditional","Mandatory if BO is a Natural Person"]
[null,"16","Request Reason","Dropdown","Mandatory"]
[null,"17","Reason Narrative","Max 180 alpha numeric characters","Conditional","Appears only when user selects \"Other Reason\" in the field Request Reason."]
[null,"18","Additional BO Title","Max 30 alphanumeric","Optional"]
[null,"19","Additional BO First Name","Max 72 alphanumeric","Optional"]
[null,"20","Additional BO Last Name","Max 72 alphanumeric","Optional"]
[null,"21","BO Relation","Max 20 alphanumeric","Conditional","Must have a value to allow for a second BO to be provided."]
[null,"22","Additional BO Building Number","Max 5 digits","Conditional","This field is mandatory if BO Relation = Other or Spouse."]
[null,"23","Additional BO Building Number Additional","Max 120 alphanumeric","Optional"]
[null,"24","Additional BO Street Name","Max 72 alphanumeric","Conditional","This field is mandatory if BO Relation = Other or Spouse."]
[null,"25","Additional BO P.O. Box","Max 8 digits","Optional"]
[null,"26","Additional BO City","Max 72 alphanumeric","Conditional","This field is mandatory if BO Relation = Other or Spouse."]
[null,"27","Additional BO Post Code","Domestic Post Code: 5 digits\nForeign Post Code: Max 12 digits","Conditional","This field is mandatory if BO Relation = Other or Spouse."]
[null,"28","Additional BO Country","ISO Alpha-2 country code","Conditional","This field is mandatory if BO Relation = Other or Spouse."]
[null,"29","Additional BO Date of Birth","DD/MM/YYYY","Mandatory"]
[null,"30","Additional BO German Identification Number","11 digits","Conditional","1) IdNr - If Country = DE, either IdNR, W-IdNr or StNr must be provided.\n2) If BO Relation = Spouse, TIN can be same or different."]
[null,"31","Additional BO German Economic Identification Number","Max 17 alphanumeric","Conditional","1) W-IdNr (Wirtschafts-IDNummer) - If Country = DE, either IdNR, W-IdNr or StNr must be provided.\n2) If BO Relation = Spouse, TIN can be same or different."]
[null,"32","Additional BO German Tax Number","13 digits","Conditional","1) St-Nr (Steuernummer) - If Country = DE, either IdNR, W-IdNr or StNr must be provided."]
[null,"33","Additional BO Foreign TIN","Max 72 alphanumeric","Conditional","Mandatory if Country <> DE if a 2nd BO is provided"]
[null,"34","Additional BO TIN Country","ISO Alpha-2 country code","Conditional","Mandatory if Foreign TIN is entered"]

{"sheet":"Fields Content","index":6,"n_rows":18,"n_cols":5,"rows_kept":18,"cut":false,"hidden":false,"merged":[[16,2,17,2],[16,1,17,1],[13,0,17,0],[2,0,4,0],[2,1,4,1],[2,2,4,2],[7,1,8,1],[7,2,8,2],[5,2,6,2],[5,1,6,1],[13,2,15,2],[13,1,15,1],[9,2,12,2],[9,1,12,1],[7,0,12,0]]}
[null,"Clearstream Xact & File Transfer - Tax Vouchers Requests file specifications"]
[null,"Position in CSV","Field name","Field values","Field decode"]
["New Request","29","Attestation Type","PV","Template I - Privatvermögen"]
[null,null,null,"SB","Template IV - Sammelbescheinigung"]
[null,null,null,"BV","Template III - Betriebsvermögen"]
[null,"35","BO Relation","Spouse"]
[null,null,null,"Other"]
["Download & Cancellation Requests",1,"File Transfer Action","CANCEL"]
[null,null,null,"DOWNLOAD"]
[null,7,"Request Reason","Tax Attestation issued with the wrong final beneficiary"]
[null,null,null,"Tax Attestation requested is a duplicate"]
[null,null,null,"Tax Attestation no longer required (e.g., missed deadline, non-eligible BO)"]
[null,null,null,"Other Reason"]
["Correction","17","Request Reason","Tax Attestation issued with incorrect Beneficial Owner Details"]
[null,null,null,"Tax Attestation issued with incorrect Quantity"]
[null,null,null,"Other Reason"]
[null,"21","BO Relation","Spouse"]
[null,null,null,"Other"]

{"sheet":"Rejection Reasons","index":7,"n_rows":21,"n_cols":2,"rows_kept":21,"cut":false,"hidden":false,"merged":[[9,0,20,0],[2,0,8,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."]
[null,"Additional BO cannot be entered for Legal Person"]
[null,"Additional BO is not a Natural Person. Only Natural person can be entered"]
[null,"Additional BO = Spouse, the address should be same as main BO."]
["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."]