Budget vs Actual: Variance %, Favourable / Unfavourable & Materiality Flags
This lesson is part of the course
In this lesson
You turn September's budget vs actual into a management-ready variance report: variance %, a favourable/unfavourable label that knows revenue from cost, a two-condition materiality flag and red highlights.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- Trial Balance from a GL Export: SUMIFS & the Debits = Credits Check Locked
- Mapping Accounts to Financial Statement Lines with XLOOKUP Locked
- Bank Reconciliation with Matching Flags: COUNTIFS on Reference and Amount Locked
- Accounts Receivable Ageing: Days Past Due, Buckets with IFS & a Chart Locked
- Prepayments & Accruals: a Monthly Release Schedule Locked
- Fixed Asset Register: SLN, Accumulated Depreciation, NBV & DB Locked
- Budget vs Actual: Variance %, Favourable / Unfavourable & Materiality Flags Locked
- Month-End Close: Checklist Deadlines with WORKDAY & the Intercompany Check Locked