Excel for Accountants: Reconciliations, Ledgers & Month-End
Build a trial balance from a GL export, map accounts to the statements, match a bank reconciliation, age receivables, run prepayment, accrual and depreciation schedules, flag budget variances and check intercompany balances: 8 hands-on labs on one company's month-end.
The first lesson is free — no account needed.
About this course
An Excel for accountants course that runs one company's month-end close in a spreadsheet, for bookkeepers, accountants and finance students. You turn a raw general-ledger export into a trial balance with SUMIFS and track down the line that breaks debits = credits, map 21 ledger accounts to balance sheet and income statement lines with an XLOOKUP mapping table, match the cash book against the bank statement with COUNTIFS on reference and amount, age open invoices into buckets with IFS, spread prepayments over their months and accrue a utilities bill, complete a fixed asset register with straight-line and declining-balance depreciation, label budget variances favourable or unfavourable with a materiality flag and turn the close checklist into WORKDAY deadlines with an intercompany check. The first lab is free.
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