{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Instructions","Wire Request Form","Enter Data Here","Module1","Module2","Module3"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":7,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"Module1","index":3,"reason":"part_missing"},{"sheet":"Module2","index":4,"reason":"part_missing"},{"sheet":"Module3","index":5,"reason":"part_missing"}],"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":"Instructions","index":0,"n_rows":73,"n_cols":8,"rows_kept":73,"cut":false,"hidden":false,"merged":[]}
[null,"WIRE TRANSFER REQUEST FORM - INSTRUCTIONS"]
[null," WILLIAM & MARY"]
[null,"DISBURSEMENTS "]
[]
[]
[null,null,"The following instructions are for the preparation of a Wire Transfer Request Form."]
[]
[null,"A.","Preparer Information - required"]
[null,null,"Enter the full name, department, and telephone."]
[]
[null,"B.","Wire Recipient Information - required"]
[null,null,"This information is prepopulated with Disbursements info, do not remove"]
[]
[null,"C.","Type of Wire Transfer - required"]
[null,null,"Enter the type of wire transfer, either foreign or domestic."]
[]
[null,null,"1.","If the final receiving point for payment is a foreign bank (non-U.S.), then the wire is a foreign wire."]
[]
[null,null,"2.","If the final receiving point for payment is a domestic bank (U.S.), then the wire is a domestic wire."]
[null,null,null,"Domestic wire are only processed for the Financial Reporting office unless paying a foreign vendor"]
[]
[null,"D.","Currency Type and Amount - required"]
[null,null,"Enter the type currency in which the wire should be sent and the amount in that currency to be paid."]
[]
[null,null,"1.","If the vendor requires payment in a foreign currency, it should be stated on the invoice."]
[]
[null,null,"2.","The currency type field must be completed.  If another currency is not entered, payment will be"]
[null,null,null,"made in U.S. dollars."]
[]
[null,"E.","Receiving Bank Information"]
[null,null,"The department requesting the wire is responsible for obtaining the vendor's bank information prior"]
[null,null,"to submitting this form for processing. The vendors banking information is required as supporting"]
[null,null,"documentation to avoid incurring additional fees of currency conversion losses for traced or returned wires."]
[]
[]
[null,null,"If any required information is missing, payment by wire transfer will be held until all necessary information"]
[null,null,"is received.  Before completing the receiving banks information, choose the type of transfer from the"]
[null,null,"two options listed below.  Then follow the steps for the option chosen."]
[]
[null,null,"1.","Domestic Wire Transfer"]
[null,null,null,"For a domestic wire, when payment is wired to a domestic bank, complete only the Domestic"]
[null,null,null,"Receiving Bank Information section.  Enter all available information in the spaces provided."]
[null,null,null,"a)","Both the bank name and the branch name (if there is one) are required."]
[null,null,null,"b)","The address is optional."]
[null,null,null,"c)","The city and state where the bank/branch is located is required."]
[null,null,null,"d)","The Routing / Swift Codes are specific codes and should be found on the invoice - optional."]
[]
[]
[null,null,"2.","Foreign Wire Transfer - no corresponding Domestic Bank"]
[null,null,null,"For a foreign wire, when payment is wired directly to a foreign bank, complete only the Foreign"]
[null,null,null,"Receiving Bank Information section.  Enter all available information in the spaces provided."]
[null,null,null,"a)","Both the bank name and the branch name (if there is one) are required."]
[null,null,null,"b)","The address is optional."]
[null,null,null,"c)","The city, state, and country where the bank/branch is located is required."]
[null,null,null,"d)","The IBAN / Swift Codes are specific codes and should be found on the invoice.  The IBAN"]
[null,null,null,null,"number or swift code is required for a foreign bank wire transfer."]
[]
[null,"F.","Beneficiary Information"]
[null,null,"The beneficiary is the vendor or individual receiving payment.  If there is any other information provided,"]
[null,null,"enter it in the Other Beneficiary Information."]
[]
[null,"H.  ","Printing Wire Transfer Request Form for Signature"]
[null,null,"This file has three spreadsheet tabs:  an instructions tab, a data entry sheet tab, and the wire"]
[null,null,"request form tab.  It is not necessary to print the data entry sheet information. The signed Wire  "]
[null,null,"Transer Request Form should be attached to the buyW&M invoice for processing. Please refer to the "]
[null,null,"buyW&M Invoice user guides on how to mark the invoice as a wire payment. "]
[]
[null,null,"Note:","A $40 wire processing fee will be charged via an accounting journal through Workday"]
[null,null,null,"After the wire transfer is complete, there will be no notification to the originator of that fact."]
[null,null,null,"If there are any questions or concerns regarding a transfer, please contact the Disbursements"]
[null,null,null,"Office:"]
[]
[null,null,null,null,null,"Email:",null,"disbursements@wm.edu"]

{"sheet":"Wire Request Form","index":1,"n_rows":39,"n_cols":9,"rows_kept":39,"cut":false,"hidden":false,"merged":[[5,1,5,8],[14,4,14,6],[15,1,15,7],[16,4,16,8],[21,4,21,8]]}
[]
[]
[]
[]
[]
[null,"WIRE TRANSFER REQUEST FORM"]
[]
[null,"TO:",{"$f":"IF('Enter Data Here'!E8<>\"\",'Enter Data Here'!E8,\" \")","v":"DISBURSEMENTS"},null,null,null,"FROM:",{"$f":"IF('Enter Data Here'!E4<>\"\",'Enter Data Here'!E4,\" \")","v":" "}]
[null,null,null,null,null,null,null,{"$f":"IF('Enter Data Here'!E5<>\"\",'Enter Data Here'!E5,\" \")","v":" "}]
[null,null,"Email:",{"$f":"IF('Enter Data Here'!E9<>\"\",'Enter Data Here'!E9,\" \")","v":"disbursements@wm.edu"},null,null,null,"Phone:",{"$f":"IF('Enter Data Here'!E6<>\"\",'Enter Data Here'!E6,\" \")","v":" "}]
[]
[null,null,null,null,null,null,null,"Date:",{"$f":"IF(Start<>\"\",NOW(),\" \")","v":" "}]
[null,"SUBJECT:",{"$f":"CONCATENATE(\"Wire Transfer -- \",'Enter Data Here'!E11)","v":"Wire Transfer -- "}]
[]
[null,"CURRENCY TYPE",null,null,{"$f":"IF('Enter Data Here'!E13<>\"\",'Enter Data Here'!E13,\" \")","v":" "},null,null,"AMOUNT",{"$f":"IF('Enter Data Here'!E15<>\"\",'Enter Data Here'!E15,\" \")","v":" "}]
[null,"Requested Transfer Date:",null,null,null,null,null,null,{"$f":"IF('Enter Data Here'!E17<>\"\",'Enter Data Here'!E17,\" \")","v":" "}]
[null,"RECEIVING BANKS",null,null,"Domestic Bank"]
[null,"     Bank & Branch Names",null,null,{"$f":"IF('Enter Data Here'!E20<>\"\",'Enter Data Here'!E20,\" \")","v":" "}]
[null,"     Address",null,null,{"$f":"IF('Enter Data Here'!E21<>\"\",'Enter Data Here'!E21,\" \")","v":" "}]
[null,"     City, State",null,null,{"$f":"IF('Enter Data Here'!E22<>\"\",'Enter Data Here'!E22,\" \")","v":" "}]
[null,"     Routing # / Swift Code",null,null,{"$f":"CONCATENATE('Enter Data Here'!E23,\"      \",'Enter Data Here'!E24)","v":"      "}]
[null,null,null,null,"Foreign Bank"]
[null,"     Bank & Branch Names",null,null,{"$f":"IF('Enter Data Here'!E27<>\"\",'Enter Data Here'!E27,\" \")","v":" "}]
[null,"     Address",null,null,{"$f":"IF('Enter Data Here'!E28<>\"\",'Enter Data Here'!E28,\" \")","v":" "}]
[null,"     City, State, Country",null,null,{"$f":"IF('Enter Data Here'!E29<>\"\",'Enter Data Here'!E29,\" \")","v":" "}]
[null,"     IBAN / Swift Code",null,null,{"$f":"CONCATENATE(  \"IBAN # \",   'Enter Data Here'!E30,\"      Swift Code # \",'Enter Data Here'!E31)","v":"IBAN #       Swift Code # "}]
[null,"BENEFICIARY INFORMATION",null,null,null,null,null,null,{"$f":"IF('Enter Data Here'!E35<>\"\",CONCATENATE(\"Banner ID# \",'Enter Data Here'!E35),\" \")","v":" "}]
[null,"     Name on Account",null,null,{"$f":"IF('Enter Data Here'!E34<>\"\",'Enter Data Here'!E34,\" \")","v":" "}]
[null,"     Address",null,null,{"$f":"IF('Enter Data Here'!E36<>\"\",'Enter Data Here'!E36,\" \")","v":" "}]
[null,"     City, State, Country",null,null,{"$f":"IF('Enter Data Here'!E37<>\"\",'Enter Data Here'!E37,\" \")","v":" "}]
[null,"     Account Number",null,null,{"$f":"IF('Enter Data Here'!E38<>\"\",'Enter Data Here'!E38,\" \")","v":" "}]
[null,"ORIGINATOR TO BENEFICIARY INFORMATION"]
[null,{"$f":"IF('Enter Data Here'!E41<>\"\",'Enter Data Here'!E41,\" \")","v":" "}]
[null,{"$f":"IF('Enter Data Here'!E42<>\"\",'Enter Data Here'!E42,\" \")","v":" "}]
[null,{"$f":"IF('Enter Data Here'!E43<>\"\",'Enter Data Here'!E43,\" \")","v":" "}]
[]
[null,"Proof of the vendors banking wire details must be provided with the Wire Transfer Request Form when submitted "]
[null,"into buyW&M for processing. This is required to help reduce the chances of a returned wire which can result in "]
[null,"additional fees."]

{"sheet":"Enter Data Here","index":2,"n_rows":40,"n_cols":7,"rows_kept":40,"cut":false,"hidden":false,"merged":[[19,4,19,7],[20,4,20,7],[21,4,21,7],[22,4,22,5]]}
[null,"WILLIAM & MARY WIRE TRANSFER REQUEST"]
[null,"DATA ENTRY SHEET"]
[]
["A.","Full Name of Preparer"]
[null,"     Department Name"]
[null,"     Phone Number"]
[]
["B.","Fin Ops-Recipient Name",null,null,"DISBURSEMENTS"]
[null,"     Email",null,null,"disbursements@wm.edu"]
[]
["C.","Type of Wire Transfer",null,null,null,"  (Foreign or Domestic)"]
[]
["D. ","Currency Type",null,null,null,"  (USD, GBP, HKD, etc.)"]
[]
[null,"Amount",null,null,null,"  Required Field"]
[]
[null,"Date transfer to be made",null,null,null,"  Required Field"]
[]
["E.  ","Domestic Receiving Bank Information - Please read the instructions carefully before completing this section"]
[null,"     Bank Name and Branch Name"]
[null,"     Address"]
[null,"     City, State"]
[null,"     Routing # (ABA) / Swift Code",null,null,null,null,"  Do NOT enter bank account numbers here"]
[null,"     Other Bank or Branch Codes",null,null,null,null,"  (please specify--eg. Type \"Bank Code: 004\")"]
[]
[null,"Foreign Receiving Bank Information - Please read the instructions carefully before completing this section"]
[null,"     Bank Name and Branch Name"]
[null,"     Address"]
[null,"     City, State, Country"]
[null,"     IBAN:",null,null,null,null,"  Do NOT enter bank a/c numbers here unless"]
[null,"     SWIFT",null,null,null,null,"  it is the foreign bank's a/c with domestic bank."]
[null,null,null,null,null,null,"  (please specify--eg. Type \"Bank Code: 004\")"]
[null,"VENDOR Information - (company or individual to received funds)"]
[null,"     Name on Bank Account"]
[null,"     BANNER  Vendor ID"]
[null,"     Address"]
[null,"     City, State, Zip, Country"]
[null,"     Account Number"]
[]
["F. ","Other Originator to Beneficiary Information"]