Preparing Management Accounts: Practical Workshop
From trial balance to a board-ready monthly pack, with a full capstone case.
Created by JMatrix Learn
About this course
Learn to prepare monthly management accounts the way finance teams do in real businesses. You will move step by step from the chart of accounts and trial balance to month-end adjustments, the management profit and loss, balance sheet and cash flow, budget variances with flexed budgets, KPIs and a one-page dashboard, and finish with a full capstone case (Bello & Sons Foods Ltd) with complete worked solutions. Every module has practical labs with numbers you can rebuild in Excel, a quiz and an assignment. Tax rates are kept general: always apply the rates and rules in current law.
What you'll learn
Curriculum
40 lessons · 608 minutes total
- Management Accounts vs Statutory Accounts Preview 12 min
- Who Uses Management Accounts and What They Ask 12 min
- The Management Accounts Workflow, Start to Finish 12 min
- Practical Lab - Design Your Reporting Plan 20 min
- Module 1: What Management Accounts Are (and Are Not) — Quiz 10 min
- Assignment: Your Reporting Plan
- The Chart of Accounts: Your Filing Cabinet 14 min
- The Trial Balance and How to Test It 14 min
- The Month-End Close Checklist 14 min
- Practical Lab - Find the Error in the Trial Balance 20 min
- Module 2: Chart of Accounts, the Trial Balance and the Month-End Close — Quiz 10 min
- Assignment: Trial Balance Detective
- Accruals and Prepayments: Matching Costs to the Month 14 min
- Depreciation, Provisions and Stock Adjustments 14 min
- Deferred Income, Payroll and Tax Accruals 14 min
- Practical Lab - Month-End Adjustments for Adaeze Printing Ltd 25 min
- Module 3: Month-End Adjustments - Accruals, Prepayments, Depreciation and Provisions — Quiz 10 min
- Assignment: Month-End Adjustments Workbook
- Building the Management P&L: Gross Margin, EBITDA and Below the Line 14 min
- Building the Management Balance Sheet 14 min
- Common Presentation Mistakes and How to Avoid Them 12 min
- Practical Lab - Build Kemi's Bakery Month-End Statements 25 min
- Module 4: The Management Profit and Loss and Balance Sheet — Quiz 10 min
- Assignment: Build the Statements
- Why Profit Is Not Cash, and the Indirect Cash Flow Statement 14 min
- The 13-Week Cash Forecast 14 min
- Working Capital: Debtor, Stock and Creditor Days 14 min
- Practical Lab - Cash Flow Statement and a 4-Week Forecast 25 min
- Module 5: Cash Flow and Working Capital — Quiz 10 min
- Assignment: Cash Flow and Forecast
- Budgets, Forecasts and How to Compare Them 14 min
- Flexed Budgets: Separating Volume from Price and Cost 14 min
- Writing Variance Commentary That Managers Actually Read 12 min
- Practical Lab - Sunrise Water Ltd Variance Analysis 25 min
- Module 6: Budget vs Actual and Variance Commentary — Quiz 10 min
- Assignment: Variance Report
- The Core Ratios: Profitability, Liquidity, Efficiency and Gearing 14 min
- Choosing KPIs That Drive Behaviour 12 min
- Building a One-Page Dashboard in Excel 14 min
- Practical Lab - KPI Pack for Kemi's Bakery 25 min
- Module 7: KPIs, Ratios and the One-Page Dashboard — Quiz 10 min
- Assignment: KPI Dashboard
- Assembling the Monthly Reporting Pack 14 min
- Using Accounting Software, Excel and the Workflow Together 12 min
- Practical Lab - Capstone Part 1: Adjustments and the Adjusted Trial Balance 25 min
- Practical Lab - Capstone Part 2: Statements, KPIs, Variances and Commentary 30 min
- Module 8: The Reporting Pack and Capstone Case — Quiz 10 min
- Assignment: Full Management Accounts Pack
Requirements
- Basic understanding of debits and credits
- Microsoft Excel (basic formulas)
- Willingness to rebuild every lab yourself
Also available in a bundle
Student reviews
New (0)No reviews yet — be the first to share your experience.
Related courses
This is a hands-on class taught on request. Tell the instructor when suits you and they will schedule it.
- Full lifetime access
- Access on mobile and desktop
- Learn by doing: written lessons, quizzes and hands-on practice (video lessons coming soon)
- Instructor Q&A on every lesson