Track E: Month-End Close & Reporting
What you will be able to do
- Plan and track the close
- Reconcile bank, debtors and suppliers
- Prepare accruals, prepayments and depreciation
- Check the trial balance and report
17 lessons and projects. Short, practical steps in a spreadsheet, with real Excel for the features a browser cannot run.
Outline
Module 1: Planning the close
- Close calendar and checklist
- Tidying ledger and bank exports
Module 2: Reconciliations
- Bank reconciliation
- Unmatched items and timing differences
- Debtors ledger to control account
- Creditors and supplier statement reconciliation
- Intercompany reconciliation basics
Module 3: Adjustments
- Accruals schedule
- Prepayments schedule and monthly release
- Fixed asset register and monthly depreciation
- Deferred income schedule
- Journal template with debits = credits check
Module 4: Reporting
- Trial balance checks
- Mapping the trial balance to the financial statements
- Month-on-month review with variance thresholds
- Close pack summary
Capstone: full month-end close
Completing it earns a certificate of completion. It is not an accreditation or a professional qualification.
Start free