Schedule II, Valuation and Qualifying Accounts

12 Months Ended

Dec. 31, 2019

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)	2019				2018				2017				2019				2018				2017
Balance at Jan. 1	$	55			$	52			$	51			$	79			$	77			$	58
Additions charged to costs and expenses	42				42				39				9				7				9
Additions charged to other accounts	16			(a)	11			(a)	10			(a)	—				—				22			(c)
Deductions from reserves	(58		)	(b)	(50		)	(b)	(48		)	(b)	(21		)	(e)	(5		)	(e)	(12		)	(d)
Balance at Dec. 31	$	55			$	55			$	52			$	67			$	79			$	77

^(a)  Recovery of amounts previously written off.

^(b)  Deductions related primarily to bad debt write-offs.

^(c)  Accrual of valuation allowances for North Dakota ITC, net of federal income tax benefit, that is offset to a regulatory liability and includes $14 million expense related to the revaluation of federal benefit as a result of the TCJA.

^(d)  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 change includes $4 million of reduced expense related to the revaluation of federal benefit as a result of TCJA.

^(e) 

Primarily the reductions to valuation allowances due to additional NOLs and tax credits now forecasted to be used prior to expiration.