Book · Julian R. Sterling

The Consolidated Tax Return Handbook

A Practitioner's Guide to U.S. Federal Consolidated Corporate Returns Under IRC Section 1502: Affiliated Group Eligibility, Intercompany Transactions, Stock Basis Adjustments, Excess Loss Accounts, CNOL and SRLY Limitations, the Unified Loss Rule, Divestitures and Tax-Sharing Agreements

About the book

Cover of The Consolidated Tax Return Handbook

Filing a U.S. federal consolidated corporate income tax return under IRC Sections 1501 to 1504 and the Treas. Reg. 1.1502 series is a discipline of its own. Book consolidation under US GAAP ASC 810 eliminates intercompany balances cleanly on paper, whereas federal tax consolidation layers single-entity timing and character over separate-entity location, stock basis adjustments, excess loss accounts, SRLY registers, and the three-tier Unified Loss Rule.

The Consolidated Tax Return Handbook follows one fictional corporate group, Alderbrook Industrial Holdings, Inc. (P) and its operating subsidiaries S1, S2, and S3, across three consecutive calendar tax years (2026 to 2028) under P.L. 119-21 and TD 10018. Over the three-year span, consolidation reduces cumulative federal tax from $6,663,741 on separate returns to $5,431,755 consolidated, a net cash tax savings of $1,231,986, while exposing the exact exit traps that ambush unprepared groups: a $4,482,200 Excess Loss Account on S2, a $1,320,000 Unified Loss Rule attribute reduction on S3, and a $270,137 short-year income swing between Closing of the Books and Ratable Allocation. Every number ties to a live, unlocked ten-tab Excel workbook.

What is inside

Free companion files

The live Excel workbooks behind every figure in the book. Inputs in blue, formulas in black, automated Controls tab reading zero. No sign-up required for book readers.

Download all files (ZIP)44 KB

Start with 00_START_HERE.md.

Want the standalone calculator first? Open the free consolidated tax return calculator page for the worked example and Excel download.

Worked articles from the book

Also by Julian R. Sterling

Related corporate tax and accounting handbooks. Full list on the author page.