Trial Balance from a GL Export: SUMIFS & the Debits = Credits Check
This lesson is part of the course
In this lesson
You turn a raw general-ledger export into a trial balance with SUMIFS, test whether debits equal credits and track down the line that breaks it.
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