Schedule II, Valuation and Qualifying Accounts SEC Schedule, 12-09, Schedule of Valuation and Qualifying Accounts (Tables)

12 Months Ended

Dec. 31, 2022

SEC Schedule, 12-09, Valuation and Qualifying Accounts Disclosure [Line Items]

SEC Schedule, 12-09, Schedule of Valuation and Qualifying Accounts Disclosure [Text Block]

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)	2022			2021			2020			2022			2021			2020
Balance at Jan. 1	$	106		$	79		$	55		$	64		$	64		$	67
Additions charged to costs and expenses	73			60			60			6			5			6
Additions charged to other accounts	26		(a)	14		(a)	12		(a)	—			—			—
Deductions from reserves	(83)		(b)	(47)		(b)	(48)		(b)	(8)		(c)	(5)		(c)	(9)		(d)
Balance at Dec. 31	$	122		$	106		$	79		$	62		$	64		$	64

(a)Recovery of amounts previously written-off.

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

(c)Primarily reductions to valuation allowances due to additional NOLs and tax credits forecasted to be used prior to expiration.

(d)Primarily the reduction of valuation allowances for North Dakota ITC, net of federal income tax benefit, that is offset to a regulatory liability forecasted to be used prior to expiration along with valuation allowances that expired.