Description
Mastering IPSAS, IAS & IFRS: Financial Reporting & Compliance with Excel
Course Modules
Module 1: Introduction to IPSAS, IAS, and IFRS
- Overview of IPSAS, IAS, and IFRS frameworks
- Key differences and similarities between the standards
- Benefits of compliance for organizations
- Regulatory landscape and implementation challenges
Advanced Excel Application:
- Excel Shortcuts for Financial Reporting
- Formatting & Conditional Formatting for Financial Data
- Basic Formulas (SUM, AVERAGE, COUNTIF)
Module 2: IPSAS 1, IAS 1 & IFRS 18 – Presentation of Financial Statements
- Format of IPSAS & IFRS-compliant financial statements
- Key Presentation & Disclosure Requirements
- Accounting Policies & Notes to Financial Statements
Advanced Excel Application:
- Pivot Tables & Pivot Charts for Financial Statement Analysis
- INDIRECT & OFFSET Functions for Dynamic Reports
- SUMIF & COUNTIF for Statement Preparation
Module 3: IPSAS 2, IAS 7 & IFRS – Cash Flow Statements
- Preparation of Cash Flow Statements (Direct vs. Indirect method)
- Classification of Cash Flows: Operating, Investing, and Financing Activities
- Impact of Foreign Exchange on Cash Flows
Advanced Excel Application:
- Cash Flow Projections using FORECAST & TREND
- Automation of Cash Flow Reports using Macros
- Sensitivity Analysis using Scenario Manager
Module 4: IPSAS 17, IAS 16 & IFRS – Property, Plant, and Equipment (PPE)
- Recognition & Measurement of PPE
- Depreciation & Impairment
- Valuation of PPE Assets
Advanced Excel Application:
- Depreciation Calculation using SLN, DB, DDB functions
- Asset Valuation using Present Value (PV) and Net Present Value (NPV) functions
- Scenario Analysis using Data Tables & Goal Seek
Module 5: IPSAS 29, IAS 39 & IFRS 9 – Financial Instruments
- Classification of financial assets and liabilities
- Expected Credit Loss Model (ECL)
- Hedge Accounting & Impairment
Advanced Excel Application:
- Financial Modeling with XLOOKUP & INDEX MATCH
- Sensitivity Analysis using Scenario Manager
- Risk Modeling using Monte Carlo Simulation (Excel Add-ins)
Module 6: IPSAS 13, IAS 17 & IFRS 16 – Leases
- Lease accounting principles (Lessor vs. Lessee)
- Lease Liabilities & Right-of-Use Assets
- Impact of Leases on Financial Statements
Advanced Excel Application:
- Lease Amortization Schedules using PMT, IPMT, PPMT functions
- Forecasting Lease Expenses using TREND, FORECAST & LINEST
- Financial Ratio Analysis for Lease Impact Assessment
Module 7: IPSAS 9, IAS 18 & IFRS 15 – Revenue Recognition
- Revenue Recognition for different contract types
- Contract Costs & Contract Liabilities
- Performance Obligations & Variable Consideration
Advanced Excel Application:
- Revenue Forecasting Models using LINEST & FORECAST
- Data Analysis with Power Pivot for Revenue Trends
- Automation of Revenue Recognition using VBA
Module 8: IPSAS 19, IAS 37 & IFRS – Provisions, Contingent Liabilities & Contingent Assets
- Recognition of Provisions & Contingent Liabilities
- Disclosure Requirements under IPSAS & IFRS
- Actuarial Assumptions for Employee Benefits
Advanced Excel Application:
- Actuarial Valuation Modeling using NPV, PV & FV functions
- Data Analysis with Power Pivot for Employee Benefit Trends
- Automation of Provisions Calculation using VBA
Module 9: IPSAS 10, IAS 21 & IFRS – Effects of Foreign Exchange Rates
- Multi-currency transactions & Foreign Currency Translation
- Exchange Rate Gains & Losses Treatment
- Impact of Foreign Exchange on Financial Statements
Advanced Excel Application:
- Exchange Rate Conversion using Dynamic Formulas
- Foreign Currency Hedging using Statistical Functions (STDEV, CORREL)
- Multinational Financial Statement Consolidation in Power BI
Module 10: Advanced Financial Reporting & Audit Compliance with IPSAS, IAS, and IFRS
- Consolidated Financial Statements Preparation
- Audit Trail Management & Internal Controls
- Compliance Reporting & Automation
Advanced Excel Application:
- Dashboard Creation for IFRS/IPSAS Reporting
- Automation with Macros & VBA for Compliance Checks
- Power BI Integration for Financial Reporting
Description
Course Objectives:
Mastering IPSAS, IAS, and IFRS with Advanced Excel for Financial Reporting and Compliance
By the end of this 10-day training, participants will be able to:
- Understand Key Accounting Standards
- Gain a deep understanding of IPSAS, IAS, and IFRS, including their principles, scope, and application in financial reporting.
- Identify the similarities and differences between these frameworks and their impact on public and private sector organizations.
- Apply International Accounting Standards in Financial Reporting
- Prepare financial statements in accordance with IPSAS 1, IAS 1, and IFRS standards.
- Accurately classify and report financial transactions related to cash flows, leases, provisions, and revenue recognition using international standards.
- Enhance Financial Analysis and Decision-Making
- Use financial models to analyze key accounting areas such as fixed assets, financial instruments, and foreign exchange transactions.
- Conduct financial performance evaluations through ratios, forecasting, and scenario analysis.
- Leverage Advanced Excel for Financial Reporting
- Utilize Pivot Tables, Power Query, and Power BI for effective financial data visualization and analysis.
- Automate financial calculations, reporting, and compliance checks using advanced formulas, Macros, and VBA.
- Ensure Compliance and Risk Management
- Develop audit-ready financial reports that comply with IPSAS, IAS, and IFRS regulations.
- Implement internal controls, risk assessment techniques, and compliance reporting for regulatory adherence.
- Prepare for Financial Statement Audits
- Identify common audit challenges and apply best practices for financial reporting compliance.
- Utilize Excel tools for audit trails, reconciliations, and variance analysis.
- Develop Hands-on Practical Expertise
- Work on real-world case studies to apply IPSAS, IAS, and IFRS principles in financial statement preparation.
- Build dynamic financial models using Excel to streamline accounting and reporting processes.
- Integrate Technology for Enhanced Financial Management
- Use Power BI for dashboard creation and financial reporting automation.
- Apply AI-driven analytics and Excel-based automation to improve accuracy and efficiency in financial decision-making.
General Notes
GENERAL NOTES
i. The clients have many options on where they would wish to have the training
ii. The client should communicate their preferred training venue at least seven days before the training date failure to which the training shall take place in Nairobi.
iii. This course is delivered by our seasoned trainers who have vast experience as expert professionals in the respective fields of practice. The course is taught through a mix of practical activities, theory, group works and case studies.
iii. Training manuals and additional reference materials are provided to the participants.
iv. Upon successful completion of this course, participants will be issued with a Chania finance consultancy certificate.
v. The onsite training fee covers tuition fees, training materials, tea at 10am, lunch, tea at 4pm, training venue and a certificate on completion. Accommodation and travel may be arranged for our participants upon request.
vi. The online training fee covers tuition fees, training materials, and a certificate on completion.
Available at the following Venues
- Nairobi
- Google Meet
Choose the date you would like to take the course
Related Courses
10,000+ unique online course list designs
