Workiva Inc. · NYSE:WK
Workiva — Technical Presentation (August 2019)
37 slides from Workiva's technical presentation, Aug 20, 2019
Slide 1: Data Quality Committee: Round 5 and 6 Validation Rules
Data Quality Committee: Round 5 and 6 Validation Rules 1
Slide 2: Legal Notice
Legal Notice The information contained in this document is for general informational purposes only. The information is provided by Workiva Inc., and while we endeavor to keep the information up to date and correct, we make no representations or warranties of any kind, express or implied, about the c
Slide 3: Overview
Overview US GAAP Round 5 and 6 IFRS Round 6 Rules Rules 3
Slide 4: US GAAP - Round 5 and 6 Rules
US GAAP - Round 5 and 6 Rules 4
Slide 5: Summary of US GAAP Round 5 and 6 rules
Summary of US GAAP Round 5 and 6 rules Rule Number Name Description 43 Incorrect Calculations Weights in The rule identifies the balance type of the elements in the calculation linkbase that Operating Cash Flows are children of the operating cash flow elements in the US GAAP taxonomy and determines
Slide 6: Summary of US GAAP Round 5 and 6 rules cont
Summary of US GAAP Round 5 and 6 rules cont Rule Number Name Description 49 Single Calculation Tree from Change This rule identifies when a single calculation tree has not been used to represent in Cash Flows the increase or decrease in cash for the period 51 Before Tax Items This rule evaluates whe
Slide 7: Summary of US GAAP Round 5 and 6 rules cont
Summary of US GAAP Round 5 and 6 rules cont Rule Number Name Description 61 Cash Flow Continuing Operations This rule is intended to identify cases where a company’s cash flow includes Elements not Used discontinued operations as a summation-child to the periodic change in cash and cash equivalents
Slide 8: US GAAP - Common Mistakes
US GAAP - Common Mistakes 8
Slide 9: US GAAP Round 5 and 6 - Top 4 Highest Firing Rules
US GAAP Round 5 and 6 - Top 4 Highest Firing Rules • Rule 48 - Required Calculation Parent Element in the Cash Flow Statement • Rule 52 - Member Values • Rule 60 - Element Dependent for Specific Elements • Rule 65 - Interest Paid Net (Operating) Not on Cash Flow 9
Slide 10: Rule 48 - Required Calculation Parent Element in the Cash Flow Statement
Rule 48 - Required Calculation Parent Element in the Cash Flow Statement This rule tests that one of the following elements appears as the ultimate 'Parent' or 'Root' calculation in the Statement of Cash Flows. 1. CashPeriodIncreaseDecreaseExcludingExchangeRateEffect 2. CashPeriodIncreaseDecrease 3.
Slide 11: Calculation relationship needed on Parent
Rule 48 - Required Calculation Parent Element in the Cash Flow Statement Scenario 1: One of the predefined parent elements is disclosed, but no calculation relationship defined. Cash Flow Disclosure Element Net cash used in operating activities Net Cash Provided by (Used in) Operating Activities Net
Slide 12: Define calculation relationship
Rule 48 - Required Calculation Parent Element in the Cash Flow Statement Scenario 1: One of the predefined parent elements is disclosed, but no calculation relationship defined Cash Flow Disclosure Element Net cash used in operating activities + Net Cash Provided by (Used in) Operating Activities Ne
Slide 13: Rule 48 - Required Calculation Parent Element in the Cash Flow Statement
Rule 48 - Required Calculation Parent Element in the Cash Flow Statement Scenario 2: Calculation is defined with "Net Cash Provided by (Used in) Continuing Operations" element with no Discontinued Operations presented Cash Flow Disclosure Element Net cash used in operating activities + Net Cash Prov
Slide 14: Rule 48 - Required Calculation Parent Element in the Cash Flow Statement continued
Rule 48 - Required Calculation Parent Element in the Cash Flow Statement Scenario 2: Calculation is defined with "Net Cash Provided by (Used in) Continuing Operations" element with no Discontinued Operations presented n t i n ued Cash Flow Disclosure o d i sco Element Net cash used in operating acti
Slide 15: Rule 52 - Member Values
Rule 52 - Member Values • The FASB has defined certain members, when used on a given axis, that cannot be tagged with a value • This rule identifies facts with a given axis and member that cannot be tagged with a value irrespective of the line item used • The “Domestic Plan [Member]” element is not
Slide 16: Rule 52 - Member Values
Rule 52 - Member Values Application of "Domestic Plan [Member]" Retirement Plan Sponsor Location [Axis] Pension Benefits Domestic Foreign Change in benefit obligation: Beginning balance $ 13,000 $ 11,000 Service cost 200 230 Interest cost 600 740 Employee contributions 300 450 Plan amendments (60) (
Slide 17: Rule 52 - Member Values
Rule 52 - Member Values Application of "Domestic Plan [Member]" Retirement Plan Sponsor Location [Axis] Pension Benefits Domestic Foreign Change in benefit obligation: Beginning balance $ 13,000 $ 11,000 Service cost 200 230 Interest cost 600 740 Employee contributions 300 450 Plan amendments (60) (
Slide 18: Rule 52 - Member Values
Rule 52 - Member Values Application of "Domestic Plan [Member]" Retirement Plan Sponsor Location [Axis] Pension Benefits Domestic Foreign Change in benefit obligation: Beginning balance $ 13,000 $ 11,000 tion Service cost 200 230 l l oc a ctua Interest cost 600 740 i t h a er]" w er]") Employee cont
Slide 19: Rule 60 - Element Dependence for Specific Elements
Rule 60 - Element Dependence for Specific Elements • If a given element is used in a filing, then a corresponding element(s) should also be present in the instance • This rule identifies where a required disclosure is defined in US-GAAP and it is more appropriate to report the broader element that i
Slide 20: Rule 60 - Element Dependence for Specific Elements
Rule 60 - Element Dependence for Specific Elements Discontinued Operations are not disclosed Cash Flow Disclosure Element Net Cash Provided by (Used in) Operating Activities, X Net cash used in operating activities Continuing Operations Net Cash Provided by (Used in) Investing Activities, Net cash p
Slide 21: Replace with broader (general) elements
Rule 60 - Element Dependence for Specific Elements Discontinued Operations are not disclosed Cash Flow Disclosure Element Net cash used in operating activities Net Cash Provided by (Used in) Operating Activities Net cash provided by (used in) investing activities Net cash provided by financing activ
Slide 22: Rule 65 - Interest Paid Net (Operating) Not on Cash Flow
Rule 65 - Interest Paid Net (Operating) Not on Cash Flow • This rule identifies those cases where the filer has included the element InterestPaid as a presentation linkbase descendant of the element SupplementalCashFlowInformationAbstract but has not included the element InterestPaidNet and the elem
Slide 23: Rule 65 - Interest Paid Net (Operating) Not on Cash Flow
Rule 65 - Interest Paid Net (Operating) Not on Cash Flow Supplemental disclosure is interest paid net of capitalized interest Supplemental Disclosure of Cash Flow Information: Interest Paid Interest Paid, Including Capitalized Interest, Operating and Investing Activities* Net Income taxes paid Paid-
Slide 24: Rule 65 - Interest Paid Net (Operating) Not on Cash Flow
Rule 65 - Interest Paid Net (Operating) Not on Cash Flow Supplemental disclosure is interest paid net of capitalized interest Supplemental Disclosure of Cash Flow Information: InterestPaid Interest Paid InterestPaidNet* Net Income taxes paid InterestPaidCapitalized Paid-in-kind dividends * Required
Slide 25: Rule 65 - Interest Paid Net (Operating) Not on Cash Flow
Rule 65 - Interest Paid Net (Operating) Not on Cash Flow Supplemental disclosure is interest paid net of capitalized interest Supplemental Disclosure of Cash Flow Information: Interest Paid Interest Paid, Excluding Capitalized Interest, Operating Activities* Net Income taxes paid Paid-in-kind divide
Slide 26: IFRS - Round 6 Rules
IFRS - Round 6 Rules 26
Slide 27: Summary of IFRS Round 6 rules
Summary of IFRS Round 6 rules Rule Number Name Description 6 DEI and Block Tag Date Contexts This rule tests that the dates used for certain Document and Entity Information, accounting policy, text block and table text block elements are consistent with the fiscal period focus of the filing (e.g. Q1
Slide 28: IFRS - Common Mistakes
IFRS - Common Mistakes 28
Slide 29: Rule 8 - Reversed Calculation
Rule 8 - Reversed Calculation • Comparing calculations against the IFRS calculations ◦ Parents should not contribute to their children Inverse Relationships For the year ended December 31, 2018 December 31, 2017 Interest on debt (900) (700) Capitalized interest 30 20 Total interest expense (870) (68
Slide 30: Rule 8 - Reversed Calculation
Rule 8 - Reversed Calculation Inverse Relationships For the year ended December 31, 2018 December 31, 2017 Interest on debt (900) (700) + Interest Costs Incurred Capitalized interest 30 20 - Interest Costs Capitalised Total interest expense (870) (680) = Interest Expense 30
Slide 31: Rule 8 - Reversed Calculation
Rule 8 - Reversed Calculation Parent Inverse Relationships For the year ended December 31, 2018 December 31, 2017 Interest on debt (900) (700) + Interest Costs Incurred Parent Capitalized interest Total interest expense 30 (870) X20 - Interest Costs Capitalised (680) = Interest Expense 31
Slide 32: Rule 8 - Reversed Calculation
Rule 8 - Reversed Calculation Parent Inverse Relationships For the year ended December 31, 2018 December 31, 2017 Interest on debt (900) (700) =Interest Costs Incurred Parent Capitalized interest Total interest expense 30 (870) ü20 +Interest Costs Capitalised (680) + Interest Expense Update calculat
Slide 33: Rule 41 - Axis with a Default Member that Differs from the Base Taxonomy
Rule 41 - Axis with a Default Member that Differs from the Base Taxonomy • Evaluates whether the dimension default is associated with a given axis in the company's extension taxonomy • Companies should not change the default member defined in the base taxonomy for a given axis in their extension tax
Slide 34: Rule 41 - Axis with a Default Member that Differs from the Base Taxonomy
Rule 41 - Axis with a Default Member that Differs from the Base Taxonomy Incorrect Range [axis] Range [domain]* û *Extension Correct Range [axis] Ranges [member] ü 34
Slide 35: Rule 41 - Axis with a Default Member that Differs from the Base Taxonomy
Rule 41 - Axis with a Default Member that Differs from the Base Taxonomy Incorrect Subsidiaries [axis] Subsidiaries [member] û Correct Subsidiaries [axis] Entity's total for subsidiaries [member] ü 35
Slide 36: Rule 41 - Axis with a Default Member that Differs from the Base Taxonomy
Rule 41 - Axis with a Default Member that Differs from the Base Taxonomy Update default domain to the proper domain within the XBRL Default Axis section within Wdesk 36
Slide 37: Questions?
Questions? xbrldataquality@workiva.com 37