This module covers the most common tax planning drivers found in tax schedules and workpapers—including timing differences, credit utilization, NOL usage, charitable carryforwards, and state apportionment shifts—and explains why each affects tax position, expense, or cash taxes. Using Microsoft Excel, you'll navigate prepared tax schedules, classify line items by driver category, and determine whether each should be documented, flagged for senior review, or escalated to a specialist. Recognizing these drivers quickly and accurately is essential for efficient tax review workflows that surface material issues without over-escalating routine fluctuations.

This module teaches you how to perform year-over-year comparisons in Excel and ONESOURCE to identify material changes in tax-related line items, apply CB1 materiality thresholds consistently, and distinguish true planning drivers from data entry errors or normal business fluctuation. You'll generate and interpret comparative views, apply variance rules (greater than 25% and greater than $10,000), and document findings appropriately—including basic forward-impact notes for timing differences expected to reverse. These comparison and threshold-application skills are fundamental to producing reliable, well-supported tax review work that senior professionals can act on with confidence.

This module focuses on constructing a clear, concise one-page planning driver summary that communicates findings effectively for senior escalation, covering all required fields: driver, magnitude, direction, trigger, authority, options identified, and open items. You'll learn to use research support appropriately to identify governing authority without making recommendations, incorporate forward-impact notes where relevant, and avoid common documentation mistakes including tool misuse and role confusion. Strong driver summaries enable faster senior review and demonstrate the professional judgment that distinguishes effective tax analysts.