Free testing period: everything is free while we test. Try it out and tell us what you think.
Accounting Practicals

Preparing Management Accounts: Practical Workshop

From trial balance to a board-ready monthly pack, with a full capstone case.

New (0 ratings) 2 students Intermediate English

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

Explain how management accounts differ from statutory accounts
Run a month-end close with a checklist and a balanced trial balance
Post accruals, prepayments, depreciation, provisions, stock and deferred income adjustments
Prepare a management P&L, balance sheet and indirect cash flow statement
Build a 13-week cash forecast and calculate debtor, stock and creditor days
Analyse budget variances with flexed budgets and write clear commentary
Calculate core ratios, choose KPIs and build a one-page dashboard
Assemble a complete monthly reporting pack

Curriculum

  • 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
Practical Accounting Skills
View bundle

Student reviews

New (0)

Related courses

Accounting Practicals
FREE
Request a live practical class
  • 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
Feedback