Schedule II, Valuation and Qualifying Accounts

12 Months Ended

Dec. 31, 2018

SEC Schedule, 12-09, Valuation and Qualifying Accounts [Abstract]

Schedule II, Valuation and Qualifying Accounts

XCEL ENERGY INC. AND SUBSIDIARIES VALUATION AND QUALIFYING ACCOUNTS YEARS ENDED DEC. 31

	Allowance for bad debts									NOL and tax credit valuation allowances
(Millions of Dollars)	2018			2017			2016			2018				2017				2016
Balance at Jan. 1	$	52		$	51		$	52		$	77			$	58			$	28
Additions Charged to Costs and Expenses	42			39			39			7				9				3
Additions Charged to Other Accounts	11			10			11			—			(a)	22			(a)	35			(a)
Deductions from Reserves	(50		)	(48		)	(51		)	(5		)	(b)	(12		)	(b)	(8		)	(b)
Balance at Dec. 31	$	55		$	52		$	51		$	79			$	77			$	58

^(a)  The 2016 - 2017 changes are the accrual of valuation allowances for North Dakota ITC, net of federal income tax benefit, that is offset to a regulatory liability; the 2017 change includes $14 million expense related to the revaluation of federal benefit as a result of the TCJA.

^(b)  Primarily the reductions to valuation allowances for North Dakota ITC carryforwards, net of federal benefit, primarily due to a consolidated adjustment to the regulatory liability accrual referenced above; the 2017 change includes $4 million of reduced expense related to the revaluation of federal benefit as a result of TCJA.