Coursera

Prepare Tax Workpapers in ONESOURCE

Coursera

Prepare Tax Workpapers in ONESOURCE

Samuel Oduro

Instructor: Samuel Oduro

Included with Coursera PlusLearn more

Gain insight into a topic and learn the fundamentals.
2 hours to complete
Flexible schedule
Learn at your own pace
Gain insight into a topic and learn the fundamentals.
2 hours to complete
Flexible schedule
Learn at your own pace

Details to know

Shareable certificate

Add to your LinkedIn profile

Assessments

5 assignments

Taught in English

See how employees at top companies are mastering in-demand skills

 logos of Petrobras, TATA, Danone, Capgemini, P&G and L'Oreal

There are 5 modules in this course

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.

What's included

1 video1 reading1 assignment

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.

What's included

1 video1 reading1 assignment

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.

What's included

1 video1 reading1 assignment

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.

What's included

1 video2 readings1 assignment

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.

What's included

1 video2 readings1 assignment

Instructor

Samuel Oduro
Coursera
7 Courses205 learners

Offered by

Coursera

Why people choose Coursera for their career

Felipe M.

Learner since 2018
"To be able to take courses at my own pace and rhythm has been an amazing experience. I can learn whenever it fits my schedule and mood."

Jennifer J.

Learner since 2020
"I directly applied the concepts and skills I learned from my courses to an exciting new project at work."

Larry W.

Learner since 2021
"When I need courses on topics that my university doesn't offer, Coursera is one of the best places to go."

Chaitanya A.

"Learning isn't just about being better at your job: it's so much more than that. Coursera allows me to learn without limits."

Frequently asked questions