Statistics Canada Statistique Canada Use of Tax Data

  • Slides: 29
Download presentation
Statistics Canada Statistique Canada Use of Tax Data in the Unified Enterprise Survey (UES)

Statistics Canada Statistique Canada Use of Tax Data in the Unified Enterprise Survey (UES) Workshop on Use of Administrative Data in Economics Statistics Marie Brodeur Moscow November, 2006

Overview of the presentation 1. 2. 3. 4. 5. 6. 7. 8. UES Background

Overview of the presentation 1. 2. 3. 4. 5. 6. 7. 8. UES Background Integrated Approach Principles Survey Characteristics Business Register Sampling Achievements and Future Directions Use of Tax Data Research and development

1. UES Background v Major project to improve provincial statistics (1996) v Reliable Annual

1. UES Background v Major project to improve provincial statistics (1996) v Reliable Annual Provincial Data for the Allocation of HST Revenues (SNA I-O Tables) v More detailed Industry & Commodity data v Creation of Enterprise Statistics Division (ESD) v UES Pilot (RY 1997) -- 7 surveys v Gradual Expansion of Surveys; Covers 65% of GDP

2. Integrated Approach Principles v Use of Single, Unduplicated Frame -- the BR v

2. Integrated Approach Principles v Use of Single, Unduplicated Frame -- the BR v Expanded coverage v Common Sample Design Methodology v Integrated Questionnaire -- common / simple language; harmonized concepts / variables v Centralized Data Collection at the Statistical Establishment level

2. Integrated Approach Principles (continued) v Common Generic Processing Systems and Methods v Centralized

2. Integrated Approach Principles (continued) v Common Generic Processing Systems and Methods v Centralized Warehouse v Head Office Survey v Maximum Use of Tax Data v Annual Profiling of Large Enterprises v Enterprise Portfolio Managers

3. Survey Characteristics v Separate Enterprise & Establishment Surveys v Over 50 Establishment Surveys

3. Survey Characteristics v Separate Enterprise & Establishment Surveys v Over 50 Establishment Surveys v Over 55, 000 collection entities representing about 68, 000 establishments (17 K replaced by tax for RY 2005) v Centralized Collection -- $3. 5 million budget v Smallest businesses estimated through tax

4. Business Register (BR) v BR covers all sectors v Incorporated and unincorporated businesses

4. Business Register (BR) v BR covers all sectors v Incorporated and unincorporated businesses v Complex and simple enterprises v Structure v. Legal v. Operational v. Statistical (Enterprise & Establishment) v Updated with Administrative Data

5. Sampling v Stratified Random Sample § Industry (NAICS 4) § Province § Size

5. Sampling v Stratified Random Sample § Industry (NAICS 4) § Province § Size v 1 Take-all stratum v 2 Take-some strata (50% of units replaced by tax) v. Take-none strata (under Royce-Maranda thresholds)

Stratification in One Look Cell Sampling revenue Take-all Take-some 2 Must take units Take-some

Stratification in One Look Cell Sampling revenue Take-all Take-some 2 Must take units Take-some 1 Take-none Royce-Maranda (RM) Exclusion Thresholds: • To reduce response burden on small enterprises

Sampling Process BR (2. 3 M businesses) Survey Universe File (2 M businesses) Sample

Sampling Process BR (2. 3 M businesses) Survey Universe File (2 M businesses) Sample Control File (2 M businesses) UES Sample (70 K businesses) Survey Interface File 38 K CEs / Questionnaires Tax Est’d (1. 4 M) 55 K CEs Tax Replacements 17 K CEs

6. Achievements v. Timeliness v. Centralized Processing Systems and Databases v. Response Burden v.

6. Achievements v. Timeliness v. Centralized Processing Systems and Databases v. Response Burden v. Use of Tax Data

6 a. Timeliness v Very problematic during start-up years v. Many processing systems in

6 a. Timeliness v Very problematic during start-up years v. Many processing systems in development v. Problems with questionnaires v Task force created in 2001 v Target: 15 months after reference year v Since RY 2003, all surveys between 12 -15 month period

6 b. Centralized Processing Systems and Databases v Develop centralized systems v Move away

6 b. Centralized Processing Systems and Databases v Develop centralized systems v Move away from stand-alone v Single point of access for security v Integrated Questionnaire Metadata System v Edit and imputation v Allocation and Estimation v Data Warehouse

Centralized Collection Pre-Contact (17 K Businesses) Mailout (38 K CEs) Receipt (75% target) Score

Centralized Collection Pre-Contact (17 K Businesses) Mailout (38 K CEs) Receipt (75% target) Score Function Edit / Verification (BLAISE) “Clean” Records Capture / Imaging Delinquent Follow-Up

Post-Collection Processing “Clean” Records Pre-Grooming Tax Data Central Data Store USTART Edit & Imputation

Post-Collection Processing “Clean” Records Pre-Grooming Tax Data Central Data Store USTART Edit & Imputation Allocation / Estimation Subject Matter Review & Correction Tool

7. Use of Tax data v Significant process since 1997 v Strategic Streamlining Initiative

7. Use of Tax data v Significant process since 1997 v Strategic Streamlining Initiative v Result v. Almost 65% of units replaced by tax data v. Impact of 27% in the total estimate

Streamlining Initiatives at STC v Announced in 2002 v Objectives v. Maintaining quality v.

Streamlining Initiatives at STC v Announced in 2002 v Objectives v. Maintaining quality v. Create efficiencies v. Enhance work flows v. Identify trade-offs v Expand the use of tax data for survey replacement

T 1T 2 Project v Objective is to substitute 50% of simple establishments. v

T 1T 2 Project v Objective is to substitute 50% of simple establishments. v Direct Data Replacement for annual surveys using v. T 1(unincorporated) v. T 2 (incorporated) v Facilitated by the Chart of Accounts (COA).

Types of Administrative (Tax) Data From the Canadian Revenue Agency (CRA) v Agreement between

Types of Administrative (Tax) Data From the Canadian Revenue Agency (CRA) v Agreement between CRA and STC v T 1 (unincorporated businesses) v T 2 (incorporated businesses) v T 4 (pay slips) v GST (goods and service tax) v PD 7 (payroll deduction accounts)

Processing of Tax Data v. Edit erroneous reports v. Outlier detection v. Eliminate duplication

Processing of Tax Data v. Edit erroneous reports v. Outlier detection v. Eliminate duplication v. Impute for missing values v. Annualize in case of monthly data

Stratification in One Look Cell Sampling revenue Take-all Take-some 2 Must take units Take-some

Stratification in One Look Cell Sampling revenue Take-all Take-some 2 Must take units Take-some 1 Take-none Royce-Maranda (RM) Exclusion Thresholds: • To reduce response burden on small enterprises

RY 2005 Methodology: Tax Replacement T 1 T 2 Main sampleto tobe besurveyed Not

RY 2005 Methodology: Tax Replacement T 1 T 2 Main sampleto tobe besurveyed Not eligible for tax : questionnaire Characteristic survey (some Services surveys) or questionnaire (all other divisions) Tax replaced ROYCE-MARANDA THRESHOLDS T 1 Take. None: Sample of e-filers T 2 Take-None: Census of General Index of Financial Information (GIFI)

UES: Use of Tax Data v Validation (comparison) v. Verify dubious collected data against

UES: Use of Tax Data v Validation (comparison) v. Verify dubious collected data against the equivalent tax data record v Imputation v. One of the methods used for non-response v Estimation v. Below take-none v. Direct Data Replacement v. Some annual surveys 100% tax (Taxi & Limousines, Survey of Mapping) v Update Business Register v Allocation of survey data ( use tax revenues, salaries and expenses)

CHART OF ACCOUNTS Why does a Bureau of Statistics need one? BUSINESS WORLD Chart

CHART OF ACCOUNTS Why does a Bureau of Statistics need one? BUSINESS WORLD Chart of Accounts (COA) BUREAU OF STATISTICS

Chart of Accounts COLLECTION Sales Operating revenue EBIT Gross Cost of profit Expenses sales

Chart of Accounts COLLECTION Sales Operating revenue EBIT Gross Cost of profit Expenses sales LINK, BRIDGE, CONCORDANCE DISSIMINATION Shipments Outputs Inputs Value added Operating Surplus GDP

Expected Benefits of a Chart of Accounts v Standardization in business data collection v

Expected Benefits of a Chart of Accounts v Standardization in business data collection v Higher survey response v Increase in quality of data v Comparison of data from various sources v Increase efficiency in using administrative data

Links to Chart of Accounts Establishment CHART OF ACCOUNT Legal entity

Links to Chart of Accounts Establishment CHART OF ACCOUNT Legal entity

GST Data v. Monthly tax data v. Used to replace survey data for monthly

GST Data v. Monthly tax data v. Used to replace survey data for monthly surveys v. Implemented for manufacturing, services and retail surveys v. For RY 2005 used for analytical comparisons for annual Services Surveys

Research and Development v Data Integration Project make a more efficient use of tax

Research and Development v Data Integration Project make a more efficient use of tax data v Development of new quality indicators (e. g. Rates, coefficients of variation)