Overview and Introduction
Begin your journey by understanding the "why" behind the numbers. This foundational module introduces the core principles of Management Account preparation. You will learn what management accounts are, how they differ from financial statements for external users, and why they are an essential tool for internal planning, control, and strategic decision-making in any successful business.
0/8
MS Excel Functions and Features used in Management Account Preparation
Unlock the power of Excel for accounting professionals. This practical module moves beyond basic spreadsheets to focus on the essential functions and features required for efficient financial analysis. You will master critical tools like Data validation, vLOOKUP, text, and custom format etc to manipulate data, automate calculations, and prepare professional-grade reports with speed and accuracy.
0/11
Introduction to Case Study
Bridge the gap between theory and the real world. In this module, you will be introduced to a business case study that will be used throughout the course. By working with a consistent, practical scenario, you will learn to apply accounting principles in a realistic context, understanding the business operations that drive the financial results.
0/4
Mapping ot Trial Balance
This module covers the engine room of the reporting process. Learn the systematic technique of mapping a trial balance—the process of linking every raw data account to its correct place on the financial statements. Mastering this skill is crucial for ensuring accuracy, consistency, and building automated reports that can be updated effortlessly each month
The covers how to create a month alone TB and how to map different general ledegr lines to groups requried for note and disclosures.
0/4
Creating the Notes to the Account
Discover how to tell the story behind the numbers. The notes are a vital part of any financial report, providing clarity and context that the main statements cannot. This module teaches you how to draft clear, concise, and informative notes that explain key figures, and important assumptions, adding significant value and credibility to your reports.
This covers how to link FS Mapping to Notes and how to structure your notes in an MA
0/3
Income Statement and Statement of Financial Position
Learn to build the two primary financial statements. This module provides a step-by-step guide to constructing:
The Income Statement: A summary of a company's financial performance (revenue, expenses, and profit) over a specific period.
The Statement of Financial Position (SOFP): A snapshot of a company's financial health—what it owns (Assets) and what it owes (Liabilities and Equity)—at a single point in time, governed by the equation: Assets=Liabilities+Equity.
0/4
Creating the Statement of Cash Flows
Learn to build the two primary financial statements. This module provides a step-by-step guide to constructing:
The Income Statement: A summary of a company's financial performance (revenue, expenses, and profit) over a specific period.
The Statement of Financial Position (SOFP): A snapshot of a company's financial health—what it owns (Assets) and what it owes (Liabilities and Equity)—at a single point in time, governed by the equation: Assets=Liabilities+Equity.
0/9
Creating A Dynamic Dashboard
Bring your data to life. This capstone module combines all your learned skills to build a dynamic and interactive management dashboard in Excel. You will learn to use charts, graphs,etc to transform your financial statements into a powerful visual tool. This dashboard will enable managers to spot trends, analyze Key Performance Indicators (KPIs), and make informed, data-driven decisions at a glance.
0/11