{"text_format":"1","workbook":"xlsx","n_sheets":16,"sheets":["Overview","Validation Results","Contacts","Profiles","Activities","Notes","Opportunities","Mortgages","Investments","Policies","Policy Cover","F&G Policies","F&G Claims","KiwiSaver","DATA","APPENDIX - KiwiSaver"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":1,"defined_names":0,"comments":5,"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":"Overview","index":0,"n_rows":55,"n_cols":6,"rows_kept":55,"cut":false,"hidden":false,"merged":[[30,2,30,3],[34,2,34,3]]}
[]
[null,null,null,null,null,"Note:  You will need to enable Macros to use this spreadsheet"]
[]
[]
[]
[]
[]
[]
[]
[null,"Visibility","Page","Description"]
[null,null,"Overview","The worksheet you are current viewing."]
[null,null,"Contacts","These are individual people, trusts or companies"]
[null,null,"Profiles","These represent different groups of contacts, such as a family or a business and it's shareholders, contacts are grouped into profiles in order to group their financial positions and to create applications for a lender or insurance provider"]
[null,null,"Activities","Past or future tasks that you have, or will complete in order to service your clients"]
[null,null,"Notes","Notes about a client that give more information about them, these will be added to the timeline for a profile"]
[null,null,"Opportunities","These are dealings you have with your client, often called deals or leads in other CRM systems. They represent an opportunity to earn commission for helping a client"]
[null,null,"Mortgages","(Optional) Historical or Current Individual Mortgages / Home Loans for your clients."]
[null,null,"Investments","(Optional) Historical or Current Investments excluding Kiwisaver for your clients."]
[null,null,"Policies","(Optional) Historical or Current Insurance policies and the individual benefits for your clients."]
[null,null,"F&G Policies","(Optional) Historical or Current Fire and General Insurance Policies and Claims for your clients."]
[null,null,"Kiwisaver","(Optional) Historical or Current Kiwisaver Investments for your clients."]
[]
[null,"Key","Priority","Description"]
[null,"Red","Critical","Red fields are typically used to link the different spreadsheets together"]
[null,"Green","Important","Green fields are typically required/mandatory by the business entity"]
[null,"Yellow","Optional","Yellow fields are Optional and can be left blank"]
[]
[null,"Adviser","All business entities will be linked to a single adviser, this typically will be the person who sends the Import File to Trail.  "]
[null,null,"If you wish to refer to multiple advisers please create one import file per adviser."]
[]
[null,"Notes","The 'Id' column is a unqiue identifier for each item. using this the sheets can reference each other in order to link together, for example; a policy has the id 'policy-76' in order to assign an item of cover to it, in the 'policy' column of the 'policy cover' spreadsheet write 'policy-76'"]
[]
[]
[]
[null,null,"Any piece of information on a client that does not fit into the columns provided can instead be imported as a note that will fit into the timeline of their profile, if you have extra pieces of information, create a new column and add the data into each row"]
[null,null,"* There may be additional charges associated with supporting fields that do not follow our standard template"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Template Version 3.06.14 last edited by Gary Mar"]

{"sheet":"Validation Results","index":1,"n_rows":1,"n_cols":3,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["Worksheet","Row Number","Message"]

{"sheet":"Contacts","index":2,"n_rows":4,"n_cols":21,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["Column","Id","Type","Title","First Name","Middle Name","Last Name","Preferred Name","Primary Phone Number","Secondary Phone Numbers","Primary Email","Secondary Email","Address","Date of Birth","Gender","Marital Status","Country of Birth","Residency Status","Employment Status","Occupation","Employer"]
["Description","Any unique identifier for this contact","Are they a person, a company or trust","The title of the contact","First name for Person, or the Company/Trust Name if Business","The middle name of the person.","The last name of the person","If the contact goes by another name, enter it here.","Primary Phone (Mobile / Home / work)","A secondary phone number ","Primary Email address","Secondary Email Address","Full residential address","Please format the dates consistently","The person’s social and personal identity","The contact's current Marital Status","The country in which they were born in","The state of the peron's residency","What is this person's income status","What job does this person perform","The current employer of the contact"]
["Example","contact-99","Person","Mr","Joesph",null,"Bloggs","Joe Bloggs","+64215555555",null,"jblog@gettrail.com",null,null,"dd/mm/yyyy",null,"Single","New Zealand","Citizen","Earning Salary/Wages","Caregiver","MyCare"]
["Your Data"]

{"sheet":"Profiles","index":3,"n_rows":4,"n_cols":9,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["Column","Id","Contacts","Name","Type","Status","Rank","Source","Annual Review Date"]
["Description","Any unique identifier for the profile","The contacts are a part of this profile, please use the Id column.  The first contact in the list will be designated the \"key contact\".","The name of the Profile / Family / Group / Trust, this may represent a collection of entities, or a single Entity.","Is this a personal group such as a family, or a business group with a company and its shareholders","What is the working relationhip with this profile","Alphabetic A-F categorisation of the Profile","How did you come to work with this profile","The annual review date for the profile"]
["Example","profile-1","contact-99, contact-102",null,"Personal","Prospect","None","Marketing","dd/mm/yyyy"]
["Your Data"]

{"sheet":"Activities","index":4,"n_rows":4,"n_cols":9,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["Column","Id","Profile","Category","Type","Description","Date Created","Date Completed","Due Date"]
["Description","Any unique identifier for this note","The profile that this activity is for","What category does this activity belong to? Select the Category from the dropdown","What name does this activity have? Add a name for the activity","The description field of the activity","When was it created","If this activity is complete, when was it completed","When is the activity due"]
["Example","activity-1","profile-1","Call","General","Joe called up about Financial Services","dd/mm/yyyy","dd/mm/yyyy","dd/mm/yyyy"]
["Your Data"]

{"sheet":"Notes","index":5,"n_rows":4,"n_cols":5,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["Column","Id","Profile","Date Created","Note"]
["Description","Any unique identifier for this note","The profile that this note is for","When was it created","The text that will appear in the note"]
["Example","note-1","profile-1","dd/mm/yyyy"]
["Your Data"]

{"sheet":"Opportunities","index":6,"n_rows":4,"n_cols":13,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["Column","Id","Profile","Type","Status","Value","Lender/Provider","Stage","Opportunity Created","Opportunity Closed","Closed Reason","Referrer","Source"]
["Description","Any unique identifier for this opportunity","The profile that this opportunity is a part of","What type of service are you providing here for our client","Is this a present opportunity you are working on, or one that you deal with previously","Estimted value of the opportunity, such as the total lending the client is applying for or the insurance API","Bank/Lender of the Mortgage, or Insurance Provider if Insurance","Where on the pipeline does this opportunity fit, if left blank the first stage will be assigned.","When was the opportunity created?","If this is a past opportunity when was it won, lost or closed","Any notes on why the opportunity was closed","Was this opportunity referred to you by someone","Was the opportunity generated through a business group or marketing"]
["Example","opportunity-51","profile-1","Refinance","Open",5000,"ANZ","Mortgage Advice - Application Submitted","dd/mm/yyyy","dd/mm/yyyy"]
["Your Data"]

{"sheet":"Mortgages","index":7,"n_rows":4,"n_cols":15,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
["Column","Id","Profile","Borrowers","Type","Amount","Expiry Date","Account Number","Lender","Management Status","Interest Rate","Repayment Status","Repayment Frequency","Repayment Amount","Fixed Term"]
["Description","A unique identifier for this loan","The profile that this loan is a associated with","Who is borrowing this loan, a list of the ids specified in the contacts spreadsheet seperated by a comma","The type of loan","The total loan amount","If this loan is fixed, when does the fixed rate rollover occur","The account number of the loan","The name of the lender that has provided the loan","Prospective: An existing product your client has that you are not yet managing.\nManaged: An existing product you are managing on behalf of your client and receiving commission from.\nExcluded: An existing product your client has that you will not have an opportunity to manage.","The interest rate recorded for the loan","The loan structure, eg interest only or principal and interest","The frequency of repayments","The amount of each repayment","Fixed term in months"]
["Example","loan-1","profile-1","contact-2, contact-5","Fixed","$","dd/mm/yyyy",null,null,"Prospective",4.99,"Interest Only","Week"]
["Your Data"]

{"sheet":"Investments","index":8,"n_rows":4,"n_cols":18,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
["Column","Id","Profile","Owners","Policy Number","Membership Number","Provider","Management Status","Product Type","Review Date","Notes","State","Fund Type1","Fund Description1","Fund Balance1","Fund Type2","Fund Description2","Fund Balance2"]
["Description","A unique identifier for this investment","The profile that this investment is associated with","Who owns this investment, single or a list of the ids specified in the contacts spreadsheet seperated by a comma","A unique policy number assigned by the provider.","The membership number assigned by the provider","The Investment Provider","Prospective: An existing product your client has that you are not yet managing.\nManaged: An existing product you are managing on behalf of your client and receiving commission from.\nExcluded: An existing product your client has that you will not have an opportunity to manage.","Investment, Retirement or Superannuation.  \nNOTE: For kiwisaver investments use the kiwisaver worksheet","Date in which the investment is to be reviewed","Any notes relating to the investment","Archived, Current or Proposed","The first fund type of the investment","A description or category of the first fund type","The current balance of the first fund","(Optional) The second fund type of the investment","(Optional) A description or category of the second fund type","(Optional) The current balance of the second fund"]
["Example","investment-1","profile-1",null,null,null,"Sharesies","Prospective","Investment","dd/mm/yyyy",null,"Current","Superannuation","Balanced",392]
["Your Data"]

{"sheet":"Policies","index":9,"n_rows":999,"n_cols":14,"rows_kept":999,"cut":false,"hidden":true,"merged":[]}
["Column","Id","Profile","Policy Owners","Policy Number","Provider","Management Status","Enforced status","Commencement Date","Review Date","Payment Frequency","Payment Method","Policy Fee","Policy Fee Freqency"]
["Description","Any unique internal identifier for this policy","The profile that this policy is a part of (optional if any policy owners are specified)","Who is owns this policy, a list of the ids specified in the contacts spreadsheet, separated by a comma (\",\") character.","A unique policy number assigned by the provider.","The insurance provider","Prospective: An existing product your client has that you are not yet managing.\nManaged: An existing product you are managing on behalf of your client and receiving commission from.\nExcluded: An existing product your client has that you will not have an opportunity to manage.","When a policy is deemed in force the policyholder is entitled to the policy's benefits","When the policy is set to start","When the policy is set to be reviewed, typically a year from the commencement date","How frequent the policy is to be paid","The payment method utilised by the client","Policy Fee in Dollars","How frequent the policy fee is to be applied"]
["Example","policy-1","profile-1",null,null,"AA Insurance","Managed","In Force","dd/mm/yyyy","dd/mm/yyyy","Monthly","Credit Card","$","Monthly"]
["Your Data"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["x"]

{"sheet":"Policy Cover","index":10,"n_rows":4,"n_cols":9,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
["Column","Id","Policy","Insured Person","Cover Type","Description","Sum Assured","Payout","Premium"]
["Description","A unique identifier for this cover item","The policy that this cover falls under","Who is protected by this cover item, a list of the ids specified in the contacts worksheet seperated by a comma","What is the product of this cover item","Any further details such as the excess","The amount that is paid to the nominee of the plan in the event of a claim by the policyholder.","How does this cover get paid out in the event of a claim","The premium relating to the cover item, applied at the same frequency as the policy."]
["Example","coveritem-1","policy-1",null,"Income Protection Insurance","30 day WP paid over 2 years",null,"Lump sum"]
["Your Data"]

{"sheet":"F&G Policies","index":11,"n_rows":4,"n_cols":15,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
["Column","Id","Profile","Policy Owners","Policy Number","Provider","Client Number","Enforced status","Management Status","Commencement Date","Review Date","Payment Amount","Payment Frequency","Payment Method","Notes"]
["Description","A unique identifier for this policy","The profile that this policy is a part of","Who is owns this policy, a list of the ids specified in the contacts worksheet seperated by a comma","The policy number assigned to the F&G Policy","The fire and general insurance provider","The unique customer number","The Enforced / In Forced status of the Policy","Prospective: An existing product your client has that you are not yet managing.\nManaged: An existing product you are managing on behalf of your client and receiving commission from.\nExcluded: An existing product your client has that you will not have an opportunity to manage.","When the policy is due to start","When the policy is due to be reviewed, typically annually from the commencement date.","The payment amount for the policy defined by the frequency","The payment frequency associated with the policy","Payment method of the Policy","Any notes applying to the policy"]
["Example","policy-1","profile-1",null,546512,"AA Insurance",null,"In Force","Managed","dd/mm/yyyy","dd/mm/yyyy",null,"Monthly","Credit Card"]
["Your Data"]

{"sheet":"F&G Claims","index":12,"n_rows":4,"n_cols":11,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
["Column","Id","Policy","Claim Number","Value","Status","Notes","Date Claim","Date Loss","Date Closed","Closed Reason"]
["Description","A unique identifier for this claim","The F&G policy ID from the \"F&G Policies\" tab","Number assigned to the claim","Estimated value of the claim","Status of the claim","Any notes relating to the claim","Date the claim was reported","Date the loss occurred","If this is a past claim the date it was won, lost or closed","Any notes on why the claim was closed"]
["Example","claim-51","policy-1","N006407242",5000,"Pending","Rain water flooded into garage and damaged wall","dd/mm/yyyy","dd/mm/yyyy","dd/mm/yyyy"]
["Your Data"]

{"sheet":"KiwiSaver","index":13,"n_rows":4,"n_cols":20,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
["Column","Id","Profile","Owner","Policy Number","Membership Number","Management Status","Review Date","Notes","State","Provider","Fund 1","Balance 1","Contribution Split 1","Fund 2","Balance 2","Contribution Split 2","Fund 3","Balance 3","Contribution Split 3"]
["Description","A unique identifier for this KiwiSaver investment","The profile that this investment is a part of","Who owns this KiwiSaver investment, single id of the contact in the contacts worksheet ","Policy number of the KiwiSaver Investment","Any membership number associated with the investment","Prospective: An existing product your client has that you are not yet managing.\nManaged: An existing product you are managing on behalf of your client and receiving commission from.\nExcluded: An existing product your client has that you will not have an opportunity to manage.","The next KiwiSaver review date ","Any customer notes you would like to add.","Archived, Current or Proposed","The KiwiSaver Provider","Refer to Fund Name in \"APPENDIX - KiwiSaver\" worksheet or leave blank if you do not know.","The balance of the KiwiSaver fund","Percentage of Contribution Split","Refer to Fund Name in \"APPENDIX - KiwiSaver\" worksheet or leave blank if you do not know.","The balance of the second KiwiSaver fund","Percentage of Contribution Split of the second fund.","Refer to Fund Name in \"APPENDIX - KiwiSaver\" worksheet or leave blank if you do not know.","The balance of the third KiwiSaver fund","Percentage of Contribution Split of the third fund"]
["Example","kiwisaver-1","profile-1","contact-1",525049,525049,"Prospective","dd/mm/yyyy",null,"Current","AE Kiwisaver Plan","Growth Fund",10000,0.5,"Balanced Growth Fund",210101]
["Your Data"]

{"sheet":"DATA","index":14,"n_rows":251,"n_cols":29,"rows_kept":251,"cut":false,"hidden":true,"merged":[]}
["Kiwisaver Providers","FG Providers","Opportunity Type","Insurance Provider","Client Rank","Gender","Marital Status","Resident Status","Employment Type","Country","Contact Type","Profile Type","Profile Status","Profile Source","Pipeline Stage","Loan Type","Lender","Management Status","Repayment Status","Repayment Frequency","Investment Type","State","Insurance Enforced","Policy Frequency","Payment Method","Policy Cover Type","Payout Type","Claim Status","Activity Category"]
["AE KiwiSaver Plan","AA Insurance","Personal Risk","AA Insurance","A","Male","Single","Citizen","Earning Salary/Wages","New Zealand","Person","Personal","Prospect","Existing CRM Contact","Mortgage Prospecting - New Prospect","Fixed","ANZ","Excluded","Interest Only","Week","Retirement","Archived","In Force","Weekly","Credit Card","Health","Per Week","Pending","Call"]
["AMP KiwiSaver Scheme","AIG New Zealand","Business Risk","Accuro","B","Female","Defacto","Permanent Resident","Self Employed","Afghanistan","Trust","Business","Existing Client","Adviser Generated","Mortgage Prospecting - Emailed","Floating","ASB","Managed","Principal and Interest","Fortnight","Superannuation","Current","Lapsed","Fortnightly","Direct Debit","Income Protection","Per Fortnight","Accepted","Email"]
["ANZ Default KiwiSaver Scheme","Allianz Australia Insurance Ltd (NZ Branch)","Policy Renewal","AIA","C",null,"Married","Resident Visa","Student","Åland Islands","Company",null,"Previous Client","Facebook Advertising","Mortgage Prospecting - Contact Attempted","Flexible (Revolving Credit)","BNZ","Prospective",null,"Month","Investment","Proposed","Cancelled","Monthly","Cheque","Loss of Earnings Premier","Per Month","Declined","Meeting"]
["ANZ KiwiSaver Scheme","AMI","Insurance Claim","AIG Insurance New Zealand","D",null,"Engaged","Work permit","Home-Maker","Albania",null,null,"Referral Partner","Google Advertising","Mortgage Prospecting - Contact Made","Offset","Westpac",null,null,null,null,null,"Withdrawn","Quarterly","Automatic Payment","Mortgage, Income and Rent Cover","Per Year",null,"Review"]
["AON KiwiSaver Scheme","AMP General Insurance","Refinance","Allianz Australia Insurance","E",null,"Divorced","Other","Unemployed","Algeria",null,null,"Product Provider","Marketing","Mortgage Prospecting - Needs Confirmed",null,"Sovereign",null,null,null,null,null,"Not Active","6 Monthly",null,"Vital Income Protection","Lump Sum",null,"Task"]
["ASB KiwiSaver Scheme","ANDO Insurance Group","New Purchase","ANZ Life & Living Insurance","F",null,"Widowed",null,"Retired","American Samoa",null,null,"Service Provider","Mailout","Mortgage Advice - New Lead",null,"Avanti Finance",null,null,null,null,null,"Replaced","Yearly",null,"Cancer Treatment Benefit"]
["Aurora KiwiSaver Scheme","ARGIS Limited ","Topup","American Income Life Insurance Company","None",null,"Civil Union",null,null,"Andorra",null,null,"Unsubscribed","Unknown","Mortgage Advice - Fact Find Completed",null,"Bank of China",null,null,null,null,null,null,null,null,"Life Cover"]
["BCF KiwiSaver Scheme","Chubb Insurance New Zealand Ltd","Other","AMP Life",null,null,null,null,null,"Angola",null,null,"Not a Client","Unspecified","Mortgage Advice - Application Submitted",null,"Basecorp",null,null,null,null,null,null,null,null,"Accidental Death"]
["BNZ KiwiSaver Scheme","Delta Liability","Fixed Rate Review","ASB Insurance",null,null,null,null,null,"Anguilla",null,null,"Unspecified",null,"Mortgage Advice - Conditional Approval",null,"Bluestone",null,null,null,null,null,null,null,null,"Total and Permanent Disability Cover"]
["Booster KiwiSaver Scheme","Delta Property","Investment Advice","Asteron Life",null,null,null,null,null,"Antarctica",null,null,null,null,"Mortgage Advice - Loan Structure Confirmed",null,"Cooperative Bank",null,null,null,null,null,null,null,null,"Trauma Cover"]
["Christian KiwiSaver Scheme","Dual New Zealand Ltd","Financial Planning","Beneficial Insurance",null,null,null,null,null,"Antigua And Barbuda",null,null,null,null,"Mortgage Advice - Loan Settled",null,"CFML",null,null,null,null,null,null,null,null,"Income Protection Insurance"]
["Fisher Funds KiwiSaver Scheme","Elantis Premium Funding ","Investment Review","Berkshire Hathaway Specialty Insurance Company",null,null,null,null,null,"Argentina",null,null,null,null,"Mortgage Advice - Commission Received",null,"Cressida Capital",null,null,null,null,null,null,null,null,"Workability Insurance"]
["Fisher Funds Two KiwiSaver Scheme","FMG","Financial Plan Review","BNZ Life Insurance",null,null,null,null,null,"Armenia",null,null,null,null,"Mortgage Advice - Progress drawdown",null,"DBR",null,null,null,null,null,null,null,null,"Mortgage and Rent Insurance"]
["Generate KiwiSaver Scheme","Initio","KiwiSaver Advice","Booster Assurance",null,null,null,null,null,"Aruba",null,null,null,null,"Mortgage Servicing - New Fixed Rate Review",null,"First Mortgage Trust",null,null,null,null,null,null,null,null,"Life Insurance"]
["Investnow KiwiSaver Scheme","Insurance Underwriters NZ","Complaint","Chubb Insurance New Zealand",null,null,null,null,null,"Australia",null,null,null,null,"Mortgage Servicing - Online Quick Form Sent",null,"Funding Partners",null,null,null,null,null,null,null,null,"Accidental Death Insurance"]
["Juno KiwiSaver Scheme","Macquarie Pacific Premium Funding","Fire & General Advice","Cigna Life Insurance New Zealand",null,null,null,null,null,"Austria",null,null,null,null,"Mortgage Servicing - Online Quick Form Completed",null,"Heartland",null,null,null,null,null,null,null,null,"Total and Permanent Disablement Insurance"]
["Kernel KiwiSaver Plan","MAS","Fire & General Servicing","Co-operative Life",null,null,null,null,null,"Azerbaijan",null,null,null,null,"Mortgage Servicing - Rates Received",null,"HSBC",null,null,null,null,null,null,null,null,"Trauma Insurance"]
["Kiwi Wealth KiwiSaver Scheme","MECON Insurance Ltd",null,"DPL Insurance",null,null,null,null,null,"Bahamas",null,null,null,null,"Mortgage Servicing - Fixed Rate Review Confirmed",null,"Kiwibank",null,null,null,null,null,null,null,null,"Cancer Insurance"]
["Koura KiwiSaver Scheme","NM Insurance Agency",null,"Education Benevolent Society Incorporated",null,null,null,null,null,"Bahrain",null,null,null,null,"Mortgage Servicing - Commission Received",null,"Liberty",null,null,null,null,null,null,null,null,"Business Disability Insurance"]
["Lifestages KiwiSaver Scheme","NZI",null,"Factory Mutual Insurance Company",null,null,null,null,null,"Bangladesh",null,null,null,null,"Insurance Prospecting - New Prospect",null,"NZ Home Loans",null,null,null,null,null,null,null,null,"Business Expenses Insurance"]
["Maritime KiwiSaver Scheme","Protecsure",null,"Fidelity Life",null,null,null,null,null,"Barbados",null,null,null,null,"Insurance Prospecting - Emailed",null,"Pepper Money",null,null,null,null,null,null,null,null,"Farmers Disability Insurance"]
["MAS KiwiSaver Scheme","QBE Insurance (Australia) Ltd",null,"FMG Insurance",null,null,null,null,null,"Belarus",null,null,null,null,"Insurance Prospecting - Contact Attempted",null,"Resimac",null,null,null,null,null,null,null,null,"Income Protection Cover"]
["Mercer KiwiSaver Scheme","Rosser",null,"Foundation Life (NZ)",null,null,null,null,null,"Belgium",null,null,null,null,"Insurance Prospecting - Contact Made",null,"SBS",null,null,null,null,null,null,null,null,"Funeral Cover"]
["Milford KiwiSaver Plan","Star Insurance",null,"Health Service Welfare Society",null,null,null,null,null,"Belize",null,null,null,null,"Insurance Prospecting - Needs Confirmed",null,"TSB",null,null,null,null,null,null,null,null,"Life Assurance"]
["New Zealand Defence Force KiwiSaver Scheme","State Insurance",null,"IAG New Zealand",null,null,null,null,null,"Benin",null,null,null,null,"Insurance Advice - New Lead",null,"Unity",null,null,null,null,null,null,null,null,"Total and Permanent Disability Cover"]
["Nikko AM KiwiSaver Scheme","Tower",null,"Indemnity and General Insurance Company",null,null,null,null,null,"Bermuda",null,null,null,null,"Insurance Advice - Fact Find Completed",null,"Other",null,null,null,null,null,null,null,null,"Total and Permanent Disability Cover for Business"]
["NZ Funds KiwiSaver Scheme","TradeMe",null,"Kiwi Insurance",null,null,null,null,null,"Bhutan",null,null,null,null,"Insurance Advice - Statement of Advice Completed",null,null,null,null,null,null,null,null,null,null,"Mortgage Protection"]
["Oneanswer KiwiSaver Scheme","Vero Insurance New Zealand Limited ",null,"Lifetime Income",null,null,null,null,null,"Bolivia",null,null,null,null,"Insurance Advice - Client Recommendation Delivered",null,null,null,null,null,null,null,null,null,null,"Trauma Cover"]
["Pathfinder KiwiSaver Plan","Vero – Surepoint",null,"Marac Insurance",null,null,null,null,null,"Bonaire, Sint Eustatius and Saba",null,null,null,null,"Insurance Advice - Policy Structure Confirmed",null,null,null,null,null,null,null,null,null,null,"Business Expenses Cover"]
["Quaystreet KiwiSaver Scheme","Vero Marine",null,"Medical Insurance Society",null,null,null,null,null,"Bosnia and Herzegovina",null,null,null,null,"Insurance Advice - Application Submitted",null,null,null,null,null,null,null,null,null,null,"Key Person Cover"]
["Select KiwiSaver Scheme","Vero Liability Insurance Limited",null,"Medical Life Assurance Society",null,null,null,null,null,"Botswana",null,null,null,null,"Insurance Advice - Underwriting Pending",null,null,null,null,null,null,null,null,null,null,"Rural Key Person Cover"]
["Sharesies KiwiSaver Scheme","Zurich Australian Insurance Ltd - New Zealand Branch",null,"New Zealand Dental Insurance Society",null,null,null,null,null,"Bouvet Island",null,null,null,null,"Insurance Advice - Offer of Terms Received",null,null,null,null,null,null,null,null,null,null,"Trauma Cover for Business"]
["Simplicity KiwiSaver Scheme",null,null,"New Zealand Medical Professionals",null,null,null,null,null,"Brazil",null,null,null,null,"Insurance Advice - Policy Accepted",null,null,null,null,null,null,null,null,null,null,"Group Cover"]
["Smartshares KiwiSaver Scheme",null,null,"NIB NZ",null,null,null,null,null,"British Indian Ocean Territory",null,null,null,null,"Insurance Advice - Commission Received",null,null,null,null,null,null,null,null,null,null,"Private Medical Cover"]
["Summer KiwiSaver Scheme",null,null,"OnePath Life",null,null,null,null,null,"Brunei Darussalam",null,null,null,null,"Insurance Servicing - Upcoming Policy Anniversary",null,null,null,null,null,null,null,null,null,null,"Hospital Cash Cover"]
["Supereasy KiwiSaver Superannuation Scheme",null,null,"Partners Life",null,null,null,null,null,"Bulgaria",null,null,null,null,"Insurance Servicing - Online Quick Form Sent",null,null,null,null,null,null,null,null,null,null,"Specialist & Tests"]
["Westpac KiwiSaver Scheme",null,null,"Pinnacle Life",null,null,null,null,null,"Burkina Faso",null,null,null,null,"Insurance Servicing - Online Quick Form Completed",null,null,null,null,null,null,null,null,null,null,"Income Cover"]
["Superlife KiwiSaver Scheme",null,null,"Police Health Plan",null,null,null,null,null,"Burundi",null,null,null,null,"Insurance Servicing - Personal Review Completed",null,null,null,null,null,null,null,null,null,null,"Mortgage Repayment Protection"]
[null,null,null,"Provident Insurance Corporation",null,null,null,null,null,"Cambodia",null,null,null,null,"Insurance Claims - New Claim Requested",null,null,null,null,null,null,null,null,null,null,"Household Expenses Cover"]
[null,null,null,"QBE Insurance (Australia)",null,null,null,null,null,"Cameroon",null,null,null,null,"Insurance Claims - Claims Forms Completed",null,null,null,null,null,null,null,null,null,null,"Life Cover"]
[null,null,null,"QBE Lenders Mortgage Insurance",null,null,null,null,null,"Canada",null,null,null,null,"Insurance Claims - Claims Forms Lodged",null,null,null,null,null,null,null,null,null,null,"Life Income Cover"]
[null,null,null,"Resolution Life",null,null,null,null,null,"Cape Verde",null,null,null,null,"Insurance Claims - Insurance Claim Accepted",null,null,null,null,null,null,null,null,null,null,"Accidental Death Cover"]
[null,null,null,"Southern Cross Benefits",null,null,null,null,null,"Cayman Islands",null,null,null,null,"Fire & General Advice - New lead",null,null,null,null,null,null,null,null,null,null,"Terminal Illness Cover"]
[null,null,null,"Southern Cross Medical Care Society",null,null,null,null,null,"Central African Republic",null,null,null,null,"Fire & General Advice - Client info gathered",null,null,null,null,null,null,null,null,null,null,"Premium Cover"]
[null,null,null,"Southsure Assurance",null,null,null,null,null,"Chad",null,null,null,null,"Fire & General Advice - Comparing providers",null,null,null,null,null,null,null,null,null,null,"Total Permanent Disability Cover"]
[null,null,null,"Sovereign",null,null,null,null,null,"Chile",null,null,null,null,"Fire & General Advice - Client recommendation/quoting delivered",null,null,null,null,null,null,null,null,null,null,"Ownership Buyout Cover"]
[null,null,null,"Swiss Re Life & Health Australia",null,null,null,null,null,"China",null,null,null,null,"Fire & General Advice - Policy confirmed",null,null,null,null,null,null,null,null,null,null,"Debt Protection Cover"]
[null,null,null,"Teal Insurance",null,null,null,null,null,"Christmas Island",null,null,null,null,"Fire & General Advice - Commission received",null,null,null,null,null,null,null,null,null,null,"Permanent Loss of Key Person Cover"]
[null,null,null,"Teleco Insurance (NZ)",null,null,null,null,null,"Cocos (Keeling) Islands",null,null,null,null,"Fire & General Servicing - Upcoming Policies Reviews",null,null,null,null,null,null,null,null,null,null,"Severe Trauma Cover"]
[null,null,null,"TOWER Insurance",null,null,null,null,null,"Colombia",null,null,null,null,"Fire & General Servicing - Client Raised Changes",null,null,null,null,null,null,null,null,null,null,"Trauma Cover"]
[null,null,null,"TrustPower Insurance",null,null,null,null,null,"Comoros",null,null,null,null,"Fire & General Servicing - Comparing products",null,null,null,null,null,null,null,null,null,null,"Specific Condition Cover"]
[null,null,null,"Union Medical Benefits Society",null,null,null,null,null,"Congo",null,null,null,null,"Fire & General Servicing - Client recommendation/quoting delivered",null,null,null,null,null,null,null,null,null,null,"Specialist and Diagnostic Testing"]
[null,null,null,"Unison Insurance",null,null,null,null,null,"Congo, the Democratic Republic of the",null,null,null,null,"Fire & General Servicing - Policy confirmed",null,null,null,null,null,null,null,null,null,null,"Private Health Insurance"]
[null,null,null,"Vero Insurance New Zealand",null,null,null,null,null,"Cook Islands",null,null,null,null,"Investment Prospecting - New Prospect",null,null,null,null,null,null,null,null,null,null,"Healthy by Sovereign;"]
[null,null,null,"Vero Liability Insurance",null,null,null,null,null,"Costa Rica",null,null,null,null,"Investment Prospecting - Emailed",null,null,null,null,null,null,null,null,null,null,"Income Protection Insurance"]
[null,null,null,"Westpac Life-NZ",null,null,null,null,null,"Cote dIvoire",null,null,null,null,"Investment Prospecting - Contact Attempted",null,null,null,null,null,null,null,null,null,null,"Start-up Income Protection"]
[null,null,null,"Youi NZ Pty",null,null,null,null,null,"Croatia",null,null,null,null,"Investment Prospecting - Contact Made",null,null,null,null,null,null,null,null,null,null,"Life Insurance"]
[null,null,null,null,null,null,null,null,null,"Cuba",null,null,null,null,"Investment Prospecting - Needs Confirmed",null,null,null,null,null,null,null,null,null,null,"Business Life Cover"]
[null,null,null,null,null,null,null,null,null,"Curaçao",null,null,null,null,"Investment Advice - New Lead",null,null,null,null,null,null,null,null,null,null,"Total Permanent Disability Insurance"]
[null,null,null,null,null,null,null,null,null,"Cyprus",null,null,null,null,"Investment Advice - Consultation Completed",null,null,null,null,null,null,null,null,null,null,"Trauma Insurance"]
[null,null,null,null,null,null,null,null,null,"Czech Republic",null,null,null,null,"Investment Advice - Plan Completed",null,null,null,null,null,null,null,null,null,null,"Business Continuity Insurance"]
[null,null,null,null,null,null,null,null,null,"Denmark",null,null,null,null,"Investment Advice - Plan Presented",null,null,null,null,null,null,null,null,null,null,"Rural Continuity Insurance"]
[null,null,null,null,null,null,null,null,null,"Djibouti",null,null,null,null,"Investment Advice - Commitment Received",null,null,null,null,null,null,null,null,null,null,"Workplace Insurance"]
[null,null,null,null,null,null,null,null,null,"Dominica",null,null,null,null,"Investment Advice - Documents Received"]
[null,null,null,null,null,null,null,null,null,"Dominican Republic",null,null,null,null,"Investment Advice - Application Submitted"]
[null,null,null,null,null,null,null,null,null,"Ecuador",null,null,null,null,"Investment Advice - Application Approved"]
[null,null,null,null,null,null,null,null,null,"Egypt",null,null,null,null,"Investment Advice - Commission Received"]
[null,null,null,null,null,null,null,null,null,"El Salvador",null,null,null,null,"Investment Servicing - New Investment Review"]
[null,null,null,null,null,null,null,null,null,"Equatorial Guinea",null,null,null,null,"Investment Servicing - Meeting Arranged"]
[null,null,null,null,null,null,null,null,null,"Eritrea",null,null,null,null,"Investment Servicing - Review Plan w/ Goals"]
[null,null,null,null,null,null,null,null,null,"Estonia",null,null,null,null,"Investment Servicing - Plan adjustment"]
[null,null,null,null,null,null,null,null,null,"Ethiopia",null,null,null,null,"Investment Servicing - Asset Allocation Forms Submitted"]
[null,null,null,null,null,null,null,null,null,"Falkland Islands (Malvinas)",null,null,null,null,"Investment Servicing - Process Complete"]
[null,null,null,null,null,null,null,null,null,"Faroe Islands",null,null,null,null,"KiwiSaver Prospecting - New Prospect"]
[null,null,null,null,null,null,null,null,null,"Fiji",null,null,null,null,"KiwiSaver Prospecting - Emailed"]
[null,null,null,null,null,null,null,null,null,"Finland",null,null,null,null,"KiwiSaver Prospecting - Contact Attempted"]
[null,null,null,null,null,null,null,null,null,"France",null,null,null,null,"KiwiSaver Prospecting - Contact Made"]
[null,null,null,null,null,null,null,null,null,"French Guiana",null,null,null,null,"KiwiSaver Prospecting - Needs Confirmed"]
[null,null,null,null,null,null,null,null,null,"French Polynesia",null,null,null,null,"KiwiSaver Advice - New Lead"]
[null,null,null,null,null,null,null,null,null,"French Southern Territories",null,null,null,null,"KiwiSaver Advice - Fact Find Completed"]
[null,null,null,null,null,null,null,null,null,"Gabon",null,null,null,null,"KiwiSaver Advice - Plan Completed"]
[null,null,null,null,null,null,null,null,null,"Gambia",null,null,null,null,"KiwiSaver Advice - Plan Presented"]
[null,null,null,null,null,null,null,null,null,"Georgia",null,null,null,null,"KiwiSaver Advice - Commitment Received"]
[null,null,null,null,null,null,null,null,null,"Germany",null,null,null,null,"KiwiSaver Advice - Documents Received"]
[null,null,null,null,null,null,null,null,null,"Ghana",null,null,null,null,"KiwiSaver Advice - Application Submitted"]
[null,null,null,null,null,null,null,null,null,"Gibraltar",null,null,null,null,"KiwiSaver Advice - Application Approved"]
[null,null,null,null,null,null,null,null,null,"Greece",null,null,null,null,"KiwiSaver Advice - Commission Received"]
[null,null,null,null,null,null,null,null,null,"Greenland",null,null,null,null,"Complaints - Initial Contact"]
[null,null,null,null,null,null,null,null,null,"Grenada",null,null,null,null,"Complaints - Resolution In Progress"]
[null,null,null,null,null,null,null,null,null,"Guadeloupe",null,null,null,null,"Complaints - Internal Escalation"]
[null,null,null,null,null,null,null,null,null,"Guam",null,null,null,null,"Complaints - External Escalation"]
[null,null,null,null,null,null,null,null,null,"Guatemala",null,null,null,null,"Complaints - Outcome Reached"]
[null,null,null,null,null,null,null,null,null,"Guernsey"]
[null,null,null,null,null,null,null,null,null,"Guinea"]
[null,null,null,null,null,null,null,null,null,"Guinea-Bissau"]
[null,null,null,null,null,null,null,null,null,"Guyana"]
[null,null,null,null,null,null,null,null,null,"Haiti"]
[null,null,null,null,null,null,null,null,null,"Heard Island and McDonald Islands"]
[null,null,null,null,null,null,null,null,null,"Holy See (Vatican City State)"]
[null,null,null,null,null,null,null,null,null,"Honduras"]
[null,null,null,null,null,null,null,null,null,"Hong Kong"]
[null,null,null,null,null,null,null,null,null,"Hungary"]
[null,null,null,null,null,null,null,null,null,"Iceland"]
[null,null,null,null,null,null,null,null,null,"India"]
[null,null,null,null,null,null,null,null,null,"Indonesia"]
[null,null,null,null,null,null,null,null,null,"Iran"]
[null,null,null,null,null,null,null,null,null,"Iraq"]
[null,null,null,null,null,null,null,null,null,"Ireland"]
[null,null,null,null,null,null,null,null,null,"Isle of Man"]
[null,null,null,null,null,null,null,null,null,"Israel"]
[null,null,null,null,null,null,null,null,null,"Italy"]
[null,null,null,null,null,null,null,null,null,"Jamaica"]
[null,null,null,null,null,null,null,null,null,"Japan"]
[null,null,null,null,null,null,null,null,null,"Jersey"]
[null,null,null,null,null,null,null,null,null,"Jordan"]
[null,null,null,null,null,null,null,null,null,"Kazakhstan"]
[null,null,null,null,null,null,null,null,null,"Kenya"]
[null,null,null,null,null,null,null,null,null,"Kiribati"]
[null,null,null,null,null,null,null,null,null,"Kuwait"]
[null,null,null,null,null,null,null,null,null,"Kyrgyzstan"]
[null,null,null,null,null,null,null,null,null,"Lao Peoples Democratic Republic"]
[null,null,null,null,null,null,null,null,null,"Latvia"]
[null,null,null,null,null,null,null,null,null,"Lebanon"]
[null,null,null,null,null,null,null,null,null,"Lesotho"]
[null,null,null,null,null,null,null,null,null,"Liberia"]
[null,null,null,null,null,null,null,null,null,"Libyan Arab Jamahiriya"]
[null,null,null,null,null,null,null,null,null,"Liechtenstein"]
[null,null,null,null,null,null,null,null,null,"Lithuania"]
[null,null,null,null,null,null,null,null,null,"Luxembourg"]
[null,null,null,null,null,null,null,null,null,"Macao"]
[null,null,null,null,null,null,null,null,null,"Macedonia"]
[null,null,null,null,null,null,null,null,null,"Madagascar"]
[null,null,null,null,null,null,null,null,null,"Malawi"]
[null,null,null,null,null,null,null,null,null,"Malaysia"]
[null,null,null,null,null,null,null,null,null,"Maldives"]
[null,null,null,null,null,null,null,null,null,"Mali"]
[null,null,null,null,null,null,null,null,null,"Malta"]
[null,null,null,null,null,null,null,null,null,"Marshall Islands"]
[null,null,null,null,null,null,null,null,null,"Martinique"]
[null,null,null,null,null,null,null,null,null,"Mauritania"]
[null,null,null,null,null,null,null,null,null,"Mauritius"]
[null,null,null,null,null,null,null,null,null,"Mayotte"]
[null,null,null,null,null,null,null,null,null,"Mexico"]
[null,null,null,null,null,null,null,null,null,"Micronesia"]
[null,null,null,null,null,null,null,null,null,"Moldova"]
[null,null,null,null,null,null,null,null,null,"Monaco"]
[null,null,null,null,null,null,null,null,null,"Mongolia"]
[null,null,null,null,null,null,null,null,null,"Montenegro"]
[null,null,null,null,null,null,null,null,null,"Montserrat"]
[null,null,null,null,null,null,null,null,null,"Morocco"]
[null,null,null,null,null,null,null,null,null,"Mozambique"]
[null,null,null,null,null,null,null,null,null,"Myanmar"]
[null,null,null,null,null,null,null,null,null,"Namibia"]
[null,null,null,null,null,null,null,null,null,"Nauru"]
[null,null,null,null,null,null,null,null,null,"Nepal"]
[null,null,null,null,null,null,null,null,null,"Netherlands"]
[null,null,null,null,null,null,null,null,null,"New Caledonia"]
[null,null,null,null,null,null,null,null,null,"New Zealand"]
[null,null,null,null,null,null,null,null,null,"Nicaragua"]
[null,null,null,null,null,null,null,null,null,"Niger"]
[null,null,null,null,null,null,null,null,null,"Nigeria"]
[null,null,null,null,null,null,null,null,null,"Niue"]
[null,null,null,null,null,null,null,null,null,"Norfolk Island"]
[null,null,null,null,null,null,null,null,null,"North Korea"]
[null,null,null,null,null,null,null,null,null,"Northern Mariana Islands"]
[null,null,null,null,null,null,null,null,null,"Norway"]
[null,null,null,null,null,null,null,null,null,"Oman"]
[null,null,null,null,null,null,null,null,null,"Pakistan"]
[null,null,null,null,null,null,null,null,null,"Palau"]
[null,null,null,null,null,null,null,null,null,"Palestine"]
[null,null,null,null,null,null,null,null,null,"Panama"]
[null,null,null,null,null,null,null,null,null,"Papua New Guinea"]
[null,null,null,null,null,null,null,null,null,"Paraguay"]
[null,null,null,null,null,null,null,null,null,"Peru"]
[null,null,null,null,null,null,null,null,null,"Philippines"]
[null,null,null,null,null,null,null,null,null,"Pitcairn"]
[null,null,null,null,null,null,null,null,null,"Poland"]
[null,null,null,null,null,null,null,null,null,"Portugal"]
[null,null,null,null,null,null,null,null,null,"Puerto Rico"]
[null,null,null,null,null,null,null,null,null,"Qatar"]
[null,null,null,null,null,null,null,null,null,"Réunion"]
[null,null,null,null,null,null,null,null,null,"Romania"]
[null,null,null,null,null,null,null,null,null,"Russian Federation"]
[null,null,null,null,null,null,null,null,null,"Rwanda"]
[null,null,null,null,null,null,null,null,null,"Saint Barthélemy"]
[null,null,null,null,null,null,null,null,null,"Saint Helena"]
[null,null,null,null,null,null,null,null,null,"Saint Kitts and Nevis"]
[null,null,null,null,null,null,null,null,null,"Saint Lucia"]
[null,null,null,null,null,null,null,null,null,"Saint Martin (French Part)"]
[null,null,null,null,null,null,null,null,null,"Saint Pierre and Miquelon"]
[null,null,null,null,null,null,null,null,null,"Saint Vincent and the Grenadines"]
[null,null,null,null,null,null,null,null,null,"Samoa"]
[null,null,null,null,null,null,null,null,null,"San Marino"]
[null,null,null,null,null,null,null,null,null,"Sao Tome and Principe"]
[null,null,null,null,null,null,null,null,null,"Saudi Arabia"]
[null,null,null,null,null,null,null,null,null,"Senegal"]
[null,null,null,null,null,null,null,null,null,"Serbia"]
[null,null,null,null,null,null,null,null,null,"Seychelles"]
[null,null,null,null,null,null,null,null,null,"Sierra Leone"]
[null,null,null,null,null,null,null,null,null,"Singapore"]
[null,null,null,null,null,null,null,null,null,"Sint Maarten (Dutch Part)"]
[null,null,null,null,null,null,null,null,null,"Slovakia"]
[null,null,null,null,null,null,null,null,null,"Slovenia"]
[null,null,null,null,null,null,null,null,null,"Solomon Islands"]
[null,null,null,null,null,null,null,null,null,"Somalia"]
[null,null,null,null,null,null,null,null,null,"South Africa"]
[null,null,null,null,null,null,null,null,null,"South Georgia and the South Sandwich Islands"]
[null,null,null,null,null,null,null,null,null,"South Korea"]
[null,null,null,null,null,null,null,null,null,"South Sudan"]
[null,null,null,null,null,null,null,null,null,"Spain"]
[null,null,null,null,null,null,null,null,null,"Sri Lanka"]
[null,null,null,null,null,null,null,null,null,"Sudan"]
[null,null,null,null,null,null,null,null,null,"Suriname"]
[null,null,null,null,null,null,null,null,null,"Svalbard and Jan Mayen"]
[null,null,null,null,null,null,null,null,null,"Swaziland"]
[null,null,null,null,null,null,null,null,null,"Sweden"]
[null,null,null,null,null,null,null,null,null,"Switzerland"]
[null,null,null,null,null,null,null,null,null,"Syrian Arab Republic"]
[null,null,null,null,null,null,null,null,null,"Taiwan"]
[null,null,null,null,null,null,null,null,null,"Tajikistan"]
[null,null,null,null,null,null,null,null,null,"Tanzania"]
[null,null,null,null,null,null,null,null,null,"Thailand"]
[null,null,null,null,null,null,null,null,null,"Timor-Leste"]
[null,null,null,null,null,null,null,null,null,"Togo"]
[null,null,null,null,null,null,null,null,null,"Tokelau"]
[null,null,null,null,null,null,null,null,null,"Tonga"]
[null,null,null,null,null,null,null,null,null,"Trinidad and Tobago"]
[null,null,null,null,null,null,null,null,null,"Tunisia"]
[null,null,null,null,null,null,null,null,null,"Turkey"]
[null,null,null,null,null,null,null,null,null,"Turkmenistan"]
[null,null,null,null,null,null,null,null,null,"Turks and Caicos Islands"]
[null,null,null,null,null,null,null,null,null,"Tuvalu"]
[null,null,null,null,null,null,null,null,null,"Uganda"]
[null,null,null,null,null,null,null,null,null,"Ukraine"]
[null,null,null,null,null,null,null,null,null,"United Arab Emirates"]
[null,null,null,null,null,null,null,null,null,"United Kingdom"]
[null,null,null,null,null,null,null,null,null,"United States"]
[null,null,null,null,null,null,null,null,null,"United States Minor Outlying Islands"]
[null,null,null,null,null,null,null,null,null,"Uruguay"]
[null,null,null,null,null,null,null,null,null,"Uzbekistan"]
[null,null,null,null,null,null,null,null,null,"Vanuatu"]
[null,null,null,null,null,null,null,null,null,"Venezuela"]
[null,null,null,null,null,null,null,null,null,"Vietnam"]
[null,null,null,null,null,null,null,null,null,"Virgin Islands, British"]
[null,null,null,null,null,null,null,null,null,"Virgin Islands, U.S."]
[null,null,null,null,null,null,null,null,null,"Wallis and Futuna"]
[null,null,null,null,null,null,null,null,null,"Western Sahara"]
[null,null,null,null,null,null,null,null,null,"Yemen"]
[null,null,null,null,null,null,null,null,null,"Zambia"]
[null,null,null,null,null,null,null,null,null,"Zimbabwe"]

{"sheet":"APPENDIX - KiwiSaver","index":15,"n_rows":354,"n_cols":5,"rows_kept":354,"cut":false,"hidden":true,"merged":[]}
["Provider Name","Fund","FundStatus","Fund Type","Growth Percentage"]
["AE KiwiSaver Plan","AE KiwiSaver Plan","Open","Balanced",41.47]
["AMP KiwiSaver Scheme","Macquarie Global Multi-Asset Fund","ClosedNewInvestors"]
["AMP KiwiSaver Scheme","Macquarie Income Generator Fund","ClosedNewInvestors"]
["AMP KiwiSaver Scheme","AMP Defensive Conservative Fund","ClosedNewInvestors"]
["AMP KiwiSaver Scheme","AMP Cash Fund","Open","Defensive",0]
["AMP KiwiSaver Scheme","AMP Global Fixed Interest Fund","Open","Defensive",0]
["AMP KiwiSaver Scheme","AMP NZ Fixed Interest Fund","Open","Defensive",0]
["AMP KiwiSaver Scheme","Milford Conservative Fund","Open","Conservative",13.1]
["AMP KiwiSaver Scheme","ANZ Conservative Fund","Open","Conservative",19.010000000000002]
["AMP KiwiSaver Scheme","AMP Conservative Fund (Lifesteps)","Open","Conservative",24.02]
["AMP KiwiSaver Scheme","AMP Conservative Fund","Open","Conservative",24.02]
["AMP KiwiSaver Scheme","Nikko AM Conservative Fund","Open","Conservative",24.77]
["AMP KiwiSaver Scheme","AMP Moderate Fund","Open","Balanced",36.9]
["AMP KiwiSaver Scheme","AMP Moderate Fund (Lifesteps)","Open","Balanced",36.9]
["AMP KiwiSaver Scheme","Milford Balanced Fund","Open","Balanced",41.16]
["AMP KiwiSaver Scheme","ASB Moderate Fund","Open","Balanced",41.32]
["AMP KiwiSaver Scheme","AMP Moderate Balanced Fund","Open","Balanced",46.82]
["AMP KiwiSaver Scheme","AMP Moderate Balanced Fund (Lifesteps)","Open","Balanced",46.82]
["AMP KiwiSaver Scheme","AMP Balanced Fund (Lifesteps)","Open","Balanced",56.78]
["AMP KiwiSaver Scheme","AMP Balanced Fund","Open","Balanced",56.78]
["AMP KiwiSaver Scheme","AMP Balanced Fund No. 2","Open","Balanced",56.78]
["AMP KiwiSaver Scheme","Mercer Balanced Fund","Open","Balanced",60.78]
["AMP KiwiSaver Scheme","ASB Balanced Fund","Open","Balanced",61.27]
["AMP KiwiSaver Scheme","Milford Active Growth Fund","Open","Balanced",62.68]
["AMP KiwiSaver Scheme","ANZ Balanced Growth Fund","Open","Growth",64]
["AMP KiwiSaver Scheme","Nikko AM Balanced Fund","Open","Growth",68.69]
["AMP KiwiSaver Scheme","AMP Growth Fund (Lifesteps)","Open","Growth",76.900000000000006]
["AMP KiwiSaver Scheme","AMP Growth Fund","Open","Growth",76.900000000000006]
["AMP KiwiSaver Scheme","ANZ Growth Fund","Open","Growth",78.81]
["AMP KiwiSaver Scheme","ASB Growth Fund","Open","Growth",81.2]
["AMP KiwiSaver Scheme","AMP Aggressive Fund","Open","Growth",85.85]
["AMP KiwiSaver Scheme","AMP Aggressive Fund (Lifesteps)","Open","Growth",85.85]
["AMP KiwiSaver Scheme","Nikko AM Growth Fund","Open","Growth",87.5]
["AMP KiwiSaver Scheme","Milford Aggressive Fund","Open","Growth",89.65]
["AMP KiwiSaver Scheme","ANZ Property Fund","Open","Aggressive",94.72]
["AMP KiwiSaver Scheme","AMP Australasian Shares Fund","Open","Aggressive",99.84]
["AMP KiwiSaver Scheme","AMP International Shares Fund No. 2","Open","Aggressive",100]
["AMP KiwiSaver Scheme","AMP International Shares Fund","Open","Aggressive",100]
["ANZ Default KiwiSaver Scheme","Growth Fund","ClosedNewInvestors"]
["ANZ Default KiwiSaver Scheme","Balanced Growth Fund","ClosedNewInvestors"]
["ANZ Default KiwiSaver Scheme","Balanced Fund","ClosedNewInvestors"]
["ANZ Default KiwiSaver Scheme","Conservative Balanced Fund","ClosedNewInvestors"]
["ANZ Default KiwiSaver Scheme","Conservative Fund","ClosedNewInvestors"]
["ANZ Default KiwiSaver Scheme","Cash Fund","ClosedNewInvestors"]
["ANZ KiwiSaver Scheme","Cash Fund","Open","Defensive",0]
["ANZ KiwiSaver Scheme","Conservative Fund","Open","Conservative",19.010000000000002]
["ANZ KiwiSaver Scheme","Conservative Balanced Fund","Open","Conservative",34.24]
["ANZ KiwiSaver Scheme","Balanced Fund","Open","Balanced",49.29]
["ANZ KiwiSaver Scheme","Balanced Growth Fund","Open","Growth",63.99]
["ANZ KiwiSaver Scheme","Growth Fund","Open","Growth",78.81]
["AON KiwiSaver Scheme","ANZ Cash Fund","Disestablished"]
["AON KiwiSaver Scheme","Russell Lifepoints® Target Date 2055 Fund","Disestablished"]
["AON KiwiSaver Scheme","Nikko Cash Fund","Disestablished"]
["AON KiwiSaver Scheme","Russell Lifepoints® Conservative Fund","Disestablished"]
["AON KiwiSaver Scheme","Russell Lifepoints® Moderate Fund","Disestablished"]
["AON KiwiSaver Scheme","ANZ Balanced Fund","Disestablished"]
["AON KiwiSaver Scheme","Nikko Balanced Fund","Disestablished"]
["AON KiwiSaver Scheme","Russell Lifepoints® Balanced Fund","Disestablished"]
["AON KiwiSaver Scheme","Milford Active Growth Wholesale Fund","Disestablished"]
["AON KiwiSaver Scheme","Russell Lifepoints® Growth Fund","Disestablished"]
["AON KiwiSaver Scheme","Russell Lifepoints® Target Date 2015 Fund","Disestablished"]
["AON KiwiSaver Scheme","Russell Lifepoints® Target Date 2025 Fund","Disestablished"]
["AON KiwiSaver Scheme","Russell Lifepoints® Target Date 2035 Fund","Disestablished"]
["AON KiwiSaver Scheme","Russell Lifepoints® Target Date 2045 Fund","Disestablished"]
["ASB KiwiSaver Scheme","NZ Cash Fund","Open","Defensive",0]
["ASB KiwiSaver Scheme","Conservative Fund","Open","Conservative",21.87]
["ASB KiwiSaver Scheme","Moderate Fund","Open","Balanced",41.58]
["ASB KiwiSaver Scheme","Positive Impact Fund","Open","Balanced",56.71]
["ASB KiwiSaver Scheme","Balanced Fund","Open","Balanced",61.44]
["ASB KiwiSaver Scheme","Growth Fund","Open","Growth",81.2]
["Aurora KiwiSaver Scheme","Aurora Liquidity Fund","Open","Defensive",0]
["Aurora KiwiSaver Scheme","Aurora Conservative Fund","Open","Conservative",30.12]
["Aurora KiwiSaver Scheme","Aurora Retirementplus Age 75","Open","Balanced",36.92]
["Aurora KiwiSaver Scheme","Aurora Retirementplus Age 65","Open","Balanced",52.79]
["Aurora KiwiSaver Scheme","Aurora Future Focused Fund","Open","Growth",70.94]
["Aurora KiwiSaver Scheme","Aurora Retirementplus Age 50","Open","Growth",75.459999999999994]
["Aurora KiwiSaver Scheme","Aurora Growth Fund","Open","Growth",79.98]
["BCF KiwiSaver Scheme","BCF KiwiSaver Scheme","Open","Defensive",0]
["BNZ KiwiSaver Scheme","BNZ KiwiSaver Cash Fund","Open","Defensive",0]
["BNZ KiwiSaver Scheme","BNZ KiwiSaver First Home Buyer Fund","Open","Conservative",13.11]
["BNZ KiwiSaver Scheme","BNZ KiwiSaver Conservative Fund","Open","Conservative",19.2]
["BNZ KiwiSaver Scheme","BNZ KiwiSaver Moderate Fund","Open","Balanced",38.159999999999997]
["BNZ KiwiSaver Scheme","BNZ KiwiSaver Balanced Fund","Open","Balanced",57.96]
["BNZ KiwiSaver Scheme","BNZ KiwiSaver Default Fund","Open","Balanced",58.01]
["BNZ KiwiSaver Scheme","BNZ KiwiSaver Growth Fund","Open","Growth",77]
["Booster KiwiSaver Scheme","Conservative Fund","ClosedNewInvestors"]
["Booster KiwiSaver Scheme","Trans-Tasman Share Fund","Disestablished"]
["Booster KiwiSaver Scheme","International Share Fund","Disestablished"]
["Booster KiwiSaver Scheme","Options Fund","Disestablished"]
["Booster KiwiSaver Scheme","Enhanced Cash Fund","Open","Defensive",0]
["Booster KiwiSaver Scheme","Capital Guaranteed Fund","Open","Defensive",5.76]
["Booster KiwiSaver Scheme","Socially Responsible Moderate Fund","Open","Conservative",31.41]
["Booster KiwiSaver Scheme","Asset Class Conservative Fund","Open","Conservative",32.5]
["Booster KiwiSaver Scheme","Moderate Fund","Open","Conservative",34.729999999999997]
["Booster KiwiSaver Scheme","Default Saver Fund","Open","Balanced",54.13]
["Booster KiwiSaver Scheme","Socially Responsible Balanced Fund","Open","Balanced",55.03]
["Booster KiwiSaver Scheme","Balanced Fund","Open","Balanced",58.44]
["Booster KiwiSaver Scheme","Asset Class Balanced Fund","Open","Balanced",59.49]
["Booster KiwiSaver Scheme","Socially Responsible Growth Fund","Open","Growth",75.900000000000006]
["Booster KiwiSaver Scheme","Growth Fund","Open","Growth",79.03]
["Booster KiwiSaver Scheme","Socially Responsible High Growth Fund","Open","Growth",89.1]
["Booster KiwiSaver Scheme","Asset Class Growth Fund","Open","Growth",89.66]
["Booster KiwiSaver Scheme","Shielded Growth Fund","Open","Aggressive",91.93]
["Booster KiwiSaver Scheme","High Growth Fund","Open","Aggressive",94.52]
["Booster KiwiSaver Scheme","Socially Responsible Geared Growth Fund","Open","Aggressive",97.69]
["Booster KiwiSaver Scheme","Geared Growth Fund","Open","Aggressive",98.57]
["Christian KiwiSaver Scheme","Income Fund","Open","Defensive",0]
["Christian KiwiSaver Scheme","Balanced Fund","Open","Balanced",48.48]
["Christian KiwiSaver Scheme","Growth Fund","Open","Growth",72.48]
["Fisher Funds KiwiSaver Scheme","Conservative Fund","Open","Conservative",27.73]
["Fisher Funds KiwiSaver Scheme","Glidepath Age 75","Open","Conservative",32.54]
["Fisher Funds KiwiSaver Scheme","Glidepath Age 60","Open","Balanced",50.72]
["Fisher Funds KiwiSaver Scheme","Balanced Strategy","Open","Balanced",59.81]
["Fisher Funds KiwiSaver Scheme","Glidepath Age 50","Open","Growth",73.72]
["Fisher Funds KiwiSaver Scheme","Growth Fund","Open","Growth",81.2]
["Fisher Funds KiwiSaver Scheme","Glidepath Age 30","Open","Growth",81.2]
["Fisher Funds Two KiwiSaver Scheme","Cash Enhanced Fund","ClosedNewInvestors"]
["Fisher Funds Two KiwiSaver Scheme","Preservation Fund","Open","Defensive",0]
["Fisher Funds Two KiwiSaver Scheme","Glidepath Age 75","Open","Conservative",25.82]
["Fisher Funds Two KiwiSaver Scheme","Conservative Fund","Open","Conservative",28.07]
["Fisher Funds Two KiwiSaver Scheme","Glidepath Age 65","Open","Conservative",33.46]
["Fisher Funds Two KiwiSaver Scheme","Balanced Fund","Open","Balanced",59.75]
["Fisher Funds Two KiwiSaver Scheme","Glidepath Age 55","Open","Balanced",62.14]
["Fisher Funds Two KiwiSaver Scheme","Growth Fund","Open","Growth",81.52]
["Fisher Funds Two KiwiSaver Scheme","Glidepath Age 40","Open","Growth",85.86]
["Fisher Funds Two KiwiSaver Scheme","Equity Fund","Open","Aggressive",95.08]
["Fisher Funds Two KiwiSaver Scheme","Glidepath Age 25","Open","Aggressive",95.08]
["Generate KiwiSaver Scheme","Stepping Stones Growth 61-64","Disestablished"]
["Generate KiwiSaver Scheme","Stepping Stones Growth 65+","Disestablished"]
["Generate KiwiSaver Scheme","Stepping Stones 65+","Disestablished"]
["Generate KiwiSaver Scheme","Defensive Fund","Open","Defensive",0]
["Generate KiwiSaver Scheme","Conservative Fund","Open","Conservative",18.16]
["Generate KiwiSaver Scheme","Stepping Stones 76+","Open","Conservative",18.16]
["Generate KiwiSaver Scheme","Stepping Stones Growth 76+","Open","Conservative",18.16]
["Generate KiwiSaver Scheme","Stepping Stones 65-75","Open","Conservative",28.07]
["Generate KiwiSaver Scheme","Stepping Stones Growth 61-75","Open","Balanced",37.97]
["Generate KiwiSaver Scheme","Moderate Fund","Open","Balanced",37.97]
["Generate KiwiSaver Scheme","Stepping Stones 61-64","Open","Balanced",37.97]
["Generate KiwiSaver Scheme","Stepping Stones 56-60","Open","Balanced",47.57]
["Generate KiwiSaver Scheme","Stepping Stones 46-55","Open","Balanced",57.16]
["Generate KiwiSaver Scheme","Balanced Fund","Open","Balanced",57.16]
["Generate KiwiSaver Scheme","Stepping Stones Growth 56-60","Open","Balanced",57.16]
["Generate KiwiSaver Scheme","Stepping Stones Growth 51-55","Open","Growth",76.88]
["Generate KiwiSaver Scheme","Stepping Stones 36-45","Open","Growth",76.88]
["Generate KiwiSaver Scheme","Growth Fund","Open","Growth",76.88]
["Generate KiwiSaver Scheme","Focused Growth Fund","Open","Aggressive",91.22]
["Generate KiwiSaver Scheme","Stepping Stones Growth 0-50","Open","Aggressive",91.22]
["Generate KiwiSaver Scheme","Stepping Stones 0-35","Open","Aggressive",91.22]
["Investnow KiwiSaver Scheme","Investnow Macquarie Australasian Property Index Fund","Disestablished"]
["Investnow KiwiSaver Scheme","Investnow Foundation Series Total World Fund","Registered"]
["Investnow KiwiSaver Scheme","Investnow Foundation Series US 500 Fund","Registered"]
["Investnow KiwiSaver Scheme","Investnow Harbour NZ Core Fixed Interest Fund","Open","Defensive",0]
["Investnow KiwiSaver Scheme","Investnow Macquarie Ethical Leaders Hedged Global Fixed Interest Index Fund","Open","Defensive",0]
["Investnow KiwiSaver Scheme","Investnow Hunter Global Fixed Interest Fund","Open","Defensive",0]
["Investnow KiwiSaver Scheme","Investnow Macquarie NZ Cash Fund","Open","Defensive",0]
["Investnow KiwiSaver Scheme","Investnow Macquarie NZ Fixed Interest Fund","Open","Defensive",0]
["Investnow KiwiSaver Scheme","Investnow Russell Investments Global Fixed Interest Fund","Open","Defensive",1.56]
["Investnow KiwiSaver Scheme","Investnow Russell Investments NZ Fixed Interest Fund","Open","Defensive",3.64]
["Investnow KiwiSaver Scheme","Investnow Milford Conservative Fund","Open","Conservative",13.1]
["Investnow KiwiSaver Scheme","Investnow Fisher Funds Conservative Fund","Open","Conservative",28.07]
["Investnow KiwiSaver Scheme","Investnow Mint Diversified Income Fund","Open","Conservative",30.33]
["Investnow KiwiSaver Scheme","Investnow Milford Balanced Fund","Open","Balanced",41.16]
["Investnow KiwiSaver Scheme","Investnow Castle Point 5 Oceans Fund","Open","Balanced",51.61]
["Investnow KiwiSaver Scheme","Investnow Foundation Series Balanced Fund","Open","Balanced",58.73]
["Investnow KiwiSaver Scheme","Investnow Milford Active Growth Fund","Open","Balanced",61.68]
["Investnow KiwiSaver Scheme","Investnow Macquarie Ethical Leaders Balanced Fund","Open","Growth",66.819999999999993]
["Investnow KiwiSaver Scheme","Investnow Pathfinder Ethical Growth Fund","Open","Growth",70.06]
["Investnow KiwiSaver Scheme","Investnow Harbour Active Growth Fund","Open","Growth",72.180000000000007]
["Investnow KiwiSaver Scheme","Investnow Foundation Series Growth Fund","Open","Growth",78.41]
["Investnow KiwiSaver Scheme","Investnow Smartshares Growth Fund","Open","Growth",79.989999999999995]
["Investnow KiwiSaver Scheme","Investnow Mint Diversified Growth Fund","Open","Growth",80.41]
["Investnow KiwiSaver Scheme","Investnow Fisher Funds Growth Fund","Open","Growth",81.150000000000006]
["Investnow KiwiSaver Scheme","Investnow Antipodes Global Fund - Long","Open","Aggressive",94.53]
["Investnow KiwiSaver Scheme","Investnow Harbour Australasian Equity Focus Fund","Open","Aggressive",96.02]
["Investnow KiwiSaver Scheme","Investnow Macquarie All Country Global Shares Index Fund","Open","Aggressive",96.65]
["Investnow KiwiSaver Scheme","Investnow Castle Point Trans-Tasman Fund","Open","Aggressive",97.62]
["Investnow KiwiSaver Scheme","Investnow Salt NZ Dividend Appreciation Fund","Open","Aggressive",97.79]
["Investnow KiwiSaver Scheme","Investnow Te Ahumairangi Global Equity Fund","Open","Aggressive",97.89]
["Investnow KiwiSaver Scheme","Investnow Mint Australasian Equity Fund","Open","Aggressive",98.03]
["Investnow KiwiSaver Scheme","Investnow Clarity Global Shares Fund","Open","Aggressive",98.2]
["Investnow KiwiSaver Scheme","Investnow Macquarie NZ Shares Index Fund","Open","Aggressive",98.62]
["Investnow KiwiSaver Scheme","Investnow Russell Investments Global Shares Fund","Open","Aggressive",98.77]
["Investnow KiwiSaver Scheme","Investnow Russell Investments Hedged Global Shares Fund","Open","Aggressive",98.77]
["Investnow KiwiSaver Scheme","Investnow Macquarie Global Listed Real Estate Fund","Open","Aggressive",99.14]
["Investnow KiwiSaver Scheme","Investnow Salt Enhanced Property Fund","Open","Aggressive",99.34]
["Investnow KiwiSaver Scheme","Investnow Harbour T. Rowe Price Global Equity Fund","Open","Aggressive",99.44]
["Juno KiwiSaver Scheme","Juno Conservative Fund","Open","Conservative",18.760000000000002]
["Juno KiwiSaver Scheme","Juno Balanced Fund","Open","Balanced",48.96]
["Juno KiwiSaver Scheme","Juno Growth Fund","Open","Growth",67.959999999999994]
["Kernel KiwiSaver Plan","Kernel Cash Plus Fund","Open","Defensive",0]
["Kernel KiwiSaver Plan","Kernel Balanced Fund","Open","Balanced",60.06]
["Kernel KiwiSaver Plan","Kernel High Growth Fund","Open","Aggressive",97.89]
["Kernel KiwiSaver Plan","Kernel S&P 500 Fund","Open","Aggressive",98.7]
["Kernel KiwiSaver Plan","Kernel Global Infrastructure (NZD Hedged) Fund","Open","Aggressive",99.58]
["Kernel KiwiSaver Plan","Kernel S&P Global 100 (NZD Hedged) Fund","Open","Aggressive",99.65]
["Kernel KiwiSaver Plan","Kernel Global Infrastructure Fund","Open","Aggressive",99.83]
["Kernel KiwiSaver Plan","Kernel S&P Global Clean Energy Fund","Open","Aggressive",99.87]
["Kernel KiwiSaver Plan","Kernel S&P Kensho Electric Vehicle Innovation Fund","Open","Aggressive",99.95]
["Kernel KiwiSaver Plan","Kernel S&P Global 100 Fund","Open","Aggressive",99.96]
["Kernel KiwiSaver Plan","Kernel S&P Global Dividend Aristocrats Fund","Open","Aggressive",99.96]
["Kernel KiwiSaver Plan","Kernel S&P Kensho Moonshots Innovation Fund","Open","Aggressive",99.99]
["Kernel KiwiSaver Plan","Kernel NZ Commercial Property Fund","Open","Aggressive",99.99]
["Kernel KiwiSaver Plan","Kernel NZ 50 Esg Tilted Fund","Open","Aggressive",100]
["Kernel KiwiSaver Plan","Kernel NZ 20 Fund","Open","Aggressive",100]
["Kernel KiwiSaver Plan","Kernel NZ Small & Mid Cap Opportunities Fund","Open","Aggressive",100.21]
["Kernel KiwiSaver Plan","Kernel Global Green Property Fund","Open","Aggressive",100.47]
["Kiwi Wealth KiwiSaver Scheme","Cashplus","ClosedNewInvestors"]
["Kiwi Wealth KiwiSaver Scheme","Cash","Open","Defensive",0]
["Kiwi Wealth KiwiSaver Scheme","Default","Open","Conservative",19.48]
["Kiwi Wealth KiwiSaver Scheme","Conservative","Open","Conservative",31.36]
["Kiwi Wealth KiwiSaver Scheme","Balanced","Open","Balanced",59.63]
["Kiwi Wealth KiwiSaver Scheme","Default","Open","Balanced",59.7]
["Kiwi Wealth KiwiSaver Scheme","Growth","Open","Growth",84.4]
["Koura KiwiSaver Scheme","New Zealand Cash Fund","Open","Defensive",0]
["Koura KiwiSaver Scheme","New Zealand Fixed Interest Fund","Open","Defensive",0]
["Koura KiwiSaver Scheme","NZ Property Fund","Open","Aggressive",92.83]
["Koura KiwiSaver Scheme","Clean Energy Fund","Open","Aggressive",98.36]
["Koura KiwiSaver Scheme","New Zealand Equities Fund","Open","Aggressive",98.95]
["Koura KiwiSaver Scheme","Emerging Markets Equities Fund","Open","Aggressive",99.04]
["Koura KiwiSaver Scheme","US Equities Fund","Open","Aggressive",99.27]
["Koura KiwiSaver Scheme","Carbon Neutral Cryptocurrency Fund","Open","Aggressive",99.29]
["Koura KiwiSaver Scheme","Rest Of World Equities Fund","Open","Aggressive",99.42]
["Lifestages KiwiSaver Scheme","Lifestages Auto Option Age 0 - 34","Disestablished"]
["Lifestages KiwiSaver Scheme","Lifestages Auto Option Age 35 - 44","Disestablished"]
["Lifestages KiwiSaver Scheme","Lifestages Auto Option Age 45 - 54","Disestablished"]
["Lifestages KiwiSaver Scheme","Lifestages Auto Option Age 55 - 64","Disestablished"]
["Lifestages KiwiSaver Scheme","Lifestages Capital Stable Portfolio","Disestablished"]
["Lifestages KiwiSaver Scheme","Lifestages Growth Portfolio","Disestablished"]
["Lifestages KiwiSaver Scheme","Lifestages Income Fund","Open","Conservative",11.69]
["Lifestages KiwiSaver Scheme","Lifestages Auto Option Age 65+","Open","Balanced",37.049999999999997]
["Lifestages KiwiSaver Scheme","Lifestages Auto Option Age 60 - 64","Open","Balanced",45.52]
["Lifestages KiwiSaver Scheme","Lifestages Auto Option Age 55 - 59","Open","Balanced",62.45]
["Lifestages KiwiSaver Scheme","Lifestages Auto Option Age 50 - 54","Open","Growth",79.349999999999994]
["Lifestages KiwiSaver Scheme","Lifestages High Growth Fund","Open","Aggressive",96.28]
["Lifestages KiwiSaver Scheme","Lifestages Auto Option Age 0 - 49","Open","Aggressive",96.28]
["Maritime KiwiSaver Scheme","Conservative Portfolio","Open","Conservative",20.82]
["Maritime KiwiSaver Scheme","Balanced Portfolio","Open","Balanced",60.82]
["Maritime KiwiSaver Scheme","Growth Portfolio","Open","Growth",80]
["MAS KiwiSaver Scheme","Cash Fund","Open","Defensive",0]
["MAS KiwiSaver Scheme","Conservative Fund","Open","Conservative",18.97]
["MAS KiwiSaver Scheme","Moderate Fund","Open","Balanced",38.270000000000003]
["MAS KiwiSaver Scheme","Balanced Fund","Open","Balanced",57.25]
["MAS KiwiSaver Scheme","Growth Fund","Open","Growth",76.11]
["MAS KiwiSaver Scheme","Aggressive Fund","Open","Growth",85.69]
["MAS KiwiSaver Scheme","Global Equities Fund","Open","Aggressive",95.29]
["Mercer KiwiSaver Scheme","Cash Fund","Open","Defensive",0]
["Mercer KiwiSaver Scheme","Sustainable Conservative Fund","Open","Conservative",19.93]
["Mercer KiwiSaver Scheme","Sustainable Plus Moderate Fund","Open","Balanced",40.54]
["Mercer KiwiSaver Scheme","Sustainable Plus Balanced Fund","Open","Balanced",59.59]
["Mercer KiwiSaver Scheme","Sustainable Plus Growth Fund","Open","Growth",79.540000000000006]
["Mercer KiwiSaver Scheme","Sustainable Plus High Growth Fund","Open","Aggressive",93.85]
["Mercer KiwiSaver Scheme","Sustainable Plus Shares Fund","Open","Aggressive",98.79]
["Milford KiwiSaver Plan","Milford KiwiSaver Cash Fund","Open","Defensive",0]
["Milford KiwiSaver Plan","Milford KiwiSaver Conservative Fund","Open","Conservative",12.88]
["Milford KiwiSaver Plan","Milford KiwiSaver Moderate Fund","Open","Conservative",26.47]
["Milford KiwiSaver Plan","Milford KiwiSaver Balanced Fund","Open","Balanced",40.93]
["Milford KiwiSaver Plan","Milford KiwiSaver Active Growth Fund","Open","Growth",63.6]
["Milford KiwiSaver Plan","Milford KiwiSaver Aggressive Fund","Open","Growth",88.72]
["New Zealand Defence Force KiwiSaver Scheme","Cash Fund","Open","Defensive",0]
["New Zealand Defence Force KiwiSaver Scheme","Conservative Fund","Open","Conservative",19.260000000000002]
["New Zealand Defence Force KiwiSaver Scheme","Moderate Fund","Open","Balanced",38.86]
["New Zealand Defence Force KiwiSaver Scheme","Balanced Fund","Open","Balanced",58.59]
["New Zealand Defence Force KiwiSaver Scheme","Growth Fund","Open","Growth",77.989999999999995]
["New Zealand Defence Force KiwiSaver Scheme","High Growth Fund","Open","Aggressive",93.81]
["New Zealand Defence Force KiwiSaver Scheme","Shares Fund","Open","Aggressive",97.87]
["Nikko AM KiwiSaver Scheme","Option Fund","Disestablished"]
["Nikko AM KiwiSaver Scheme","NZ Cash Fund","Open","Defensive",0]
["Nikko AM KiwiSaver Scheme","NZ Corporate Bond Fund","Open","Defensive",0]
["Nikko AM KiwiSaver Scheme","Conservative Fund","Open","Conservative",24.53]
["Nikko AM KiwiSaver Scheme","Balanced Fund","Open","Growth",68.569999999999993]
["Nikko AM KiwiSaver Scheme","Growth Fund","Open","Growth",87.34]
["Nikko AM KiwiSaver Scheme","ARK Disruptive Innovation Fund","Open","Aggressive",92]
["Nikko AM KiwiSaver Scheme","SRI Equity Fund","Open","Aggressive",96.72]
["Nikko AM KiwiSaver Scheme","Global Shares Fund","Open","Aggressive",96.93]
["NZ Funds KiwiSaver Scheme","Income Strategy","Open","Defensive",0]
["NZ Funds KiwiSaver Scheme","Balanced Fund","Open","Balanced",49.33]
["NZ Funds KiwiSaver Scheme","Life Cycle - Age 75","Open","Balanced",60.33]
["NZ Funds KiwiSaver Scheme","Life Cycle - Age 65","Open","Growth",68.05]
["NZ Funds KiwiSaver Scheme","Inflation Strategy","Open","Growth",87.37]
["NZ Funds KiwiSaver Scheme","Life Cycle - Age 0-54","Open","Aggressive",90.44]
["NZ Funds KiwiSaver Scheme","Growth Strategy","Open","Aggressive",95.45]
["Oneanswer KiwiSaver Scheme","Cash Fund","Open","Defensive",0]
["Oneanswer KiwiSaver Scheme","New Zealand Fixed Interest Fund","Open","Defensive",0]
["Oneanswer KiwiSaver Scheme","International Fixed Interest Fund","Open","Defensive",0]
["Oneanswer KiwiSaver Scheme","Conservative Fund","Open","Conservative",19.010000000000002]
["Oneanswer KiwiSaver Scheme","Conservative Balanced Fund","Open","Conservative",34.24]
["Oneanswer KiwiSaver Scheme","Balanced Fund","Open","Balanced",49.29]
["Oneanswer KiwiSaver Scheme","Balanced Growth Fund","Open","Growth",63.99]
["Oneanswer KiwiSaver Scheme","Growth Fund","Open","Growth",78.81]
["Oneanswer KiwiSaver Scheme","Sustainable International Share Fund","Open","Aggressive",99.95]
["Oneanswer KiwiSaver Scheme","International Property Fund","Open","Aggressive",99.98]
["Oneanswer KiwiSaver Scheme","Australasian Share Fund","Open","Aggressive",99.99]
["Oneanswer KiwiSaver Scheme","International Share Fund","Open","Aggressive",99.99]
["Oneanswer KiwiSaver Scheme","Australasian Property Fund","Open","Aggressive",99.99]
["Pathfinder KiwiSaver Plan","Pathfinder KiwiSaver Conservative Fund","Open","Conservative",15.78]
["Pathfinder KiwiSaver Plan","Pathfinder KiwiSaver Balanced Fund","Open","Balanced",53.17]
["Pathfinder KiwiSaver Plan","Pathfinder KiwiSaver Growth Fund","Open","Growth",69.39]
["Quaystreet KiwiSaver Scheme","Quaystreet Fixed Interest Fund","Open","Defensive",0]
["Quaystreet KiwiSaver Scheme","Quaystreet Income Fund","Open","Defensive",6.06]
["Quaystreet KiwiSaver Scheme","Quaystreet Conservative Fund","Open","Conservative",18.850000000000001]
["Quaystreet KiwiSaver Scheme","Quaystreet Socially Responsible Investment Fund","Open","Balanced",53.92]
["Quaystreet KiwiSaver Scheme","Quaystreet Balanced Fund","Open","Balanced",54.26]
["Quaystreet KiwiSaver Scheme","Quaystreet Altum Fund","Open","Growth",66.7]
["Quaystreet KiwiSaver Scheme","Quaystreet Growth Fund","Open","Growth",70.900000000000006]
["Quaystreet KiwiSaver Scheme","Quaystreet New Zealand Equity Fund","Open","Growth",87.73]
["Quaystreet KiwiSaver Scheme","Quaystreet Australian Equity Fund","Open","Growth",89.61]
["Quaystreet KiwiSaver Scheme","Quaystreet International Equity Fund","Open","Aggressive",94.86]
["Select KiwiSaver Scheme","Conservative Fund","Open","Conservative",25.35]
["Select KiwiSaver Scheme","Balanced Fund","Open","Balanced",54.8]
["Select KiwiSaver Scheme","Growth Fund","Open","Growth",74.459999999999994]
["Sharesies KiwiSaver Scheme","Sharesies Smartshares Growth Fund","Open"]
["Sharesies KiwiSaver Scheme","Sharesies Smartshares Conservative Fund","Open"]
["Sharesies KiwiSaver Scheme","Sharesies Smartshares Balanced Fund","Open"]
["Sharesies KiwiSaver Scheme","Sharesies Pie Global Growth 2 Fund","Open"]
["Sharesies KiwiSaver Scheme","Sharesies Pathfinder Ethical Growth Fund","Open"]
["Simplicity KiwiSaver Scheme","Guaranteed Income Fund","Disestablished"]
["Simplicity KiwiSaver Scheme","Conservative Fund","Open","Conservative",22.98]
["Simplicity KiwiSaver Scheme","Default Fund","Open","Balanced",58.65]
["Simplicity KiwiSaver Scheme","Balanced Fund","Open","Balanced",58.7]
["Simplicity KiwiSaver Scheme","Growth Fund","Open","Growth",79.67]
["Smartshares KiwiSaver Scheme","Smartkiwi Conservative Fund","Disestablished"]
["Smartshares KiwiSaver Scheme","Smartkiwi Balanced Fund","Disestablished"]
["Smartshares KiwiSaver Scheme","Smartkiwi Growth Fund","Disestablished"]
["Summer KiwiSaver Scheme","Summer New Zealand Fixed Interest","Open","Defensive",0]
["Summer KiwiSaver Scheme","Summer Global Fixed Interest","Open","Defensive",0]
["Summer KiwiSaver Scheme","Summer New Zealand Cash","Open","Defensive",0]
["Summer KiwiSaver Scheme","Summer Conservative Selection","Open","Conservative",26.77]
["Summer KiwiSaver Scheme","Summer Balanced Selection","Open","Balanced",50.79]
["Summer KiwiSaver Scheme","Summer Growth Selection","Open","Growth",73.37]
["Summer KiwiSaver Scheme","Summer Australian Equities","Open","Aggressive",94.66]
["Summer KiwiSaver Scheme","Summer Global Equities","Open","Aggressive",95.39]
["Summer KiwiSaver Scheme","Summer Listed Property","Open","Aggressive",96.16]
["Summer KiwiSaver Scheme","Summer New Zealand Equities","Open","Aggressive",98.06]
["Supereasy KiwiSaver Superannuation Scheme","Automatic Fund (Age 80)","Open"]
["Supereasy KiwiSaver Superannuation Scheme","Conservative Fund","Open","Conservative",19.46]
["Supereasy KiwiSaver Superannuation Scheme","Balanced Fund","Open","Balanced",49.52]
["Supereasy KiwiSaver Superannuation Scheme","Automatic Fund (Age 60)","Open","Balanced",54.44]
["Supereasy KiwiSaver Superannuation Scheme","Growth Fund","Open","Growth",69.91]
["Supereasy KiwiSaver Superannuation Scheme","Automatic Fund (Age 40)","Open","Growth",74.69]
["Supereasy KiwiSaver Superannuation Scheme","Aggressive Fund","Open","Growth",89.79]
["Supereasy KiwiSaver Superannuation Scheme","Automatic Fund (Age 20)","Open","Aggressive",94.58]
["Westpac KiwiSaver Scheme","CPP Fund No. 1","Disestablished"]
["Westpac KiwiSaver Scheme","CPP Fund No. 2","Disestablished"]
["Westpac KiwiSaver Scheme","CPP Fund No. 3","Disestablished"]
["Westpac KiwiSaver Scheme","CPP Fund No. 4","Disestablished"]
["Westpac KiwiSaver Scheme","CPP Fund No. 5","Disestablished"]
["Westpac KiwiSaver Scheme","Cash Fund","Open","Defensive",0]
["Westpac KiwiSaver Scheme","Defensive Conservative Fund","Open","Conservative",17.87]
["Westpac KiwiSaver Scheme","Conservative Fund","Open","Conservative",22.68]
["Westpac KiwiSaver Scheme","Moderate Fund","Open","Balanced",37.119999999999997]
["Westpac KiwiSaver Scheme","Default Balanced Fund","Open","Balanced",47.43]
["Westpac KiwiSaver Scheme","Balanced Fund","Open","Balanced",56.74]
["Westpac KiwiSaver Scheme","Growth Fund","Open","Growth",76.13]