Teacher Resources
UNIT02 - Lesson 2
Skill Introduction: Accruals, Deferrals & SLN Depreciation
45 minutes
Lesson Overview
Lesson Focus
Direct instruction on GAAP-compliant adjusting entries and depreciation calculations
Key Unit Objectives
Enduring Understandings:
- Automation reduces human error and increases efficiency in financial processes
- GAAP compliance requires systematic tracking of accruals, deferrals, and adjusting entries
- User interface design determines the usability and adoption of financial tools
- Time savings through automation creates competitive advantage for businesses
Lesson Activities
Activity 1: Connect to Month-End Reality
5 minutesLink yesterday's timing challenge to today's technical skills
Details:
- Review: Manual processes are slow and error-prone
- Bridge: What specific accounting knowledge enables automation?
- Preview: Master the technical foundation before building Excel solutions
Activity 2: Accruals & Deferrals: The Timing Challenge
20 minutesDirect instruction on matching principle and timing adjustments
Details:
- Explain the matching principle: expenses matched to revenues in same period
- Accruals: Revenue earned but not yet received, expenses incurred but not yet paid
- Deferrals: Cash received/paid but revenue/expense recognition delayed
- Work through specific business examples showing GAAP compliance
GAAP Timing Requirements
Revenue and expenses must be recorded in the correct accounting period
- Accrued Revenue: Services performed but payment not yet received
- Accrued Expenses: Costs incurred but bills not yet received
- Deferred Revenue: Payment received but services not yet performed
- Prepaid Expenses: Payment made but benefits not yet consumed
Activity 3: Straight-Line Depreciation Calculation
15 minutesMathematical foundation for automated depreciation entries
Details:
- Formula: (Cost - Salvage Value) ÷ Useful Life = Annual Depreciation
- Monthly depreciation calculation for month-end entries
- Practice calculations with office equipment and technology examples
- Connect to Excel formula construction for automation
Office Equipment Depreciation Example
Computer system: $3,000 cost, $300 salvage, 3-year life
- Annual depreciation: ($3,000 - $300) ÷ 3 = $900
- Monthly depreciation: $900 ÷ 12 = $75
- Entry: Debit Depreciation Expense $75, Credit Accumulated Depreciation $75
Activity 4: Guided Practice & Team Application
5 minutesTeams apply concepts to their chosen automation focus
Details:
- Teams work through scenarios relevant to their chosen specialization
- Quick check: Can each team calculate and record their focus area entries?
- Preview Day 3: Map these concepts into systematic ledger processes
Required Materials
- GAAP timing rules slide deck
- Accrual/deferral scenario worksheets
- Depreciation calculation templates
- Sample ledger with adjusting entry examples
Differentiation Strategies
For Struggling Students
- • Step-by-Step Macro Guides: Visual walkthroughs for macro recorder usage
- • Pre-built Templates: Partial VBA code with clear modification instructions
- • Simplified Scenarios: Focus on one adjusting entry type before expanding
- • Peer Support: Pair with students strong in Excel automation skills
For Advanced Students
- • Advanced VBA Functions: Error handling routines and user input validation
- • Cross-Sheet Integration: Link multiple workbooks for comprehensive systems
- • Custom Functions: Write UDF (User Defined Functions) for complex calculations
- • Mentoring Role: Support other teams with technical troubleshooting
For English Language Learners
- • Visual Interface Design: Use icons and graphics to supplement text instructions
- • Technical Vocabulary Support: Accounting and Excel terms with visual definitions
- • Collaborative Documentation: Partner with native speakers for user instruction writing
- • Multiple Demonstration Formats: Video tutorials with visual emphasis over verbal explanation