Overview

Google, IBM & Meta Certificates – 40% Off

One Coursera Plus subscription covers most Professional Certificates on Coursera.

This course introduces the core workflow used by entry-level corporate tax analysts to build tax returns through Excel workpapers and map those workpapers into ONESOURCE. Learners will study the standard five-tab workpaper architecture, build field-code crosswalks, understand how book-to-tax reconciliation and carryforwards fit into the process, avoid common data-entry and system errors, and follow the full tie-out chain from source accounting data to e-file readiness. The course is designed for beginners who need a practical foundation in workpaper preparation and ONESOURCE data flow. Course Learning Objectives 1. Explain the role of workpapers in building tax returns and describe how Excel data flows into ONESOURCE. 2. Apply the five-tab workpaper architecture to organize tax schedules consistently and reviewably. 3. Create and validate mappings between Excel workpaper lines and ONESOURCE field codes. 4. Interpret key reconciliation concepts, including Schedule M-1 and common corporate return line relationships. 5. Identify which prior-year amounts carry forward and verify them using final filed returns. 6. Prevent and troubleshoot common ONESOURCE entry, mapping, and system-session errors. 7. Describe the end-to-end workflow from ERP data to validation, review, e-file, and archive.

Syllabus

Workpapers as the Foundation of the Return
- This module introduces the role of Excel workpapers in corporate tax return preparation. Learners explore how source accounting data moves from records such as the trial balance and general ledger into organized workpapers and then into ONESOURCE through mapped field codes. The module also introduces the five-tab workpaper structure and emphasizes the importance of using the final filed prior-year return when verifying carryforwards.
Building the Five-Tab Workpaper
- This module focuses on the standard five-tab architecture used to organize tax workpapers: README, Inputs, Mapping, Calculations, and Output. Learners study what belongs on each tab, how to separate raw data from formulas and final output, and why this structure improves reviewability, debugging, and consistency across return preparation files.
Mapping Workpaper Lines to ONESOURCE
- This module explains how workpaper lines are connected to ONESOURCE through field-code crosswalks. Learners practice mapping chart-of-accounts values to tax categories, ONESOURCE field codes, and Form 1120-style return lines. The module also introduces Schedule M-1 as the framework for reconciling book-to-tax differences and distinguishing regular return lines from reconciliation items.
Carryforwards and Common Entry Errors
- This module covers how to verify common carryforwards and prevent frequent ONESOURCE entry mistakes. Learners review which items carry forward from prior years, how to confirm them using the final filed prior-year return and related forms, and how to identify issues such as wrong-line placement, sign errors, decimal precision problems, and stale prior-year references.
Using ONESOURCE Correctly and Managing the Full Workflow
- This module brings together the full tax return workflow from source accounting data through filing and archive. Learners examine why data should be entered through organizer view, why direct overrides are risky, how return data moves into XML for e-file submission, and how to verify the complete tie-out chain from ERP totals to final filing acknowledgment.