{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Instructions","Report information","Individual accounts","Organisation accounts","Generate report","Lookups"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":22,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":19,"n_cols":2,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Foreign Account Tax Compliance Act (FATCA)\nATO Small Reporter Tool v1.08"]
[null,"The Small Reporter Tool has been designed by the ATO to provide a solution for small Financial Institutions with less than 50 Reportable Accounts. The tool will produce a FATCA report in the required xml format. This tool also allows you to advise the ATO that you have no Reportable Accounts i.e. ‘nil reporting’."]
[null,"Instructions for use"]
[null,"Please refer to the Small Reporter Tool User Guide before using this spreadsheet.  "]
[null,"This tool contains tabs at the bottom of the workbook. The Report information tab is mandatory. Use the Individual accounts tab for Reportable Accounts held by one or more individuals (if any) and the Organisation accounts tab for Reportable Accounts held by one or more non-individuals (if any). Cell information with a * denotes a mandatory field. When all Reportable Accounts have been recorded, use the Generate report tab."]
[null,"How to lodge"]
[null,"You can lodge your FATCA report online through:"]
[null,"·          Online services for business"]
[null,"·          Online services for agents"]
[]
[null,"  For other information regarding the FATCA you can refer to:"]
[null,"·         Foreign Account Tax Compliance Act reporting"]
[null,"·         The Automatic Exchange of Information Guidance"]
[null,"·         FATCA XML Schema guide v2.0"]
[]
[null,"More Information"]
[null,"If you have any further questions regarding FATCA please contact the FATCA Project Team."]

{"sheet":"Report information","index":1,"n_rows":57,"n_cols":3,"rows_kept":57,"cut":false,"hidden":false,"merged":[[53,0,56,0],[25,0,41,0],[42,0,52,0],[1,4,35,10],[1,1,1,2],[8,1,8,2],[14,0,24,0],[35,1,35,2],[1,0,13,0],[30,1,30,2]]}
[]
[null,"Report information"]
[null,"Sending company Id number*"]
[null,"Warning"]
[null,"Contact*"]
[null,"Corrected message identifier"]
[null,"Reporting period end date*"]
[null,"Message reference",""]
[null,"Reporting financial institution"]
[null,"Name*"]
[null,"Name type"]
[null,"Country of residence*"]
[null,"Tax identification number (GIIN)"]
[null,"Tax identification number (ABN)"]
["Address","Type"]
[null,"Country*"]
[null,"Country subentity (state or territory)"]
[null,"Street*"]
[null,"District"]
[null,"Building identifier"]
[null,"Suite identifier"]
[null,"Floor identifier"]
[null,"Post office box"]
[null,"Post code*"]
[null,"City*"]
[null,"Filer category"]
[null,"Document type*"]
[null,"Document reference"]
[null,"Corrected message identifier"]
[null,"Corrected document reference identifier"]
[null,"Nil report"]
[null,"Nil report*"]
[null,"Document reference"]
[null,"Corrected message identifier"]
[null,"Corrected document reference identifier"]
[null,"Sponsor/Intermediary"]
[null,"Type"]
[null,"Name"]
[null,"Name type"]
[null,"Country of residence"]
[null,"Tax identification number (GIIN or TIN)"]
[null,"Tax identification number (ABN)"]
["Address","Type"]
[null,"Country"]
[null,"Country subentity (state or territory)"]
[null,"Street"]
[null,"District"]
[null,"Building identifier"]
[null,"Suite identifier"]
[null,"Floor identifier"]
[null,"Post office box"]
[null,"Post code"]
[null,"City"]
[null,"Filer category"]
[null,"Document reference"]
[null,"Corrected message identifier"]
[null,"Corrected document reference identifier"]

{"sheet":"Individual accounts","index":2,"n_rows":2,"n_cols":43,"rows_kept":2,"cut":false,"hidden":false,"merged":[[0,40,0,42],[0,11,0,13],[0,0,0,2],[0,14,0,24],[0,30,0,31],[0,32,0,39],[0,25,0,29],[0,3,0,10]]}
["Account details",null,null,"Name",null,null,null,null,null,null,null,"Account holder details",null,null,"Address",null,null,null,null,null,null,null,null,null,null,"Birth details",null,null,null,null,"Account balance",null,"Payment details",null,null,null,null,null,null,null,"Report details"]
["Account number*","Account number type","Closed","Name type","Title","First name*","Middle name","Last name*","Generation identifier","Suffix","General suffix","Country of residence","Tax identification number","Country of issue","Type","Country*","Country Subentity","Street*","Building identifier","Suite identifier","Floor identifier","District name","Post office box","Post code*","City*","Date","City","City subentity","Country","Former country name","Account balance*","Currency*","Dividend","Currency","Interest","Currency","Gross proceeds","Currency","Other payment","Currency","Document reference","Corrected message identifier","Corrected document reference identifier"]

{"sheet":"Organisation accounts","index":3,"n_rows":3,"n_cols":60,"rows_kept":3,"cut":false,"hidden":false,"merged":[[1,57,1,59],[0,20,0,46],[1,28,1,30],[1,47,1,48],[1,31,1,41],[1,49,1,56],[1,20,1,27],[1,42,1,46],[0,47,0,59],[1,0,1,3],[0,4,0,19],[1,4,1,5],[1,6,1,8],[1,9,1,19],[0,0,0,3]]}
[null,null,null,null,"Organisation details",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Substantial owner (Controlling person)"]
["Account details",null,null,null,"Name",null,"Account holder details",null,null,"Address",null,null,null,null,null,null,null,null,null,null,"Name",null,null,null,null,null,null,null,"Substantial owner details",null,null,"Address",null,null,null,null,null,null,null,null,null,null,"Birth details",null,null,null,null,"Account balance",null,"Payment details",null,null,null,null,null,null,null,"Report details"]
["Account number*","Account number type","Closed","Account holder type*","Name type","Name*","Country of residence","Tax identification number","Country of issue","Type","Country*","Country Subentity","Street*","Building identifier","Suite identifier","Floor identifier","District name","Post office box","Post code*","City*","Name type","Title","First name","Middle name","Last name","Generation identifier","Suffix","General suffix","Country of residence","Tax identification number","Country of issue","Type","Country","Country Subentity","Street","Building identifier","Suite identifier","Floor identifier","District name","Post office box","Post code","City","Date","City","City subentity","Country","Former country name","Account balance*","Currency*","Dividend","Currency","Interest","Currency","Gross proceeds","Currency","Other payment","Currency","Document reference","Corrected message identifier","Corrected document reference identifier"]

{"sheet":"Generate report","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Lookups","index":5,"n_rows":251,"n_cols":11,"rows_kept":251,"cut":false,"hidden":true,"merged":[]}
["Countries",null,null,"CRS Message types",null,null,"Document types",null,null,"Account types"]
["Country","Code",null,"CRS701 - New information",null,null,"FATCA1 - New data","FATCA1",null,"OECD601 - International back account number","OECD601"]
["Afghanistan","AF",null,"CRS702 - Correction",null,null,"FATCA2 - Corrected data","FATCA2",null,"OECD602 - Other bank account number","OECD602"]
["Åland Islands","AX",null,"CRS703 - No data to report",null,null,"FATCA3 - Void data","FATCA3",null,"OECD603 - International securities information number","OECD603"]
["Albania","AL",null,null,null,null,"FATCA4 - Amended data","FATCA4",null,"OECD604 - Other securities information number","OECD604"]
["Algeria","DZ",null,null,null,null,null,null,null,"OECD605 - Other","OECD605"]
["American Samoa","AS"]
["Andorra","AD",null,"Boolean","Currencies"]
["Angola","AO",null,"true","AED",null,"Address types"]
["Anguilla","AI",null,"false","AFN",null,"OECD301","OECD301 - Residential or business"]
["Antarctica","AQ",null,null,"ALL",null,"OECD302","OECD302 - Residential",null,"Controlling person types"]
["Antigua and Barbuda","AG",null,"Nil report options","AMD",null,"OECD303","OECD303 - Business",null,"CRS801 - legal person – ownership"]
["Argentina","AR",null,"This is a nil report","ANG",null,"OECD304","OECD304 - Registered office",null,"CRS802 - legal person – other means"]
["Armenia","AM",null,"This is not a nil report","AOA",null,"OECD305","OECD305 - Unspecified",null,"CRS803 - legal person – senior managing official"]
["Aruba","AW",null,null,"ARS",null,null,null,null,"CRS804 - legal arrangement – trust – settlor"]
["Australia","AU",null,null,"AUD",null,null,null,null,"CRS805 - legal arrangement – trust – trustee"]
["Austria","AT",null,null,"AWG",null,"Name types",null,null,"CRS806 - legal arrangement – trust – protector"]
["Azerbaijan","AZ",null,null,"AZN",null,"OECD202","OECD202 - Individual",null,"CRS807 - legal arrangement – trust – beneficiary"]
["Bahrain","BH",null,null,"BAM",null,"OECD203","OECD203 - Alias",null,"CRS808 - legal arrangement – trust – other"]
["Bahamas","BS",null,null,"BBD",null,"OECD204","OECD204 - Nickname",null,"CRS809 - legal arrangement – other – settlor-equivalent"]
["Bangladesh","BD",null,null,"BDT",null,"OECD205","OECD205 - Also known as",null,"CRS810 - legal arrangement – other – trustee-equivalent"]
["Barbados","BB",null,null,"BGN",null,"OECD206","OECD206 - Does business as",null,"CRS811 - legal arrangement – other – protector-equivalent"]
["Belarus","BY",null,null,"BHD",null,"OECD207","OECD207 - Legal",null,"CRS812 - legal arrangement – other – beneficiary-equivalent"]
["Belgium","BE",null,null,"BIF",null,"OECD208","OECD208 - At birth",null,"CRS813 - legal arrangement – other – other-equivalent"]
["Belize","BZ",null,null,"BMD"]
["Benin","BJ",null,null,"BND",null,"Account holder type"]
["Bermuda","BM",null,null,"BOB",null,"FATCA101"]
["Bhutan","BT",null,null,"BOV",null,"FATCA102"]
["Bolivia, Plurinational State of","BO",null,null,"BRL",null,"FATCA103",null,null,"SponsorIntermediary"]
["Bonaire, Sint Eustatius and Saba","BQ",null,null,"BSD",null,"FATCA104","Document types",null,"Sponsor"]
["Bosnia and Herzegovina","BA",null,null,"BTN",null,"FATCA105","FATCA1 - New data","FATCA1","Intermediary"]
["Botswana","BW",null,null,"BWP",null,null,"FATCA2 - Corrected data","FATCA2"]
["Bouvet Island","BV",null,null,"BYR",null,"Filer categories","FATCA3 - Void data","FATCA3"]
["Brazil","BR",null,null,"BZD",null,"FATCA601","FATCA4 - Amended data","FATCA4"]
["British Indian Ocean Territory","IO",null,null,"CAD",null,"FATCA602"]
["Brunei Darussalam","BN",null,null,"CDF",null,"FATCA603"]
["Bulgaria","BG",null,null,"CHE",null,"FATCA604"]
["Burkina Faso","BF",null,null,"CHF",null,"FATCA605"]
["Burundi","BI",null,null,"CHW",null,"FATCA606"]
["Cambodia","KH",null,null,"CLF",null,"FATCA610"]
["Cameroon","CM",null,null,"CLP",null,"FATCA611"]
["Canada","CA",null,null,"CNY"]
["Cape Verde","CV",null,null,"COP",null,"FATCA607"]
["Cayman Islands","KY",null,null,"COU",null,"FATCA608"]
["Central African Republic","CF",null,null,"CRC",null,"FATCA609"]
["Chad","TD",null,null,"CUP"]
["Chile","CL",null,null,"CVE"]
["China","CN",null,null,"CYP"]
["Christmas Island","CX",null,null,"CZK"]
["Cocos (Keeling) Islands","CC",null,null,"DJF"]
["Colombia","CO",null,null,"DKK"]
["Comoros","KM",null,null,"DOP"]
["Congo","CG",null,null,"DZD"]
["Congo, the Democratic Republic of the","CD",null,null,"EEK"]
["Cook Islands","CK",null,null,"EGP"]
["Costa Rica","CR",null,null,"ERN"]
["Côte d'Ivoire","CI",null,null,"ETB"]
["Croatia","HR",null,null,"EUR"]
["Cuba","CU",null,null,"FJD"]
["Curaçao","CW",null,null,"FKP"]
["Cyprus","CY",null,null,"GBP"]
["Czech Republic","CZ",null,null,"GEL"]
["Denmark","DK",null,null,"GHS"]
["Djibouti","DJ",null,null,"GIP"]
["Dominica","DM",null,null,"GMD"]
["Dominican Republic","DO",null,null,"GNF"]
["Ecuador","EC",null,null,"GTQ"]
["Egypt","EG",null,null,"GYD"]
["El Salvador","SV",null,null,"HKD"]
["Equatorial Guinea","GQ",null,null,"HNL"]
["Eritrea","ER",null,null,"HRK"]
["Estonia","EE",null,null,"HTG"]
["Ethiopia","ET",null,null,"HUF"]
["Falkland Islands (Malvinas)","FK",null,null,"IDR"]
["Faroe Islands","FO",null,null,"ILS"]
["Fiji","FJ",null,null,"INR"]
["Finland","FI",null,null,"IQD"]
["France","FR",null,null,"IRR"]
["French Guiana","GF",null,null,"ISK"]
["French Polynesia","PF",null,null,"JMD"]
["French Southern Territories","TF",null,null,"JOD"]
["Gabon","GA",null,null,"JPY"]
["Gambia","GM",null,null,"KES"]
["Georgia","GE",null,null,"KGS"]
["Germany","DE",null,null,"KHR"]
["Ghana","GH",null,null,"KMF"]
["Gibraltar","GI",null,null,"KPW"]
["Greece","GR",null,null,"KRW"]
["Greenland","GL",null,null,"KWD"]
["Grenada","GD",null,null,"KYD"]
["Guadeloupe","GP",null,null,"KZT"]
["Guam","GU",null,null,"LAK"]
["Guatemala","GT",null,null,"LBP"]
["Guernsey","GG",null,null,"LKR"]
["Guinea","GN",null,null,"LRD"]
["Guinea-Bissau","GW",null,null,"LSL"]
["Guyana","GY",null,null,"LTL"]
["Haiti","HT",null,null,"LVL"]
["Heard Island and McDonald Islands","HM",null,null,"LYD"]
["Holy See (Vatican City State)","VA",null,null,"MAD"]
["Honduras","HN",null,null,"MDL"]
["Hong Kong","HK",null,null,"MGA"]
["Hungary","HU",null,null,"MKD"]
["Iceland","IS",null,null,"MMK"]
["India","IN",null,null,"MNT"]
["Indonesia","ID",null,null,"MOP"]
["Iran, Islamic Republic of","IR",null,null,"MRO"]
["Iraq","IQ",null,null,"MTL"]
["Ireland","IE",null,null,"MUR"]
["Isle of Man","IM",null,null,"MVR"]
["Israel","IL",null,null,"MWK"]
["Italy","IT",null,null,"MXN"]
["Jamaica","JM",null,null,"MXV"]
["Japan","JP",null,null,"MYR"]
["Jersey","JE",null,null,"MZN"]
["Jordan","JO",null,null,"NAD"]
["Kazakhstan","KZ",null,null,"NGN"]
["Kenya","KE",null,null,"NIO"]
["Kiribati","KI",null,null,"NOK"]
["Korea, Democratic People's Republic of","KP",null,null,"NPR"]
["Korea, Republic of","KR",null,null,"NZD"]
["Kuwait","KW",null,null,"OMR"]
["Kyrgyzstan","KG",null,null,"PAB"]
["Lao People's Democratic Republic","LA",null,null,"PEN"]
["Latvia","LV",null,null,"PGK"]
["Lebanon","LB",null,null,"PHP"]
["Lesotho","LS",null,null,"PKR"]
["Liberia","LR",null,null,"PLN"]
["Libya","LY",null,null,"PYG"]
["Liechtenstein","LI",null,null,"QAR"]
["Lithuania","LT",null,null,"RON"]
["Luxembourg","LU",null,null,"RSD"]
["Macao","MO",null,null,"RUB"]
["Macedonia, the Former Yugoslav Republic of","MK",null,null,"RWF"]
["Madagascar","MG",null,null,"SAR"]
["Malawi","MW",null,null,"SBD"]
["Malaysia","MY",null,null,"SCR"]
["Maldives","MV",null,null,"SDG"]
["Mali","ML",null,null,"SEK"]
["Malta","MT",null,null,"SGD"]
["Marshall Islands","MH",null,null,"SHP"]
["Martinique","MQ",null,null,"SKK"]
["Mauritania","MR",null,null,"SLL"]
["Mauritius","MU",null,null,"SOS"]
["Mayotte","YT",null,null,"SRD"]
["Mexico","MX",null,null,"STD"]
["Micronesia, Federated States of","FM",null,null,"SYP"]
["Moldova, Republic of","MD",null,null,"SZL"]
["Monaco","MC",null,null,"THB"]
["Mongolia","MN",null,null,"TJS"]
["Montenegro","ME",null,null,"TMM"]
["Montserrat","MS",null,null,"TND"]
["Morocco","MA",null,null,"TOP"]
["Mozambique","MZ",null,null,"TRY"]
["Myanmar","MM",null,null,"TTD"]
["Namibia","NA",null,null,"TWD"]
["Nauru","NR",null,null,"TZS"]
["Nepal","NP",null,null,"UAH"]
["Netherlands","NL",null,null,"UGX"]
["New Caledonia","NC",null,null,"USD"]
["New Zealand","NZ",null,null,"USN"]
["Nicaragua","NI",null,null,"USS"]
["Niger","NE",null,null,"UYU"]
["Nigeria","NG",null,null,"UZS"]
["Niue","NU",null,null,"VEB"]
["Norfolk Island","NF",null,null,"VND"]
["Northern Mariana Islands","MP",null,null,"VUV"]
["Norway","NO",null,null,"WST"]
["Oman","OM",null,null,"XAF"]
["Pakistan","PK",null,null,"XAG"]
["Palau","PW",null,null,"XAU"]
["Palestine, State of","PS",null,null,"XBA"]
["Panama","PA",null,null,"XBB"]
["Papua New Guinea","PG",null,null,"XBC"]
["Paraguay","PY",null,null,"XBD"]
["Peru","PE",null,null,"XCD"]
["Philippines","PH",null,null,"XDR"]
["Pitcairn","PN",null,null,"XFO"]
["Poland","PL",null,null,"XFU"]
["Portugal","PT",null,null,"XOF"]
["Puerto Rico","PR",null,null,"XPD"]
["Qatar","QA",null,null,"XPF"]
["Réunion","RE",null,null,"XPT"]
["Romania","RO",null,null,"XTS"]
["Russian Federation","RU",null,null,"XXX"]
["Rwanda","RW",null,null,"YER"]
["Saint Barthélemy","BL",null,null,"ZAR"]
["Saint Helena, Ascension and Tristan da Cunha","SH",null,null,"ZMK"]
["Saint Kitts and Nevis","KN",null,null,"ZWD"]
["Saint Lucia","LC"]
["Saint Martin (French part)","MF"]
["Saint Pierre and Miquelon","PM"]
["Saint Vincent and the Grenadines","VC"]
["Samoa","WS"]
["San Marino","SM"]
["Sao Tome and Principe","ST"]
["Saudi Arabia","SA"]
["Senegal","SN"]
["Serbia","RS"]
["Seychelles","SC"]
["Sierra Leone","SL"]
["Singapore","SG"]
["Sint Maarten (Dutch part)","SX"]
["Slovakia","SK"]
["Slovenia","SI"]
["Solomon Islands","SB"]
["Somalia","SO"]
["South Africa","ZA"]
["South Georgia and the South Sandwich Islands","GS"]
["South Sudan","SS"]
["Spain","ES"]
["Sri Lanka","LK"]
["Sudan","SD"]
["Suriname","SR"]
["Svalbard and Jan Mayen","SJ"]
["Swaziland","SZ"]
["Sweden","SE"]
["Switzerland","CH"]
["Syrian Arab Republic","SY"]
["Taiwan, Province of China","TW"]
["Tajikistan","TJ"]
["Tanzania, United Republic of","TZ"]
["Thailand","TH"]
["Timor-Leste","TL"]
["Togo","TG"]
["Tokelau","TK"]
["Tonga","TO"]
["Trinidad and Tobago","TT"]
["Tunisia","TN"]
["Turkey","TR"]
["Turkmenistan","TM"]
["Turks and Caicos Islands","TC"]
["Tuvalu","TV"]
["Uganda","UG"]
["Ukraine","UA"]
["United Arab Emirates","AE","AU"]
["United Kingdom","GB","US"]
["United States","US"]
["United States Minor Outlying Islands","UM"]
["Uruguay","UY"]
["Uzbekistan","UZ"]
["Vanuatu","VU"]
["Venezuela, Bolivarian Republic of","VE"]
["Viet Nam","VN"]
["Virgin Islands, British","VG"]
["Virgin Islands, U.S.","VI"]
["Wallis and Futuna","WF"]
["Western Sahara","EH"]
["Yemen","YE"]
["Zambia","ZM"]
["Zimbabwe","ZW"]