Management Account and Analysis

About Course

This course provides a complete walkthrough of the management account preapration process, taking you from raw data to a finished, professional report. In this hands-on course, you will learn how to:

Distinguish between management account (for internal decisions) and financial statement (for external reporting).
Map a trial balance to efficiently structure your financial statements.
Prepare the core financial reports: the Income Statement, Statement of Financial Position ( $SOFP$ ), and Statement of Cash Flows ( $SOCF$ ).
Master essential MS Excel functions to automate and streamline your work.
Design a dynamic, interactive dashboard to visualize performance and support effective business management.

This course is designed to equip you with a complete, end-to-end skill set in management accounting. We provide you with the theory, the practical tools, and the hands-on experience needed to translate raw numbers into high-impact business intelligence. Whether you are starting your career or looking to upgrade your skills, this program will give you the confidence to handle any management reporting task.
By the end of this course, you will be able to:
Understand the core concepts of management accounting and its purpose.
Apply key MS Excel functions like data validation, VLOOKUP(), TEXT(), Custom Format, etc help analyze and prepare financial data.
Build the three primary financial statements: Income Statement, Statement of Financial Position (SOFP), and Statement of Cash Flows (SOCF).
Analyze financial performance and position using the reports you create.
Communicate your findings effectively by creating insightful notes and visualizations.
Design a dynamic dashboard from scratch that allows for interactive analysis and supports high-level decision-making.

Course Content

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.

Objective and Expectation of the class

00:00
What a management Account is and Difference with FInancial Statement

00:00
Illustrating a Management Account and FInancial Statement

00:00
Q&A Ilustrating a Management Account and FInancial Statement

00:00
Component of a management Account

00:00
Illustrating components of a management Account

00:00
Steps in preparing a management account

00:00
Illustraing the link between TB FS Mapping Notes and Income

00:00

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.

Introduction to Excel Functions and Features in preparing MA

00:00
Cell Referencing in MS Excel

00:00
MS Excel Data Validation

00:00
Q&A MS Excel Data Validation

00:00
MS Excel DATE() and EOMOTH() Functions

00:00
Ms Excel TEXT() Function

00:00
MS Excel Introduction to VLOOKUP() function

00:00
Introduction to VLOOKUP() Function

00:00
Detailed look into VLOOKUP() Function

00:00
Ms Excel Custom format an TEXT() function

00:00
Excel For MA

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.

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.

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

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.

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.

Introduction to SOCF

00:00
Notes required in preparation of SOCF

00:00
Preapring the SOCF

00:00
Q&A Introduction to SOCF

00:00
SOCF- Operating Activties

00:00
SOCF- Investing and Financing Activties

00:00
Troubleshooting an unbalance SOCF

00:00
Direct method of SOCF

00:00
Q&A Direct mehod of SOCF

00:00

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.

Introduction to Preparation of Dashboard

00:00
Creating the KPI Buttons on Dashboard

00:00
Comparing Actual vs Budget on KPI Dashboard

00:00
COmparing Actual vs Budget part 2

00:00
Analyzing sales data using MS Excel Pivot

00:00
Creating charts from analyzed sales data

00:00
Creating doughnut charts for Actual vs Budget

00:00
Creating trend analysis for sales usign line chart

00:00
Creating Financial Highlights for a dashboard

00:00
Q&A on financial highlights for adashboard

00:00
Final Assessment

Student Ratings & Reviews

4.7

Total 3 Ratings

2 Ratings

1 Rating

0 Rating

Abdulhamid Muhammed Isa

5 months ago

I now have more confident and look forward for more courses

Philip Oyelude

6 months ago

The tutorials in the videos are very direct and straightforward

Oluokun Oladayo

7 months ago

It was a really brain stimulating experience for me. I learnt how to perform so many processes on excel, I also learnt how to use some shortcuts to make life easier with the software.
I now ultimately can create a management account from scratch.

About Course

What Will You Learn?

Course Content

Objective and Expectation of the class

What a management Account is and Difference with FInancial Statement

Illustrating a Management Account and FInancial Statement

Q&A Ilustrating a Management Account and FInancial Statement

Component of a management Account

Illustrating components of a management Account

Steps in preparing a management account

Illustraing the link between TB FS Mapping Notes and Income

Introduction to Excel Functions and Features in preparing MA

Cell Referencing in MS Excel

MS Excel Data Validation

Q&A MS Excel Data Validation

MS Excel DATE() and EOMOTH() Functions

Ms Excel TEXT() Function

MS Excel Introduction to VLOOKUP() function

Introduction to VLOOKUP() Function

Detailed look into VLOOKUP() Function

Ms Excel Custom format an TEXT() function

Excel For MA

Understanding the requirement of the case study

Creating the Initial Sheets in the Management Account

Creating the cover page

Creating the Table of Content

Creating Monthly TB from Year to Date TB

Q&A On creating the monthly TB from Year to date TB

Creating Financial Statement Mapping of the trial balance

FS Mapping fundamental using Primary 3 FS as a guide

Introduction to creating the Notes to the Account

Creating Notes for Statement of Financial Position Components

Q&A Creating Notes to the Account

Creating the Income Statement

Q&A on creating Income Statement

Creating the Statement of Financial Position

Q&A Creating the Statement of Financial Position

Introduction to SOCF

Notes required in preparation of SOCF

Preapring the SOCF

Q&A Introduction to SOCF

SOCF- Operating Activties

SOCF- Investing and Financing Activties

Troubleshooting an unbalance SOCF

Direct method of SOCF

Q&A Direct mehod of SOCF

Introduction to Preparation of Dashboard

Creating the KPI Buttons on Dashboard

Comparing Actual vs Budget on KPI Dashboard

COmparing Actual vs Budget part 2

Analyzing sales data using MS Excel Pivot

Creating charts from analyzed sales data

Creating doughnut charts for Actual vs Budget

Creating trend analysis for sales usign line chart

Creating Financial Highlights for a dashboard

Q&A on financial highlights for adashboard

Final Assessment

Student Ratings & Reviews