UBmatrix Calculation Trace Report
Line Concept Weight Balance Decimals Precision Reported Calculated Source Message
1 Extended Link [ http://opentext.com/role/BalanceSheet ]
2 Context c00000 [ 2009-06-30 - ]
c-equal
3 Unit u000
u-equal
us-gaap:LiabilitiesAndStockholdersEquity NA -3 [7] 1507236000 1,507,236,000 Instance OK
us-gaap:StockholdersEquity 1.0 NA -3 [6] 686464000 228,482,000 Instance Inconsistency found, calculated value is 228,482,000
us-gaap:AdditionalPaidInCapitalCommonStock 1.0 credit -3 [5] 52152000 52,152,000 Instance
us-gaap:AccumulatedOtherComprehensiveIncomeLossNetOfTax 1.0 credit -3 [5] 71851000 71,851,000 Instance
us-gaap:RetainedEarningsAccumulatedDeficit 1.0 credit -3 [6] 104479000 104,479,000 Instance
us-gaap:Liabilities 1.0 NA -3 [6] 502044000 502,044,000 Instance OK
us-gaap:AccountsPayableAndAccruedLiabilitiesNoncurrent 1.0 credit -3 [5] 23073000 23,073,000 Instance
us-gaap:LongTermLoansFromBank 1.0 credit -3 [6] 299234000 299,234,000 Instance
us-gaap:DeferredRevenueAndCreditsNoncurrent 1.0 credit -3 [4] 7914000 7,914,000 Instance
us-gaap:LiabilityForUncertainTaxPositionsNoncurrent 1.0 credit -3 [5] 47131000 47,131,000 Instance
us-gaap:DeferredTaxLiabilitiesNoncurrent 1.0 credit -3 [6] 108889000 108,889,000 Instance
us-gaap:DefinedBenefitPensionPlanLiabilitiesNoncurrent 1.0 credit -3 [5] 15803000 15,803,000 Instance
us-gaap:LiabilitiesCurrent 1.0 NA -3 [6] 318728000 318,728,000 Instance OK
otex:AccountsPayableAndAccruedLiabilitie 1.0 -3 [6] 115018000 115,018,000 Instance
us-gaap:LoansPayableToBankCurrent 1.0 credit -3 [4] 3449000 3,449,000 Instance
us-gaap:DeferredRevenueCurrent 1.0 credit -3 [6] 189397000 189,397,000 Instance
us-gaap:DeferredTaxLiabilitiesCurrent 1.0 credit -3 [3] 508000 508,000 Instance
us-gaap:AccruedIncomeTaxesCurrent 1.0 credit -3 [5] 10356000 10,356,000 Instance
us-gaap:Assets NA -3 [7] 1507236000 1,507,236,000 Instance OK
us-gaap:AssetsCurrent 1.0 NA -3 [6] 434910000 434,910,000 Instance OK
us-gaap:CashAndCashEquivalentsAtCarryingValue 1.0 debit -3 [6] 275819000 275,819,000 Instance
us-gaap:AvailableForSaleSecuritiesCurrent 1.0 debit -3 [0] 0 0 Instance
us-gaap:AccountsReceivableNetCurrent 1.0 debit -3 [6] 115802000 115,802,000 Instance
us-gaap:IncomeTaxesReceivable 1.0 debit -3 [4] 4496000 4,496,000 Instance
otex:PrepaidExpensesAndOtherCurrentAssets 1.0 -3 [5] 18172000 18,172,000 Instance
us-gaap:DeferredTaxAssetsNetCurrent 1.0 debit -3 [5] 20621000 20,621,000 Instance
us-gaap:PropertyPlantAndEquipmentNet 1.0 debit -3 [5] 45165000 45,165,000 Instance
us-gaap:Goodwill 1.0 debit -3 [6] 576111000 576,111,000 Instance
us-gaap:IntangibleAssetsNetExcludingGoodwill 1.0 debit -3 [6] 315048000 315,048,000 Instance
us-gaap:DeferredTaxAssetsNetNoncurrent 1.0 debit -3 [5] 69877000 69,877,000 Instance
us-gaap:OtherAssetsNoncurrent 1.0 debit -3 [5] 13064000 13,064,000 Instance
otex:LongTermIncomeTaxesRecoverable 1.0 -3 [5] 39958000 39,958,000 Instance
otex:InvestmentsInMarketableSecurities 1.0 -3 [5] 13103000 13,103,000 Instance
2 Context c00003 [ 2009-09-30 - ]
c-equal
3 Unit u000
u-equal
us-gaap:LiabilitiesAndStockholdersEquity NA -3 [7] 1720551000 1,720,551,000 Instance OK
us-gaap:StockholdersEquity 1.0 NA -3 [6] 836439000 247,568,000 Instance Inconsistency found, calculated value is 247,568,000
us-gaap:AdditionalPaidInCapitalCommonStock 1.0 credit -3 [5] 55307000 55,307,000 Instance
us-gaap:AccumulatedOtherComprehensiveIncomeLossNetOfTax 1.0 credit -3 [5] 86052000 86,052,000 Instance
us-gaap:RetainedEarningsAccumulatedDeficit 1.0 credit -3 [6] 106209000 106,209,000 Instance
us-gaap:Liabilities 1.0 NA -3 [6] 536175000 536,175,000 Instance OK
us-gaap:AccountsPayableAndAccruedLiabilitiesNoncurrent 1.0 credit -3 [5] 21506000 21,506,000 Instance
us-gaap:LongTermLoansFromBank 1.0 credit -3 [6] 299182000 299,182,000 Instance
us-gaap:DeferredRevenueAndCreditsNoncurrent 1.0 credit -3 [5] 10969000 10,969,000 Instance
us-gaap:LiabilityForUncertainTaxPositionsNoncurrent 1.0 credit -3 [5] 53465000 53,465,000 Instance
us-gaap:DeferredTaxLiabilitiesNoncurrent 1.0 credit -3 [6] 134543000 134,543,000 Instance
us-gaap:DefinedBenefitPensionPlanLiabilitiesNoncurrent 1.0 credit -3 [5] 16510000 16,510,000 Instance
us-gaap:LiabilitiesCurrent 1.0 NA -3 [6] 347937000 347,937,000 Instance OK
otex:AccountsPayableAndAccruedLiabilitie 1.0 -3 [6] 128660000 128,660,000 Instance
us-gaap:LoansPayableToBankCurrent 1.0 credit -3 [4] 3489000 3,489,000 Instance
us-gaap:DeferredRevenueCurrent 1.0 credit -3 [6] 205998000 205,998,000 Instance
us-gaap:DeferredTaxLiabilitiesCurrent 1.0 credit -3 [4] 2083000 2,083,000 Instance
us-gaap:AccruedIncomeTaxesCurrent 1.0 credit -3 [4] 7707000 7,707,000 Instance
us-gaap:Assets NA -3 [7] 1720551000 1,720,551,000 Instance OK
us-gaap:AssetsCurrent 1.0 NA -3 [6] 423801000 423,801,000 Instance OK
us-gaap:CashAndCashEquivalentsAtCarryingValue 1.0 debit -3 [6] 212190000 212,190,000 Instance
us-gaap:AvailableForSaleSecuritiesCurrent 1.0 debit -3 [5] 19768000 19,768,000 Instance
us-gaap:AccountsReceivableNetCurrent 1.0 debit -3 [6] 135575000 135,575,000 Instance
us-gaap:IncomeTaxesReceivable 1.0 debit -3 [4] 6225000 6,225,000 Instance
otex:PrepaidExpensesAndOtherCurrentAssets 1.0 -3 [5] 27858000 27,858,000 Instance
us-gaap:DeferredTaxAssetsNetCurrent 1.0 debit -3 [5] 22185000 22,185,000 Instance
us-gaap:PropertyPlantAndEquipmentNet 1.0 debit -3 [5] 57435000 57,435,000 Instance
us-gaap:Goodwill 1.0 debit -3 [6] 718600000 718,600,000 Instance
us-gaap:IntangibleAssetsNetExcludingGoodwill 1.0 debit -3 [6] 384242000 384,242,000 Instance
us-gaap:DeferredTaxAssetsNetNoncurrent 1.0 debit -3 [5] 75211000 75,211,000 Instance
us-gaap:OtherAssetsNoncurrent 1.0 debit -3 [5] 18871000 18,871,000 Instance
otex:LongTermIncomeTaxesRecoverable 1.0 -3 [5] 42391000 42,391,000 Instance
otex:InvestmentsInMarketableSecurities 1.0 -3 [0] 0 0 Instance


1 Extended Link [ http://opentext.com/role/StatementOfIncome ]
2 Context c00004 [ 2009-07-01 - 2009-09-30 ]
c-equal
3 Unit u000
u-equal
us-gaap:NetIncomeLoss NA -3 [4] 1730000 1,730,000 Instance OK
otex:NetIncomeBeforeMinorityInterest 1.0 NA -3 [4] 1730000 1,730,000 Instance OK
us-gaap:IncomeLossFromContinuingOperationsBeforeIncomeTaxesMinorityInterestAndIncomeLossFromEquityMethodInvestments 1.0 NA -3 [4] 5186000 5,186,000 Instance OK
us-gaap:OperatingIncomeLoss 1.0 NA -3 [4] 4792000 4,792,000 Instance OK
us-gaap:GrossProfit 1.0 NA -3 [6] 139902000 139,902,000 Instance OK
us-gaap:Revenues 1.0 NA -3 [6] 211422000 211,422,000 Instance OK
us-gaap:LicensesRevenue 1.0 credit -3 [5] 47329000 47,329,000 Instance
us-gaap:MaintenanceRevenue 1.0 credit -3 [6] 123649000 123,649,000 Instance
otex:ServiceAndOtherRevenue 1.0 -3 [5] 40444000 40,444,000 Instance
us-gaap:CostOfRevenue -1.0 NA -3 [5] 71520000 71,520,000 Instance OK
us-gaap:LicenseCosts 1.0 debit -3 [4] 3145000 3,145,000 Instance
us-gaap:CostOfServicesMaintenanceCosts 1.0 debit -3 [5] 20939000 20,939,000 Instance
otex:CostOfRevenuesServiceAndOther 1.0 -3 [5] 33294000 33,294,000 Instance
otex:CostOfRevenuesAmortizationOfAcquiredTechnologyIntangibleAssets 1.0 -3 [5] 14142000 14,142,000 Instance
us-gaap:OperatingExpenses -1.0 NA -3 [6] 135110000 135,110,000 Instance OK
us-gaap:ResearchAndDevelopmentExpenseExcludingAcquiredInProcessCost 1.0 debit -3 [5] 31542000 31,542,000 Instance
us-gaap:SellingAndMarketingExpense 1.0 debit -3 [5] 50690000 50,690,000 Instance
us-gaap:GeneralAndAdministrativeExpense 1.0 debit -3 [5] 21225000 21,225,000 Instance
us-gaap:DepreciationNonproduction 1.0 debit -3 [4] 4147000 4,147,000 Instance
otex:AmortizationOfAcquiredCustomerIntangibleAssets 1.0 -3 [4] 8917000 8,917,000 Instance
us-gaap:RestructuringCharges 1.0 debit -3 [5] 18589000 18,589,000 Instance
us-gaap:OtherNonoperatingIncomeExpense 1.0 credit -3 [4] 3440000 3,440,000 Instance
us-gaap:InterestIncomeExpenseNet 1.0 credit -3 [4] -3046000 -3,046,000 Instance
us-gaap:IncomeTaxExpenseBenefit -1.0 debit -3 [4] 3456000 3,456,000 Instance
us-gaap:NetIncomeLossAttributableToNoncontrollingInterest -1.0 debit -3 [0] 0 0 Instance
2 Context c00005 [ 2008-07-01 - 2008-09-30 ]
c-equal
3 Unit u000
u-equal
us-gaap:NetIncomeLoss NA -3 [5] 14661000 14,661,000 Instance OK
otex:NetIncomeBeforeMinorityInterest 1.0 NA -3 [5] 14780000 14,780,000 Instance OK
us-gaap:IncomeLossFromContinuingOperationsBeforeIncomeTaxesMinorityInterestAndIncomeLossFromEquityMethodInvestments 1.0 NA -3 [5] 20712000 20,712,000 Instance OK
us-gaap:OperatingIncomeLoss 1.0 NA -3 [5] 22977000 22,977,000 Instance OK
us-gaap:GrossProfit 1.0 NA -3 [6] 125687000 125,687,000 Instance OK
us-gaap:Revenues 1.0 NA -3 [6] 182623000 182,623,000 Instance OK
us-gaap:LicensesRevenue 1.0 credit -3 [5] 50074000 50,074,000 Instance
us-gaap:MaintenanceRevenue 1.0 credit -3 [5] 98429000 98,429,000 Instance
otex:ServiceAndOtherRevenue 1.0 -3 [5] 34120000 34,120,000 Instance
us-gaap:CostOfRevenue -1.0 NA -3 [5] 56936000 56,936,000 Instance OK
us-gaap:LicenseCosts 1.0 debit -3 [4] 2893000 2,893,000 Instance
us-gaap:CostOfServicesMaintenanceCosts 1.0 debit -3 [5] 15567000 15,567,000 Instance
otex:CostOfRevenuesServiceAndOther 1.0 -3 [5] 27729000 27,729,000 Instance
otex:CostOfRevenuesAmortizationOfAcquiredTechnologyIntangibleAssets 1.0 -3 [5] 10747000 10,747,000 Instance
us-gaap:OperatingExpenses -1.0 NA -3 [6] 102710000 102,710,000 Instance OK
us-gaap:ResearchAndDevelopmentExpenseExcludingAcquiredInProcessCost 1.0 debit -3 [5] 28578000 28,578,000 Instance
us-gaap:SellingAndMarketingExpense 1.0 debit -3 [5] 44832000 44,832,000 Instance
us-gaap:GeneralAndAdministrativeExpense 1.0 debit -3 [5] 18387000 18,387,000 Instance
us-gaap:DepreciationNonproduction 1.0 debit -3 [4] 2698000 2,698,000 Instance
otex:AmortizationOfAcquiredCustomerIntangibleAssets 1.0 -3 [4] 8215000 8,215,000 Instance
us-gaap:RestructuringCharges 1.0 debit -3 [0] 0 0 Instance
us-gaap:OtherNonoperatingIncomeExpense 1.0 credit -3 [3] 729000 729,000 Instance
us-gaap:InterestIncomeExpenseNet 1.0 credit -3 [4] -2994000 -2,994,000 Instance
us-gaap:IncomeTaxExpenseBenefit -1.0 debit -3 [4] 5932000 5,932,000 Instance
us-gaap:NetIncomeLossAttributableToNoncontrollingInterest -1.0 debit -3 [3] 119000 119,000 Instance


1 Extended Link [ http://opentext.com/role/CashFlow ]
2 Context c00004 [ 2009-07-01 - 2009-09-30 ]
c-equal
3 Unit u000
u-equal
us-gaap:CashAndCashEquivalentsPeriodIncreaseDecrease NA -3 [5] -63629000 -63,629,000 Instance OK
us-gaap:NetCashProvidedByUsedInOperatingActivities 1.0 NA -3 [4] 4502000 4,502,000 Instance OK
us-gaap:NetIncomeLoss 1.0 credit -3 [4] 1730000 1,730,000 Instance
us-gaap:DepreciationAndAmortization 1.0 debit -3 [5] 27206000 27,206,000 Instance
us-gaap:ShareBasedCompensation 1.0 debit -3 [4] 3506000 3,506,000 Instance
otex:EmployeeLongTermIncentivePlan 1.0 -3 [4] 2675000 2,675,000 Instance
us-gaap:ExcessTaxBenefitFromShareBasedCompensationOperatingActivities 1.0 credit -3 [3] -691000 -691,000 Instance
us-gaap:PensionExpense 1.0 debit -3 [3] 192000 192,000 Instance
us-gaap:AmortizationOfFinancingCosts 1.0 debit -3 [3] 266000 266,000 Instance
us-gaap:UnrealizedGainLossOnDerivatives 1.0 credit -3 [4] -2390000 -2,390,000 Instance
us-gaap:DeferredIncomeTaxExpenseBenefit 1.0 debit -3 [4] -2957000 -2,957,000 Instance
us-gaap:IncreaseDecreaseInReceivables 1.0 credit -3 [4] 7928000 7,928,000 Instance
us-gaap:IncreaseDecreaseInPrepaidDeferredExpenseAndOtherAssets 1.0 credit -3 [4] -3218000 -3,218,000 Instance
otex:IncomeTaxes 1.0 -3 [4] -4787000 -4,787,000 Instance
us-gaap:IncreaseDecreaseInAccountsPayableAndAccruedLiabilities 1.0 debit -3 [4] -9343000 -9,343,000 Instance
us-gaap:IncreaseDecreaseInDeferredRevenue 1.0 debit -3 [5] -12437000 -12,437,000 Instance
us-gaap:IncreaseDecreaseInOtherOperatingAssets 1.0 credit -3 [4] 1175000 1,175,000 Instance
us-gaap:NetIncomeLossAttributableToNoncontrollingInterest 1.0 debit -3 [0] 0 0 Instance
otex:ReleaseOfUnrealizedGainOnMarketableSecuritiesToIncome 1.0 debit -3 [4] -4353000 -4,353,000 Instance
us-gaap:NetCashProvidedByUsedInInvestingActivities 1.0 NA -3 [5] -75895000 -50,963,000 Instance Inconsistency found, calculated value is -50,963,000
us-gaap:PaymentsToAcquireProductiveAssets -1.0 credit -3 [4] -7665000 -7,665,000 Instance
us-gaap:PaymentsForProceedsFromPreviousAcquisition -1.0 credit -3 [4] -4801000 -4,801,000 Instance
otex:PurchaseOfHummingbirdNetOfCashAcquired 1.0 -3 [5] -90600000 -90,600,000 Instance
otex:PurchaseOfEmotionLlcNetOfCashAcquired 1.0 -3 [0] 0 0 Instance
us-gaap:PaymentsToAcquireMarketableSecurities -1.0 credit -3 [0] 0 0 Instance
otex:PurchaseOfDivisionOfSpicerCorporation 1.0 -3 [0] 0 0 Instance
otex:MaturityOfShortTermInvestments 1.0 debit -3 [5] 27171000 27,171,000 Instance
us-gaap:NetCashProvidedByUsedInFinancingActivities 1.0 NA -3 [4] 3280000 7,056,000 Instance Inconsistency found, calculated value is 7,056,000
us-gaap:ExcessTaxBenefitFromShareBasedCompensationFinancingActivities 1.0 debit -3 [3] 691000 691,000 Instance
us-gaap:ProceedsFromIssuanceOfCommonStock 1.0 debit -3 [4] 4477000 4,477,000 Instance
us-gaap:RepaymentsOfLongTermDebt -1.0 credit -3 [3] -864000 -864,000 Instance
us-gaap:PaymentsOfDebtIssuanceCosts -1.0 credit -3 [4] -1024000 -1,024,000 Instance
us-gaap:EffectOfExchangeRateOnCashAndCashEquivalents 1.0 debit -3 [4] 4484000 4,484,000 Instance
2 Context c00005 [ 2008-07-01 - 2008-09-30 ]
c-equal
3 Unit u000
u-equal
us-gaap:CashAndCashEquivalentsPeriodIncreaseDecrease NA -3 [4] -4783000 -4,783,000 Instance OK
us-gaap:NetCashProvidedByUsedInOperatingActivities 1.0 NA -3 [5] 24813000 24,813,000 Instance OK
us-gaap:NetIncomeLoss 1.0 credit -3 [5] 14661000 14,661,000 Instance
us-gaap:DepreciationAndAmortization 1.0 debit -3 [5] 21660000 21,660,000 Instance
us-gaap:ShareBasedCompensation 1.0 debit -3 [4] 1423000 1,423,000 Instance
otex:EmployeeLongTermIncentivePlan 1.0 -3 [4] 1059000 1,059,000 Instance
us-gaap:ExcessTaxBenefitFromShareBasedCompensationOperatingActivities 1.0 credit -3 [4] -6629000 -6,629,000 Instance
us-gaap:PensionExpense 1.0 debit -3 [0] 0 0 Instance
us-gaap:AmortizationOfFinancingCosts 1.0 debit -3 [3] 224000 224,000 Instance
us-gaap:UnrealizedGainLossOnDerivatives 1.0 credit -3 [3] -722000 -722,000 Instance
us-gaap:DeferredIncomeTaxExpenseBenefit 1.0 debit -3 [3] -256000 -256,000 Instance
us-gaap:IncreaseDecreaseInReceivables 1.0 credit -3 [5] 27946000 27,946,000 Instance
us-gaap:IncreaseDecreaseInPrepaidDeferredExpenseAndOtherAssets 1.0 credit -3 [4] -1926000 -1,926,000 Instance
otex:IncomeTaxes 1.0 -3 [4] 4731000 4,731,000 Instance
us-gaap:IncreaseDecreaseInAccountsPayableAndAccruedLiabilities 1.0 debit -3 [5] -18369000 -18,369,000 Instance
us-gaap:IncreaseDecreaseInDeferredRevenue 1.0 debit -3 [5] -19430000 -19,430,000 Instance
us-gaap:IncreaseDecreaseInOtherOperatingAssets 1.0 credit -3 [3] 322000 322,000 Instance
us-gaap:NetIncomeLossAttributableToNoncontrollingInterest 1.0 debit -3 [3] 119000 119,000 Instance
otex:ReleaseOfUnrealizedGainOnMarketableSecuritiesToIncome 1.0 debit -3 [0] 0 0 Instance
us-gaap:NetCashProvidedByUsedInInvestingActivities 1.0 NA -3 [5] -25259000 -3,683,000 Instance Inconsistency found, calculated value is -3,683,000
us-gaap:PaymentsToAcquireProductiveAssets -1.0 credit -3 [4] -3887000 -3,887,000 Instance
us-gaap:PaymentsForProceedsFromPreviousAcquisition -1.0 credit -3 [4] -3293000 -3,293,000 Instance
otex:PurchaseOfHummingbirdNetOfCashAcquired 1.0 -3 [0] 0 0 Instance
otex:PurchaseOfEmotionLlcNetOfCashAcquired 1.0 -3 [4] -3635000 -3,635,000 Instance
us-gaap:PaymentsToAcquireMarketableSecurities -1.0 credit -3 [4] -3608000 -3,608,000 Instance
otex:PurchaseOfDivisionOfSpicerCorporation 1.0 -3 [5] -10836000 -10,836,000 Instance
otex:MaturityOfShortTermInvestments 1.0 debit -3 [0] 0 0 Instance
us-gaap:NetCashProvidedByUsedInFinancingActivities 1.0 NA -3 [5] 11304000 13,038,000 Instance Inconsistency found, calculated value is 13,038,000
us-gaap:ExcessTaxBenefitFromShareBasedCompensationFinancingActivities 1.0 debit -3 [4] 6629000 6,629,000 Instance
us-gaap:ProceedsFromIssuanceOfCommonStock 1.0 debit -3 [4] 5542000 5,542,000 Instance
us-gaap:RepaymentsOfLongTermDebt -1.0 credit -3 [3] -867000 -867,000 Instance
us-gaap:PaymentsOfDebtIssuanceCosts -1.0 credit -3 [0] 0 0 Instance
us-gaap:EffectOfExchangeRateOnCashAndCashEquivalents 1.0 debit -3 [5] -15641000 -15,641,000 Instance


Copyright (c) UBmatrix, Inc. 2009