Build a Personal Tax Return Workbook: From Source Documents to Refund or Balance Due
Assemble a complete household return in one linked workbook – document register, income by person, capital-gains netting with carryforwards, capped adjustments, joint vs separate filing, credits with phase-outs, refund or balance due and an audit panel – 8 hands-on labs for one fictional household, with every cell checked as you go.
One-time payment · lifetime access · lessons, labs, exam and certificate included · no subscription.
About this course
In this advanced capstone you build a complete household tax return in one linked workbook. You start with a source-document register and catch duplicates and missing statements, total income per category and person with SUMIFS, net short- and long-term capital gains with a loss cap and carryforward, and apply capped adjustments with a phase-out to reach adjusted gross income. You then compare joint and separate filing with bracket tables and the SUMPRODUCT method, calculate credits that phase out in steps, work out the refund or balance due and finish with an audit panel of tie-outs, cross-foots and prior-year flags. All rules are fictional and simplified for learning.
Lessons
- The Source-Document Register: Withholding Rates, Duplicates & a Completeness Checklist Pro
- Income Lines: SUMIFS per Category and per Person Pro
- Capital Gains Netting: Short vs Long Term, Loss Cap & Carryforward Pro
- Adjustments to Income: Pension Limits, Capped Interest & a Phase-Out to AGI Pro
- Joint vs Separate Filing: Two Parallel Calculations with Bracket Tables Pro
- Dependant & Childcare Credits: Counting Qualifiers and Step Phase-Outs Pro
- Refund or Balance Due: Non-Refundable Credits, Withholding & Estimated Payments Pro
- The Audit-Check Panel: Tie-Outs, Cross-Foots & Prior-Year Flags Pro