Trial Balance from a GL Export: SUMIFS & the Debits = Credits Check
All lessons
- Trial Balance from a GL Export: SUMIFS & the Debits = Credits CheckFree
- Mapping Accounts to Financial Statement Lines with XLOOKUP Pro
- Bank Reconciliation with Matching Flags: COUNTIFS on Reference and Amount Pro
- Accounts Receivable Ageing: Days Past Due, Buckets with IFS & a Chart Pro
- Prepayments & Accruals: a Monthly Release Schedule Pro
- Fixed Asset Register: SLN, Accumulated Depreciation, NBV & DB Pro
- Budget vs Actual: Variance %, Favourable / Unfavourable & Materiality Flags Pro
- Month-End Close: Checklist Deadlines with WORKDAY & the Intercompany Check Pro
You are not signed in — the lab works, but your progress is not saved. Start free
Loading the spreadsheet…