UBmatrix Calculation Trace Report
Line Concept Weight Balance Decimals Precision Reported Calculated Source Message
1 Extended Link [ http://www.adp.com/role/StatementConsolidatedBalanceSheets ]
2 Context As_Of_9_30_2009 [ 2009-09-30 - ]
c-equal
3 Unit Unit_1
u-equal
us-gaap:Assets NA -5 [6] 24436100000 24,436,100,000 Instance OK
us-gaap:AssetsCurrent 1.0 NA -5 [6] 19718400000 19,718,400,000 Instance OK
adp:TotalAssetsBeforeFundsHeldClients 1.0 NA -5 [5] 3445900000 3,445,900,000 Instance OK
us-gaap:CashAndCashEquivalentsAtCarryingValue 1.0 debit -5 [5] 1582800000 1,582,800,000 Instance
us-gaap:ShortTermInvestments 1.0 debit -5 [3] 36600000 36,600,000 Instance
us-gaap:AccountsReceivableNetCurrent 1.0 debit -5 [4] 994300000 994,300,000 Instance
us-gaap:OtherAssetsCurrent 1.0 debit -5 [4] 825500000 825,500,000 Instance
us-gaap:AssetsOfDisposalGroupIncludingDiscontinuedOperationCurrent 1.0 debit -5 [2] 6700000 6,700,000 Instance
adp:FundsHeldClients 1.0 debit -5 [6] 16272500000 16,272,500,000 Instance
us-gaap:MarketableSecuritiesNoncurrent 1.0 debit -5 [3] 99200000 99,200,000 Instance
us-gaap:AccountsReceivableNetNoncurrent 1.0 debit -5 [4] 147700000 147,700,000 Instance
us-gaap:PropertyPlantAndEquipmentNet 1.0 debit -5 [4] 723500000 723,500,000 Instance
us-gaap:OtherAssetsNoncurrent 1.0 debit -5 [4] 780100000 780,100,000 Instance
us-gaap:Goodwill 1.0 debit -5 [5] 2409800000 2,409,800,000 Instance
us-gaap:IntangibleAssetsNetExcludingGoodwill 1.0 debit -5 [4] 557400000 557,400,000 Instance
us-gaap:LiabilitiesAndStockholdersEquity NA -5 [6] 24436100000 24,436,100,000 Instance OK
us-gaap:StockholdersEquity 1.0 NA -5 [5] 5654000000 5,654,000,000 Instance OK
us-gaap:PreferredStockValue 1.0 credit -5 [0] 0 0 Instance
us-gaap:CommonStockValue 1.0 credit -5 [3] 63900000 63,900,000 Instance
us-gaap:AdditionalPaidInCapitalCommonStock 1.0 credit -5 [4] 470000000 470,000,000 Instance
us-gaap:TreasuryStockValue -1.0 debit -5 [5] 6054800000 6,054,800,000 Instance
us-gaap:AccumulatedOtherComprehensiveIncomeLossNetOfTax 1.0 credit -5 [4] 339900000 339,900,000 Instance
us-gaap:RetainedEarningsAccumulatedDeficit 1.0 credit -5 [6] 10835000000 10,835,000,000 Instance
us-gaap:Liabilities 1.0 NA -5 [6] 18782100000 18,782,100,000 Instance OK
us-gaap:OtherLongTermDebtNoncurrent 1.0 credit -5 [3] 42200000 42,200,000 Instance
us-gaap:DeferredRevenueNoncurrent 1.0 credit -5 [4] 484000000 484,000,000 Instance
us-gaap:DeferredTaxLiabilitiesNoncurrent 1.0 credit -5 [4] 350000000 350,000,000 Instance
us-gaap:OtherLiabilitiesNoncurrent 1.0 credit -5 [4] 461900000 461,900,000 Instance
us-gaap:LiabilitiesCurrent 1.0 NA -5 [6] 17444000000 17,444,000,000 Instance OK
adp:ClientFundsObligations -1.0 debit -5 [6] -15633700000 -15,633,700,000 Instance
adp:TotalCurrentLiabilitiesBeforeClientFundsObligations -1.0 NA -5 [5] -1810300000 -1,810,300,000 Instance OK
us-gaap:AccountsPayableCurrent -1.0 credit -5 [3] 94600000 94,600,000 Instance
us-gaap:AccruedLiabilitiesCurrent -1.0 credit -5 [4] 725400000 725,400,000 Instance
us-gaap:EmployeeRelatedLiabilitiesCurrent -1.0 credit -5 [4] 361600000 361,600,000 Instance
us-gaap:AccruedIncomeTaxesCurrent -1.0 credit -5 [4] 143100000 143,100,000 Instance
us-gaap:DeferredRevenueAndCreditsCurrent -1.0 credit -5 [4] 323400000 323,400,000 Instance
adp:ObligationUnderReverseRepurchaseAgreement 1.0 debit -5 [0] 0 0 Instance
us-gaap:InterestAndDividendsPayableCurrent -1.0 credit -5 [4] 162200000 162,200,000 Instance
2 Context As_Of_6_30_2009 [ 2009-06-30 - ]
c-equal
3 Unit Unit_1
u-equal
us-gaap:Assets NA -5 [6] 25351700000 25,351,700,000 Instance OK
us-gaap:AssetsCurrent 1.0 NA -5 [6] 20703900000 20,703,900,000 Instance OK
adp:TotalAssetsBeforeFundsHeldClients 1.0 NA -5 [5] 4284700000 4,284,700,000 Instance OK
us-gaap:CashAndCashEquivalentsAtCarryingValue 1.0 debit -5 [5] 2265300000 2,265,300,000 Instance
us-gaap:ShortTermInvestments 1.0 debit -5 [3] 30800000 30,800,000 Instance
us-gaap:AccountsReceivableNetCurrent 1.0 debit -5 [5] 1055400000 1,055,400,000 Instance
us-gaap:OtherAssetsCurrent 1.0 debit -5 [4] 921100000 921,100,000 Instance
us-gaap:AssetsOfDisposalGroupIncludingDiscontinuedOperationCurrent 1.0 debit -5 [3] 12100000 12,100,000 Instance
adp:FundsHeldClients 1.0 debit -5 [6] 16419200000 16,419,200,000 Instance
us-gaap:MarketableSecuritiesNoncurrent 1.0 debit -5 [3] 92400000 92,400,000 Instance
us-gaap:AccountsReceivableNetNoncurrent 1.0 debit -5 [4] 162600000 162,600,000 Instance
us-gaap:PropertyPlantAndEquipmentNet 1.0 debit -5 [4] 734500000 734,500,000 Instance
us-gaap:OtherAssetsNoncurrent 1.0 debit -5 [4] 702700000 702,700,000 Instance
us-gaap:Goodwill 1.0 debit -5 [5] 2375500000 2,375,500,000 Instance
us-gaap:IntangibleAssetsNetExcludingGoodwill 1.0 debit -5 [4] 580100000 580,100,000 Instance
us-gaap:LiabilitiesAndStockholdersEquity NA -5 [6] 25351700000 25,351,700,000 Instance OK
us-gaap:StockholdersEquity 1.0 NA -5 [5] 5322600000 5,322,600,000 Instance OK
us-gaap:PreferredStockValue 1.0 credit -5 [0] 0 0 Instance
us-gaap:CommonStockValue 1.0 credit -5 [3] 63900000 63,900,000 Instance
us-gaap:AdditionalPaidInCapitalCommonStock 1.0 credit -5 [4] 520000000 520,000,000 Instance
us-gaap:TreasuryStockValue -1.0 debit -5 [5] 6133900000 6,133,900,000 Instance
us-gaap:AccumulatedOtherComprehensiveIncomeLossNetOfTax 1.0 credit -5 [4] 156000000 156,000,000 Instance
us-gaap:RetainedEarningsAccumulatedDeficit 1.0 credit -5 [6] 10716600000 10,716,600,000 Instance
us-gaap:Liabilities 1.0 NA -5 [6] 20029100000 20,029,100,000 Instance OK
us-gaap:OtherLongTermDebtNoncurrent 1.0 credit -5 [3] 42700000 42,700,000 Instance
us-gaap:DeferredRevenueNoncurrent 1.0 credit -5 [4] 498500000 498,500,000 Instance
us-gaap:DeferredTaxLiabilitiesNoncurrent 1.0 credit -5 [4] 254500000 254,500,000 Instance
us-gaap:OtherLiabilitiesNoncurrent 1.0 credit -5 [4] 477100000 477,100,000 Instance
us-gaap:LiabilitiesCurrent 1.0 NA -5 [6] 18756300000 18,756,300,000 Instance OK
adp:ClientFundsObligations -1.0 debit -5 [6] -15992600000 -15,992,600,000 Instance
adp:TotalCurrentLiabilitiesBeforeClientFundsObligations -1.0 NA -5 [5] -2763700000 -2,763,700,000 Instance OK
us-gaap:AccountsPayableCurrent -1.0 credit -5 [4] 130300000 130,300,000 Instance
us-gaap:AccruedLiabilitiesCurrent -1.0 credit -5 [4] 778500000 778,500,000 Instance
us-gaap:EmployeeRelatedLiabilitiesCurrent -1.0 credit -5 [4] 402300000 402,300,000 Instance
us-gaap:AccruedIncomeTaxesCurrent -1.0 credit -5 [4] 230700000 230,700,000 Instance
us-gaap:DeferredRevenueAndCreditsCurrent -1.0 credit -5 [4] 329800000 329,800,000 Instance
adp:ObligationUnderReverseRepurchaseAgreement 1.0 debit -5 [4] -730000000 -730,000,000 Instance
us-gaap:InterestAndDividendsPayableCurrent -1.0 credit -5 [4] 162100000 162,100,000 Instance


1 Extended Link [ http://www.adp.com/role/StatementStatementsOfConsolidatedEarnings ]
2 Context Duration_7_1_2008_To_9_30_2008 [ 2008-07-01 - 2008-09-30 ]
c-equal
3 Unit Unit_1
u-equal
us-gaap:IncomeLossFromContinuingOperationsIncludingPortionAttributableToNoncontrollingInterest NA -5 [4] 278000000 278,000,000 Instance OK
us-gaap:IncomeLossFromContinuingOperationsBeforeIncomeTaxesMinorityInterestAndIncomeLossFromEquityMethodInvestments 1.0 NA -5 [4] 441300000 441,300,000 Instance OK
us-gaap:Revenues 1.0 NA -5 [5] 2181500000 2,181,500,000 Instance OK
adp:InterestOnFundsHeldClients -1.0 debit -5 [4] -151900000 -151,900,000 Instance
adp:Peorevenues 1.0 credit -5 [4] 277100000 277,100,000 Instance
us-gaap:SalesRevenueNet 1.0 credit -5 [5] 1752500000 1,752,500,000 Instance
us-gaap:OperatingExpenses -1.0 NA -5 [5] 1782600000 1,782,600,000 Instance OK
us-gaap:InterestExpense 1.0 debit -5 [3] 19200000 19,200,000 Instance
us-gaap:CostOfGoodsAndServicesSold 1.0 debit -5 [5] 1236700000 1,236,700,000 Instance
us-gaap:SellingGeneralAndAdministrativeExpense 1.0 debit -5 [4] 526700000 526,700,000 Instance
us-gaap:NonoperatingIncomeExpense 1.0 credit -5 [3] 42400000 42,400,000 Instance
us-gaap:IncomeTaxExpenseBenefit -1.0 debit -5 [4] 163300000 163,300,000 Instance
2 Context Duration_7_1_2009_To_9_30_2009 [ 2009-07-01 - 2009-09-30 ]
c-equal
3 Unit Unit_1
u-equal
us-gaap:IncomeLossFromContinuingOperationsIncludingPortionAttributableToNoncontrollingInterest NA -5 [4] 284100000 284,100,000 Instance OK
us-gaap:IncomeLossFromContinuingOperationsBeforeIncomeTaxesMinorityInterestAndIncomeLossFromEquityMethodInvestments 1.0 NA -5 [4] 447300000 447,300,000 Instance OK
us-gaap:Revenues 1.0 NA -5 [5] 2102800000 2,102,800,000 Instance OK
adp:InterestOnFundsHeldClients -1.0 debit -5 [4] -127900000 -127,900,000 Instance
adp:Peorevenues 1.0 credit -5 [4] 293900000 293,900,000 Instance
us-gaap:SalesRevenueNet 1.0 credit -5 [5] 1681000000 1,681,000,000 Instance
us-gaap:OperatingExpenses -1.0 NA -5 [5] 1689200000 1,689,200,000 Instance OK
us-gaap:InterestExpense 1.0 debit -5 [2] 3200000 3,200,000 Instance
us-gaap:CostOfGoodsAndServicesSold 1.0 debit -5 [5] 1193300000 1,193,300,000 Instance
us-gaap:SellingGeneralAndAdministrativeExpense 1.0 debit -5 [4] 492700000 492,700,000 Instance
us-gaap:NonoperatingIncomeExpense 1.0 credit -5 [3] 33700000 33,700,000 Instance
us-gaap:IncomeTaxExpenseBenefit -1.0 debit -5 [4] 163200000 163,200,000 Instance


1 Extended Link [ http://www.adp.com/role/StatementStatementsOfConsolidatedCashFlows ]
2 Context Duration_7_1_2008_To_9_30_2008 [ 2008-07-01 - 2008-09-30 ]
c-equal
3 Unit Unit_1
u-equal
us-gaap:CashAndCashEquivalentsPeriodIncreaseDecrease NA -5 [4] 478900000 478,900,000 Instance OK
us-gaap:NetCashProvidedByUsedInOperatingActivities 1.0 NA -5 [4] 398200000 398,200,000 Instance OK
us-gaap:NetIncomeLoss 1.0 credit -5 [4] 276900000 276,900,000 Instance
us-gaap:DiscontinuedOperationProvisionForLossGainOnDisposalNetOfTax 1.0 debit -5 [2] 1100000 1,100,000 Instance
us-gaap:DepreciationAndAmortization 1.0 debit -5 [3] 77300000 77,300,000 Instance
us-gaap:DeferredIncomeTaxExpenseBenefit 1.0 debit -5 [3] -12200000 -12,200,000 Instance
us-gaap:ShareBasedCompensation 1.0 debit -5 [3] 27900000 27,900,000 Instance
us-gaap:PensionExpense 1.0 debit -5 [2] 8500000 8,500,000 Instance
us-gaap:GainLossOnInvestments -1.0 credit -5 [1] -800000 -800,000 Instance
us-gaap:AmortizationOfDebtDiscountPremium 1.0 debit -5 [3] 14300000 14,300,000 Instance
us-gaap:ImpairmentOfInvestments 1.0 debit -5 [0] 0 0 Instance
adp:GainOnSaleOfAssetsHeldForSale 1.0 debit -5 [0] 0 0 Instance
us-gaap:OtherNoncashExpense 1.0 debit -5 [2] 1100000 1,100,000 Instance
us-gaap:IncreaseDecreaseInAccountsAndNotesReceivable 1.0 credit -5 [2] -6100000 -6,100,000 Instance
us-gaap:IncreaseDecreaseInOtherOperatingAssets 1.0 credit -5 [3] 77400000 77,400,000 Instance
us-gaap:IncreaseDecreaseInAccountsPayableTrade 1.0 debit -5 [3] -28200000 -28,200,000 Instance
us-gaap:IncreaseDecreaseInAccruedLiabilities 1.0 debit -5 [3] -40600000 -40,600,000 Instance
us-gaap:NetCashProvidedByUsedInInvestingActivities 1.0 NA -5 [4] -500900000 -500,900,000 Instance OK
us-gaap:PaymentsToAcquireMarketableSecurities -1.0 credit -5 [4] 965800000 965,800,000 Instance
us-gaap:ProceedsFromSaleOfAvailableForSaleSecurities 1.0 debit -5 [4] 704000000 704,000,000 Instance
adp:NetDecreaseIncreaseInRestrictedCashCashEquivalentsOtherRestrictedAssetsHeldToSatisfyClientFundsObligations 1.0 debit -5 [3] 14400000 14,400,000 Instance
us-gaap:PaymentsToAcquireOtherPropertyPlantAndEquipment -1.0 credit -5 [3] 45100000 45,100,000 Instance
us-gaap:PaymentsToAcquireIntangibleAssets -1.0 credit -5 [3] 16400000 16,400,000 Instance
us-gaap:PaymentsToAcquireBusinessesNetOfCashAcquired -1.0 credit -5 [2] 4200000 4,200,000 Instance
adp:ReclassificationFromCashCashEquivalentsToShorttermMarketableSecurities 1.0 debit -5 [4] -211100000 -211,100,000 Instance
us-gaap:PaymentsForProceedsFromOtherInvestingActivities -1.0 credit -5 [2] -3400000 -3,400,000 Instance
us-gaap:ProceedsFromSaleOfPropertyPlantAndEquipment 1.0 debit -5 [3] 19900000 19,900,000 Instance
us-gaap:NetCashProvidedByUsedInFinancingActivities 1.0 NA -5 [4] 614100000 614,100,000 Instance OK
adp:NetDecreaseIncreaseInClientFundsObligations 1.0 debit -5 [4] -406500000 -406,500,000 Instance
us-gaap:RepaymentsOfLongTermDebt -1.0 credit -5 [3] 12900000 12,900,000 Instance
adp:NetProceedsFromReverseRepurchaseAgreements 1.0 debit -5 [3] -11800000 -11,800,000 Instance
us-gaap:ProceedsFromRepaymentsOfDebt 1.0 debit -5 [5] 1362900000 1,362,900,000 Instance
us-gaap:PaymentsForRepurchaseOfCommonStock -1.0 credit -5 [4] 257500000 257,500,000 Instance
adp:ProceedsFromStockPurchasePlanExcercisesStockOptions 1.0 debit -5 [3] 88800000 88,800,000 Instance
us-gaap:PaymentsOfDividends -1.0 credit -5 [4] 148900000 148,900,000 Instance
us-gaap:EffectOfExchangeRateOnCashAndCashEquivalents 1.0 debit -5 [3] -32500000 -32,500,000 Instance
2 Context Duration_7_1_2009_To_9_30_2009 [ 2009-07-01 - 2009-09-30 ]
c-equal
3 Unit Unit_1
u-equal
us-gaap:CashAndCashEquivalentsPeriodIncreaseDecrease NA -5 [4] -682500000 -682,500,000 Instance OK
us-gaap:NetCashProvidedByUsedInOperatingActivities 1.0 NA -5 [4] 243700000 243,700,000 Instance OK
us-gaap:NetIncomeLoss 1.0 credit -5 [4] 284100000 284,100,000 Instance
us-gaap:DiscontinuedOperationProvisionForLossGainOnDisposalNetOfTax 1.0 debit -5 [0] 0 0 Instance
us-gaap:DepreciationAndAmortization 1.0 debit -5 [3] 77600000 77,600,000 Instance
us-gaap:DeferredIncomeTaxExpenseBenefit 1.0 debit -5 [3] 25700000 25,700,000 Instance
us-gaap:ShareBasedCompensation 1.0 debit -5 [3] 17500000 17,500,000 Instance
us-gaap:PensionExpense 1.0 debit -5 [2] 8700000 8,700,000 Instance
us-gaap:GainLossOnInvestments -1.0 credit -5 [1] 700000 700,000 Instance
us-gaap:AmortizationOfDebtDiscountPremium 1.0 debit -5 [3] 14500000 14,500,000 Instance
us-gaap:ImpairmentOfInvestments 1.0 debit -5 [2] 5300000 5,300,000 Instance
adp:GainOnSaleOfAssetsHeldForSale 1.0 debit -5 [2] -1500000 -1,500,000 Instance
us-gaap:OtherNoncashExpense 1.0 debit -5 [2] 7500000 7,500,000 Instance
us-gaap:IncreaseDecreaseInAccountsAndNotesReceivable 1.0 credit -5 [3] 64100000 64,100,000 Instance
us-gaap:IncreaseDecreaseInOtherOperatingAssets 1.0 credit -5 [2] -6300000 -6,300,000 Instance
us-gaap:IncreaseDecreaseInAccountsPayableTrade 1.0 debit -5 [3] -22000000 -22,000,000 Instance
us-gaap:IncreaseDecreaseInAccruedLiabilities 1.0 debit -5 [4] -230800000 -230,800,000 Instance
us-gaap:NetCashProvidedByUsedInInvestingActivities 1.0 NA -5 [4] 367700000 367,700,000 Instance OK
us-gaap:PaymentsToAcquireMarketableSecurities -1.0 credit -5 [4] 497500000 497,500,000 Instance
us-gaap:ProceedsFromSaleOfAvailableForSaleSecurities 1.0 debit -5 [5] 1007800000 1,007,800,000 Instance
adp:NetDecreaseIncreaseInRestrictedCashCashEquivalentsOtherRestrictedAssetsHeldToSatisfyClientFundsObligations 1.0 debit -5 [3] -95500000 -95,500,000 Instance
us-gaap:PaymentsToAcquireOtherPropertyPlantAndEquipment -1.0 credit -5 [3] 34400000 34,400,000 Instance
us-gaap:PaymentsToAcquireIntangibleAssets -1.0 credit -5 [3] 16600000 16,600,000 Instance
us-gaap:PaymentsToAcquireBusinessesNetOfCashAcquired -1.0 credit -5 [1] 300000 300,000 Instance
adp:ReclassificationFromCashCashEquivalentsToShorttermMarketableSecurities 1.0 debit -5 [0] 0 0 Instance
us-gaap:PaymentsForProceedsFromOtherInvestingActivities -1.0 credit -5 [2] -1100000 -1,100,000 Instance
us-gaap:ProceedsFromSaleOfPropertyPlantAndEquipment 1.0 debit -5 [2] 3100000 3,100,000 Instance
us-gaap:NetCashProvidedByUsedInFinancingActivities 1.0 NA -5 [5] -1306400000 -1,306,400,000 Instance OK
adp:NetDecreaseIncreaseInClientFundsObligations 1.0 debit -5 [4] -441200000 -441,200,000 Instance
us-gaap:RepaymentsOfLongTermDebt -1.0 credit -5 [1] 400000 400,000 Instance
adp:NetProceedsFromReverseRepurchaseAgreements 1.0 debit -5 [0] 0 0 Instance
us-gaap:ProceedsFromRepaymentsOfDebt 1.0 debit -5 [4] -730000000 -730,000,000 Instance
us-gaap:PaymentsForRepurchaseOfCommonStock -1.0 credit -5 [3] 13700000 13,700,000 Instance
adp:ProceedsFromStockPurchasePlanExcercisesStockOptions 1.0 debit -5 [3] 44500000 44,500,000 Instance
us-gaap:PaymentsOfDividends -1.0 credit -5 [4] 165600000 165,600,000 Instance
us-gaap:EffectOfExchangeRateOnCashAndCashEquivalents 1.0 debit -5 [3] 12500000 12,500,000 Instance


Copyright (c) UBmatrix, Inc. 2009