{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Department","Business Unit and group","Sheet8","Subsidiaries","Departments"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":1,"comments":2,"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":"Department","index":0,"n_rows":23,"n_cols":3,"rows_kept":23,"cut":false,"hidden":false,"merged":[[0,1,0,2],[1,1,1,2],[22,1,26,2]]}
[null,"NetSuite Object Request Form - Department"]
[null,"Approver:  Global Controller/Chief Financial Officer"]
[]
[null,"Field Name","Enter Value"]
[null,"Requestor Name"]
[null,"Request Date"]
[null,"Request Type"]
[null,"Department Name  *"]
[null,"Does this new department code track an individual, group, or activity associated with a specific revenue type?"]
[null,"If \"yes\" to the above, please select the revenue type associated with this new department code:"]
[null,"Parent Department (If applicable)"]
[null,"Subsidary(s)"]
[null,"        Include Children?"]
[null,"                But Exlcude Subsidary"]
[null,"Business Unit (Required for UK)"]
[null,"Business Group (Required for UK)"]
[null,"For AY Internal Income State Reporting - Where does it need to be mapped in the Direct Cost Section?"]
[]
[]
[null,"* = Required Field"]
[]
[null,"Overview"]
[null,"Currently we are using Departments to segment Corporate Departments and Service Line Departments on transactions.  Every transaction within NetSuite is required to have a department identified, so we do have a “ZOT – Other” department available for use.  If a new department is required, it should follow the format of our current structure.  Corporate Departments begin with a 3 letter code (Cxx) followed by a name (Corp xxxx).  Service Line Departments begin with a 3 letter code (Sxx) followed by a name (Scv Line – xxxx).  Departments can be used by any Subsidiary. "]

{"sheet":"Business Unit and group","index":1,"n_rows":49,"n_cols":3,"rows_kept":49,"cut":false,"hidden":true,"merged":[[0,2,1,2]]}
["Translation",null,"BUS Group"]
["10 Industrial & Distribution"]
["13 Risk and Compliance",null,"BG01 Transactions"]
["14 General Overheads",null,"BG02 Rating and Technology"]
["16 London Leasing",null,"BG03 Professional Advisory"]
["17 London Investment",null,"BG04 Building & Project Consultancy"]
["18 Occupier Advisory & Flex",null,"BG05 London Markets"]
["19 Lease Advisory",null,"BG06 Place"]
["20 Lease Consultancy",null,"BG07 Real Estate, Facilities and IM"]
["23 REM",null,"BG08 Business Solutions"]
["27 IM"]
["38 Health"]
["40 Retail"]
["43 Hotels"]
["44 Leisure"]
["45 Investments"]
["53 Energy"]
["60 Business Rates"]
["63 Valuation"]
["67 Telecoms"]
["72 Place Advisory"]
["73 Place Professional"]
["74 Place Transactional"]
["75 BPC"]
["75 BPC Bristol"]
["75 BPC Cardiff"]
["75 BPC Leads"]
["75 BPC Manchester"]
["75 BPC Newcastle"]
["75 BPC Scotland"]
["75 BPC/BC"]
["76 BPC/BC London"]
["76 PBC Manchester"]
["80 Finance"]
["81 IT"]
["82 Legal"]
["83 Facilities"]
["85 Offices"]
["86 CEO Office"]
["87 Marketing"]
["88 Market Intelligence"]
["89 ESG"]
["92 RMD"]
["93 Client & Business Services"]
["94 Sales Enablement and Client Development"]
["98 BPC/WAC London"]
["98 EMEA Projects"]
["98 Occupier Solutions"]
["99 FM"]

{"sheet":"Sheet8","index":2,"n_rows":19,"n_cols":12,"rows_kept":19,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,null,null,"Account Type","Currency","Bill To Type",null,"New",null,"Revenue Type","Direct Costs"]
["Yes","Average","Asset Account",null,"Bank","British Pound","Company","Lawyer","Inactivate",null,"Brokerage","Commissions"]
["No","Current","Depreciation Account",null,"Accounts Receivable","CAN","Individual","Trust Client","Change",null,"Property Management","Brokerage"]
[null,"Historical","Depreciation Expense",null,"Other Current Asset","Euro",null,null,null,null,"Project Management","Property Management - Recoverable Cost"]
[null,null,"Write Off Account",null,"Fixed Asset","Mexican Pesos",null,null,null,null,"Valuations","Property Management - Direct Cost"]
[null,null,"Disposal Cost Account",null,"Accounts Payable","Polish Zloty",null,null,null,null,"Consulting","Project Management - Direct Cost"]
[null,null,null,null,"Credit Card ","US Dollar",null,null,null,null,"Other","Bad Debt"]
[null,null,null,null,"Other Current Liability",null,null,null,null,null,null,"Other Direct Costs"]
[null,null,null,null,"Long Term Liability"]
[null,null,null,null,"Equity"]
[null,null,null,null,"Income"]
[null,null,null,null,"Cost of Goods Sold"]
[null,null,null,null,"Expense"]
[null,null,null,null,"Other Income"]
[null,null,null,null,"Other Expense"]
[null,null,null,null,"Deffered Revenue"]
[null,null,null,null,"Unbilled Receivable"]
[null,null,null,null,"Statistical"]

{"sheet":"Subsidiaries","index":3,"n_rows":92,"n_cols":8,"rows_kept":92,"cut":false,"hidden":false,"merged":[]}
["Internal ID","Legal Name","Parent Subsidiary","Name","Inactive","Country","Currency","Elimination"]
[1,"Avison Young Consolidated (Canada) Inc.","","000 - Avison Young CONSOLIDATED (AYCI)","No","Canada","CAN","No"]
[44,"Elim AYCI Consolidated",1,"0000 - Elim Avison Young (Canada) Inc. Parent","No","Canada","CAN","Yes"]
[132,"Elim Avison Young (Canada) Inc.",2,"001 - Elim AYCI","No","Canada","CAN","Yes"]
[54,"Avison Young Investments (Canada) Inc.",1,"006 - Avison Young Investments (Canada) Inc.","No","Canada","CAN","No"]
[56,"Avison Young - Investments (USA) Inc.",1,"007 - Avison Young - Investments (USA) Inc.","No","United States","US Dollar","No"]
[2,"Avison Young (Canada) Inc.",1,"010 - Avison Young (Canada) Inc.","No","Canada","CAN","No"]
[225,"Avison Young GP, Inc.",2,"010 - 010 - AY GP Inc.","No","Canada","CAN","No"]
[219,"Avison Young Commercial Real Estate Services, LP",2,"010 - 011 - AY Commercial Real Estate Services, LP","No","Canada","CAN","No"]
[220,"Avison Young Real Estate Management Services, LP",2,"010 - 012 - AY Real Estate Management Services, LP","No","Canada","CAN","No"]
[221,"Avison Young Project Management Services, LP",2,"010 - 013 - AY Project Management Services, LP","No","Canada","CAN","No"]
[222,"Avison Young Valuation and Advisory Services, LP",2,"010 - 014 - AY Valuation & Advisory Services, LP","No","Canada","CAN","No"]
[223,"Avison Young Consulting Services, LP",2,"010 - 015 - AY Consulting Services, LP","No","Canada","CAN","No"]
[226,"Avison Young Legal Services LLP",2,"010 - 016 - AY Legal Services LLP","No","Canada","CAN","No"]
[236,"",2,"010 - 098 - AYCI Share Purchase Trust","No","Canada","CAN","No"]
[218,"12182335 Canada Inc.",2,"010 - 099 - 12182335 Canada Inc.","No","Canada","CAN","No"]
[224,"Avison Young Global Investment Management, LP",1,"011 -  AY Global Investment Management, LP","No","Canada","CAN","No"]
[51,"Avison Young USA Consolidation",1,"020 - Avison Young CONSOLIDATED (AY USA Inc)","No","United States","US Dollar","No"]
[142,"Elim AY USA Consolidated",51,"020-01 - Elim AY USA Consolidated","No","United States","US Dollar","Yes"]
[104,"Avison Young (USA) Inc.",51,"020-11 - Avison Young (USA) Inc.","No","United States","US Dollar","No"]
[144,"Elim AY USA",104,"020-11-01 - Elim AY USA","No","United States","US Dollar","Yes"]
[114,"Avison Young - Atlanta LLC",104,"020-11-11 - Avison Young - Atlanta LLC","No","United States","US Dollar","No"]
[149,"Elim Atlanta",114,"020-11-11-01 - Elim Atlanta","No","United States","US Dollar","Yes"]
[115,"AYA Management Services LLC",114,"020-11-11-11 - AYA Management Services LLC","No","United States","US Dollar","No"]
[116,"Avison Young - North Carolina LLC",114,"020-11-11-12 - Avison Young - North Carolina LLC","No","United States","US Dollar","No"]
[117,"Avison Young - Chicago LLC",104,"020-11-12 - Avison Young - Chicago LLC","No","United States","US Dollar","No"]
[150,"Elim Chicago",117,"020-11-12-01 - Elim Chicago","No","United States","US Dollar","Yes"]
[118,"Avison Young - Development LLC",117,"020-11-12-11 - Avison Young - Development LLC","No","United States","US Dollar","No"]
[119,"Avison Young - Florida LLC",104,"020-11-13 - Avison Young - Florida LLC","No","United States","US Dollar","No"]
[151,"Elim Florida",119,"020-11-13-01 - Elim Florida","No","United States","US Dollar","Yes"]
[120,"Avison Young Property Management (USA) LLC",119,"020-11-13-11 - Avison Young - Property Management (USA) LLC","No","United States","US Dollar","No"]
[121,"Avison Young - Michigan LLC",104,"020-11-14 - Avison Young - Michigan LLC","No","United States","US Dollar","No"]
[152,"Elim Michigan",121,"020-11-14-01 - Elim Michigan","No","United States","US Dollar","Yes"]
[122,"Avison Young - Indiana, LLC",121,"020-11-14-11 - Avison Young - Indiana LLC","No","United States","US Dollar","No"]
[123,"Avison Young - Ohio LLC",121,"020-11-14-12 - Avison Young - Ohio LLC","No","United States","US Dollar","No"]
[124,"Avison Young - New York LLC",104,"020-11-15 - Avison Young - New York LLC","No","United States","US Dollar","No"]
[154,"Elim NY",124,"020-11-15-01 - Elim NY","No","United States","US Dollar","Yes"]
[235,"Eagle Group of Springfield LLC",125,"020-11-15-10 Avison Young Studio Project Services LLC","No","United States","US Dollar","No"]
[125,"Avison Young - Project Management (USA) LLC",124,"020-11-15-11 - Avison Young - Project Management (USA) LLC","No","United States","US Dollar","No"]
[105,"Avison Young - Nevada LLC",104,"020-11-16 - Avison Young - Nevada LLC","No","United States","US Dollar","No"]
[106,"Avison Young - New England, LLC",104,"020-11-17 - Avison Young - New England LLC","No","United States","US Dollar","No"]
[107,"Avison Young - Northern California Ltd.",104,"020-11-18 - Avison Young - Northern California Ltd.","No","United States","US Dollar","No"]
[126,"Avison Young - Texas LLC",104,"020-11-19 - Avison Young - Texas LLC","No","United States","US Dollar","No"]
[155,"Elim TX",126,"020-11-19-01 - Elim TX","No","United States","US Dollar","Yes"]
[129,"Avison Young - Dallas LLC",126,"020-11-19-11 - Avison Young - Dallas LLC","No","United States","US Dollar","No"]
[108,"Avison Young - Philadelphia LLC",104,"020-11-20 - Avison Young - Philadelphia LLC","No","United States","US Dollar","No"]
[109,"Avison Young - Pittsburgh LLC",104,"020-11-21 - Avison Young - Pittsburgh LLC","No","United States","US Dollar","No"]
[110,"Avison Young - Southern California Ltd",104,"020-11-22 - Avison Young - Southern California Ltd","No","United States","US Dollar","No"]
[113,"Avison Young - Washington DC LLC",104,"020-11-23 - Avison Young - Washington DC LLC","No","United States","US Dollar","No"]
[156,"Avison Young Management Services (USA) Inc.",104,"020-11-24 - Avison Young - Management Services (USA) Inc.","No","United States","US Dollar","No"]
[161,"Avison Young - Arizona, Ltd.",104,"020-11-25 - Avison Young - Arizona, Ltd.","No","United States","US Dollar","No"]
[162,"Avison Young - South Carolina, Inc.",104,"020-11-26 - Avison Young - South Carolina, Inc.","No","United States","US Dollar","No"]
[181,"Avison Young - Tennessee, Inc.",104,"020-11-27 - Avison Young - Tennessee, Inc.","No","United States","US Dollar","No"]
[227,"Avison Young Global Investment Management (USA) Inc.",1,"021 -  AY Global Investment Management (USA) Inc.","No","United States","US Dollar","No"]
[216,"AY Investments (US) LLC",1,"025 - AY Investments (US) LLC","No","United States","US Dollar","No"]
[58,"Avison Young Holdings Limited",1,"040 - Avison Young Holdings Limited","No","United Kingdom","British pound","No"]
[185,"Elim Avison Young Holdings",58,"040-01 - Elim Avison Young Holdings","No","United Kingdom","British pound","Yes"]
[186,"Avison Young UK Consolidated",58,"040-12 - Avison Young UK Consolidated","No","United Kingdom","British pound","No"]
[187,"Elim Avison Young UK",186,"040-12-01 - Elim Avison Young UK","No","United Kingdom","British pound","Yes"]
[196,"Avison Young (UK) Limited",186,"040-12-12 - Avison Young (UK) Limited","No","United Kingdom","British pound","No"]
[197,"Avison Young Workplace Limited",186,"040-12-13 - Avison Young Workplace Limited","No","United Kingdom","British pound","No"]
[199,"Avison Young Project Management Limited",186,"040-12-14 - Avison Young Project Management Limited","No","United Kingdom","British pound","No"]
[192,"Avison Young Real Estate Finance Limited",186,"040-12-15 - Avison Young Real Estate Finance Limited","No","United Kingdom","British pound","No"]
[193,"GVA Worldwide Ltd",186,"040-12-16 - GVA Worldwide Ltd","No","United Kingdom","British pound","No"]
[194,"AY Infrastructure Mgt Ltd",186,"040-12-17 - AY Infrastructure Mgt Ltd","No","United Kingdom","British pound","No"]
[209,"AY Iberia Holdings (UK)",58,"040-13 - AY Iberia Holdings (UK)","No","United Kingdom","British pound","No"]
[202,"Avison Young Planning and Regeneration Limited",58,"050 -Avison Young Planning and Regeneration Limited","No","Ireland","Euro","No"]
[205,"Elim Avison Young Planning & Regeneration Ltd (Ireland)",202,"050-01 - Elim Avison Young Planning & Regeneration Ltd (Ireland)","No","Ireland","Euro","Yes"]
[206,"Avison Young Planning & Regeneration Ltd (Ireland) - IFRS Adj",202,"050-99 - Avison Young Planning & Regeneration Ltd (Ireland) - IFRS Adj","No","Ireland","Euro","No"]
[203,"Avison Young Polska Sp. z o.o.",58,"051 - Avison Young Polska S.p.z.o.o.","No","Poland","Polish Zloty","No"]
[207,"Elim Avison Young Polska S.p.z.o.o.",203,"051-01 - Elim Avison Young Polska S.p.z.o.o.","No","Poland","Polish Zloty","Yes"]
[208,"Avison Young Polska S.p.z.o.o. - IFRS Adj",203,"051-99 - Avison Young Polska S.p.z.o.o. - IFRS Adj","No","Poland","Polish Zloty","No"]
[210,"AY Spain",209,"052 - AY Spain","No","Spain","Euro","No"]
[211,"Elim AY Spain",210,"052-01 - Elim AY Spain","No","Spain","Euro","No"]
[212,"AY Spain - IFRS Adj",210,"052-99 - AY Spain - IFRS Adj","No","Spain","Euro","No"]
[213,"AY Portugal (UK Branch)",209,"053 - AY Portugal (UK Branch)","No","Portugal","Euro","No"]
[214,"Elim AY Portugal (UK Branch)",213,"053-01 - Elim AY Portugal (UK Branch)","No","Portugal","Euro","No"]
[215,"AY Portugal - IFRS Adj",213,"053-99 - AY Portugal - IFRS Adj","No","Portugal","Euro","No"]
[231,"Avison Young Investment Management Services (France) SAS",58,"054 - Avison Young Investment Management Services (France)","No","France","Euro","No"]
[233,"Elim Avison Young France",231,"054-01 – Elim AY France","No","France","Euro","Yes"]
[234,"Avison Young (France) SAS",231,"054-10 - Avison Young (France)","No","France","Euro","No"]
[232,"Avison Young France - IFRS Adj",231,"054-99 – AY France - IFRS Adj","No","France","Euro","No"]
[59,"Avison Young Germany GmbH",1,"060 - Avison Young Germany GmbH","No","Germany","Euro","No"]
[180,"Elim AY Germany",59,"060-01 - Elim AY Germany","No","Germany","Euro","Yes"]
[179,"Avison Young Germany-IFRS Adj",59,"060-99 - Avison Young Germany-IFRS Adj","No","Germany","Euro","No"]
[171,"Avison Young (Mexico) Holdings Inc.",1,"080 - Avison Young (Mexico) Holdings Inc.","No","Canada","CAN","No"]
[172,"Elim AY Mexico",171,"080-01 - Elim AY Mexico","No","Canada","CAN","Yes"]
[173,"Avison Young Mexico Topside",171,"080-11 - Avison Young Mexico Topside","No","Mexico","Mexican Pesos","No"]
[174,"Elim AY Mexico Topside",173,"080-11-01 - Elim AY Mexico Topside","No","Mexico","Mexican Pesos","Yes"]
[175,"Avison Young Mexico, S DE RL DE CV",173,"080-11-11 - Avison Young Mexico","No","Mexico","Mexican Pesos","No"]
[177,"Avison Young Mexico Services, S DE RL DE CV",173,"080-11-12 - Avison Young Mexico Services","No","Mexico","Mexican Pesos","No"]
[47,"AYCI Elim/FX/Topside Entity (AYCI Dummy Consolidated)",1,"900 - AYCI Elim/FX/Topside Entity (AYCI Dummy Consolidated)","No","Canada","CAN","No"]

{"sheet":"Departments","index":4,"n_rows":88,"n_cols":3,"rows_kept":88,"cut":false,"hidden":false,"merged":[]}
["Internal ID","Name","Internal ID"]
[105,"AFAL - Agency Leasing",105]
[175,"AFBLS - Affinity Group Bio & Life Sciences",175]
[168,"AFCL - Clients Affinity Group",168]
[108,"AFDJ - Debt JV Structured Fin",108]
[121,"AFEL - Emerging Leaders",121]
[109,"AFES - Enterprise Solutions",109]
[113,"AFI - Industrial",113]
[114,"AFO - Operations",114]
[174,"AFPE - Affinity Group Private Equity",174]
[115,"AFPJM - Project Management",115]
[116,"AFPM - Property Management",116]
[117,"AFR - Research",117]
[118,"AFRT - Retail",118]
[163,"AFSCL - Supply Chain & Logistic",163]
[119,"AFTA - Tenant Advisory",119]
[125,"AFV - Valuation",125]
[123,"AMULTI - Multi-Family",123]
[122,"AP Clearing",122]
[127,"CAYUN - Corp AY University",127]
[128,"CCOMP - Corp Risk & Compliance",128]
[172,"CESG - Enviro, Social, Governance",172]
[16,"CEX - Corp Exec",16]
[14,"CFN - Corp Fin",14]
[17,"CGN - Corp General",17]
[13,"CHR - Corp HR",13]
[12,"CIT - Corp IT",12]
[162,"CIT_ARCH - Data Architecture",162]
[158,"CIT_AY PRODUCT - Product Development",158]
[182,"CIT_AY PRODUCT - Product Management",182]
[188,"CIT_BUSINESS INTELLIGENCE",188]
[157,"CIT_CRM - CRM",157]
[161,"CIT_CYBER - Cyber Security",161]
[151,"CIT_DATA - Data Mgmt",151]
[159,"CIT_FINSYS - Financial Systems",159]
[184,"CIT_PORTFOLIO ANALYTICS",184]
[178,"CIT_RPA",178]
[160,"CIT_WEB - Website",160]
[18,"CLG - Corp Legal",18]
[15,"CMK - Corp Mkt",15]
[173,"COFC_Admin - Corporate Office Costs",173]
[11,"COP - Corp Ops",11]
[126,"COSW - Corp OSW",126]
[134,"CSTRAT - Corporate Strategy",134]
[150,"Market Intelligence",150]
[191,"SBI Industrial",191]
[1,"SBK - Svc Line - Brokerage",1]
[164,"SBK_CORPSVC – Brk Corp Services",164]
[145,"SCBA – Building Advisory",145]
[181,"SCBD - Consulting Business Development",181]
[143,"SCBI - Business Intelligence",143]
[142,"SCLSI Location Strat/Logistics",142]
[9,"SCM - Svc Line - Cap Mkts",9]
[4,"SCN - Svc Line - Consulting",4]
[186,"SCNAM – Consulting Account Management",186]
[101,"SCO - Svc Line - Construct Mgmt",101]
[165,"SCONOPS – Consulting Operations",165]
[166,"SCPGM – Consulting Program Mana",166]
[139,"SCPROC - Procurement",139]
[136,"SCS - Svc Line - Corp Solutions",136]
[141,"SCSCL - Supply Chain Logistics",141]
[148,"SCTA - Svc Line - Tax Appeal",148]
[140,"SCWPI - Workplace Intelligence",140]
[6,"SDS - Svc Line - Debt Svcs",6]
[102,"SDV - Svc Line - Develop Svcs",102]
[138,"SFLX - Svc Line - Flexible Off",138]
[10,"SFM - Svc Line - Fac. Mgmt",10]
[103,"SHC - Svc Line - Healthcare",103]
[124,"SHP - Svc Line - Hospitality",124]
[8,"SIM - Svc Line - Investment Mgt",8]
[129,"SLA - Service Line-Lease Admin",129]
[171,"SLD – Svc Line – Land Development",171]
[149,"SLG - Svc Line - Legal Services",149]
[5,"SMS - Svc Line - Maint Svcs",5]
[3,"SPJ - Svc Line - Project Mgt",3]
[2,"SPM - Svc Line - Prop Mgt",2]
[155,"SPMA - PM Accounting",155]
[156,"SPMC - PM Condo",156]
[185,"SPMRM Property Management Retail Marcom",185]
[187,"SPN - Svc Line - Planning",187]
[132,"SRCV - Svc Line - Receivership",132]
[104,"SRT - Svc Line - Retail",104]
[133,"SRTE - Svc Line - Rates",133]
[167,"SVALOPS – Valuation Operations",167]
[7,"SVL - Svc Line - Valuation",7]
[19,"ZOT - Other",19]
[107,"zzAFCM - Capital Markets (Do not use)",107]
[135,"zzCGI - Corp Global Innovations (Do Not Use)",135]