Toggle Side Panel
Close search
Course Content
Module 1: Foundations of Management Accounts and the 7-Step Preparation Framework
Explain what management accounts are, how they differ from financial statements and across sectors, and follow the 7-step framework from trial balance to the primary statements.
0/22
1.1 Introduction to the Preparing Management Accounts Course
08:04
1.2 Participants’ Expectations for the Course
25:44
1.3 Introduction to Management Accounts: How They Differ from Financial Statements (Live Walkthrough)
20:32
1.4 Q&A: What Management Accounts Are and How They Differ from Financial Statements
04:18
1.5 Why Management Accounts Matter and Common Pitfalls in Preparing Them
14:16
1.6 Q&A: Management Accounts vs Financial Statements – Part 2
44:11
1.7 How Management Accounts Differ by Sector
11:35
1.8 Q&A: KPIs for Different Sectors
26:14
1.9 Introduction to the Case Study (Snapshot)
01:52
1.10 Components of Management Accounts and the Data Required
11:13
1.11 Q&A: Components of Management Accounts and Data Sources
17:04
1.12 The 7-Step Framework for Preparing Management Accounts
09:03
1.13 Demo: Trial Balance to FS Mapping to Notes to the Three Primary Statements
06:34
1.14 Q&A: The 7-Step Framework and the MA Flow Demo
04:40
1.15 Demo: Types of Notes to the Accounts
07:59
1.16 Q&A: Note Structure and Types
14:45
1.17 Skills Needed to Prepare Management Accounts and How to Review Them
14:40
1.18 Q&A: Skills and Reviewing Management Accounts – Day 1 Wrap-up
13:52
1.19 Day 1 Recap: The Professional MA Blueprint Infographic
06:54
1.20 From Chaos to Clarity: Management Accounts Revision
06:24
1.21 Architecting Decision-Grade Management Accounts: The FastBite Case Study
09:47
PMA Day 1: Foundations Quiz
Module 2: Choosing Comparatives and Core Excel Skills: Cell References, Dates and Data Validation
Choose the right comparatives for management accounts and use cell references, DATE, EOMONTH, data validation and custom formats confidently in Excel.
0/13
2.1 Demo: Choosing the Right Comparatives
11:26
2.2 Q&A: Choosing the Right Comparatives
03:43
2.3 Introduction to Excel Functions and Features
02:11
2.4 Cell References and Cell Reference Types
14:00
2.5 Q&A: Cell References
21:43
2.6 Cell Reference Illustration – Part 2
03:33
2.7 Q&A: Cell References – Part 2
07:27
2.8 The DATE and EOMONTH Functions
05:58
2.9 Q&A: DATE and EOMONTH Functions
15:40
2.10 Q&A: Data Validation
02:06
2.11 Custom Number Formats in Format Cells
00:53
2.12 Day 2 Recap: Mastering Excel for Management Accounts
08:48
PMA Day 2: Excel Quiz
Module 3: Lookups, SUMIFS and PivotTables, and Setting Up the MA Workbook
Use VLOOKUP, IFERROR, mixed references, SUMIFS and PivotTables, then set up the FastBite MA workbook with parameters, a cover page, table of contents and FS mapping sheet.
0/23
3.1 Recap and Q&A from the Previous Class
38:38
3.2 VLOOKUP and IFERROR Functions
10:51
3.3 Q&A: VLOOKUP and IFERROR
15:11
3.4 Mixed Cell References
08:24
3.5 Q&A: Mixed Cell References
14:51
3.6 The SUMIFS Function
08:23
3.7 Q&A: SUMIFS
20:27
3.8 PivotTables in Excel
09:00
3.9 Q&A: PivotTables
13:33
3.10 Case Study: Creating the MA Sheets and Parameters
14:09
3.11 Naming Parameters in the MA Workbook
03:27
3.12 Q&A: MA Parameters
04:27
3.13 Completing the Parameters and Building the Cover Page
07:18
3.14 Q&A: Creating the Cover Page
02:52
3.15 Q&A: Participant Demonstration of the Data Validation Sheet
10:04
3.16 Creating and Populating the MA Sheets
08:31
3.17 Q&A: Creating the Table of Contents and Other Sheets
11:31
3.18 Formatting the Table of Contents
03:40
3.19 Q&A: Initial Formatting of the Table of Contents and Other Sheets
10:02
3.20 Introduction to the FS Mapping Sheet
11:58
3.21 Q&A: Introduction to FS Mapping
01:58
3.22 Q&A: Participant Support
27:03
PMA Day 3 Quiz
Module 4: Mapping the Trial Balance to the Financial Statements
Map a trial balance to financial statement lines using two different approaches, link it with VLOOKUP and outline the IS and SOFP that drive the notes.
0/22
4.1 Recap: Building the MA Structure in Excel
04:03
4.2 Q&A: Structure of the MA Workbook
03:54
4.3 Q&A: Structure of the MA Workbook – Part 2
01:28
4.4 Understanding Trial Balance Mapping
08:27
4.5 Approaches to Mapping the Trial Balance
11:25
4.6 Q&A: Trial Balance Mapping Approaches
03:45
4.7 Preparing the FS Mapping Sheet and Trial Balance
04:41
4.8 Q&A: Preparing the FS Mapping Sheet and Trial Balance
02:26
4.9 Trial Balance Mapping: Approach 1
19:28
4.10 Q&A: Trial Balance Mapping Approach 1
04:20
4.11 Trial Balance Mapping: Approach 2 – Part 1
01:52
4.12 Trial Balance Mapping: Approach 2 – Part 2
05:57
4.13 Using VLOOKUP to Link the FS Mapping to the Trial Balance
06:21
4.14 Q&A: Linking the Trial Balance to the FS Mapping Sheet
14:06
4.15 Trial Balance Mapping: Approach 2 – Part 3
05:53
4.16 Q&A: Linking the Trial Balance to the FS Mapping with VLOOKUP
12:41
4.17 Trial Balance Mapping: Approach 2 – Part 4
14:26
4.18 Q&A: Trial Balance Mapping
05:13
4.19 Creating the IS and SOFP Outline to Guide the Note Structure
10:30
4.20 Q&A: IS and SOFP Structure and Next Steps
04:06
4.21 Q&A: Class Wrap-up
17:02
PMA Day 4 Quiz
Module 5: Building the Notes to the Management Accounts
Map the trial balance with SUMIF and data validation and build each income statement and SOFP note, from revenue and expenses to tax, assets, liabilities and equity.
0/19
5.1 Recap and General Q&A
27:49
5.2 FS Mapping with SUMIF and Data Validation – Part 1
23:00
5.3 Q&A: FS Mapping with SUMIF and Data Validation – Part 1
09:51
5.4 FS Mapping with SUMIF and Data Validation – Part 2
02:40
5.5 Q&A: FS Mapping with SUMIF and Data Validation – Part 2 and Wrap-up
07:37
5.6 Note on Revenue
08:24
5.7 Q&A: Revenue Note
02:34
5.8 Note on Cost of Sales and Operating Expenses
07:52
5.9 Q&A: Operating Expenses and Cost of Sales Notes
19:30
5.10 Note on Other Income, Depreciation and Amortisation
04:40
5.11 Note on Finance Costs, Finance Income and Exchange Differences
06:57
5.12 Q&A: Finance Costs, Finance Income and Exchange Differences
05:01
5.13 Note on Income Tax Expense
03:54
5.14 Q&A: Income Tax Expense
08:38
5.15 Notes on PPE, Intangible Assets, Right-of-Use Assets and Deferred Tax Assets
09:21
5.16 Q&A: Non-current Asset Notes
09:57
5.17 Q&A: Current Asset Notes
11:13
5.18 Notes on Trade and Other Payables, Leases, Gratuity, Borrowings and Equity
14:54
Module 5 Quiz: Notes to the Management Accounts
00:20:00
Module 6: Preparing the Income Statement and SOFP with Comparatives and Variances
Build the income statement and SOFP linked to the notes, add comparatives and variances, resolve balance sheet check differences and start the statement of cash flows from SOFP movements.
0/21
6.1 Recap: Note Components for the IS and SOFP
08:54
6.2 Creating the Income Statement Structure
08:11
6.3 Q&A: Income Statement Structure
06:29
6.4 Linking the Income Statement to the Notes
06:03
6.5 Q&A: Linking the Income Statement to the Notes
04:50
6.6 Formatting the Income Statement
01:05
6.7 Introducing Variances in the Income Statement
08:24
6.8 Q&A: Introducing Variances
24:35
6.9 Creating the SOFP and Linking to the Notes
07:33
6.10 Adding Subtotals and Comparative Figures to the SOFP
06:05
6.11 Q&A: Creating the SOFP
06:10
6.12 Completing Retained Earnings and Resolving the Balance Sheet Check
02:51
6.13 Resolving Balance Sheet Differences with PivotTables and the FS Mapping
12:25
6.14 Q&A: Balance Sheet Checks
07:10
6.15 Introducing Variances in the SOFP
01:50
6.16 Q&A: Variances in the SOFP
04:18
6.17 Introduction to the Statement of Cash Flows: Explaining SOFP Movements
12:28
6.18 Statement of Cash Flows from SOFP Movements – Part 2
16:39
6.19 Q&A: General Class Questions
02:03
6.20 Q&A: Using PivotTables to Create a Dynamic Income Statement
08:33
PMA Day 5 & 6 Quiz
Module 7: Variance Analysis and Completing the Statement of Cash Flows
Analyse variances in the income statement and SOFP and prepare the operating, investing and financing sections of the statement of cash flows, reconciling any difference.
0/16
7.1 Class Scope and Objectives
01:58
7.2 Q&A: Foreign Exchange and Comparative Figures
12:46
7.3 Understanding Variance Analysis
12:03
7.4 Q&A: Understanding Variance Analysis
03:50
7.5 Variance Analysis for the Income Statement
09:25
7.6 Variance Analysis for the SOFP
04:53
7.7 Q&A: Variance Analysis
04:17
7.8 Recap: The Statement of Cash Flows
03:19
7.9 Preparing Cash Flows from Operating Activities
17:09
7.10 Q&A: Operating Activities
14:55
7.11 Preparing Cash Flows from Investing Activities
07:18
7.12 Q&A: Investing Activities
07:58
7.13 Preparing Cash Flows from Financing Activities
15:31
7.14 Q&A: Financing Activities
03:44
7.15 Reconciling Differences in the Statement of Cash Flows
05:57
Module 7 Quiz: Variance Analysis and the Statement of Cash Flows
00:20:00
Module 8: Designing the Management Accounts Dashboard
Design a dashboard layout, build KPI boxes with comparatives and variances, and prepare the sales and financial analysis sections.
0/11
8.1 Introduction to the Dashboard: Designing the Layout
07:06
8.2 Q&A: Dashboard Layout
00:48
8.3 Designing the KPI Boxes and Populating Them
10:59
8.4 Q&A: Designing the KPI Boxes
19:10
8.5 Adding Comparatives, Variances and Variance Percentages
05:07
8.6 Q&A: Choosing the KPIs
05:11
8.7 Preparing the Sales Section of the Dashboard – Part 1
11:43
8.8 Preparing the Sales Section of the Dashboard – Part 2
10:31
8.9 Q&A: Custom Number Formats
07:11
8.10 Financial Analysis Section of the Dashboard
16:48
Module 8 Quiz: Designing the MA Dashboard
00:20:00
Module 9: Preparing Management Accounts and a Board Pack with AI
Set up Claude in Excel, use a structured MA prompt to prepare and correct management accounts from a trial balance, and produce and review an AI-generated board pack.
0/18
9.1 Overview: AI-Assisted Management Accounts Preparation
04:22
9.2 Setting Up Claude in Microsoft Excel
06:19
9.3 Q&A: Initial Claude Setup
08:36
9.4 Loading the MA Prompt in Excel and Updating the FS Mapping for the Trial Balance
10:23
9.5 Q&A: FS Mapping for AI-Assisted MA Preparation
02:22
9.6 Demo: AI Building the Management Accounts with the 13-Step Prompt
10:40
9.7 Q&A: AI Prompts in MA Preparation – Part 1
23:00
9.8 Q&A: AI Prompts in MA Preparation – Part 2
18:45
9.9 Reviewing the AI-Prepared Management Accounts
07:18
9.10 Q&A: The AI-Prepared Management Accounts
16:17
9.11 Q&A: The AI-Prepared Management Accounts – Part 2
02:02
9.12 Correcting the Management Accounts with AI Prompts – Part 1
20:33
9.13 Correcting the Management Accounts with AI Prompts – Part 2
06:19
9.14 Q&A: Correcting the Management Accounts with AI Prompts – Part 3
10:57
9.15 Creating a Board Pack with AI Prompts
09:36
9.16 Board Pack Progress and Q&A on Using AI
03:41
9.17 Reviewing the AI-Generated Board Pack
03:51
PMA Day Final Quiz
Module 10: Final Assessment and Certification
Complete the final test and case study assessment to earn your certificate.
0/1
Final Test: Preparing Management Accounts 2026
00:40:00
Preparing Management Accounts 2026: From Trial Balance to AI-Powered Board Pack
Exercise Files
MTN-Group-FY-22-Annual-Financial-Statement.pdf
Size: 3.77 MB
Previous
Next
0% Complete