{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Personal","Income","Deduction","ItemizedDeduction","States","Misc","Foreign Assets","Additional Info","Applicant-1","Applicant-2","Applicant-3","F1-VISA_Only"],"not_rendered":{"charts":0,"images":17,"macros":1,"external_links":2,"defined_names":9,"comments":8,"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":"Personal","index":0,"n_rows":120,"n_cols":18,"rows_kept":120,"cut":false,"hidden":false,"merged":[[55,0,69,0],[42,1,42,17],[68,5,68,9],[68,3,68,4],[69,3,69,4],[69,5,69,9],[63,5,63,9],[64,5,64,9],[65,5,65,9],[66,5,66,9],[67,5,67,9],[58,5,58,9],[59,5,59,9],[60,5,60,9],[61,5,61,9],[62,5,62,9],[63,3,63,4],[64,3,64,4],[65,3,65,4],[66,3,66,4],[67,3,67,4],[58,3,58,4],[59,3,59,4],[60,3,60,4],[61,3,61,4],[62,3,62,4],[55,3,55,4],[55,5,55,9],[56,3,56,4],[57,3,57,4],[56,5,56,9],[57,5,57,9],[46,5,46,9],[47,5,47,9],[48,5,48,9],[49,5,49,9],[50,5,50,9],[25,1,25,10],[40,1,40,2],[43,2,43,3],[43,5,43,9],[34,5,34,9],[31,2,31,8],[32,2,32,8],[31,9,31,10],[32,9,32,10],[36,1,36,2],[37,1,37,2],[38,1,38,2],[34,1,34,2],[35,1,35,2],[26,0,26,15],[27,1,27,10],[30,0,33,0],[36,5,36,9],[37,5,37,9],[38,5,38,9],[39,5,39,9],[40,5,40,9],[40,14,40,16],[34,12,34,16],[52,1,52,2],[46,3,46,4],[47,3,47,4],[42,0,43,0],[45,1,45,2],[46,1,46,2],[47,1,47,2],[48,3,48,4],[49,3,49,4],[50,3,50,4],[52,3,52,4],[49,1,49,2],[50,1,50,2],[51,1,51,2],[48,1,48,2],[51,3,51,4],[12,1,12,9],[13,1,13,3],[13,5,13,9],[22,1,22,10],[23,1,23,10],[20,1,20,10],[21,14,21,15],[10,5,10,9],[11,5,11,9],[15,1,15,10],[16,1,16,10],[14,0,14,10],[14,12,14,15],[15,12,15,15],[17,12,17,15],[17,1,17,10],[16,0,17,0],[7,15,9,15],[8,0,9,0],[8,1,8,2],[8,5,8,9],[8,14,9,14],[9,1,9,2],[10,1,10,2],[11,1,11,2],[7,1,7,14],[80,0,80,11],[81,0,81,11],[36,14,36,16],[4,8,4,12],[4,2,4,7],[0,4,0,11],[1,4,1,11],[6,2,6,3],[6,7,6,9],[24,13,24,15],[25,13,25,15],[20,14,20,15],[19,1,19,10],[19,14,19,15],[27,13,27,15],[5,2,5,12],[2,2,2,12],[3,2,3,12],[24,1,24,10],[72,1,72,3],[39,1,39,2],[22,13,22,15],[23,13,23,15],[18,1,18,15],[21,16,22,17],[77,0,77,8],[78,0,78,11],[79,0,79,11],[21,1,21,10],[45,5,45,9],[45,0,52,0],[29,13,29,15],[30,13,30,15],[31,13,31,15],[32,13,32,15],[33,2,33,15],[30,2,30,8],[30,9,30,10],[29,9,29,12],[29,1,29,8],[37,14,37,16],[38,14,38,16],[39,14,39,16],[34,0,40,0],[35,14,35,16],[45,3,45,4],[51,5,51,9],[52,5,52,9]]}
[null,null,"TAX ORGANIZER",null,"PAL ASSOCIATES INC.",null,null,null,null,null,null,null,{"$f":"A9","v":2024}]
[null,null,null,null,"Tax & Accounting Services"]
[null,null,"956 W. Bailey Road, Naperville, IL 60565"]
[null,null,"PH: (630) 778-7442, Cell: 630-631-1248, Find me # (609) TAX-TIME (829-8463)"]
[null,null,"E-mail: CPA@yourtaxpal.com",null,null,null,null,null,"http://www.yourtaxpal.com"]
[null,null,"Committed to Quality & Confidentiality sm"]
["Perosonal","FBAR/8938","Health Insurance",null,"ITIN","VISA",null,"Dependents",null,null,"Bank","Child Care Expense","Income","Deduction","States"]
["TAX YEAR","Personal Information",null,null,null,null,null,null,null,null,null,null,null,null,null,"Disable"]
[2024,"First Name",null,"Middle Initial","Last Name","Social Security /               ITIN number",null,null,null,null,"Date of Birth","Phone Number","Occupation / Business Title","E-mail","Blind"]
[null,null,null,null,null,"XXX","-","XX","-","XXXX","mm/dd/yyyy","(xxx)xxx-xxxx","Engineer/Consultant / Homemaker etc.","Personal / work E-mail"]
["Taxpayer"]
["Spouse"]
["Home Address",null,null,null,null,null,null,null,null,null,"APT #",null," "]
["City",null,null,null,"State",null,null,null,null,null,"Zip code",null,"Country"]
["EV/PHEV purchased and Home energy tax credits",null,null,null,null,null,null,null,null,null,null,"Amount ","Comments"]
["Electric Vehicle","Verify your EV/PHEV Qualify for Federal Tax credit (Need form 15400 - 30D from Dealer)",null,null,null,null,null,null,null,null,null,null,"If you Installed Home EV Charger, provide cost"]
["Energy Credit","Energy Efficient Home Improvement Credit "]
[null,"Residential Clean Energy Credit"]
["FBAR/\n8938","You must declare ALL Income earned including Interest and Investment from anywhere in the world during US tax year\n (Click to see difference between FBAR FIN CEN 114 and FATCA form 8938 - You may need to file both)\nNon-Compliance will have a significant Penalty for Foreign Income/Assets"]
[null,"Double-click on cell (YES/NO) to make selection OR Right-Click to Clear (Yes/No)",null,null,null,null,null,null,null,null,null,"NO","YES",null,"Additional info Needed",null,"Currency"]
["Q1","Do you have any foreign bank account(s) (accounts outside the USA) during the tax year?"]
["Q2","Have you earned any bank interest, dividends, or capital gains from foreign sources during the tax year? If yes, please provide the amount, tax deducted at source, and the currency.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"INR - Exchange rate is \n$1 = 83.67 INR (Year 2024)"]
["Q3","Do you have an aggregate balance of more than $10,000 USD (or equivalent) in foreign bank account(s) at any time during the tax year? If yes, you must file FINCEN Form 114."]
["Q4","Do you have specified foreign financial asset(s) outside the USA during the tax year? Please refer to IRS Form 8938 (https://www.irs.gov/pub/irs-pdf/i8938.pdf) for the asset threshold.\nFor additional details, see Row 73 below."]
["Q5","At any time during the tax year, did you:\n(a) receive a digital asset (as a reward, award, or payment for property or services), or\n(b) sell, exchange, gift, or otherwise dispose of a digital asset (or a financial interest in a digital asset)?  (YES/NO)"]
["Q6","Did you purchase health insurance through the government-sponsored Marketplace (not through your employer or privately)? If YES, please send Form 1095-A. Without Form 1095-A, your refund will not be processed."]
[]
["ITIN","Do you need to apply for an ITIN number for any of your dependent(s)?\nNEW RULE for existing ITIN holders (see comments for details)."]
[]
[null,"Optional for US Citizen and Greencard holder -                                       VISA Status (If you are on H1/L1/Student Visa, Provide entry date in USA) ",null,null,null,null,null,null,null,"Number of days Physically Presence in US",null,null,null,"Tax Status"]
["VISA INFO",null,"VISA (select using drop down menu)",null,null,null,null,null,null,{"$f":"A9","v":2024},null,{"$f":"J31-1","v":2023},{"$f":"L31-1","v":2022},"Resident/Non-Resident"]
[null,"Taxpayer",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C32=\"F1/F2\",\"Unhide F1-VISA Tab and fill-out\",\"\")","v":""}]
[null,"Spouse",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(C33=\"U.S.Citizen\",C33=\"Greencard holder\"),\"RESIDENT\",IF(C33=\"F1/F2\",\"NON-RESIDENT\",IF(J33=\"\",\"\",IF(AND((J33>30),(J33+L33/3+M33/6>182)),\"RESIDENT\",\"NON-RESIDENT\"))))","v":""}]
[null,"Comments:"]
["Dependent(s) Info","First Name",null,"Middle Initial","Last Name","Social Security /               ITIN number",null,null,null,null,"Date of Birth","Relationship","Number of days lived with you in US (Calculate Duration)",null,null,null,null,"Substantial Presence Test"]
[null,null,null,null,null,"XXX","-","XX","-","XXXX","mm/dd/yyyy","Son / Daughter /        Parents etc.",{"$f":"A9","v":2024},{"$f":"M36-1","v":2023},{"$f":"N36-1","v":2022},null,null,"Qualify/Non-Qualify"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M37=\"\",\"\",IF(AND((M37>30),(M37+N37/3+O37/6>182)),\"QUALIFY\", \"NON-QUALIFY\"))","v":""}]
[null,null,null,null,null,null,"-",null,"-",null,null,null,null,null,null,null,null,{"$f":"IF(M38=\"\",\"\",IF(AND((M38>30),(M38+N38/3+O38/6>182)),\"QUALIFY\", \"NON-QUALIFY\"))","v":""}]
[null,null,null,null,null,null,"-",null,"-",null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,"-",null,"-",null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,"-",null,"-",null,null,null,null,null,null,null,null,""]
[]
["Bank Info","Bank Information: (If you are getting a Refund and want to direct deposit, Provide Bank Routing and Account #)"]
[null,"Routing #",null,null,"Account #",null,null,null,null,null,"A/C Type","Checking","Bank Name",null,"Note:  You can also send me via two separate E-mail"]
[]
["Child and Dependent Care Expense","Child name",null,"Care Provider Name",null,"Address",null,null,null,null,"City","State - Zip","EIN/SSN for Care Provider","Amount Paid"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"If any member of household does not have full year of health Insurance coverage, please fill-out Monthly covergae information for each Member"]
["ACA Health Care Organizer",null,"Taxpayer","Spouse",null,"Dependent-1",null,null,null,null,"Dep-2","Dependent-3","Dependent-4","Dependent-5"]
[null,"Reason"]
[null,"ALL"]
[null,"January"]
[null,"February"]
[null,"March"]
[null,"April"]
[null,"May"]
[null,"June"]
[null,"July"]
[null,"August"]
[null,"September"]
[null,"October"]
[null,"November"]
[null,"December"]
[]
[]
[null,"Client Service Agreement"]
[null,"I have read & understand the terms & conditions of Pal Associates Inc. ",null,null,null,null,null,null,null,null,null,null,null,"Note:  You can also send me via two separate E-mail"]
[]
["Additional Info:"]
["If Below information is applicable to you, please inform us and we will collect necessary info to complete form 8938."]
["Form 8938 - Statement of Specified Foreign Financial Assets"]
["http://www.irs.gov/Businesses/Corporations/Basic-Questions-and-Answers-on-Form-8938"]
["New reporting requirements. For tax years beginning after March 18, 2010, certain individuals must file new Form 8938 to report the ownership of specified foreign financial assets if the total value of those assets exceeds an applicable threshold amount (the “reporting threshold”). The reporting threshold varies depending on whether an individual lives in the United States or files a joint income tax return with his or her spouse."]
["Specified foreign financial assets generally include the following assets.\nAny financial account maintained by a foreign financial institution.\nTo the extent held for investment and not held in a financial account, any stock or securities issued by someone that is not a U.S. person, any interest in a foreign entity, and any financial instrument or contract with an issuer or counterparty that is not a U.S. person.\n"]
["Determining the Reporting Threshold That Applies to You\nIf you satisfy the reporting threshold discussed next that applies to you and no exception applies, file Form 8938 with your income tax return.\nUnmarried taxpayer living in the United States. If you are not married and not living abroad, you satisfy the reporting threshold only if the total value of your specified foreign financial assets is more than $50,000 on the last day of the tax year or more than $75,000 at any time during the tax year.\nMarried taxpayers filing a joint income tax return and living in the United States. If you are married and you and your spouse file a joint income tax return and do not live abroad, you satisfy the reporting threshold only if the total value of your specified foreign financial assets is more than $100,000 on the last day of the tax year or more than $150,000 at any time during the tax year.\nMarried taxpayers filing separate income tax returns and living in the United States. If you are married, file a separate income tax return from your spouse, and do not live abroad, you satisfy the reporting threshold only if the total value of your specified foreign financial assets is more than $50,000 on the last day of the tax year or more than $75,000 at any time during the tax year.\nTaxpayers living abroad. If your tax home is in a foreign country and you meet one of the presence abroad tests described next, you satisfy the reporting threshold if you are not filing a joint return and the total value of your specified foreign financial assets is more than $200,000 on the last day of the tax year or more than $300,000 at any time during the tax year.\nIf you are married and file a joint income tax return, you satisfy the reporting threshold only if the total value of all specified foreign financial assets you or your spouse owns is more than $400,000 on the last day of the tax year or more than $600,000 at any time during the tax year.\n",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["U.S.Citizen",null,null,null,null,null,null,null,null,null,null,"Checking"]
["Greencard holder",null,null,null,null,null,null,null,null,null,null,"Savings"]
["H1"]
["H4"]
["L1"]
["L2"]
["J1"]
["J2"]
["F1/F2"]
["Other"]

{"sheet":"Income","index":1,"n_rows":18,"n_cols":7,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,0,1,7],[3,0,3,3],[3,6,3,7],[4,0,4,3],[4,6,4,7],[2,0,2,7],[8,6,8,7],[9,0,9,3],[9,6,9,7],[5,0,5,3],[5,6,5,7],[6,0,6,3],[6,6,6,7],[7,0,7,3],[7,6,7,7],[8,0,8,3],[15,0,15,3],[15,6,15,7],[13,0,13,3],[13,6,13,7],[14,0,14,3],[14,6,14,7],[10,0,10,3],[10,6,10,7],[11,0,11,3],[11,6,11,7],[12,0,12,3],[12,6,12,7]]}
[]
["Income & Supporting Documents"]
["Double-click on cell (YES/NO) to make selection OR Right-Click to Clear"]
["Description",null,null,null,"NO","YES","Provide Documents"]
["Wages and Salaries"]
["Interest Income"]
["Dividend Income"]
["State Tax refund from Previous Year\n(Only if you have used Itemized deduction)"]
["Capital Gain (Stock)\n(1099-DIV, 1099-OID, 1099-B etc.)"]
["Total IRA Distribution"]
["Unemployment Compensation"]
["Social Security Benefits"]
["Alimony Received"]
["Business Income/Expense \n(Sole Properitary)"]
["Business Income/Expense \n(S-Corp or Partnership )"]
["Rental Investment Income/Expense"]
["Notes:  You can add any additional info below as applicable to you."]
["1099-Q","If you have any Withdrawl from 529 plan."]

{"sheet":"Deduction","index":2,"n_rows":29,"n_cols":7,"rows_kept":29,"cut":false,"hidden":false,"merged":[[5,0,5,3],[5,6,5,7],[1,0,1,7],[3,0,3,3],[3,6,3,7],[4,0,4,3],[4,6,4,7],[2,0,2,7],[6,6,6,7],[7,0,7,3],[7,6,7,7],[8,0,8,3],[8,6,8,7],[6,0,6,3],[15,0,15,3],[15,6,15,7],[14,0,14,3],[14,6,14,7],[12,0,12,3],[12,6,12,7],[13,0,13,3],[13,6,13,7],[9,0,9,3],[9,6,9,7],[10,0,10,3],[10,6,10,7],[11,0,11,3],[11,6,11,7],[28,1,28,6],[23,0,23,7],[16,0,16,3],[16,6,16,7],[17,0,17,3],[17,6,17,7],[18,0,18,3],[18,6,18,7],[19,0,19,3],[19,6,19,7],[24,1,24,6],[25,1,25,6],[26,1,26,6],[27,1,27,6]]}
[]
["Adjusted Gross Income & Supporting Documents"]
["Double-click on cell (YES/NO) to make selection OR Right-Click to Clear"]
["Description",null,null,null,"NO","YES","Provide Documents"]
["Are you a Teacher? (Max up to $250)"]
["Health Savings Account Deduction"]
["Reserved"]
["Self Empolyed SEP SIMPLE IRA"]
["Self Employed Health Insurance Deduction"]
["Penalty on early withdrawl savings"]
["Alimony Paid"]
["IRA Deduction"]
["Student Loan Interest Deduction"]
["Tuition and fees Deduction"]
["Mortgage Interest paid on Primary home"]
["Property Tax paid on Primary home"]
["Gifts to Charity - Cash/Checks"]
["Gifts to Charity - Household items"]
["Medical Expense - Post tax (Not HSA)"]
["Itemized Deduction\n(Medical Expense, Non-Reimbursed Employer Expense, Charity etc.)"]
["Notes:  You can add additional info below, if needed."]
[]
[]
["Moving Expense - See List of Moving Expenses Eligible/Ineligible for Tax Benefits"]
[1,"Enter the number of Miles from your old Home to your new Workplace"]
[2,"Enter the number of Miles from your old Home to your old Workplace"]
[3,"Do you meet the Time test requirments  (See comments)"]
[4,"Transportation and Storage of household and personal effects"]
[5,"Travel (Including Lodging) from your old home to your new home.  - Do not include the cost of meals."]

{"sheet":"ItemizedDeduction","index":3,"n_rows":53,"n_cols":9,"rows_kept":53,"cut":false,"hidden":true,"merged":[[19,8,19,9],[14,1,14,7],[17,8,17,9],[21,1,21,7],[19,1,19,7],[20,1,20,7],[20,8,20,9],[21,8,21,9],[16,1,16,7],[43,8,43,9],[43,1,43,7],[44,1,44,9],[42,1,42,7],[39,8,39,9],[50,8,50,9],[45,1,45,7],[46,1,46,7],[47,1,47,4],[49,1,49,7],[48,1,48,7],[8,8,8,9],[9,8,9,9],[18,0,18,9],[17,1,17,7],[11,1,11,7],[12,1,12,7],[11,8,11,9],[8,1,8,7],[9,1,9,7],[10,1,10,7],[13,1,13,7],[15,1,15,7],[3,0,3,9],[4,1,4,7],[5,1,5,7],[6,1,6,7],[7,1,7,7],[22,1,22,7],[22,8,22,9],[26,8,26,9],[27,8,27,9],[28,8,28,9],[34,0,34,9],[37,8,37,9],[41,8,41,9],[38,8,38,9],[29,8,29,9],[40,8,40,9],[38,1,38,7],[39,1,39,7],[40,1,40,7],[41,1,41,7],[51,1,51,7],[51,8,51,9],[30,8,30,9],[31,8,31,9],[32,1,32,7],[32,8,32,9],[45,8,45,9],[46,8,46,9],[36,1,36,9],[35,1,35,9],[42,8,42,9],[37,1,37,7],[49,8,49,9],[48,8,48,9],[47,5,47,7],[47,8,47,9],[2,0,2,9],[24,1,24,7],[24,8,24,9],[25,8,25,9],[10,8,10,9],[12,8,12,9],[13,8,13,9],[14,8,14,9],[15,8,15,9],[16,8,16,9],[23,1,23,7],[23,8,23,9],[4,8,4,9],[5,8,5,9],[6,8,6,9],[7,8,7,9]]}
[null,"Mortgage","Gifts to Charity",null,"Medical","Non-Reimbursed Business Expense"]
[]
["Schedule A - Itemized Deduction"]
["Mortgage Interest, Property Tax and other Tax"]
[1,"State and Local Tax"]
[null,"  State and local tax from W-2, 1099 (you can ignore it, if W-2 is atatched)"]
[null,{"$f":"CONCATENATE(\"State estimated paid in \",Personal!A9)","v":"State estimated paid in 2024"},null,null,null,null,null,null," "]
[null,{"$f":"CONCATENATE(\"  Prior year state and local estimates paid after 12-31-\",#REF!)","v":{"$error":"#REF!"}},null,null,null,null,null,null," "]
[null,"  - or -"]
[null,"  General Sales Taxes"]
[2,"Real Estate Tax",null,null,null,null,null,null," "]
[" ","  If Staying in IL, provide PIN # (Located on Property Tax bill)"]
[3,"Personal Property Taxes"]
[4,"Mortgage Interest and points paid"]
[5,"Points not reported to you on Form 1098"]
[6,"Qualified Mortgage Insurance Premiums"]
[7,"Investment Interest"]
[]
["Gifts to Charity"]
[1,"Total Contributions by cash or check"]
[2,"Vehicle Expense"]
[null,"  # of miles Driven for Charity "]
[null,"  Other Expenses"]
[3,"Other than cash or check "]
[null,"  If more than $500, Provide Donee Organization, Description of donation, and below info"]
[null,"Date of Contribution","Date Acquired","How Acquired","Donor's Cost","Fair Market Value","Reduced FMV","Method"]
[]
[]
[]
[]
[]
[]
[4,"Carry over from Previous year"]
[]
["Medical and Dental Expenses"]
[null,"Do not Include Expense reimbursed, paid by others, paid with pretax dollars or claimed elsewhere on your return"]
[1,"Insurance Premiums"]
[null,"  Medical and dental care insurance premiums (Other than Self-Employed)"]
[null,"  Self Employed health Insurance premiums not included on form 1040 - 29"]
[null,"  Medicare Part B and D premiums from SSA-1099 and RRB-1099-R"]
[null,"  Qulaified long term care premiums"]
[2,"Doctor, dentist and hospital fees"]
[3,"Prescription medicines and drugs"]
[4,"Medical aids such as eysglases, contact lenses, and hearing aids"]
[5,"Transportaion"]
[null,"  Parking Fees and Tolls"]
[null,"  Actual out-of-Pocket expense fo vehicle"]
[null," - or - "]
[null,"  # of Miles Driven"]
[6,"Other Medical and dental expenses"]
[" "]
[null,"Non-Reimbursed Business Expenses including Vehicle and other (list down)"]
[null,"Notes:  You can add additional info below, if needed."]

{"sheet":"States","index":4,"n_rows":201,"n_cols":14,"rows_kept":201,"cut":false,"hidden":false,"merged":[[23,4,23,6],[24,4,24,6],[23,7,23,8],[23,9,23,11],[71,2,71,8],[21,1,21,8],[21,9,21,11],[16,1,16,8],[16,9,16,11],[22,9,22,11],[22,1,22,8],[17,1,17,8],[17,9,17,11],[24,7,24,8],[24,9,24,11],[23,1,23,2],[18,1,18,8],[18,9,18,11],[19,1,19,8],[19,9,19,11],[20,1,20,8],[20,9,20,11],[25,1,25,2],[25,4,25,6],[113,1,113,8],[113,9,113,11],[114,1,114,8],[25,7,25,8],[25,9,25,11],[26,1,26,2],[26,4,26,6],[145,1,145,11],[143,4,143,7],[143,8,143,11],[144,4,144,11],[38,9,38,11],[37,0,37,10],[135,0,135,10],[136,4,136,5],[136,9,136,11],[137,5,137,6],[137,10,137,11],[142,7,142,11],[138,1,138,8],[138,9,138,11],[139,1,139,8],[140,1,140,8],[141,1,141,8],[147,9,147,11],[146,9,146,11],[147,2,147,8],[123,1,123,8],[123,9,123,11],[124,5,124,11],[117,9,117,11],[118,9,118,11],[119,7,119,11],[131,9,131,11],[125,9,125,11],[126,9,126,11],[127,9,127,11],[128,9,128,11],[130,4,130,11],[129,9,129,11],[129,1,129,8],[126,1,126,8],[120,8,120,11],[139,9,139,11],[140,9,140,11],[114,9,114,11],[115,1,115,11],[116,9,116,11],[121,4,121,11],[122,1,122,8],[122,9,122,11],[44,1,44,5],[44,6,44,8],[44,9,44,11],[52,9,52,11],[52,1,52,8],[53,1,53,8],[54,1,54,8],[53,9,53,11],[54,9,54,11],[55,1,57,11],[65,1,67,11],[77,1,79,11],[74,2,74,8],[75,2,75,8],[76,2,76,8],[68,0,68,10],[69,1,69,11],[70,9,70,11],[42,6,42,8],[50,9,50,11],[50,1,50,8],[51,1,51,8],[51,9,51,11],[49,0,49,10],[179,1,179,7],[177,0,177,10],[180,8,180,9],[180,10,180,11],[180,1,180,7],[178,1,178,11],[150,9,150,11],[151,9,151,11],[152,9,152,11],[150,2,150,8],[151,2,151,8],[152,2,152,8],[159,0,159,10],[160,1,160,8],[82,0,82,10],[84,4,84,5],[84,7,84,8],[84,9,84,11],[190,8,190,9],[190,10,190,11],[191,8,191,9],[191,10,191,11],[191,1,191,7],[190,1,190,7],[174,1,176,11],[185,8,186,9],[185,10,186,11],[187,5,187,11],[188,8,188,9],[188,10,188,11],[189,8,189,11],[189,1,189,7],[186,1,186,7],[182,1,183,7],[182,8,183,9],[182,10,183,11],[181,8,181,9],[181,10,181,11],[184,5,184,11],[181,1,181,7],[179,8,179,9],[179,10,179,11],[71,9,71,11],[72,1,72,11],[65,0,67,0],[55,0,57,0],[73,9,73,11],[85,4,85,5],[85,7,85,8],[85,9,85,11],[86,4,86,5],[86,7,86,8],[86,9,86,11],[83,4,83,5],[83,7,83,8],[83,9,83,11],[75,9,75,11],[76,9,76,11],[74,9,74,11],[89,1,89,3],[89,4,89,5],[89,7,89,8],[89,9,90,11],[90,1,90,3],[90,4,90,5],[90,7,90,8],[87,9,87,11],[88,4,88,5],[88,7,88,8],[88,9,88,11],[87,4,87,5],[87,7,87,8],[96,1,96,8],[97,1,97,11],[98,9,98,11],[99,9,99,11],[100,9,100,11],[91,1,91,3],[91,4,91,11],[92,4,92,11],[93,1,93,11],[96,9,96,11],[109,9,109,11],[109,1,109,8],[101,9,101,11],[102,9,102,11],[103,9,103,11],[104,9,104,11],[101,1,101,8],[102,1,102,8],[103,1,103,8],[104,1,104,8],[105,1,107,11],[110,1,110,11],[111,1,111,8],[112,1,112,8],[163,1,163,11],[164,2,164,8],[164,9,164,11],[165,1,165,8],[165,9,165,11],[161,1,161,8],[160,9,160,11],[161,9,161,11],[162,1,162,11],[132,1,134,11],[153,1,155,11],[127,1,127,8],[128,1,128,8],[148,1,148,11],[149,9,149,11],[141,9,141,11],[111,9,111,11],[112,9,112,11],[116,2,116,8],[118,1,118,8],[120,4,120,7],[15,0,15,10],[62,9,62,11],[63,9,63,11],[64,9,64,11],[62,1,62,8],[63,1,63,8],[64,1,64,8],[59,1,59,8],[60,1,60,8],[61,1,61,8],[59,9,59,11],[60,9,60,11],[61,9,61,11],[58,0,58,10],[40,1,40,8],[41,1,41,5],[43,4,43,5],[39,9,39,11],[40,9,40,11],[41,6,41,8],[41,9,41,11],[45,6,45,8],[45,9,45,11],[45,1,45,5],[24,1,24,2],[1,0,1,11],[29,0,29,10],[30,8,30,11],[31,1,31,2],[31,3,31,6],[31,7,31,8],[31,9,31,11],[4,10,4,11],[27,1,28,11],[5,2,5,3],[5,4,5,5],[5,6,5,7],[5,8,5,9],[5,10,5,11],[4,0,4,1],[5,0,5,1],[6,0,6,1],[7,0,7,1],[8,0,8,1],[4,2,4,3],[4,4,4,5],[4,6,4,7],[4,8,4,9],[32,9,32,11],[33,1,33,2],[33,3,33,6],[33,7,33,8],[33,9,33,11],[2,0,2,11],[3,0,3,10],[34,1,36,11],[46,1,48,11],[34,0,36,0],[27,0,28,0],[46,0,48,0],[10,0,10,11],[32,1,32,2],[32,3,32,6],[32,7,32,8],[42,9,42,11],[43,6,43,8],[43,9,43,11],[38,1,38,8],[39,1,39,8],[26,7,26,8],[26,9,26,11],[9,0,9,1],[192,0,194,0],[200,0,202,0],[200,1,202,11],[174,0,176,0],[166,0,168,0],[153,0,155,0],[132,0,134,0],[105,0,107,0],[77,0,79,0],[197,0,197,10],[198,1,198,8],[198,9,198,11],[199,1,199,8],[199,9,199,11],[192,1,194,11],[173,7,173,8],[173,9,173,11],[171,1,171,8],[171,9,171,11],[170,1,170,11],[169,0,169,10],[94,9,94,11],[95,9,95,11],[108,0,108,10]]}
[]
["State Specific Q & A"]
["Note:  You are responsible to file Local or County tax, if required.  Our service only covers Federal & State tax return."]
["If you or your spouse have stayed in more than one state or stayed in different states please provide information below."]
[null,null,"State-1",null,"State-2",null,"State-3",null,"State-4",null,"State-5"]
["State name"]
["Dates Taxpayer lived in State (From - To)"]
["Dates Spouse lived in State (From - To)"]
["Additional Info"]
["529 tax Benefits by State",null,"If you enroll in State 529 plan, please share account Statement which shows account # and amount contributed during tax year."]
["Double-click on cell to make selection OR Right-Click to Clear"]
["IL","CT","MA","NJ","WI","CA","NY","MI","IN","OH","NC","MN","AL","OTHER"]
[1,2,3,4,5,6,7,8,9,10,11,12,13,14]
[]
[]
["Illinois",null,null,null,null,null,null,null,null,null,null,"TOP"]
[null,"Amount of real-estate taxes paid on your principal residence located in Illinois"]
[null,"PIN number of your principal residence located in Illinois (From your Property Tax bill)"]
[null,"Contribution you made to the following College Savings Plan"]
[null," a.) Brightstar College Savings Pool"]
[null," b.) College Illinois Tution Prepaid Program"]
[null," C.) Bright Direction College Savings Pool"]
[null,"Total amounts paid for elementary and secondary school tuition, book fees, lab fees (Not College)"]
[null,"Student Name",null,"Grade","School Name",null,null,"School City",null,"Total fees"]
[]
[]
[]
["Additional Info:"]
[]
["Connecticut",null,null,null,null,null,null,null,null,null,null,"TOP"]
[null,"Credit for Taxes Paid on your Principal Residence and/or Motor Vehicle:"]
[null,"Town or District",null,"Description of Property(Make, Model)",null,null,null,"Date Paid",null,"Amount Paid"]
[1]
[2]
["Additional Info:"," "]
[]
[]
["Massachusetts",null,null,null,null,null,null,null,null,null,null,"TOP"]
[null,"Amount of rent paid on your Principal Residence during the tax year"]
[null,"Total interest paid on undergraduate education debt"]
[null,"Total college tuition paid (less any scholarships, grants, or financial aid received)"]
[null,"Health Insurance Company Name (or send 1099-HC)",null,null,null,null,"Taxpayer",null,null,"Spouse"]
[null,null,"Federal ID Number of Insurance Company"]
[null,null,"Subscriber Number"]
[null,"Amount Paid through Toll through FastLane "]
[null,"Amount Paid for weekly or Monthly Transit Commuter Pass"]
["Additional Info:"," "]
[]
[]
["New Jersey",null,null,null,null,null,null,null,null,null,null,"TOP"]
[null,"Number of dependents who are attending college"]
[null,"If you did not own your home in New Jersey, how much rent did you pay in New Jersey?"]
[null,"How many days did you rent while living in New Jersey?"]
[null,"Amount of rent paid on your Principal Residence during the tax year"]
[null,"Do you have Non-reimbursed Medical Expense?  If so How Much?"]
["Additional Info:"," ",null,null,null,null,null,null,null,null,null,null,null," "]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null," "]
["Wisconsin",null,null,null,null,null,null,null,null,null,null,"TOP"]
[null,"Name of City, Village or Town of Resident"]
[null,"County of"]
[null,"Name or Number of your school district"]
[null,"Rent Paid in tax year - heat included"]
[null,"Rent Paid in tax year - heat not  included"]
[null,"Property Tax Paid in home during tax year for resident in WI"]
["Additional Info:"," "]
[]
[]
["California",null,null,null,null,null,null,null,null,null,null,"TOP"]
[null,"Did you purchase items while a California resident, but pay NO sales tax because you purchased them outside the county where you live, or through the internet, a catalog, or in another state?"]
[null,"If you answered \"Yes\" to the above question, please provide the following details:"]
[null," "," • The total amount of the purchases you made"]
[null,"Did you purchase items while a California resident, but pay a LOWER rate or amount of sales tax because you purchased them outside the county where you live, or through the internet, a catalog, or in another state?"]
[null,"If you answered \"Yes\" to the above question, please provide the following details:"]
[null," ","• The total amount of the purchases you made"]
[null," ","• County and State where items were purchased"]
[null," ","• Amount of sales taxes paid"]
["Additional Info:"," "]
[]
[]
[]
[]
["New York",null,null,null,null,null,null,null,null,null,null,"TOP"]
[null,"Dates you lived in New York:",null,null," ",null,"to"]
[null,"Dates your spouse lived in NY",null,null," ",null,"to"]
[null,"Dates you lived in New York City:",null,null," ",null,"to"]
[null,"Dates your spouse lived in NYC",null,null," ",null,"to"]
[null,"Dates you lived in Yonkers:",null,null," ",null,"to"]
[null,"Dates your spouse lived in Yonkers",null,null," ",null,"to"]
["Other State","Dates you lived in Other State:",null,null," ",null,"to",null,null,"<-- Only for Part Year Residnet"]
[null,"Dates your spouse lived in Other State ",null,null," ",null,"to"]
[null,"County you lived in "]
[null,"Name of your school district"]
[null,"Did you purchase items while a New York resident, but pay NO sales tax because you purchased them outside the county where you live, or through the internet, a catalog, or in another state?"]
[null,"If you answered \"Yes\" to the above question, please provide the following details:"]
[null,"•  The total of purchases you made of individual items that each cost under $1,000"]
[null,"• The total of purchases you made of individual items that each cost at least $1,000"]
[null,"Did you purchase items while a New York resident, but pay a LOWER rate or amount of sales tax because you purchased them outside the county where you live, or through the internet, a catalog, or in another state?"]
[null,"If you answered \"Yes\" to the above question, please provide the following details:"]
[null,"• The total of purchases you made of individual items that each cost under $1,000"]
[null,"• County and State where items where purchased "]
[null,"• Amount of sales taxes paid"]
[null,"• The total of purchases you made of individual items that each cost at least $1,000"]
[null,"• County and State where items where purchased "]
[null,"• Amount of sales taxes paid"]
["Additional Info:"," "]
[]
[]
["Michigan",null,null,null,null,null,null,null,null,null,null,"TOP"]
[null,"School District"]
[null,"Did you purchase items while a Michigan resident, but pay NO sales tax because you purchased them outside the county where you live, or through the internet, a catalog, or in another state?"]
[null,"•  If you answered \"Yes\" to the above question, enter the total of purchases you made of individual items that each cost under $1,000"]
[null,"• If you answered \"Yes\" to the above question, enter the total of purchases you ade of individual items that each cost at least $1,000"]
[null,"Taxable value of your Michigan homestead"]
[null,"The amount of property taxes levied in Michigan on your homestead"]
[null,"Did you repeal on your Michigan homestead status with regard to your Michigan property tax assessments?"]
[null,null,"• If \"Yes\", what date was your homestead status repealed?",null,null,null,null,null,null,null,null,null," "]
[null,"If you did not own your home in Michigan, how much rent did you pay in Michigan?"]
[null,"How many months did you rent while living in Michigan?"]
[null,"What is the address of the property you rented in Michigan?"]
[null,"What is your landlord's name? "]
[null,"What is your landlord's address?"]
[null,"How much of your State sponsored college savings plan contributions were to the Michigan Education Savings Program?"]
[null,"How much of your State sponsored college savings plan contributions were to the Michigan Education Trust"]
[null,"Enter the amount of your contributions to:"]
[null,"a) Michigan colleges, universities, public libraries, public broadcasting stations, art institutes or affiliates"]
[null,"b) Endowment fund of a community foundation"]
[null,"c) Homeless shelters or food bank"]
[null,"d) National or Michigan political party or candidate"]
[null,"Amount paid for community college tuition if a Michigan resident"]
[null,null,"Name of school"]
[null,"Amount withdrawn from an IRA for tuition, books, fees at a post-secondary educational institution"]
["Additional Info:"," "]
[]
[]
["Indiana",null,null,null,null,null,null,null,null,null,null,"TOP"]
[null,"County where you lived ",null,null,null,null,"County where you worked"]
[null,"County where your spouse (if married) lived",null,null,null,null,null,"County where your spouse worked"]
[null,"Name of your school district"]
[null,"Amount of real-estate taxes paid on property you own in Indiana"]
[null,"If you did not own your home in Indiana, how much rent did you pay in Indiana?"]
[null,"How many months did you rent while living in Indiana?"]
[null,"What is the address of the property you rented in Indiana?"]
[null,"What is your landlord's name? "]
[null,"What is your landlord's address?"]
[null,"Did you purchase items while an Indiana resident, but pay NO sales tax because you purchased them outside the county where you live, or through the internet, a catalog, or in another state?"]
[null,"If you answered \"Yes\" to the above question, please provide the following details:"]
[null,null,"• The total amount of the purchases you made"]
[null,"Did you purchase items while an Indiana resident, but pay a LOWER rate or amount of sales tax because you purchased them outside the county where you live, or through the internet, a catalog, or in another state?"]
[null,"If you answered \"Yes\" to the above question, please provide the following details:"]
[null," ","• The total amount of the purchases you made"]
[null," ","• County and State where items where purchased "]
[null," ","• Amount of sales taxes paid"]
["Additional Info:"," "]
[]
[]
[]
[]
[]
["Ohio",null,null,null,null,null,null,null,null,null,null,"TOP"]
[null,"County where you lived"]
[null,"Name of your school district"]
[null,"Did you purchase items while an Ohio resident, but pay NO sales tax because you purchased them outside the county where you live, or through the internet, a catalog, or in another state?"]
[null,"If you answered \"Yes\" to the above question, please provide the following details:"]
[null,null,"• The total amount of the purchases you made"]
[null,"Amount of tuition you paid during the year to an Ohio college/university (must be for the first 2 years only of college/university study)"]
["Additional Info:"]
[]
[null,null,null,null," "]
["North Carolina",null,null,null,null,null,null,null,null,null,null,"TOP"]
[null,"Did you purchase items while a North Carolina resident, but pay NO sales tax because you purchased them outside the county where you live, or through the internet, a catalog, or in another state?"]
[null,"• If you answered \"Yes\" to the above question, please enter the total amount of out-of-state purchases, including shipping and handling (you may estimate the amount if you do not have records)"]
[null,"• If you answered \"Yes\" to the above question, did you pay use tax on these purchases to another state?"]
[null,null,"•    If so, please enter the amount of tax paid"]
["Additional Info:"," "]
[]
[]
["Minnesota",null,null,null,null,null,null,null,null,null,null,"TOP"]
[null,"Kindergarten - Grade 12 Education Credit"]
[null,null,null,null,null,null,null,null,"1st Child",null,"2nd Child"]
[null,"Qualifying Child's Name"]
[null,"Grade(s) for which expenses incurred"]
[null,"Fees and tuition for enrichment classes taken outside the regular school day  or year for children in Kindergarten to 12th Grade (exclude private school  tuition)"]
[]
[null,"Name of organization and type of class:"]
[null,"Fees for individual instruction by a qualified person taught outside the regular"]
[null," school day or school year, such as tutoring or music lessons."]
[null,"Name of organization and type of class:"]
[null,"Required school expenses (textbooks, paper, notebooks, etc)"]
[null,"  - you must have receipts"]
[null,"Transportation costs paid to others for the regular school day"]
[null,"Computer hardware and software (not to exceed $200)"]
["Additional Info:"," "]
[]
[]
[]
[]
["ALABAMA",null,null,null,null,null,null,null,null,null,null,"TOP"]
[null,"Provide Taxpayer Driver License"]
[null,"Provide Spouse Driver License"]
["Additional Info:"]

{"sheet":"Misc","index":5,"n_rows":16,"n_cols":16,"rows_kept":16,"cut":false,"hidden":false,"merged":[[6,1,6,12],[6,15,6,16],[2,1,2,16],[3,1,3,12],[3,15,3,16],[5,1,5,12],[5,15,5,16],[8,1,8,12],[8,15,8,16],[9,1,9,12],[9,15,9,16],[10,1,10,12],[10,15,10,16],[1,1,1,16],[12,1,12,12],[12,15,12,16],[16,1,19,16],[13,1,13,12],[13,15,13,16],[14,1,14,12],[14,15,14,16],[15,1,15,12],[15,15,15,16],[4,1,4,12],[4,15,4,16],[11,1,11,12],[11,15,11,16],[7,1,7,12],[7,15,7,16]]}
[]
[null,"Double-click on cell (YES/NO) to make selection OR Right-Click to Clear"]
[null,"Miscellaneous Questions"]
[null,"Complete the following questions, If your answer to any question below is YES, enclose supporting documentation.",null,null,null,null,null,null,null,null,null,null,null,"NO","YES","Comments"]
[1,"Do you (and your spouse) have a social security number that allows you to work and is valid?"]
[{"$f":"A5+1","v":2},"Have you received any notice or correspondence from the IRS or state agency in the past 3 tax year?"]
[{"$f":"A6+1","v":3},"Did you pay a household employee cash wages of $1900 or more during tax year? If yes to #3, were total cash wages of $1,000 or more paid in a calendar quarter to the Household Employee?"]
[4,"Did you sell your home during tax year?"]
[5,"Did you receive any unreported tip income during tax year?"]
[6,"Do you have any children age 18 or under (or student under age 24) who had investment income for more than $2000?"]
[7,"If any of your children are required to file a return, do you elect to report your child's interest and dividends on your return?"]
[8,"If any of your children are required to file a return, do you elect to report your child's interest and dividends on your return?"]
[9,"Did you pay any expenses related to the adoption of an eligible child?"]
[10,"Are you currently repaying the First-Time Homebuyer Credit? If yes, provide details below."]
[11,"Did you qualify for Energy saving credit?  (By making modification to your Home with energy efficient material/equipments?)"]
[12,"Were you issued a Mortgage Credit Certificate (MCC) by a state or local governmental unit or agency?."]

{"sheet":"Foreign Assets","index":6,"n_rows":86,"n_cols":14,"rows_kept":86,"cut":false,"hidden":true,"merged":[[61,0,62,0],[66,0,66,2],[32,0,32,4],[33,0,33,2],[57,0,59,0],[57,1,59,1]]}
["TAX FORM REPORTING (We will Include it as a part of yoru US Tax filing)",null,null,null,null,null,"FBAR REPORTING (You MUST Complete yourself)"]
["If you earned any Interest from Foreing Bank accounts, you MUST declare on your US Tax return.",null,null,null,null,null,"You must file a form with Department of Treasury "]
["If you have paid any TDS - Tax Deducted at Source to Foreign country you may entitle to claim Foreign Tax credit.",null,null,null,null,null,"You can try attached link and see if you can E-file the FBAR form http://bsaefiling.fincen.treas.gov/main.html"]
[null,null,null,null,null,null,"http://bsaefiling.fincen.treas.gov/main.html  - Using Login"]
[{"$f":"Personal!A9","v":2024},null,null,null,null,null,"If it does not work, You can PAPER file the FinCEN form 114-http://bsaefiling.fincen.treas.gov/NoRegFBARFiler.html"]
[]
[null,null,"INR",73.94]
[null,"USD",{"$f":"IF(C13=\"\",\"\",C13/$D$7)","v":""},{"$f":"IF(D13=\"\",\"\",D13/$D$7)","v":""},{"$f":"IF(E13=\"\",\"\",E13/$D$7)","v":""},"","","","","","","","",""]
[null,"Foreign Asset"]
[null,"Description",1,{"$f":"C10+1","v":2},{"$f":"D10+1","v":3},4,5,6,7,8,9,10,11,12]
[1,"Type of Account"]
[2,"Account Number"]
[4,"Maximum Value of Account during Tax Year in Foreign Currency"]
[null,"Foreign Currency"]
[null,"Name of Financial Instituion"]
[null,"Mailing Address"]
[null,"City"]
[null,"State"]
[null,"Zip"]
[null,"Country"]
["3a","Account Open During the Tax year"]
["3b","Account Closed During the Tax year"]
["3c","Account Jointly Owned with Spouse"]
["3d","No Tax item Reported"]
[]
[null,"Bank Interest/Dividend earned during Tax Year"]
[null,"Description",1,{"$f":"C27+1","v":2},{"$f":"D27+1","v":3},4,5,6,7,8,9,10,11,12]
[null,"Bank Name"]
[null,"Currency"]
[null,"Amount Earned"]
[]
[]
["For more info, please visit: http://www.irs.gov/Businesses/Small-Businesses-&-Self-Employed/Report-of-Foreign-Bank-and-Financial-Accounts-FBAR"]
["http://www.irs.gov/Businesses/Corporations/Frequently-Asked-Questions-FAQs-FATCA--Compliance-Legal"]
["http://www.iba.org.in/Documents/FATCA00020_062014.pdf"]
[]
[{"$f":"CONCATENATE(\"DEADLINE APRIL 15 (not June 30) \",Personal!A47+1,\" for \",Personal!A47,\" Calender Year.\")","v":"DEADLINE APRIL 15 (not June 30) 1 for  Calender Year."}]
["The Statue of Limitation is for Past 6 Years"]
["You must File FBAR form, if any account exceed $10000 or more at anytime during Calender year"]
[]
["TAX FORM REPORTING (We will Include it as a part of yoru US Tax filing)"]
["If you earned any Interest from Foreing Bank accounts, you MUST declare on your US Tax return."]
["If you have paid any TDS - Tax Deducted at Source to Foreign country you may entitle to claim Foreign Tax credit."]
[]
["FBAR REPORTING (You MUST Complete yourself)"]
["You must file a form with Department of Treasury "]
["You can try attached link and see if you can E-file the FBAR form http://bsaefiling.fincen.treas.gov/main.html"]
[]
["http://bsaefiling.fincen.treas.gov/main.html  - Using Login"]
[]
["If it does not work, You can PAPER file the FinCEN form 114-http://bsaefiling.fincen.treas.gov/NoRegFBARFiler.html"]
[]
[]
["  ","Form 8938, Statement of Specified Foreign Financial Assets","FinCEN Form 114, Report of Foreign Bank and Financial Accounts (FBAR)"]
["Who Must File?","Specified individuals, which include U.S citizens, resident aliens, and certain non-resident aliens that have an interest in specified foreign financial assets and meet the reporting threshold","U.S. persons, which include U.S. citizens, resident aliens, trusts, estates, and domestic entities that have an interest in foreign financial accounts and meet the reporting threshold"]
["Does the United States include U.S. territories?","No","Yes, resident aliens of U.S territories and U.S. territory entities are subject to FBAR reporting"]
["Reporting Threshold (Total Value of Assets)","$50,000 on the last day of the tax year or $75,000 at any time during the tax year (higher threshold amounts apply to married individuals filing jointly and individuals living abroad)","$10,000 at any time during the calendar year"]
["When do you have an interest in an account or asset?","If any income, gains, losses, deductions, credits, gross proceeds, or distributions from holding or disposing of the account or asset are or would be required to be reported, included, or otherwise reflected on your income tax return","Financial interest: you are the owner of record or holder of legal title; the owner of record or holder of legal title is your agent or representative; you have a sufficient interest in the entity that is the owner of record or holder of legal title."]
[null,null,"Signature authority: you have authority to control the disposition of the assets in the account by direct communication with the financial institution maintaining the account."]
[null,null,"See instructions for further details."]
["What is Reported?","Maximum value of specified foreign financial assets, which include financial accounts with foreign financial institutions and certain other foreign non-account investment assets","Maximum value of financial accounts maintained by a financial institution physically located in a foreign country"]
["How are maximum account or asset values determined and reported?","Fair market value in U.S. dollars in accord with the Form 8938 instructions for each account and asset reported","Use periodic account statements to determine the maximum value in the currency of the account."]
[null,"Convert to U.S. dollars using the end of the taxable year exchange rate and report in U.S. dollars.","Convert to U.S. dollars using the end of the calendar year exchange rate and report in U.S. dollars."]
["When Due?","By due date, including extension, if any, for income tax return","Received by June 30 (no extensions of time granted)"]
["Where to File?","File with income tax return pursuant to instructions for filing the return","File electronically through FinCENs  BSA E-Filing System. The FBAR is not filed with a federal tax return."]
["Penalties","Up to $10,000 for failure to disclose and an additional $10,000 for each 30 days of non-filing after IRS notice of a failure to disclose, for a potential maximum penalty of $60,000; criminal penalties may also apply","If non-willful, up to $10,000; if willful, up to the greater of $100,000 or 50 percent of account balances; criminal penalties may also apply"]
["Types of Foreign Assets and Whether They are Reportable"]
["Financial (deposit and custodial) accounts held at foreign financial institutions","Yes","Yes"]
["Financial account held at a foreign branch of a U.S. financial institution","No","Yes"]
["Financial account held at a U.S. branch of a foreign financial institution","No","No"]
["Foreign financial account for which you have signature authority","No, unless you otherwise have an interest in the account as described above","Yes, subject to exceptions"]
["Foreign stock or securities held in a financial account at a foreign financial institution","The account itself is subject to reporting, but the contents of the account do not have to be separately reported","The account itself is subject to reporting, but the contents of the account do not have to be separately reported"]
["Foreign stock or securities not held in a financial account","Yes","No"]
["Foreign partnership interests","Yes","No"]
["Indirect interests in foreign financial assets through an entity","No","Yes, if sufficient ownership or beneficial interest (i.e., a greater than 50 percent interest) in the entity. See instructions for further detail."]
["Foreign mutual funds","Yes","Yes"]
["Domestic mutual fund investing in foreign stocks and securities","No","No"]
["Foreign accounts and foreign non-account investment assets held by foreign or domestic grantor trust for which you are the grantor","Yes, as to both foreign accounts and foreign non-account investment assets","Yes, as to foreign accounts"]
["Foreign-issued life insurance or annuity contract with a cash-value","Yes","Yes"]
["Foreign hedge funds and foreign private equity funds","Yes","No"]
["Foreign real estate held directly","No","No"]
["Foreign real estate held through a foreign entity","No, but the foreign entity itself is a specified foreign financial asset and its maximum value includes the value of the real estate","No"]
["Foreign currency held directly","No","No"]
["Precious Metals held directly","No","No"]
["Personal property, held directly, such as art, antiques, jewelry, cars and other collectibles","No","No"]
["‘Social Security’- type program benefits provided by a foreign government","No","No"]

{"sheet":"Additional Info","index":7,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Applicant-1","index":8,"n_rows":304,"n_cols":13,"rows_kept":304,"cut":false,"hidden":true,"merged":[[10,12,14,12],[17,12,19,12],[21,12,27,12],[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],[22,0,22,3],[22,5,22,7],[15,1,15,3],[15,7,15,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],[6,4,6,8],[7,0,8,9],[9,0,9,9],[10,0,10,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],[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],[32,0,32,1],[32,2,32,6],[32,7,32,9],[25,0,26,1],[25,2,25,5],[25,7,25,9],[26,2,26,5],[26,7,26,9],[27,0,27,1],[27,2,27,3],[27,4,27,9],[28,0,28,2],[28,3,28,5],[28,6,29,8],[30,6,30,8],[31,0,31,9],[60,0,62,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],[39,0,44,9],[45,0,49,9],[51,0,54,9],[56,0,59,9],[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]]}
["PAL ASSOCIATES INC."]
["TAX & ACCOUNTING SERVICES"]
["956 W. Bailey Road, Naperville, IL 60565"]
["Ph: 630-778-7442, Cell: 630-631-1248, E-Fax: 630-463-5278"]
["http://www.yourtaxpal.com ",null,null,null,null," E-mail: CPA@yourtaxpal.com"]
["Committed to Quality & Confidentiality sm"]
[null,null,null,{"$f":"Personal!A9","v":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"]
[{"$f":"IF(Personal!B11=\"\",\"\",Personal!B11)","v":""},null,null,null,{"$f":"IF(Personal!D11=\"\",\"\",Personal!D11)","v":""},{"$f":"IF(Personal!E11=\"\",\"\",Personal!E11)","v":""},null,null,{"$f":"IF(Personal!F11=\"\",\"\",Personal!F11)","v":""}]
["Applicant is your (Select -1)",null,null,null,"Spouse",null,"Child",null,"Parent"]
["Home Address",null,{"$f":"IF(Personal!B13=\"\",\"\",Personal!B13)","v":""},null,null,null,null,null,"APT #",{"$f":"IF(Personal!L13=\"\",\"\",Personal!L13)","v":""}]
["City",{"$f":"IF(Personal!B14=\"\",\"\",Personal!B14)","v":""},null,null,"State",{"$f":"IF(Personal!F14=\"\",\"\",Personal!F14)","v":""},"Zip",{"$f":"IF(Personal!L14=\"\",\"\",Personal!L14)","v":""},null,null,null,null,"Check for Service Available"]
["Foreign Address, if different from Above",null,null,null,null,"Phone Number",null,{"$f":"IF(Personal!L11=\"\",\"\",Personal!L11)","v":""}]
["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":9,"n_rows":321,"n_cols":10,"rows_kept":321,"cut":false,"hidden":true,"merged":[[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],[6,4,6,8],[7,0,8,9],[9,0,9,9],[10,0,10,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],[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],[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],[32,0,32,1],[32,2,32,6],[32,7,32,9],[25,0,26,1],[25,2,25,5],[25,7,25,9],[26,2,26,5],[26,7,26,9],[27,0,27,1],[27,2,27,3],[27,4,27,9],[28,0,28,2],[28,3,28,5],[28,6,29,8],[30,6,30,8],[31,0,31,9],[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],[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":"'[2]Applicant-1'!A1:J1","v":"PAL ASSOCIATES INC."}]
[{"$f":"'[2]Applicant-1'!A2:J2","v":"TAX & ACCOUNTING SERVICES"}]
[{"$f":"'[2]Applicant-1'!A3:J3","v":"956 W. Bailey Road, Naperville, IL 60565"}]
[{"$f":"'[2]Applicant-1'!A4:J4","v":"Ph: 630-778-7442, Cell: 630-631-1248, E-Fax: 630-463-5278"}]
["http://www.yourtaxpal.com ",null,null,null,null," E-mail: CPA@yourtaxpal.com"]
[{"$f":"'[2]Applicant-1'!A6:J6","v":"Committed to Quality & Confidentiality sm"}]
[null,null,null,{"$f":"Personal!A9","v":2024},"ITIN Application Input Form"]
[{"$f":"'[2]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":"'[2]Applicant-1'!A9:J9","v":0}]
["Please fill out ALL area highlighetd in Light Grey"]
[{"$f":"'[2]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":""},null,null,null,{"$f":"'Applicant-1'!E13","v":""},{"$f":"'Applicant-1'!F13:H13","v":""},null,null,{"$f":"'Applicant-1'!I13:J13","v":""}]
["Applicant is your (Select -1)",null,null,null,"Spouse",null,"Child",null,"Parent"]
["Home Address",null,{"$f":"'Applicant-1'!C15:H15","v":""},null,null,null,null,null,"APT #",{"$f":"'Applicant-1'!J15","v":""}]
["City",{"$f":"'Applicant-1'!B16:D16","v":""},null,null,"State",{"$f":"'Applicant-1'!F16","v":""},"Zip",{"$f":"'Applicant-1'!H16:J16","v":""}]
["Foreign Address, if different from Above",null,null,null,null,"Phone Number",null,{"$f":"'Applicant-1'!H17:J17","v":""}]
["Home Address"]
["City",null,null,null,"State",null,"PIN",null,"Country"]
[]
["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:       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_"},null,null,null,"h14 check",null,"A, F13"]
["><f1_39_0_"]
[{"$f":"CONCATENATE(\">\",UPPER(H17),\"</f1_39_0_\")","v":"></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":10,"n_rows":321,"n_cols":10,"rows_kept":321,"cut":false,"hidden":true,"merged":[[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],[6,4,6,8],[7,0,8,9],[9,0,9,9],[10,0,10,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],[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],[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],[32,0,32,1],[32,2,32,6],[32,7,32,9],[25,0,26,1],[25,2,25,5],[25,7,25,9],[26,2,26,5],[26,7,26,9],[27,0,27,1],[27,2,27,3],[27,4,27,9],[28,0,28,2],[28,3,28,5],[28,6,29,8],[30,6,30,8],[31,0,31,9],[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],[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":"'[2]Applicant-1'!A1:J1","v":"PAL ASSOCIATES INC."}]
[{"$f":"'[2]Applicant-1'!A2:J2","v":"TAX & ACCOUNTING SERVICES"}]
[{"$f":"'[2]Applicant-1'!A3:J3","v":"956 W. Bailey Road, Naperville, IL 60565"}]
[{"$f":"'[2]Applicant-1'!A4:J4","v":"Ph: 630-778-7442, Cell: 630-631-1248, E-Fax: 630-463-5278"}]
["http://www.yourtaxpal.com ",null,null,null,null," E-mail: CPA@yourtaxpal.com"]
[{"$f":"'[2]Applicant-1'!A6:J6","v":"Committed to Quality & Confidentiality sm"}]
[null,null,null,{"$f":"Personal!A9","v":2024},"ITIN Application Input Form"]
[{"$f":"'[2]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":"'[2]Applicant-1'!A9:J9","v":0}]
["Please fill out ALL area highlighetd in Light Grey"]
[{"$f":"'[2]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":""},null,null,null,{"$f":"'Applicant-1'!E13","v":""},{"$f":"'Applicant-1'!F13:H13","v":""},null,null,{"$f":"'Applicant-1'!I13:J13","v":""}]
["Applicant is your (Select -1)",null,null,null,"Spouse",null,"Child",null,"Parent"]
["Home Address",null,{"$f":"'Applicant-1'!C15:H15","v":""},null,null,null,null,null,"APT #",{"$f":"'Applicant-1'!J15","v":""}]
["City",{"$f":"'Applicant-1'!B16:D16","v":""},null,null,"State",{"$f":"'Applicant-1'!F16","v":""},"Zip",{"$f":"'Applicant-1'!H16:J16","v":""}]
["Foreign Address, if different from Above",null,null,null,null,"Phone Number",null,{"$f":"'Applicant-1'!H17:J17","v":""}]
["Home Address"]
["City",null,null,null,"State",null,"PIN",null,"Country"]
[]
["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":"Personal!A9","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_"},null,null,null,"h14 check",null,"A, F13"]
["><f1_39_0_"]
[{"$f":"CONCATENATE(\">\",UPPER(H17),\"</f1_39_0_\")","v":"></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":"F1-VISA_Only","index":11,"n_rows":35,"n_cols":3,"rows_kept":35,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Since you are on F1 VISA, can you please provide additional information?"]
[null,"      Have you filed US Tax return in past (Y/N)?"]
[null,"      If Yes Which Form was filed (1040, 1040-NR etc)"]
[null,{"$f":"CONCATENATE(\"      Tax Year \",B14,\", \",B15,\" etc. tax return filed\")","v":"      Tax Year 2023, 2022 etc. tax return filed"}]
[null,"General Information","Response"]
[null,"1a Type of U.S. visa (for example, F, J, M, Q, etc.) and date you entered the United States"]
[null,"b Current nonimmigrant status and date of change (see instructions)"]
[null,"2 Of what country were you a citizen during the tax year?"]
[null,"3a What country issued you a passport?"]
[null,"       Enter your passport number"]
[null,"4a Enter the actual number of days you were present in the United States during: (on F1 VISA)"]
[null,{"$f":"Personal!A9","v":2024},{"$f":"Personal!J32","v":0}]
[null,{"$f":"B13-1","v":2023},{"$f":"Personal!L32","v":0}]
[null,{"$f":"B14-1","v":2022},{"$f":"Personal!M32","v":0}]
[]
[null,"9 Enter the name, address, and telephone number of the academic institution you attended during 2016"]
[]
[null,"11 Enter the type of U.S. visa (F, J, M, or Q) you held during: "]
[]
[null,{"$f":"B22-1","v":2019}]
[null,2020]
[null,2021]
[null,2022]
[null,{"$f":"B26-1","v":2023}]
[null,{"$f":"Personal!A9","v":2024}]
[]
[null,"If the type of visa you held during any"]
[null,"of these years changed, attach a statement showing the new visa type and the date it was acquired."]
[]
[null,"12 Were you present in the United States as a teacher, trainee, or student for any part of more than 5 calendar"]
[null,"years? Yes No"]
[]
[null,{"$f":"CONCATENATE(\"13 During \",B13,\", did you apply for, or take other affirmative steps to apply for, lawful permanent resident status\")","v":"13 During 2024, did you apply for, or take other affirmative steps to apply for, lawful permanent resident status"}]
[null,"in the United States or have an application pending to change your status to that of a lawful permenant Resident of the United States."]