Mapping Accounts to Financial Statement Lines with XLOOKUP
This lesson is part of the course
In this lesson
You map 21 ledger accounts to their balance sheet and income statement lines with an XLOOKUP mapping table, summarise the TB by line and prove that the statements balance.
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