{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Applicant-1","Applicant-2","Applicant-3","Sheet2"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":3,"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":"Applicant-1","index":0,"n_rows":304,"n_cols":13,"rows_kept":304,"cut":false,"hidden":false,"merged":[[14,2,14,7],[15,1,15,3],[15,7,15,9],[16,7,16,9],[13,0,13,3],[7,0,8,9],[11,5,11,7],[10,0,10,9],[12,8,12,9],[12,0,12,3],[12,5,12,7],[60,0,62,9],[56,0,59,9],[9,0,9,9],[23,7,23,9],[11,0,11,3],[32,7,32,9],[23,2,23,4],[11,8,11,9],[14,0,14,1],[16,0,16,4],[20,0,20,9],[39,0,44,9],[45,0,49,9],[51,0,54,9],[16,5,16,6],[26,7,26,9],[19,0,19,9],[17,0,17,1],[32,0,32,1],[25,0,26,1],[21,5,21,7],[32,2,32,6],[28,3,28,5],[28,6,29,8],[28,0,28,2],[30,6,30,8],[23,5,23,6],[17,2,17,9],[18,1,18,3],[21,0,21,3],[25,2,25,5],[25,7,25,9],[64,7,64,9],[64,1,64,6],[6,4,6,8],[0,0,0,9],[1,0,1,9],[2,0,2,9],[3,0,3,9],[5,0,5,9],[4,0,4,4],[4,5,4,9],[31,0,31,9],[36,0,36,2],[35,7,35,9],[35,3,35,6],[35,0,35,2],[37,0,37,9],[66,3,66,4],[66,5,66,6],[66,7,66,9],[65,1,65,2],[66,1,66,2],[65,3,65,4],[65,5,65,6],[65,7,65,9],[10,12,14,12],[17,12,19,12],[21,12,27,12],[10,13,14,13],[17,13,19,13],[21,13,27,13],[33,2,33,6],[36,3,36,6],[22,0,22,3],[22,5,22,7],[24,2,24,4],[24,5,24,6],[24,7,24,9],[24,0,24,1],[33,0,33,1],[26,2,26,5],[23,0,23,1],[27,0,27,1],[27,2,27,3],[27,4,27,9]]}
["PAL ASSOCIATES INC."]
["TAX & ACCOUNTING SERVICES"]
["956 W. Bailey Road, Naperville, IL 60565"]
["Ph: 630-778-7442, Cell: 630-631-1248"]
["http://www.yourtaxpal.com ",null,null,null,null," E-mail: CPA@yourtaxpal.com"]
["Committed to Quality & Confidentiality sm"]
[null,null,null,2024,"ITIN Application Input Form"]
["Note: You can only apply it with US tax return. You need to fill-out separate form for each applicants. \n$40/1st Application + $20/each additional application charges will apply"]
[]
["Please fill out ALL area highlighetd in Light Blue",null,null,null,null,null,null,null,null,null,null,null,"Find IRS Office and make an appointments (No additional cost). "]
["Your - Taxpayer (Sponsor) Information",null,null,null,null,null,null,null,null,null,null,null,"Participating TAC Location and look for the service center nearby who provide service listed as - Individual Taxpayer Identification Numbers and Form W-7 (More Information)  Look for Service provided as follows"]
["First Name",null,null,null,"MI","Last Name",null,null,"SSN"]
[]
["Applicant is your (Select -1)",null,null,null,"Spouse",null,"Child",null,"Parent"]
["Home Address",null,null,null,null,null,null,null,"APT #"]
["City",null,null,null,"State",null,"Zip",null,null,null,null,null,"Check for Service Available"]
["Foreign Address, if different from Above",null,null,null,null,"Phone Number"]
["Home Address",null,null,null,null,null,null,null,null,null,null,null,"All ITIN applicants, including children, must appear in person at the time the Form W-7, Application for IRS Individual Taxpayer Identification Number, is submitted to have their passport and/or national identification card returned the same day.  This office will review and certify original passports and national identification cards only."]
["City",null,null,null,"State",null,"PIN",null,"Country"]
[]
["Applicant's Information"]
["First Name",null,null,null,"MI","Last Name",null,null,"Male","Female",null,null,"If you SEE a below message, means office does not provide ID validation service but they will accept your application including Passport and send to appropriate Agency. Once IRS validate applicant's passport, they will return back (3-4 weeks) and process ITIN/Federal return.\n \n\t This office accepts Form W-7, Application for IRS Individual Taxpayer Identification Number, with required identity documents, however:  This office does not review or certify any supporting documentation submitted with the application"]
[]
["Birth (City)",null,"Birth (State)",null,null,"Birth (Country)",null,"Have you previously applied for ITIN (Y/N)"]
[null,null,null,null,null,null,null,"N"]
[{"$f":"IF(H25=\"N\",\"Name at Birth, If Different\",\"OLD ITIN Name used\")","v":"Name at Birth, If Different"},null,"First Name",null,null,null,"MI","Last Name"]
[]
[{"$f":"IF(H25=\"N\",\"\",\"OLD ITIN Number\")","v":""}]
["Date of Birth",null,null,"First Entry Date in USA",null,null,"Country of Citizenship"]
["mm","dd","yyyy","mm","dd","yyyy",null,null,null,null,null,null,"Acceptance Agent Information:  Additional fees will be applied by them."]
[]
["Applicant's Passport/VISA Information"]
["Type of US Visa",null,"Visa Number",null,null,null,null,"VISA Expiration Date"]
[null,null,null,null,null,null,null,"mm","dd","yyyy"]
[]
["Passport Issued By (Country)",null,null,"Passport Number",null,null,null,"Passport Expiration Date"]
["INDIA"]
["Confidential - Proprietary Information"]
[]
["·           In person. You can apply for an ITIN by bringing your completed forms and documentation to any IRS Taxpayer Assistance Center in the United States or IRS office abroad. Designated IRS Taxpayer Assistance Centers will be able to verity passports and National ID documents and return them immediately. Information on our overseas offices can be found in Pub. 1915 or at IRS.gov"]
[]
[]
[]
[]
[]
["·         FIND IRS OFFICE: http://www.irs.gov/uac/Contact-Your-Local-IRS-Office-1 and look for the service center nearby who provide service listed as - Individual Taxpayer Identification Numbers and Form W-7 (More Information)  Look for Service provided as follows"]
[]
[]
[]
[]
[]
["1.  All ITIN applicants, including children, must appear in person at the time the Form W-7, Application for IRS Individual Taxpayer Identification Number, is submitted to have their passport and/or national identification card returned the same day.  This office will review and certify original passports and national identification cards only."]
[]
[]
[]
[]
["2.  If you SEE a below message, means office does not provide ID validation service but they will accept your application including Passport and send to appropriate Agency. Once IRS validate applicant's passport, they will return back (3-4 weeks) and process ITIN/Federal return.\n"]
[]
[]
[]
["Ø   This office accepts Form W-7, Application for IRS Individual Taxpayer Identification Number, with required identity documents, however:  This office does not review or certify any supporting documentation submitted with the application."]
[]
[]
[]
[null,"Number of days lived with you in US \n(Calculate Duration)",null,null,null,null,null,"Substantial Presence Test"]
[null,{"$f":"D7","v":2024},null,{"$f":"B66-1","v":2023},null,{"$f":"D66-1","v":2022},null,"Qualify/Non-Qualify"]
[null,null,null,null,null,null,null,{"$f":"IF(B67=\"\",\"\",IF(AND((B67>30),(B67+D67/3+F67/6>182)),\"QUALIFY\", \"NON-QUALIFY\"))","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["N"]
["Y"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["XML FILE"]
["<?xml version=\"1.0\" encoding=\"UTF-8\"?>"]
["<topmostSubform"]
["><PageOneHeader xmlns:xfa=\"http://www.xfa.org/schema/xfa-data/1.0/\" xfa:dataNode=\"dataGroup\""]
["/><AnIRSIndividual xmlns:xfa=\"http://www.xfa.org/schema/xfa-data/1.0/\" xfa:dataNode=\"dataGroup\""]
["/><ForIRSUseOnly xmlns:xfa=\"http://www.xfa.org/schema/xfa-data/1.0/\" xfa:dataNode=\"dataGroup\""]
["/><p1-cb3"]
[">0</p1-cb3"]
["><p1-cb4"]
[{"$f":"CONCATENATE(\">\",IF(F14=\"\",4,0),\"</p1-cb4\")","v":">4</p1-cb4"}]
["><p1-cb5"]
[{"$f":"CONCATENATE(\">\",IF(F14=\"\",4,5),\"</p1-cb5\")","v":">4</p1-cb5"}]
["><f1_01_0_"]
["/><f1_02_0_"]
[{"$f":"CONCATENATE(\">First:\",UPPER(A13),\"       Last: \",UPPER(F13),\"  SSN# \",I13,\"</f1_02_0_\")","v":">First:       Last:   SSN# </f1_02_0_"}]
["><p1-cb6"]
[">0</p1-cb6"]
["><f1_03_0_"]
["/><f1_04_0_"]
["/><f1_05_0_"]
["/><f1_06_0_"]
[{"$f":"CONCATENATE(\">\",UPPER(A23),\" </f1_06_0_\")","v":"> </f1_06_0_"}]
["><f1_07_0_"]
[{"$f":"CONCATENATE(\">\",UPPER(E23),\"</f1_07_0_\")","v":"></f1_07_0_"}]
["><f1_08_0_"]
[{"$f":"CONCATENATE(\">\",UPPER(F23),\"</f1_08_0_\")","v":"></f1_08_0_"}]
["><f1_09_0_"]
[{"$f":"CONCATENATE(\">\",UPPER(C27),\"</f1_09_0_\")","v":"></f1_09_0_"}]
["><f1_10_0_"]
[{"$f":"CONCATENATE(\">\",UPPER(G27),\"</f1_10_0_\")","v":"></f1_10_0_"}]
["><f1_11_0_"]
[{"$f":"CONCATENATE(\">\",UPPER(H27),\"</f1_11_0_\")","v":"></f1_11_0_"}]
["><f1_12_0_"]
[{"$f":"IF(J15=\"\",CONCATENATE(\">\",UPPER(C15),\"</f1_12_0_\"),CONCATENATE(\">\",UPPER(C15),\", APT # \",J15,\"</f1_12_0_\"))","v":"></f1_12_0_"}]
["><f1_13_0_"]
[{"$f":"CONCATENATE(\">\",UPPER(B16),\", \",UPPER(F16),\", \",UPPER(H16),\"</f1_13_0_\")","v":">, , </f1_13_0_"}]
["><f1_14_0_"]
[{"$f":"CONCATENATE(\">\",UPPER(C18),\"</f1_14_0_\")","v":"></f1_14_0_"}]
["><f1_15_0_"]
[{"$f":"CONCATENATE(\">\",UPPER(B19),\", \",UPPER(F19),\", \",UPPER(H19),\", \",UPPER(J19),\"</f1_15_0_\")","v":">, , , </f1_15_0_"}]
["><f1_18_0_"]
[{"$f":"CONCATENATE(\">\",UPPER(A31),\"/\",UPPER(B31),\"/\",UPPER(C31),\"</f1_18_0_\")","v":">//</f1_18_0_"}]
["><f1_19_0_"]
[{"$f":"CONCATENATE(\">\",UPPER(A25),\"</f1_19_0_\")","v":"></f1_19_0_"}]
["><f1_20_0_"]
[{"$f":"CONCATENATE(\">\",UPPER(C25),\", \",UPPER(F25),\"</f1_20_0_\")","v":">, </f1_20_0_"}]
["><f1_21_0_"]
[{"$f":"CONCATENATE(\">\",UPPER(G31),\"</f1_21_0_\")","v":"></f1_21_0_"}]
["><f1_22_0_"]
["/><f1_23_0_"]
[{"$f":"CONCATENATE(\">\",UPPER(A34),\"-\",UPPER(C34),\" Expire: \",UPPER(H35),\"/\",UPPER(I35),\"/\",UPPER(J35),\"</f1_23_0_\")","v":">- Expire: //</f1_23_0_"}]
["><p1-cb3"]
[">1</p1-cb3"]
["><p1-cb4"]
[">0</p1-cb4"]
["><p1-cb5"]
[">0</p1-cb5"]
["><f1_24_0_"]
["/><f1_25_0_"]
[{"$f":"CONCATENATE(\">\",UPPER(A37),\"</f1_25_0_\")","v":">INDIA</f1_25_0_"}]
["><f1_26_0_"]
[{"$f":"CONCATENATE(\">\",UPPER(D37),\"</f1_26_0_\")","v":"></f1_26_0_"}]
["><f1_29_0_"]
[{"$f":"CONCATENATE(\">\",IF(H37>9,UPPER(H37),CONCATENATE(\"0\",UPPER(H37))),IF(I37>9,UPPER(I37),CONCATENATE(\"0\",UPPER(I37))),UPPER(J37),\"</f1_29_0_\")","v":">00</f1_29_0_"}]
["><f1_22"]
[{"$f":"(CONCATENATE(\">\",IF(D31>9,UPPER(D31),CONCATENATE(\"0\",UPPER(D31))),IF(E31>9,UPPER(E31),CONCATENATE(\"0\",UPPER(E31))),UPPER(F31),\"</f1_22\"))","v":">00</f1_22"}]
["><f1_33_0_"]
["/><f1_34_0_"]
["/><f1_35_0_"]
["/><f1_36_0_"]
["/><f1_37_0_"]
["/><f1_40_0_"]
[{"$f":"CONCATENATE(\">\",IF(H14=\"\",,CONCATENATE(UPPER(A13),\" \",UPPER(F13))),\"</f1_40_0_\")","v":"></f1_40_0_"}]
["><f1_39_0_"]
[{"$f":"CONCATENATE(\">\",UPPER(H17),\"</f1_39_0_\")","v":"></f1_39_0_"}]
["><f1_42_0_",null,null,null,"h14 check",null,"A, F13"]
["/><f1_44_0_"]
["/><f1_45_0_"]
["/><f1_46_0_"]
["/><f1_48_0_"]
["/><f1_49_0_"]
["/><f1_50_0_"]
["/><p1-cb1"]
[">0</p1-cb1"]
["><p1-cb2"]
[">0</p1-cb2"]
["><p1-cb7"]
[">1</p1-cb7"]
["><p1-cb8"]
[{"$f":"CONCATENATE(\">\",IF(H14=\"\",0,1),\"</p1-cb8\")","v":">0</p1-cb8"}]
["><p1-cb9"]
[{"$f":"CONCATENATE(\">\",IF(I23=\"\",2,1),\"</p1-cb9\")","v":">2</p1-cb9"}]
["></topmostSubform"]
[">"]
[null,null,null,null,null,null,"I23 J23"]

{"sheet":"Applicant-2","index":1,"n_rows":321,"n_cols":10,"rows_kept":321,"cut":false,"hidden":false,"merged":[[66,1,66,2],[66,3,66,4],[66,5,66,6],[66,7,66,9],[64,1,64,6],[64,7,64,9],[65,1,65,2],[65,3,65,4],[65,5,65,6],[65,7,65,9],[40,0,45,9],[46,0,50,9],[52,0,55,9],[57,0,60,9],[61,0,63,9],[7,0,8,9],[9,0,9,9],[23,7,23,9],[10,0,10,9],[11,0,11,3],[11,5,11,7],[11,8,11,9],[12,0,12,3],[12,5,12,7],[12,8,12,9],[13,0,13,3],[14,0,14,1],[14,2,14,7],[15,1,15,3],[15,7,15,9],[16,0,16,4],[0,0,0,9],[1,0,1,9],[2,0,2,9],[3,0,3,9],[5,0,5,9],[4,0,4,4],[4,5,4,9],[16,5,16,6],[16,7,16,9],[17,0,17,1],[17,2,17,9],[18,1,18,3],[19,0,19,9],[20,0,20,9],[21,0,21,3],[21,5,21,7],[22,0,22,3],[22,5,22,7],[23,0,23,1],[23,2,23,4],[23,5,23,6],[28,0,28,2],[28,3,28,5],[28,6,29,8],[27,0,27,1],[27,2,27,3],[27,4,27,9],[30,6,30,8],[24,7,24,9],[25,0,26,1],[25,2,25,5],[25,7,25,9],[26,2,26,5],[26,7,26,9],[6,4,6,8],[36,0,36,2],[36,3,36,6],[37,0,37,9],[32,0,32,1],[32,2,32,6],[32,7,32,9],[33,0,33,1],[33,2,33,6],[35,0,35,2],[35,3,35,6],[35,7,35,9],[31,0,31,9],[24,0,24,1],[24,2,24,4],[24,5,24,6]]}
[{"$f":"'Applicant-1'!A1:J1","v":"PAL ASSOCIATES INC."}]
[{"$f":"'Applicant-1'!A2:J2","v":"TAX & ACCOUNTING SERVICES"}]
[{"$f":"'Applicant-1'!A3:J3","v":"956 W. Bailey Road, Naperville, IL 60565"}]
[{"$f":"'Applicant-1'!A4:J4","v":"Ph: 630-778-7442, Cell: 630-631-1248"}]
["http://www.yourtaxpal.com ",null,null,null,null," E-mail: CPA@yourtaxpal.com"]
[{"$f":"'Applicant-1'!A6:J6","v":"Committed to Quality & Confidentiality sm"}]
[null,null,null,{"$f":"'Applicant-1'!D7","v":2024},"ITIN Application Input Form"]
[{"$f":"'Applicant-1'!A8:J8","v":"Note: You can only apply it with US tax return. You need to fill-out separate form for each applicants. \n$40/1st Application + $20/each additional application charges will apply"}]
[{"$f":"'Applicant-1'!A9:J9","v":0}]
["Please fill out ALL area highlighetd in Light Grey"]
[{"$f":"'Applicant-1'!A11:J11","v":"Your - Taxpayer (Sponsor) Information"}]
["First Name",null,null,null,"MI","Last Name",null,null,"SSN"]
[{"$f":"'Applicant-1'!A13:D13","v":0},null,null,null,{"$f":"'Applicant-1'!E13","v":0},{"$f":"'Applicant-1'!F13:H13","v":0},null,null,{"$f":"'Applicant-1'!I13:J13","v":0}]
["Applicant is your",null,null,null,"Spouse",null,"Child",null,"Parent","X"]
["Home Address",null,{"$f":"'Applicant-1'!C15:H15","v":0},null,null,null,null,null,"APT #",{"$f":"IF('Applicant-1'!J15 = \"\",\"\",'Applicant-1'!J15)","v":""}]
["City",{"$f":"'Applicant-1'!B16:D16","v":0},null,null,"State",{"$f":"'Applicant-1'!F16","v":0},"Zip",{"$f":"'Applicant-1'!H16:J16","v":0}]
["Foreign Address, if different from Above",null,null,null,null,"Phone Number",null,{"$f":"'Applicant-1'!H17:J17","v":0}]
["Home Address",null,{"$f":"'Applicant-1'!C18:J18","v":0}]
["City",{"$f":"'Applicant-1'!B19:D19","v":0},null,null,"State",{"$f":"'Applicant-1'!F19","v":0},"PIN",{"$f":"'Applicant-1'!H19","v":0},"Country",{"$f":"'Applicant-1'!J19","v":0}]
[]
["Applicant's Information"]
["First Name",null,null,null,"MI","Last Name",null,null,"Male","Female"]
[]
["Birth (City)",null,"Birth (State)",null,null,"Birth (Country)",null,"Have you previously applied for ITIN (Y/N)"]
[null,null,null,null,null,null,null,"N"]
[{"$f":"IF(H25=\"N\",\"Name at Birth, If Different\",\"OLD ITIN Name used\")","v":"Name at Birth, If Different"},null,"First Name",null,null,null,"MI","Last Name"]
[]
[{"$f":"IF(H25=\"N\",\"\",\"OLD ITIN #\")","v":""}]
["Date of Birth",null,null,"First Entry Date in USA",null,null,"Country of Citizenship"]
["mm","dd","yyyy","mm","dd","yyyy"]
[]
["Applicant's Passport/VISA Information"]
["Type of US Visa",null,"Visa Number",null,null,null,null,"VISA Expiration Date"]
[null,null,null,null,null,null,null,"mm","dd","yyyy"]
[]
["Passport Issued By (Country)",null,null,"Passport Number",null,null,null,"Passport Expiration Date"]
["INDIA"]
["Confidential - Proprietary Information"]
["FIND IRS OFFICE: http://www.irs.gov/uac/Contact-Your-Local-IRS-Office-1"]
[]
["·           In person. You can apply for an ITIN by bringing your completed forms and documentation to any IRS Taxpayer Assistance Center in the United States or IRS office abroad. Designated IRS Taxpayer Assistance Centers will be able to verity passports and National ID documents and return them immediately. Information on our overseas offices can be found in Pub. 1915 or at IRS.gov"]
[]
[]
[]
[]
[]
["·         FIND IRS OFFICE: http://www.irs.gov/uac/Contact-Your-Local-IRS-Office-1 and look for the service center nearby who provide service listed as - Individual Taxpayer Identification Numbers and Form W-7 (More Information)  Look for Service provided as follows"]
[]
[]
[]
[]
[]
["1.  All ITIN applicants, including children, must appear in person at the time the Form W-7, Application for IRS Individual Taxpayer Identification Number, is submitted to have their passport and/or national identification card returned the same day.  This office will review and certify original passports and national identification cards only."]
[]
[]
[]
[]
["2.  If you SEE a below message, means office does not provide ID validation service but they will accept your application including Passport and send to appropriate Agency. Once IRS validate applicant's passport, they will return back (3-4 weeks) and process ITIN/Federal return.\n"]
[]
[]
[]
["Ø   This office accepts Form W-7, Application for IRS Individual Taxpayer Identification Number, with required identity documents, however:  This office does not review or certify any supporting documentation submitted with the application."]
[]
[]
[null,"Number of days lived with you in US \n(Calculate Duration)",null,null,null,null,null,"Substantial Presence Test"]
[null,{"$f":"D7","v":2024},null,{"$f":"B66-1","v":2023},null,{"$f":"D66-1","v":2022},null,"Qualify/Non-Qualify"]
[null,null,null,null,null,null,null,{"$f":"IF(B67=\"\",\"\",IF(AND((B67>30),(B67+D67/3+F67/6>182)),\"QUALIFY\", \"NON-QUALIFY\"))","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["N"]
["Y"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["XML FILE"]
["<?xml version=\"1.0\" encoding=\"UTF-8\"?>"]
["<topmostSubform"]
["><PageOneHeader xmlns:xfa=\"http://www.xfa.org/schema/xfa-data/1.0/\" xfa:dataNode=\"dataGroup\""]
["/><AnIRSIndividual xmlns:xfa=\"http://www.xfa.org/schema/xfa-data/1.0/\" xfa:dataNode=\"dataGroup\""]
["/><ForIRSUseOnly xmlns:xfa=\"http://www.xfa.org/schema/xfa-data/1.0/\" xfa:dataNode=\"dataGroup\""]
["/><p1-cb3"]
[">0</p1-cb3"]
["><p1-cb4"]
[{"$f":"CONCATENATE(\">\",IF(F14=\"\",4,0),\"</p1-cb4\")","v":">4</p1-cb4"}]
["><p1-cb5"]
[{"$f":"CONCATENATE(\">\",IF(F14=\"\",4,5),\"</p1-cb5\")","v":">4</p1-cb5"}]
["><f1_01_0_"]
["/><f1_02_0_"]
[{"$f":"CONCATENATE(\">First:\",UPPER(A13),\"       Last: \",UPPER(F13),\"  SSN# \",I13,\"</f1_02_0_\")","v":">First:0       Last: 0  SSN# 0</f1_02_0_"}]
["><p1-cb6"]
[">0</p1-cb6"]
["><f1_03_0_"]
["/><f1_04_0_"]
["/><f1_05_0_"]
["/><f1_06_0_"]
[{"$f":"CONCATENATE(\">\",UPPER(A23),\" </f1_06_0_\")","v":"> </f1_06_0_"}]
["><f1_07_0_"]
[{"$f":"CONCATENATE(\">\",UPPER(E23),\"</f1_07_0_\")","v":"></f1_07_0_"}]
["><f1_08_0_"]
[{"$f":"CONCATENATE(\">\",UPPER(F23),\"</f1_08_0_\")","v":"></f1_08_0_"}]
["><f1_09_0_"]
[{"$f":"CONCATENATE(\">\",UPPER(C27),\"</f1_09_0_\")","v":"></f1_09_0_"}]
["><f1_10_0_"]
[{"$f":"CONCATENATE(\">\",UPPER(G27),\"</f1_10_0_\")","v":"></f1_10_0_"}]
["><f1_11_0_"]
[{"$f":"CONCATENATE(\">\",UPPER(H27),\"</f1_11_0_\")","v":"></f1_11_0_"}]
["><f1_12_0_"]
[{"$f":"IF(J15=\"\",CONCATENATE(\">\",UPPER(C15),\"</f1_12_0_\"),CONCATENATE(\">\",UPPER(C15),\", APT # \",J15,\"</f1_12_0_\"))","v":">0</f1_12_0_"}]
["><f1_13_0_"]
[{"$f":"CONCATENATE(\">\",UPPER(B16),\", \",UPPER(F16),\", \",UPPER(H16),\"</f1_13_0_\")","v":">0, 0, 0</f1_13_0_"}]
["><f1_14_0_"]
[{"$f":"CONCATENATE(\">\",UPPER(C18),\"</f1_14_0_\")","v":">0</f1_14_0_"}]
["><f1_15_0_"]
[{"$f":"CONCATENATE(\">\",UPPER(B19),\", \",UPPER(F19),\", \",UPPER(H19),\", \",UPPER(J19),\"</f1_15_0_\")","v":">0, 0, 0, 0</f1_15_0_"}]
["><f1_18_0_"]
[{"$f":"CONCATENATE(\">\",UPPER(A31),\"/\",UPPER(B31),\"/\",UPPER(C31),\"</f1_18_0_\")","v":">//</f1_18_0_"}]
["><f1_19_0_"]
[{"$f":"CONCATENATE(\">\",UPPER(A25),\"</f1_19_0_\")","v":"></f1_19_0_"}]
["><f1_20_0_"]
[{"$f":"CONCATENATE(\">\",UPPER(C25),\", \",UPPER(F25),\"</f1_20_0_\")","v":">, </f1_20_0_"}]
["><f1_21_0_"]
[{"$f":"CONCATENATE(\">\",UPPER(G31),\"</f1_21_0_\")","v":"></f1_21_0_"}]
["><f1_22_0_"]
["/><f1_23_0_"]
[{"$f":"CONCATENATE(\">\",UPPER(A34),\"-\",UPPER(C34),\" Expire: \",UPPER(H35),\"/\",UPPER(I35),\"/\",UPPER(J35),\"</f1_23_0_\")","v":">- Expire: //</f1_23_0_"}]
["><p1-cb3"]
[">1</p1-cb3"]
["><p1-cb4"]
[">0</p1-cb4"]
["><p1-cb5"]
[">0</p1-cb5"]
["><f1_24_0_"]
["/><f1_25_0_"]
[{"$f":"CONCATENATE(\">\",UPPER(A37),\"</f1_25_0_\")","v":">INDIA</f1_25_0_"}]
["><f1_26_0_"]
[{"$f":"CONCATENATE(\">\",UPPER(D37),\"</f1_26_0_\")","v":"></f1_26_0_"}]
["><f1_29_0_"]
[{"$f":"CONCATENATE(\">\",IF(H37>9,UPPER(H37),CONCATENATE(\"0\",UPPER(H37))),IF(I37>9,UPPER(I37),CONCATENATE(\"0\",UPPER(I37))),UPPER(J37),\"</f1_29_0_\")","v":">00</f1_29_0_"}]
["><f1_22"]
[{"$f":"(CONCATENATE(\">\",IF(D31>9,UPPER(D31),CONCATENATE(\"0\",UPPER(D31))),IF(E31>9,UPPER(E31),CONCATENATE(\"0\",UPPER(E31))),UPPER(F31),\"</f1_22\"))","v":">00</f1_22"}]
["><f1_33_0_"]
["/><f1_34_0_"]
["/><f1_35_0_"]
["/><f1_36_0_"]
["/><f1_37_0_"]
["/><f1_40_0_"]
[{"$f":"CONCATENATE(\">\",IF(H14=\"\",,CONCATENATE(UPPER(A13),\" \",UPPER(F13))),\"</f1_40_0_\")","v":"></f1_40_0_"},null,null,null,"h14 check",null,"A, F13"]
["><f1_39_0_"]
[{"$f":"CONCATENATE(\">\",UPPER(H17),\"</f1_39_0_\")","v":">0</f1_39_0_"}]
["><f1_42_0_"]
["/><f1_44_0_"]
["/><f1_45_0_"]
["/><f1_46_0_"]
["/><f1_48_0_"]
["/><f1_49_0_"]
["/><f1_50_0_"]
["/><p1-cb1"]
[">0</p1-cb1"]
["><p1-cb2"]
[">0</p1-cb2"]
["><p1-cb7"]
[">1</p1-cb7"]
["><p1-cb8"]
[{"$f":"CONCATENATE(\">\",IF(H14=\"\",0,1),\"</p1-cb8\")","v":">0</p1-cb8"}]
["><p1-cb9"]
[{"$f":"CONCATENATE(\">\",IF(I23=\"\",2,1),\"</p1-cb9\")","v":">2</p1-cb9"},null,null,null,null,null,"I23 J23"]
["></topmostSubform"]
[">"]

{"sheet":"Applicant-3","index":2,"n_rows":321,"n_cols":10,"rows_kept":321,"cut":false,"hidden":false,"merged":[[61,0,63,9],[33,0,33,1],[33,2,33,6],[35,0,35,2],[35,3,35,6],[35,7,35,9],[36,0,36,2],[36,3,36,6],[37,0,37,9],[40,0,45,9],[46,0,50,9],[52,0,55,9],[57,0,60,9],[32,7,32,9],[25,0,26,1],[25,2,25,5],[25,7,25,9],[26,2,26,5],[26,7,26,9],[28,0,28,2],[28,3,28,5],[28,6,29,8],[30,6,30,8],[31,0,31,9],[27,0,27,1],[27,2,27,3],[27,4,27,9],[32,0,32,1],[32,2,32,6],[23,0,23,1],[23,2,23,4],[23,5,23,6],[23,7,23,9],[24,0,24,1],[24,2,24,4],[24,5,24,6],[24,7,24,9],[22,0,22,3],[22,5,22,7],[15,1,15,3],[15,7,15,9],[16,0,16,4],[16,5,16,6],[16,7,16,9],[17,0,17,1],[17,2,17,9],[18,1,18,3],[19,0,19,9],[20,0,20,9],[21,0,21,3],[21,5,21,7],[12,0,12,3],[12,5,12,7],[12,8,12,9],[13,0,13,3],[14,0,14,1],[14,2,14,7],[11,0,11,3],[11,5,11,7],[11,8,11,9],[0,0,0,9],[1,0,1,9],[2,0,2,9],[3,0,3,9],[4,0,4,4],[4,5,4,9],[5,0,5,9],[7,0,8,9],[9,0,9,9],[10,0,10,9],[6,4,6,8],[66,1,66,2],[66,3,66,4],[66,5,66,6],[66,7,66,9],[64,1,64,6],[64,7,64,9],[65,1,65,2],[65,3,65,4],[65,5,65,6],[65,7,65,9]]}
[{"$f":"'Applicant-1'!A1:J1","v":"PAL ASSOCIATES INC."}]
[{"$f":"'Applicant-1'!A2:J2","v":"TAX & ACCOUNTING SERVICES"}]
[{"$f":"'Applicant-1'!A3:J3","v":"956 W. Bailey Road, Naperville, IL 60565"}]
[{"$f":"'Applicant-1'!A4:J4","v":"Ph: 630-778-7442, Cell: 630-631-1248"}]
["http://www.yourtaxpal.com ",null,null,null,null," E-mail: CPA@yourtaxpal.com"]
[{"$f":"'Applicant-1'!A6:J6","v":"Committed to Quality & Confidentiality sm"}]
[null,null,null,{"$f":"'Applicant-1'!D7","v":2024},"ITIN Application Input Form"]
[{"$f":"'Applicant-1'!A8:J8","v":"Note: You can only apply it with US tax return. You need to fill-out separate form for each applicants. \n$40/1st Application + $20/each additional application charges will apply"}]
[{"$f":"'Applicant-1'!A9:J9","v":0}]
["Please fill out ALL area highlighetd in Light Grey"]
[{"$f":"'Applicant-1'!A11:J11","v":"Your - Taxpayer (Sponsor) Information"}]
["First Name",null,null,null,"MI","Last Name",null,null,"SSN"]
[{"$f":"'Applicant-1'!A13:D13","v":0},null,null,null,{"$f":"'Applicant-1'!E13","v":0},{"$f":"'Applicant-1'!F13:H13","v":0},null,null,{"$f":"'Applicant-1'!I13:J13","v":0}]
["Applicant is your",null,null,null,"Spouse","x","Child",null,"Parent"]
["Home Address",null,{"$f":"'Applicant-1'!C15:H15","v":0},null,null,null,null,null,"APT #",{"$f":"IF('Applicant-1'!J15 = \"\",\"\",'Applicant-1'!J15)","v":""}]
["City",{"$f":"'Applicant-1'!B16:D16","v":0},null,null,"State",{"$f":"'Applicant-1'!F16","v":0},"Zip ",{"$f":"'Applicant-1'!H16:J16","v":0}]
["Foreign Address, if different from Above",null,null,null,null,"Phone Number",null,{"$f":"'Applicant-1'!H17:J17","v":0}]
["Home Address",null,{"$f":"'Applicant-2'!C18:J18","v":0}]
["City",{"$f":"'Applicant-1'!B19:D19","v":0},null,null,"State",{"$f":"'Applicant-1'!F19","v":0},"PIN",{"$f":"'Applicant-1'!H19","v":0},"Country",{"$f":"'Applicant-1'!J19","v":0}]
[]
["Applicant's Information"]
["First Name",null,null,null,"MI","Last Name",null,null,"Male","Female"]
[]
["Birth (City)",null,"Birth (State)",null,null,"Birth (Country)",null,"Have you previously applied for ITIN (Y/N)"]
[null,null,null,null,null,null,null,"N"]
[{"$f":"IF(H25=\"N\",\"Name at Birth, If Different\",\"OLD ITIN Name used\")","v":"Name at Birth, If Different"},null,"First Name",null,null,null,"MI","Last Name"]
[]
[{"$f":"IF(H25=\"N\",\"\",\"OLD ITIN Number\")","v":""}]
["Date of Birth",null,null,"First Entry Date in USA",null,null,"Country of Citizenship"]
["mm","dd","yyyy","mm","dd","yyyy"]
[]
["Applicant's Passport/VISA Information"]
["Type of US Visa",null,"Visa Number",null,null,null,null,"VISA Expiration Date"]
[null,null,null,null,null,null,null,"mm","dd","yyyy"]
[]
["Passport Issued By (Country)",null,null,"Passport Number",null,null,null,"Passport Expiration Date"]
["INDIA"]
["Confidential - Proprietary Information"]
["FIND IRS OFFICE: http://www.irs.gov/uac/Contact-Your-Local-IRS-Office-1"]
[]
["·           In person. You can apply for an ITIN by bringing your completed forms and documentation to any IRS Taxpayer Assistance Center in the United States or IRS office abroad. Designated IRS Taxpayer Assistance Centers will be able to verity passports and National ID documents and return them immediately. Information on our overseas offices can be found in Pub. 1915 or at IRS.gov"]
[]
[]
[]
[]
[]
["·         FIND IRS OFFICE: http://www.irs.gov/uac/Contact-Your-Local-IRS-Office-1 and look for the service center nearby who provide service listed as - Individual Taxpayer Identification Numbers and Form W-7 (More Information)  Look for Service provided as follows"]
[]
[]
[]
[]
[]
["1.  All ITIN applicants, including children, must appear in person at the time the Form W-7, Application for IRS Individual Taxpayer Identification Number, is submitted to have their passport and/or national identification card returned the same day.  This office will review and certify original passports and national identification cards only."]
[]
[]
[]
[]
["2.  If you SEE a below message, means office does not provide ID validation service but they will accept your application including Passport and send to appropriate Agency. Once IRS validate applicant's passport, they will return back (3-4 weeks) and process ITIN/Federal return.\n"]
[]
[]
[]
["Ø   This office accepts Form W-7, Application for IRS Individual Taxpayer Identification Number, with required identity documents, however:  This office does not review or certify any supporting documentation submitted with the application."]
[]
[]
[null,"Number of days lived with you in US \n(Calculate Duration)",null,null,null,null,null,"Substantial Presence Test"]
[null,{"$f":"D7","v":2024},null,{"$f":"B66-1","v":2023},null,{"$f":"D66-1","v":2022},null,"Qualify/Non-Qualify"]
[null,null,null,null,null,null,null,{"$f":"IF(B67=\"\",\"\",IF(AND((B67>30),(B67+D67/3+F67/6>182)),\"QUALIFY\", \"NON-QUALIFY\"))","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["N"]
["Y"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["XML FILE"]
["<?xml version=\"1.0\" encoding=\"UTF-8\"?>"]
["<topmostSubform"]
["><PageOneHeader xmlns:xfa=\"http://www.xfa.org/schema/xfa-data/1.0/\" xfa:dataNode=\"dataGroup\""]
["/><AnIRSIndividual xmlns:xfa=\"http://www.xfa.org/schema/xfa-data/1.0/\" xfa:dataNode=\"dataGroup\""]
["/><ForIRSUseOnly xmlns:xfa=\"http://www.xfa.org/schema/xfa-data/1.0/\" xfa:dataNode=\"dataGroup\""]
["/><p1-cb3"]
[">0</p1-cb3"]
["><p1-cb4"]
[{"$f":"CONCATENATE(\">\",IF(F14=\"\",4,0),\"</p1-cb4\")","v":">0</p1-cb4"}]
["><p1-cb5"]
[{"$f":"CONCATENATE(\">\",IF(F14=\"\",4,5),\"</p1-cb5\")","v":">5</p1-cb5"}]
["><f1_01_0_"]
["/><f1_02_0_"]
[{"$f":"CONCATENATE(\">First:\",UPPER(A13),\"       Last: \",UPPER(F13),\"  SSN# \",I13,\"</f1_02_0_\")","v":">First:0       Last: 0  SSN# 0</f1_02_0_"}]
["><p1-cb6"]
[">0</p1-cb6"]
["><f1_03_0_"]
["/><f1_04_0_"]
["/><f1_05_0_"]
["/><f1_06_0_"]
[{"$f":"CONCATENATE(\">\",UPPER(A23),\" </f1_06_0_\")","v":"> </f1_06_0_"}]
["><f1_07_0_"]
[{"$f":"CONCATENATE(\">\",UPPER(E23),\"</f1_07_0_\")","v":"></f1_07_0_"}]
["><f1_08_0_"]
[{"$f":"CONCATENATE(\">\",UPPER(F23),\"</f1_08_0_\")","v":"></f1_08_0_"}]
["><f1_09_0_"]
[{"$f":"CONCATENATE(\">\",UPPER(C27),\"</f1_09_0_\")","v":"></f1_09_0_"}]
["><f1_10_0_"]
[{"$f":"CONCATENATE(\">\",UPPER(G27),\"</f1_10_0_\")","v":"></f1_10_0_"}]
["><f1_11_0_"]
[{"$f":"CONCATENATE(\">\",UPPER(H27),\"</f1_11_0_\")","v":"></f1_11_0_"}]
["><f1_12_0_"]
[{"$f":"IF(J15=\"\",CONCATENATE(\">\",UPPER(C15),\"</f1_12_0_\"),CONCATENATE(\">\",UPPER(C15),\", APT # \",J15,\"</f1_12_0_\"))","v":">0</f1_12_0_"}]
["><f1_13_0_"]
[{"$f":"CONCATENATE(\">\",UPPER(B16),\", \",UPPER(F16),\", \",UPPER(H16),\"</f1_13_0_\")","v":">0, 0, 0</f1_13_0_"}]
["><f1_14_0_"]
[{"$f":"CONCATENATE(\">\",UPPER(C18),\"</f1_14_0_\")","v":">0</f1_14_0_"}]
["><f1_15_0_"]
[{"$f":"CONCATENATE(\">\",UPPER(B19),\", \",UPPER(F19),\", \",UPPER(H19),\", \",UPPER(J19),\"</f1_15_0_\")","v":">0, 0, 0, 0</f1_15_0_"}]
["><f1_18_0_"]
[{"$f":"CONCATENATE(\">\",UPPER(A31),\"/\",UPPER(B31),\"/\",UPPER(C31),\"</f1_18_0_\")","v":">//</f1_18_0_"}]
["><f1_19_0_"]
[{"$f":"CONCATENATE(\">\",UPPER(A25),\"</f1_19_0_\")","v":"></f1_19_0_"}]
["><f1_20_0_"]
[{"$f":"CONCATENATE(\">\",UPPER(C25),\", \",UPPER(F25),\"</f1_20_0_\")","v":">, </f1_20_0_"}]
["><f1_21_0_"]
[{"$f":"CONCATENATE(\">\",UPPER(G31),\"</f1_21_0_\")","v":"></f1_21_0_"}]
["><f1_22_0_"]
["/><f1_23_0_"]
[{"$f":"CONCATENATE(\">\",UPPER(A34),\"-\",UPPER(C34),\" Expire: \",UPPER(H35),\"/\",UPPER(I35),\"/\",UPPER(J35),\"</f1_23_0_\")","v":">- Expire: //</f1_23_0_"}]
["><p1-cb3"]
[">1</p1-cb3"]
["><p1-cb4"]
[">0</p1-cb4"]
["><p1-cb5"]
[">0</p1-cb5"]
["><f1_24_0_"]
["/><f1_25_0_"]
[{"$f":"CONCATENATE(\">\",UPPER(A37),\"</f1_25_0_\")","v":">INDIA</f1_25_0_"}]
["><f1_26_0_"]
[{"$f":"CONCATENATE(\">\",UPPER(D37),\"</f1_26_0_\")","v":"></f1_26_0_"}]
["><f1_29_0_"]
[{"$f":"CONCATENATE(\">\",IF(H37>9,UPPER(H37),CONCATENATE(\"0\",UPPER(H37))),IF(I37>9,UPPER(I37),CONCATENATE(\"0\",UPPER(I37))),UPPER(J37),\"</f1_29_0_\")","v":">00</f1_29_0_"}]
["><f1_22"]
[{"$f":"(CONCATENATE(\">\",IF(D31>9,UPPER(D31),CONCATENATE(\"0\",UPPER(D31))),IF(E31>9,UPPER(E31),CONCATENATE(\"0\",UPPER(E31))),UPPER(F31),\"</f1_22\"))","v":">00</f1_22"}]
["><f1_33_0_"]
["/><f1_34_0_"]
["/><f1_35_0_"]
["/><f1_36_0_"]
["/><f1_37_0_"]
["/><f1_40_0_"]
[{"$f":"CONCATENATE(\">\",IF(H14=\"\",,CONCATENATE(UPPER(A13),\" \",UPPER(F13))),\"</f1_40_0_\")","v":"></f1_40_0_"},null,null,null,"h14 check",null,"A, F13"]
["><f1_39_0_"]
[{"$f":"CONCATENATE(\">\",UPPER(H17),\"</f1_39_0_\")","v":">0</f1_39_0_"}]
["><f1_42_0_"]
["/><f1_44_0_"]
["/><f1_45_0_"]
["/><f1_46_0_"]
["/><f1_48_0_"]
["/><f1_49_0_"]
["/><f1_50_0_"]
["/><p1-cb1"]
[">0</p1-cb1"]
["><p1-cb2"]
[">0</p1-cb2"]
["><p1-cb7"]
[">1</p1-cb7"]
["><p1-cb8"]
[{"$f":"CONCATENATE(\">\",IF(H14=\"\",0,1),\"</p1-cb8\")","v":">0</p1-cb8"}]
["><p1-cb9"]
[{"$f":"CONCATENATE(\">\",IF(I23=\"\",2,1),\"</p1-cb9\")","v":">2</p1-cb9"},null,null,null,null,null,"I23 J23"]
["></topmostSubform"]
[">"]

{"sheet":"Sheet2","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}