Advanced Diploma in Financial and Foreign Accounting with Data Analytics

ASAP Kerala Affiliated Advanced Diploma Course in Accounting

This is a comprehensive course that equips students with the skills needed in the fields of financial and foreign accounting. Through a combination of theoretical and practical coursework, students will learn the latest accounting principles and techniques and gain proficiency in data analytics. This course is designed for individuals who wish to pursue careers in finance, accounting, or data analysis and is an excellent choice for those seeking to enhance their professional qualifications.

  • Assessment and Certification by ASAP, Kerala
  • The best practical-oriented Indian and Foreign Accounting course with Data Analytics
  • Syllabus has been finalized under the supervision of subject experts from ASAP Kerala.


Any Degree Pass or Failed.


  • Normal Track: 12 months
  • Fast Track: 6 Months

  • Certifications

    • ASAP (Govt. of Kerala)
    • SAP S/4HANA (FICO) or
    • SAP S/4HANA (MM)
    • Soft Skills and Employability (Cambridge University)

    What will you learn in Advanced Diploma in Financial and Foreign Accounting with Data Analytics ?

    Unit 1: Self Analysis

    Introduction to module | Ice breaking | Who am I- Make a note | SA: questionnaires

    SWOT analysis | Detailed Self-introspection | Johari window – Self-awareness | self-confidence

    Mentoring Day

    Unit 2: Attitude

    Factors influencing attitude | Influence of perspective on behaviour | KSA – Knowledge skills and attitude

    Personal social and professional etiquette.

    Unit 3 Interpersonal skills

    Need for interpersonal skills | Gratitude | Being thankful | Understanding anger and ways to deal with it.

    Secret of happiness | Morals | Values and Ethics | Integrity | Work Ethics | Civic Virtue | Respect for Others | Living Peacefully | Caring | Sharing | Honesty | Courage | Valuing Time| Cooperation| Commitment | Empathy | Teamwork | Networking | Importance of teamwork | Teamwork activity | Leadership qualities

    Importance of decision making | Weighing positives and negatives | Process and practical way of decision making.

    Unit 4 Stress Management and Motivation

    Stress Management: Stress | Reasons and effects | Identifying stress | Stress diaries | The four A’s of stress management | Techniques | Approaches: action-oriented | Emotion-oriented | Acceptance oriented

    Resilience | Gratitude Training | Coping with emotions: Identifying and managing emotions | Harmful ways of dealing with emotions | Relaxation techniques

    Self-Motivation | Factors | Self-motivation methods and activities | Tapping and tuning inner voice

    Unit 5: Creativity

    Need for Creativity in the 21st century | Thinking out of the box | Creative thinking and Lateral Thinking

    Torrance test of creative thinking | Creative challenges and activities.

    Unit 6: Goal setting

    Wish list | SMART goals | Short | long | lifetime goals | Blueprint for success | 5W1H | Time management

    Value of time | Test your Time management skill Weekly planner | TODO list | Prioritizing work | Time management matrix | Psychometric tests

    Daily half-hour language lesson is combined with continuous reading, writing, listening, and speaking modules.

    Office 365

    Text Basics

    • Typing the text, Alignment of text
    • Editing Text: Cut, Copy, Paste, Select All, Clear
    • Find & Replace

    Text Formatting and saving file

    • New, Open, Close, Save, Save As
    • Formatting Text: Font Size, Font Style
    • Font Color, Use the Bold, Italic, and Underlined
    • Change the Text Case
    • Line spacing, Paragraph spacing
    • Shading text and paragraph
    • Working with Tabs and Indents

    Working with Objects

    • Shapes, Clipart and Picture, Word Art, Smart Art
    • Columns and Orderings – To Add Columns to a Document
    • Change the Order of Objects
    • Page Number, Date & Time
    • Inserting Text boxes
    • Inserting Word art
    • Inserting symbols
    • Inserting Chart

    Header & Footers 

    • Inserting custom Header and Footer
    • Inserting objects in the header and footer
    • Add a section break to a document

    Working with bullets and numbered lists

    • Multilevel numbering and Bulleting
    • Creating List
    • Customizing List style
    • Page bordering
    • Page background


    • Working with Tables, Table Formatting
    • Table Styles
    • Alignment option

    Styles and Content 

    • Using Build- in Styles, Modifying Styles
    • Creating Styles, Creating a list style
    • Table of contents and references
    • Adding internal references
    • Adding a Footnote
    • Adding Endnote 

    Merging Documents 

    • Typing new address list
    • Importing address list from Excel file
    • Write and insert the field
    • Merging with outlook contact
    • Preview Result
    • Merging to envelopes
    • Merging to label
    • Setting rules for merges
    • Finish & Merge options

    Sharing and Maintaining Document

    • Changing Word Options
    • Changing the Proofing Tools
    • Managing Templates
    • Restricting Document Access
    • Using Protected View
    • Working with Templates
    • Managing Templates
    • Understanding building blocks 

    Proofing the document 

    • Check Spelling as You Type.
    • Mark Grammar Errors as You Type
    • Setting AutoCorrect Options


    • Page Setup, Setting margins
    • Print Preview, Print 


    Introduction to Excel

    • Introduction to Excel interface
    • Understanding rows and columns, Naming Cells
    • Working with excel workbook and sheets

     Formatting Excel workbook:

    • New, Open, Close, Save, Save As
    • Formatting Text: Font Size, Font Style
    • Font Color, Use the Bold, Italic, and Underlined
    • Wrap text, Merge and Centre
    • Currency, Accounting and other formats
    • Modifying Columns, Rows & Cells

    Perform Calculations with Functions 

    • Creating Simple Formulas
    • Setting up your formula
    • Date and Time Functions, Financial Functions
    • Logical Functions, Lookup and Reference
    • Functions Mathematical Functions
    • Statistical Functions, Text Functions

    Sort and Filter Data with Excel

    • Sort and filter data
    • Using a number filter, Text filter
    • Custom filtering
    • Removing filters from columns’ conditional formatting

    Create Effective Charts to Present Data Visually

    • Inserting Column, Pie chart etc.
    • Create an effective chart with Chart Tool
    • Design, Format, and Layout options
    • Adding chart title
    • Changing layouts
    • Chart styles
    • Editing chart data range
    • Editing data series
    • Changing chart

    Analyze Data Using PivotTables and Pivot Charts

    • Understand PivotTables, Create a PivotTable
    • Framework Using the PivotTable and PivotChart
    • Create Pivot Chart from the pivot Table.
    • Inserting slicer
    • Creating Calculated fields

    Protecting and sharing the workbook

    • Protecting a workbook with a password
    • Allow users to edit ranges
    • Track changes
    • Working with Comments
    • Insert Excel Objects and Charts in Word Documents and PowerPoint Presentation.

    Use Macros to Automate Tasks

    • Creating and Recording Macros
    • Assigning Macros to the worksheets
    • Saving Macro enabled workbook

    Proofing and Printing

    • Page setup, setting print area, Print titles
    • Inserting custom Header and Footer
    • Inserting objects in the header and footer
    • Page Setup, setting margins, Print Preview, Print
    • Enable background error checking
    • Setting AutoCorrect Options



    Setting Up PowerPoint Environment:

    • New, Open, Close, Save, Save As
    • Typing the text, Alignment of text
    • Formatting Text: Font Size, Font Style
    • Font Color, Use the Bold, Italic, and Underlined
    • Cut, Copy, Paste, and Select All, Clear text
    • Find & Replace
    • Working with Tabs and Indents

    Creating slides and applying themes

    • Inserting new slide
    • Changing the layout of slides
    • Duplicating slides
    • Copying and pasting slide
    • Applying themes to the slide layout
    • Changing theme color
    • Slide background
    • Formatting slide background
    • Using slide views

    Working with bullets and numbering

    • Multilevel numbering and Bulleting
    • Creating List
    • Page bordering
    • Page background
    • Aligning text
    • Text directions
    • Columns option

    Working with Objects

    • Shapes, Clipart and Picture, Word Art, Smart Art
    • Change the Order of Objects
    • Inserting slide header and footer
    • Inserting Text boxes
    • Inserting shapes, using quick styles
    • Inserting Word art
    • Inserting symbols
    • Inserting Chart

    Hyperlinks and Action Buttons

    • Inserting Hyperlinks and Action Buttons
    • Edit Hyperlinks and Action Button
    • Word Art and Shapes

    Working With Movies and Sounds

    • Inserting Movie from a Computer File
    • Inserting Audio file
    • Audio Video playback and format options
    • Video options, Adjust options
    • Reshaping and bordering Video

    Using SmartArt and Tables

    • Working with Tables, Table Formatting
    • Table Styles
    • Alignment option
    • Merge and split option
    • Converting text to smart art

    Animation and Slide Transition

    • Default Animation, Custom Animation
    • Modify a Default or Custom Animation
    • Reorder Animation Using Transitions
    • Apply a Slide Transition, Modifying a
    • Transition, Advancing to the Next Slide

    Using slide master

    • Using slide master
    • Inserting layout option
    • Creating custom layout
    • Inserting place holders
    • Formatting place holders

    Slide show option

    • Start slide show
    • Start show from the current slide
    • Rehearse timing
    • Creating a custom slide show

     Proofing and Printing

    • Check Spelling as You Type
    • Setting AutoCorrect Options
    • Save as Video
    • Save as JPEG files
    • Save as PowerPoint Show file
    • Print Preview, Print

    Introduction | Accounting terms

         Accounting | Event and transaction | Bookkeeping and accounting | Stakeholders in business | Important business terms

    Capital and revenue transactions | Accounting principles

         Capital and revenue expenditure | Capital and revenue receipt | Accounting concepts and conventions | Double entry system of bookkeeping

    Account | Traditional and modern rules

         Account | Classification of account | Debit and credit | Traditional and modern rules relating to accounts


         What is journal | Journal preparation

    Ledger | Trail balance

         What is ledger | Ledger posting | Ledger balancing

    Cash book and its types

        Types of cash book and discount

    Bank reconciliation statement


         Depreciation and its causes | Needs for charging depreciation | Factors considered for depreciation | depreciation methods.

    Inventory valuation

         FIFO | LIFO

    Trail balance

         Trail balance preparation

    Trading and profit and loss account

         Trading account and its preparation | Profit and loss account and its preparation

    Yearend adjustment entries

         Adjustments regarding final accounts

    Balance sheet

         Preparation of balance sheet | Problems with final accounts

    LEVEL 1

    Accounting Introduction | Terms | Expenditures 

       Introduction to accounting | Basic accounting terms | Expenditures and Their Types

    Accounting Concepts 

      Accounting concepts | Different Accounting Concepts

    Accounting Rules

      Types of Accounts | Traditional and Modern Rules of Accounting 


       Preparation of Journal | Journal Entry Test (JET) 

    Ledger & Cash Book

       Ledger | Ledger Posting and Balancing | Cash Book | Types of Cash Books

    Trail balance, Adjustments

       Trail Balance | Format and preparation of trial balance | Adjustments 

    Final accounts

       Preparation of Final accounts

    Introduction to Tally Prime 

       Installing Tally | Tally Introduction | Types of License in Tally Prime | Activation & Deactivation of License | Work in Education Mode

    Company Creation

       Company Creation | Alteration| Shut Company | Select Company | Delete Company | Company Features | Company Configuration | Ledger Creation | Alteration | Display | Delete(Single & Multiple) | Navigation(top,right) | Swich to | Go to

    Chart of Accounts

       Introduction to Chart of Accounts| Master Creation- Ledger | Group- Both Single and Multiple – Deletion | Alteration

    Inventory Master

       Creation- Alteration – Deletion Of -Inventory Group | Inventory Category | Unit | Stock Item | Location | Sub Group | Sub Category 


    Vouchers- Recording and Maintaining Accounting Transactions

       Voucher | Voucher Creation

    Bill Wise Allocation & Practice Question Including All

    Completed Portions

       Bill Wise Allocation of Sundry Debtors and Sundry Creditors


       Banking – Cheque Printing| Deposit Slip Printing | Bank Payments | Payment Advice | BRS- Manual and Auto

    Reports Generation

       Generating reports in tally | MIS Reports Generation

    Data Security

       Data Security- Backup | Restore | Activation of Security Control in Tally | Creation of Security Levels | Creation of Passwords for Company | Activation of Company Vault | Auto Login



    LEVEL 2

    Inventory Storage | Maintaining Batch

       Storage and classification of inventory ( Godown transfer and management) | maintain batch-wise details

    Price level

       Price List | Practice

    Additional Features In Tally Prime | Voucher Class Settings

       Credit Limit | Zero Value Voucher | Actual and Billed Quantity Column | Separate Discount Column | Additional Cost of Purchase | Sales Invoice Logo | Banking Details in Invoice | Voucher Class Settings

    Purchase Order -Quotation | Re-order level

       Purchase Order Processing | Re-Order Level

    Sales order- proforma invoice

       Sales Order Processing | Proforma Invoice

    Cost centre | profit centre management

       Cost centre | Pre-Defined Cost Centre | Profit Centre Management

    Budget & scenario | sales invoice numbering


    Debtors – creditors’ interest calculation


    Non-accounting vouchers and generating | printing reports | forex conversion

    Full portion practice day 



    LEVEL 3

    GST introduction 

       Introduction of GST | GST Components | GST rates 

    Activating GST in Company

       Activating GST in Tally Prime, GST master creation, inward and outward supply of goods / local and interstate GST reports 

    GST Purchase and Sales of Goods & Service

       Purchase and sales of goods and services & practice

    ITC and GST payments  

      ITC in Tally | GST Payments | Practice



    Live projects


    Basic Concepts:

    Introduction to GST | Advantages of GST | Taxes subsumed under GST | Components | Rates | GST council.  

    Supply Under GST: Meaning of Supply | Scope of Supply | Composite Supply | Mixed Supply | Schedule 1 and 2 of Supply.  

    Composition Scheme under GST:

     Eligibility & Non-eligibility of composition scheme | Conditions & restrictions for composition levy | Composition rate of Tax | Important forms | Validity of Composition levy  

    Reverse Charge Mechanism:

    Forward charge mechanism | Reverse charge mechanism | Section 9 (3) of CGST | Supply of specific services | Supply by an Unregistered person.  

    Time of Supply and Value of Supply: 

    Time of Supply of Goods under forward charge and reverse charge | Time of Supply of services under forward charge and reverse charge | The value of Supply  

    Place of Supply of Goods:

    Supply involves the movement of goods; Goods are delivered at the direction of a third party; Supply does not involve movement. Goods are assembled at the site. Goods supplied on board a conveyance and any other cases  

    Place of Supply-Specific Provisions: 

    services in direct relation to immovable property | services by way of lodging accommodation | Accommodation in any immovable property for organizing | Training & Performance appraisal etc  

    Input tax Credit: 

    introduction | Availability of ITC | Blocked credits with examples | Utilization of ITC | Process of availing ITC | ITC set off Process | Conditions for availing ITC  

    General Procedures under GST:

    Registration under GST | Electronic ledgers under GST | Issuance of Invoice | Particulars of Invoice | HSN code and SAC code | Bill of Supply and other Vouchers  

    E-Way Bill: 


    Goods Exempted from E-way Bill | Return forms | Annual return | Late fee | Interest | Audit under GST | Refund | GST e-invoicing.  

    Unit Test  

    GST using Tally Prime: Composition dealer Accounting | Regular dealer Accounting | GST reports | JSON file | ITC adjustment entries | Blocked credits Entry | RCM entries | GST on advance receipts | GST Tax Payment Entries  

    GST Using Tally Prime:

    Accounting of Mixed Supply & Composite Supply | Supply of Exempted/nil rated goods | Supply of Goods to SEZ | Supply of Goods to another territory | Reversal of ITC  

    Project on GST  

    GST registration using simulation software  

    GSTR 1 filing using simulation software and E-way Bill Generation.  

    GSTR 3b filing and challan payment using simulation software

    Introduction to GCC VAT Supplies under UAE VAT Federal Tax Authority Tax payable Types of registrations under VAT Reverse charge mechanism Types of transactions under VAT Penalties Maintenance of accounts GCC VAT in Tally Prime VAT reports generation using  Tally Prime

    TDS | Basic Concepts & Important Sections

    Financial Statement Analysis

    • Comparative Balance sheet | Common size | Balance sheet | Ratio Analysis | Liquidity Ratios | Solvency Ratios

    Activity ratio | Profitability Ratios

    Fixed Asset Schedule Preparation with Depreciation

    Projected Balance sheet and Profit & Loss Account

    Branch Accounting- Meaning & Concepts

    • Branch Accounting Practical using Tally

    Debtors’ creditor’s Reconciliation

    Educational Institute Accounting

    Exporting & Importing Company Accounting 


    Hotel Accounting

    Unit Test

    Franchise Accounting

    Payroll Accounting (Based on Presentation)

    Payroll Accounting

    Final Unit Test

    Basic Concepts

         Income-tax law: An introduction | Important definitions in the Income-tax Act, 1961 | Concept of the previous year and assessment year | Basis of Charge and Rates of Tax

    Residential status and scope of Total Income

         Residential status | Scope of Total Income

    Incomes which do not form part of total Income (other than charitable trusts and institutions, political parties and electoral trusts)

         Incomes not included in total income | Tax holiday for newly established units in Special Economic Zones

    Heads of Income and the provisions governing the computation of Income under different heads

         Salaries | Income from house property | Profits and gains of business or profession | Capital gains | Income from other sources

    Income of other persons included in the assessee’s Total Income

         Clubbing of Income: An introduction | Transfer of Income without transfer of assets |

         Income arising from revocable transfer of assets | Clubbing of Income arising to spouse | Minor child and son’s wife in some instances

    Aggregation of Income; Set-off, or carry forward and set off of losses

         Collection of income | Concept of set-off and bring forward and set-off of losses | Provisions governing set-off and carry on and set-off of losses under different heads of payment | Order of set-off of losses

    Deductions from total gross Income

         General provisions | Deductions in respect of certain payments | Specific deductions in respect of certain income | Deductions in respect of other income | Other deductions

    Computation of Total Income and tax liability of individuals

         Income to be considered while computing the total income of individuals | Procedure for calculation of total Income and tax liability of individuals

    Advance tax, tax deduction at source and introduction to tax collection at source

    Provisions for filing return of Income and self-assessment

         Return of Income | Compulsory filing of return of income | Fee and Interest for default in furnishing return of income | Return of loss | Provisions relating to belated Return, revised Return etc | Permanent account number | Persons authorized to verify Return of income | Self-assessment | ITR 1 Return filing (Registration & Return filing) | DT

    • Introduction And History Of Quickbooks Accounting
    • Features | Benefits | Online Quickbooks Accounts Setup
    • Company creation | Customising Invoice
    • Estimates | Cash memo
    • Hide/Show Accounts | Import Of Chart Of Accounts
    • Depreciation | Journal
    • GST In Quickbooks | Rates
    • Inventory Creation | Alteration | Import Of Inventory
    • Customer Creation | Supplier Creation | Import
    • Purchase | purchase order | Debit Note
    • Sales | Credit Note
    • Payment | Receipt
    • Transfer | Additional Features
    • TDS | Reports | Reports customisation
    • Export Reports To Excel File
    • Project

    Introduction to Excel

         Introduction to Excel 365 | Editing sheet | Formatting | Project1

    Worksheet view

         Viewing worksheet | Filling series | Flash fill

    Conditional formatting | Data validation

         Conditional formatting- new rule | Data validation

    Lookup and cell reference


    Important functions in Excel

         Remove duplicate values | Hyperlink | Important functions in excel

    Logical operations | sum and count functions

         Logical functions | sum | sumif | sumifs | count | countif | countifs

    Working with formulas

         Statistical functions and mathematical functions | Date related functions

    Text functions

         Text functions in excel | Match and index functions

    Database functions and subtotal functions

         Dsum | dcount | Subtotal functions

    Classic pivot table and chart

         Chart element | Pivot table and pivot chart

    Data extraction

         Filter and advanced filter

    Graphics and insert object function

         Custom view | Graphics | Insert object

    Print area setup

         Header and footer | Print area setup | Text to column function

    Important tools in excel

    Form data | Auditing tool | Web data

    Goal seak | Solver | Scenario manager

    Speak cell | Camera tool | Sparkline chart

    People graph | Data forecast | Import text file

    Mail merge | Consolidating data

    Macro | Password protection

    • Creating five professional accounting dashboards for different industries.
    • Introduction
    • Data Visualization
    • Data Modeling
    • DAX
    • Report Design
    • Data Sharing and Collaboration

    SAP Introduction

         ERP | SAP SE | SAP partners | ASAP | T-code

    Organisational Elements

         Define Company | Company Code | Business Area

    Define Chart of Account & Account Group

         COA Meaning | Company Accounts

    Define retained earnings | Fiscal Year variant | Posting Period Variant

         Setting year for the Company code

    Define Field Status Variant | Tolerance Group

         TG for the GL Account | Employee | Assignment

    Define Document type for GL Account & Ledger Creation

         Define Document Type SA for GL Account | Creation of ledger

    Parking the Document | Reverse Document | GL Account Adjustment

         Reverse Document | GL Account Adjustment

    AP Process

         Vendor Creation | Posting Purchase Entry | Outgoing Payment

    AR process

         Customer Creation | Sales Entry Posting

    Credit Memo AP

         Credit Memo with Clearing Entry

    Credit Memo AR

         Credit Memo with Clearing Entry

    Advance Payment in AP Process

    Advance Receipt in AR Process


    Define Dunning area | Define Dunning Procedure |

    House Bank Creation

         Automatic Payment Process | Cheque Management


         Define Controlling Area | Number Range Settings for the controlling Area | Maintain version | Cost Centre Creation

    Asset Management

         Define Depreciation Area | Define Asset Class | Asset Creation | Asset Posting

    GST in SAP

    Configuration for GS

    Cash Journal Preparation

    SAP Introduction

         ERP|SAP SE|SAP partners|ASAP| T-code

    Enterprise Structure

         Defining Organizational Units

    Define Company

         Define Company Code

    Define Controlling Area

         Define Plant

    Valuation Area

         Define Storage Location

    Assigning Organizational Units

         Assign company code to the company

    Assign company code to controlling area

         Assign plant to company code

    Assign purchasing organization to co-code

         Assign purchasing organization to plant

    Master Data-Material Master data


    Material Master

    Material Type

    Material Group

         Material Class

    Master Data: Vendor

         Vendor|Vendor Master|Vendor Master Record|Vendor Account|Vendor Account Group

    Procurement Cycle

         IMG setting for Purchasing Requisition| Purchase Info Record – IMG settings

    IMG settings – Purchase Orders

         Goods Receipt (GR)| Entering of Invoice (in MIRO)


         The final year project signifies a milestone for an ADFFA student. It helps to bridge the gap between theory-based learning and skills-based learning.
         These projects fulfil the purpose of synthesizing the knowledge acquired during the ADFFA course at Skillspark and demonstrating aptitude by applying the knowledge. Also, it can be added to the resume and shown during the placement interviews.

    Summing up life skills qualities | Email- Business Communication | Professional profiles in digital platforms | Grooming | What is a Structured Interview? Preliminary Preparation | Do’s & Don’ts of an Interview | Discussion of frequently asked questions in the interview | Real-world Interviews examples | Personal Interview Assessment with constructive feedback.

    Interested to join?

    Please furnish your details below. Then, one of our course advisors will contact you for enrollment.

    Choose preferred study centre

    Career opportunities for Advanced Diploma in Financial and Foreign Accounting with Data Analytics

    • Accountant
    • Administrator
    • Manager
    • Marketing Manager
    • GST Practitioner
    • Accounts Executive

    Frequently Asked Questions (FAQ)

    Why Indian and Foreign Accounting Courses?

    Indian and Foreign accounting courses with Entrepreneurship skills will empower you to become a professional in Indian and foreign accounting.  Through this accounting courses, we provide professional training in accounting and covers most relevant job-oriented courses like,

    Accounts Manager, Auditor, Payroll Officer, Tax Specialist, Financial Analyst, Branch manager, Loan officer and Senior staff accountant to name a few

    We create eminent professionals in the field of accounting and finance as well as entrepreneurs by training them from basic levels to expert level by certified and well qualified faculties. We Provides ONLINE and CLASSROOM training. Our in-house Placement cell is well enough to assist students to reach their dream career. Let’s train with us to procure your fulfilling job in accounting and finance. High level of expertise in Accounting and Finance is vital for any professionals who wish to be in the top level of an organization. The skills from an Entrepreneur’s point of view will be a great asset to attain this goal. Our course will take you to the highest level of financial management skills.

    What do you get from this Indian and Foreign accounting course with Entrepreneurship skills?

    • In depth practical knowledge in all aspects of Accounts & Finance management.
    • Highest level of business communication skills
    • Management & analytical thinking skills from an Entrepreneur’s point of view.