SAP Finance & Controlling (FICO) Program

Certificate in:

SAP CENTRAL FINANCE & CONTROLLING (FICO) WITH CORPORATE SKILLS & INCOME & SALES TAX & COMPUTERIZED ACCOUNTING PROGRAM

(SUPER USER, POWER USER & END TRAINING FOR CURRENT JOB STANDARDS IN MULTINATIONALS UPTO 2027, JOB READY PROGRAM – PAKISTAN / GLOBAL)

CORPORATE SKILLS

  • Practical Accounting Concept & System
  • International Accounting Standards, Conventions & Policies
  • Regulatory Bodies in Pakistan, Working & Reporting
  • Financial Management, Cash Control, Budgeting & Cash Flow
  • Preparation of Vouchers & Procedure of Receipts & Payments
  • Book keeping of Petty Cash & Bank Book
  • Data Entry of Vouchers & other Documents
  • Maintenance of Ledger & Preparation of Trial Balance
  • Accruals, Adjustments, Pre Payments, Reversal & Corrections
  • Final Accounts Preparation (International Standard)
  • Financial Analysis & Interpreting of Financial Statements
  • Working with Fix Assets & Fix Assets Register
  • Sales Tax Act, Different Schedule of Product in Sales Tax, Special Procedure Rules, Withholding Sales Tax, Understanding with e-Filing Clauses under Section Reference with FBR & SRB Ordinance, Online e-Filing of Sales Tax Returns and Annexures on FBR/IRIS & SRB/PRA e-Portals , Audit & Refunds
  • Income Tax Ordinance, Charge of Taxes , Type of Incomes, Deductions and Exemptions, Tax Credits, Income Tax Rules, Withholding Income Tax, Create NTN#, Forms, Annexures, Statements, Filling Techniques, Challan, e-Payment,   Understanding with e-Filing Clauses under Section Reference with Ordinance, e-filing of Statements, e-filing of Returns on IRIS & Wealth Statement, SRO`s Handling
  • Import & Export – Good Declaration – How to Calculate Landed Cost – EIF (Electronically Import Filling) – Important Incoterms – How Letter of Credit works – Harmonized System Code (H. S. Code Structure)
  • Depreciation, Bad Debts & Inventory Valuation
  • Purchase, Sales, Stores Inventory Procedure & Accounting
  • Payroll Preparation, Payment Procedure & Accounting
  • Financial Audit, W.H.T Audit, Income Tax & Sales Tax Audits
  • Banking Procedure, Accounting & Reconciliation
  • Bank Loan Approval Reporting

SAP ERP S/4 HANA, ECC6 FINANCIAL ACCOUNTING CONTENTS

1) SAP FI-GENERAL LEDGER ACCOUNTING

Contents

  • In this Course, You will learn about the SAP FI-CO Module. You will learn the Following Key Terms used in SAP FI-Module
    • What is the SAPFI Module
    • What is the SAP-CO Module
    • What is the Company Code in the SAP-FI Module
    • What is the Controlling Area in SAP –CO Module
    • What is a Document in the SAP FI Module
    • What are the Document Types in the SAP FI Module
    • What are Posting Keys in the SAP FI Module
    • What is the difference between FI & CO Module
    • What is the difference between Parking and posting of a document in SAP FI-Module
    • What is the difference between Master Data and transactional Data
    • What is an Open Item & Line Item in SAP-FI Module
    • Different Reports in SAP FI-CO Module

     

    Sr.No Tasks of FI-General Ledger Transaction Code
    1 How to Create a General Ledger in SAP FI-GL FS00
    2 How to Create Cost & Revenue Elements in SAP CO KA01
    3 How to Enter a Document in SAP FI-GL FB50
    4 How to Park a Document in SAP FI-GL FB50
    5 How to Post a Parked Document in SAP FI-GL FBV0
    6 How to  Edit/Delete a Parked Document in SAP FI-GL FBV0
    7 How to Reverse a Posted Document in SAP FI-GL FB08
    8 How to View GL Ledger Report in SAP FI-GL FBL3N
    9 How to Trace Park Documents by any user in SAP-FI FBV0
    10 How to Trace Posted Documents by any user in SAP-FI FB03
    11 How to Enter a Document via “Post with Reference” in SAP-FI FB50
    12 How to Open & Close Posting Periods in SAP-FI OB52
    13 How to Enter and maintain Exchange Rates in SAP-FI OB08
    14 How to Change a Document after Posting in SAP FI FB02
    15 How to Create Cost Center in SAP-CO Module KS01
    16 How to Create a Profit Center in the SAP-CO Module KE51
    17 How to Enter a Document in Special Posting Period F-02

2) SAP FI-ACCOUNTS PAYABLE ACCOUNTING

Contents

You will learn the Following things in SAP Accounts Payable Accounting

  • What is Master Data of Accounts Payable
  • What is Account Group in SAP-AP Module
  • What is Special GL Transactions in SAP-AP Module
  • What is Open Item & Line Item in SAP-AP Module
  • What is Clearing a Vendor Account in SAP-AP Module
  • What are Cleared Items in SAP-AP Module
  • What is Resetting of Cleared Item in SAP-AP Module
  • What is Payment Terms in SAP-AP Module
  • What is Check Printing, Check Lot, Check Cancellation, Check Reprint in SAP-AP
  • What are Partial Payments in SAP AP
  • What is Residual Payment in SAP AP
  • How Foreign Currency Invoice & Payment is done in SAP AP
  • How Exchange Rate Difference variance is maintained in SAP AP
  • What are Internal Orders and how they are used in SAP-AP

 

Sr.No

Tasks of FI-Accounts Payable

Transaction Code

1

How to Create a Vendor in SAP FI-AP

FK01

2

How to Post a Vendor invoice in SAP-AP

FB60

3

How to make Payment to Vendor through

Bank transfer and through Cheque printing

F-53(For Transfer Method)

F-58(For Cheque Printing)

4

How to create Cheque lot in SAP AP

FCHI

5

How to check Vendor Ledger in SAP

FBL1N

6

How to display Check Register in SAP

FCHN

7

How to Process Partial Payments in SAP

F-53/F-58

8

How to Process Residual Payment in SAP

F-53/F-58

9

How to make Advance to Vendor in SAP

F-48

10

How to Create Internal Orders and use them in SAP-AP

KO01

11

How to assign Budget to Internal Orders in SAP CO

KO22

12

How to maintain Foreign Currency Rates in SAP

OB08

13

How to make Payment in FC in SAP AP

F-53/F-58

14

How to Void a Cheque in SAP

FCH9

15

How to Cancel a Cheque in SAP

FCH8

16

How to Re-print Cheque after void in SAP

FCH5

17

How to Process Clearing b/w Customer & Vendor

F-53/F-28

18

How to Reset Clearing in SAP AP/AR

FBRA

3) SAP FI-ACCOUNTS RECEIVABLE ACCOUNTING

Contents

  • You will learn the following things in SAP Accounts Receivable Accounting

    • What is the Master Data of SAP-AR Module
    • What is Account Group in the SAP-AR Module
    • What is Special GL Transactions in SAP-AR Module
    • What is Open Item & Line Item in SAP-AR Module
    • What is Clearing a Customer Account in SAP-AR Module
    • What is Cleared Items in SAP-AR Module
    • What is Resetting of Cleared Item in SAP-AR Module
    • What are the Payment Terms in the SAP-AR Module
    • What are Partial Payments in the SAP AR Module
    • What is Residual Payment in SAP AR Module

     

    Sr.No

    Tasks of FI-Accounts Receivable

    Transaction Code

    1

    How to Create a Customer in SAP-AR

    FD01

    2

    How to Post Customer Invoice in SAP-AR

    FB70

    3

    How to Receive Customer Payment in SAP-AR

    F-28

    4

    How to View Customer Ledger in SAP-AR

    FBL5N

    5

    How to receive Advance Payment from Customer in SAP-AR

    F-29

    6

    How to process Partial Payments of Customers in SAP-AR

    F-28

    7

    How to process Residual Payment of Customer in SAP-AR

    F-28

    8

    How to process Clearing b/w Customer & Vendor

    F-53/F-28

    9

    How to reset Clearing in SAP AP/AR

    FBRA

4) SAP FI-CASH & BANK ACCOUNTING

Contents

In this module, you will learn the following things in SAP Cash & Bank

  • What is House Bank in SAP FI Module
  • What is Cash Journal in SAP FI Module
  • How House Bank is created in the SAP FI Module
  • How Cash related accounting entries are recorded in the Cash Journal
  • What isBatch Input Session
  • How Bank Reconciliation is run in SAP

 

Sr.No

Tasks of FI-Cash & Bank

Transaction Code

1

How to Create a House Bank in SAP

FBZP

2

How to Create Bank Key in SAP

FI01/FBZP

3

How to map GL A/C in your House Bank

FBZP

4

How to use Cash Journal in SAP

FBCJ

5

How to record Cash receipts in Cash journal

FBCJ

6

How to record Cash related expenses in Cash journal

FBCJ

7

How to Return excess cash from Petty cash to Bank A/C

FBCJ

8

How to run Bank Reconciliation in SAP

FF67

9

How to run Batch Input Session for Bank Recon

SM35

5) SAP FI-ASSET ACCOUNTING MODULE

Contents

In this module, you will learn the following things in SAP Asset Accounting Module

  • What is Asset Master Data in SAP-AA
  • What is Asset Explorer in SAP-AA
  • What is Asset Class in SAP-AA
  • What is APC (Acquisition Production Cost) in SAP-AA
  • What is Chart of Depreciation in SAP-AA
  • What is Depreciation Key in SAP-AA
  • What is Transaction Type in SAP-AA
  • What is Asset Value Date in SAP-AA
  • What is AUC(Asset Under Construction) /CWIP (Capital Work in Progress) in SAP-AA
  • What is an Internal Order in SAP-CO& how this will be integrated with SAP-AA

 

Sr.No

Tasks of FI-Asset Accounting

Transaction Code

1

How to Create Asset Master in SAP-AA

AS01

2

How to Acquire an Asset in SAP-AA

F-90

3

How to View Asset Explorer in SAP-AA

AW01N

4

How to Retire an Asset with Customer with Revenue

F-92

5

How to Retire an Asset with Customer with Loss

F-92

6

How to Transfer an Asset from one Class to another

ABUMN

7

How to Retire and Asset without Customer in SAP-AA

ABAON

8

How to Create Internal Order in SAP-CO

KO01

9

How to assign Budget to your Internal Order in SAP-CO

KO22

10

How to map Internal Order in SAP-AA

AS01

11

How to Retire an Asset by Scrapping

ABAVN

12

How to Capitalize& Settle AUC/CWIP

AIAB& AIBU

13

How to Run Depreciation in SAP-AA

AFAB

SAP ERP S/4 HANA, ECC6 FINANCIAL ACCOUNTING

SKILLS SET IN SAP CENTRAL FINANCE & COSTING (FICO) TRAINING

During the Academy, We have been Proactive towards Learning SAP FI Skills and practiced the Following Scenarios in SAP FI and SAP CO Modules.

  • GL Master Data Maintenance i-e updating Chart of Accounts, Creating New Account Group, Cost Elements
  • Opening and Closing of Posting Periods
  • Sales Tax Codes & Withholding Tax Codes Creation through SPRO
  • Journal Voucher Parking Postings, Reversals, Recurring Document Postings
  • GRIR Reclassification
  • Vendor Master Data maintenance through FK01
  • Posting Vendor invoices through FB60
  • Blocking of Vendor
  • Check Lot Creation through FCHI
  • Configuration of Banks and payment terms in Accounts Payable Accounting
  • Making Partial & Residual Payments to Vendor
  • Making Payment to Vendor through Cheque through F-58
  • Making Payment to Vendor through Bank transfer method through F-53
  • Making Advance/Down Payment to Vendor through F-48
  • Clearing Down Payment of Vendor through F-54
  • Adjusting Advance made to Vendor against Open invoices in AP
  • Clearing between Vendor & Customer in AP
  • Manual Clearing of Line items of Vendor
  • House Bank Creation through FBZP
  • Executing Automatic Payment Program in AP-F110
  • Executing Procure to Pay cycle in SAP Materials Management
  • Vendor Customer Data maintenance
  • Posting Customer invoice
  • Posting Special General ledger transactions in SAP AR
  • Posting of Customer incoming Payments through F-28
  • Adjusting Customer’s advances against their invoices
  • Clearing of Customer Open items
  • Posting Cash vouchers through Cash Journal-FBCJ
  • Creation of a New Cash journal through SPRO
  • Making Cash Payments to Vendors through FBCJ
  • Execution of Bank Reconciliation through FF67
  • Creation of Asset Master
  • Procurement of Asset through F-90
  • Asset Retirement with Customer F-92 on Loss & Gain
  • Transfer of Assets from one Class to another
  • Asset Retirement without Customer
  • Asset Retirement by Scrapping
  • CWIP Creation with the help of Internal Orders as statistical and assigned them in Asset Master as Investment Order
  • Allocation of Budget on investment order for CWIP
  • Procurement of CWIP using internal order
  • Settlement of CWIP as Line item wise and Complete Settlement
  • Budget Supplement & Return of internal order and mark the order as Complete one
  • Execution of Depreciation run through AFAB
  • Executing Reports of Asset Accounting

KEY FEATURES

After You will Join this Course, You will Get the Following Skill as well

  1. Difference between S/4 HANA & ECC6 (Enterprise Central Component)
  2. Integration of SAP Finance (FI) Module with SAP Costing (CO)
  3. Integration of SAP Finance (FI) Module with SAP Material Management (MM)
  4. Integration of SAP Finance (FI) Module with SAP Sales & Distribution (SD)
  5. SAP other Modules (Overview SAP PP, SD & MM)
  6. Budgeting in SAP Costing Module
  7. How SAP Project is implemented in any Organization
  • What does a SAP Project Manager do?
  • What are the Steps to becoming a Project Manager?
  • What are the Steps to becoming a Project Manager?
  • How do You manage the SAP implementation Project?

 

SYLLABUS OF PEACHTREE, QUICKBOOKS SOFTWARE (ADVANCED LEVEL)

  • General Journal to Balance Sheet
  • Working with Service & Trading Business
  • Working with Sales Tax & Income Tax
  • Working with Assembling / Manufacturing
  • Working with Payroll
  • Working with Closing Process
  • Working with Find Transaction, Users, many more

 

Part 01 (Working Journalizing to Balance Sheet)

  • Creation of Chart of Accounts
  • Enter the Beginning Balances
  • Make the General Journal

Part 02 (Working Trading & Service Business)

Customer Record Creation

Vendor Record Creation

Inventory Record Creation

Accounting Voucher Creation

  • Credit Sales Voucher
  • Sales Return Voucher
  • Receipt Voucher
  • Credit Purchase Voucher
  • Purchase Return Voucher
  • Payment Voucher

Non-Accounting Voucher Creation

  • Quotation Voucher
  • Sales Order Voucher
  • Purchase Order Voucher

Working with Sales Tax

  • Apply Single Sales Tax
  • Apply Multiple Sales Tax

Part 03 (Working Assembling & Manufacturing Business and with Trading Business)

  • Creation of Raw Material Item
  • Creation of Bill of Material (Finished Goods)
  • Creation of Manufacturing Journal Voucher

Part 04 (Working Payroll System)

  • Payroll Setup Wizard
  • Payroll Default Information
  • Maintain Employee personnel record
  • Maintain Payroll Voucher

 

Part 05 (Working with Closing Entries)

Working with Backup, Restore, Data Verification, Data Purge Wizard, Users (Data Security Control), Finding Transaction, Inventory adjustment, Write Checks, Default Information (Vendor, Customer, Inventory) etc.

SYLLABUS OF TALLY ACCOUNTING SOFTWARE (ADVANCED LEVEL)

  • Introduction To Tally
  • Company Creation
  • Maintain Ledgers
  • Maintain Customers
  • Maintain Vendors
  • Inventory Control
  • Accounting Voucher
  • Contra Voucher
  • Payment Voucher
  • Receipt Voucher
  • Journal Voucher
  • Sales Voucher
  • Purchase Voucher
  • Inventory Voucher
  • Sales Order
  • Purchase Order
  • Sales Procedure
  • Sales Order
  • Sales Invoice
  • Credit Note “Sales Return”
  • Receipt
  • Purchase Procedure
  • Purchase Order
  • Purchases Invoice
  • Debit Note “Purchase Return”
  • Payment
  • Assembling/Manufacturing
    • Creation Of Raw Material Item
    • Creation Of Bill Of Material (Finished Goods)
    • Creation Of Manufacturing Journal Voucher
  • Payroll System
  • Creation Of Pay Heads
  • Creation Of Employees
  • Creation Of Salary Linking
  • Payroll Voucher

 

Get More From Tally

  • Sales Tax
  • All Reporting
  • Backup
  • Restore
  • Password

SYLLABUS OF EXCEL ADVANCED (WITH FINANCIAL MODELING)

    • Why is MS Excel used?
    • Spreadsheet of Excel.
    • Menus / Toolbars / Shortcuts.
    • Basic Formulas (Sum, Average, Max, Min, Mode Etc.)
    • Simple IF
    • Nested IF
    • IF AND
    • IF OR
    • Count IF, Count IF Advanced
    • Sum IF, Sum IF Advanced
    • Dated IF
    • Lookup, H Lookup, V Lookup
    • Rank
    • Large, Small
    • Count A, Count Blank
    • Days360
    • Concatenate
    • Average A
    • Sum, Count, Average, Maximum, Minimum, Today, Now, Hour, Minute, Row,
    • Column, Weekday, Upper, Lower, Proper, and many more…….
    • Charts / Graphs
    • Filter, / Advance Filter
    • Data Validation
    • Subtotals
    • Sorting
    • Conditional Formatting (Simple)
    • Conditional Formatting (Advance)
    • Consolidation
    • Data Base Function (Dsum, Daverage Etc.)
    • Cell alignment
    • Pivot Table with Special tips & tricks
    • Naming Sheet
    • Text to Column
    • Cell Comments
    • Currency symbol
    • Border & Shading
    • Headers & Footers
    • Printing (Basic to Advance)
    • Marks Sheet
    • Sales Reports
    • Attendance Register
    • Cricket Match Report
    • Student test report
    • Payroll sheet
    • Monthly Commission Sales Report (Simple to Advance)
    • Auditing, Validation (Simple to Advance)
    • Protect Worksheet & Workbook
    • Paste Special
    • Sheet To Sheet Linking
    • Excel Linking With Word
    • General Journal
    • Trial Balance
    • Income Statement
    • Balance Sheet
    • Financial Modeling