Diploma in E-Accounting, Finance, Taxation, Banking, SAP & Excel Course Duration- 15 Months

(1)

Make Career Solutions (MCS)

makecareersolutions.com

Diploma in E-Accounting, Finance, Taxation & Banking Mob. No.: 8375048622 and 9971835097

Email Id: makecareersolutions5097@gmail.com

Diploma in E-Accounting, Finance, Taxation, Banking, SAP & Excel

Course Duration- 15 Months

Basic Computer :-

• Windows 2007

• MS-Office 2016

• MS- Word

• MS Excel

• PowerPoint,

• Outlook

• Software Installation & Printing

• Internet

• Email

Financial Accounting :-

• Introduction to Accounting

• Rules of debit and credit

• Opening entry;

• Rules regarding posting;

• Trial balance; Subdivisions of a journal.

• Purchase order, Sales Order

• Quotation preparation Fixed Asset Register Preparation

• Preparation of Trading and Profit & Loss

• Preparation Account Balance Sheet Preparation Rectification Entries Depreciation Entries

• Preparation of Bank reconciliation

• Cheque Preparation and Deposit slips

• Balance Sheet Review/ analysis

(2)

Tally:-

• Creation, Modification & Deletion

• Company, Group & Ledger

• Security Control, Back-up & Restore process

• Accounting Voucher & Inventory Entries

• Generation of Returns, TDS, PF, ESI

• Reports in Tally ERP & Year End Process

• Basic Concept of GST & use of GST in Tally

• GST Returns

• Company Merging and Splitting

Busy:-

• Accounting

• Taxation

• Inventory

•

Income Tax:-

• Concept & Provisions of Income Tax

• Computation of Income Tax

• Preparation of Income Tax Return

• Project on e-payment

• Project on e-filing TDS

• Concept and provisions of TDS

• Project on Preparation of TDS return

• Project on e-payment and e-filing of TDST Return Training Students how to file E TDS return online

• Permanent Account No

• Application and its procedure

• E- TDS Return filing Practical Training

• E- TDS software like Taxman Income Tax return filing techniques

• How to compute Income Tax on Salary Income.

• How to prepare Form 16 online and manual How to fill up Form 49A, 49B

• Preparation of Challan 281 and 280 manual and computerized both

• Form 3CD Tax Audit procedure and laws practical training

• Income tax Return filing

Payroll:-

(3)

• Payroll process

• Pay components – taxability and specific checkpoints

• TDS Mechanism - Snapshot • Concept & Provisions of PF & ESI

• Documentation and e-filing of PF & ESI

• Payroll processing through Tally Payroll Real Life Projects on PF & ESI

• Employee setup and functions Define employee wise weekly off/ second weekly off

• Define employee wise salary type (Daily / monthly)

• Define Employee wise per our OT Rate • Define Employee wise Bonus % &Limit

• Define employee wise PF ESI rate Define educational / Technical / professional qualification and experience of employee

• Define local address permanent address telephone no. DOJ etc for employee

• Link employee signature ration card voter id card thumb impression

• Define special remarks for employee same ESE no. validation in employee setup Help on PF no. ESE No. in employee setup

GST:-

• What is GST :- Goods and Service Tax indirect Tax for the whole India

• Overview of Goods & Service Tax Registration under GST (Regular and Composition)

• Meaning & Scope of Supply, Time of Supply, Value of Supply

• Tax Rate structure

• General Procedures, Payment of Tax

• GST using Tally

• GST Payment Mechanism:

• GST Registration process:

• GSTR-1 Details of outward supplies of goods or services Registered Supplier

• GSTR-2A Details of auto drafted supplies Not to be filed; For reconciliation with inward supplies

• GSTR-3B Summary return Registered Supplier

• GSTR-4 Quarterly return for registered person opting for composition levy Composition Dealer

• GSTR-5 Return for Non-resident taxable person Non-Resident Taxable Person

• GSTR-6 Return for input service distributor Input Service Distributor

• GSTR-9 Annual Return Registered Person

• GSTR-9A Annual Return (For Composition Taxpayer) Composition Dealer

• GSTR-10 Final Return Taxable person whose registration has been surrendered or cancelled.

Auditing:-

• Types of Auditing

• Internal Auditing

(4)

• External Auditing

• Financial Audit

• Strategic, Operational, and IT Audit

Advance Excel:-

• Advance Application

• Number Formatting

• Advance Conditional Formatting

• Power View, Power Map, Power Query, Power Pivot

• Match & Index, Financial Functions, Array Formulas

• ASAP Utilities, Mail Merge through Google Drive, Dashboard Spreadsheet basics

• Creating, editing, saving and printing spreadsheets

• Working with functions & formulae

• Graphically representing data: Charts & Graphs

• Analysing data: Data Menu, Subtotal, Filtering Data

• Working with functions & formulae Formatting worksheets, Securing & Protecting spreadsheets

• Formulas & Macros Formulas in Advanced Excel Course

• What-if-analysis

• Data Tables

• Scenario Manager

• Goal Seek

• Reporting

• Character Functions

• Date Functions

• Age Calculations

• Consolidation of Data

• Data Validation

• PIVOT TABLES is part of Advanced Excel Course

• Enter the Pivot Table Data • Create the Pivot Table

• Adding Data to the Pivot Table

• Filtering the Pivot Table Data

• Change the Pivot Table Data

• Sparklines, Inline Charts,

• Data Charts

• Create charts, enhance charts, Drawing toolbar features

• Use multiple windows Copy/ paste between Worksheets

• Link worksheets, Consolidate worksheets

SAP (FICO):-

(5)

• Create a Company

• Assign to Company Code

• General Ledger

• How to Create Chart of Accounts

• Retained Earnings Account

• GL Account Create, Display, Block & Delete FS00 Order to Cash Process, General Ledger Accounting

• Accounts Payable Business Process, Accounts Payable Closing Process

• Accounts Receivable Business Process, Accounts Receivable Closing Process

• Bank Related Accounting Business Process, Financial Statement Creation Business Process

• Asset Accounting Business Process, Daily Postings

• G/L Document Park, Hold, Posting in SAP

• Customer Master Data Create, Display, Block, Delete in SAP

• Change Customer Documents

• Create Customer Account Group

• One Time Customer

• How to post a Sales Invoice

• Sales Returns – Credit Mem

• How to post a Sales Invoice

• Sales Returns – Credit Memo

• How to Post Incoming Payment

• How to post a Foreign Currency Invoice

• Residual Method: Incoming & Outgoing Partial Payments Posting in SAP Data, Planning in Management Accounting, Accounting Logistic Integration

• Analytics in Management Accounting, Investments- Treasury Management

• Borrowings-Treasury Management, Retired Earnings-Balance Carry Forward Disclosures- Bank Guarantee, Related Party, Segment Reporting. Treasury and Risk Management

• SAP Controlling Organization Structure, SAP Controlling Master

• SAP FICO Course contains the following sub-modules: -

• General Ledger accounting

• Accounts Receivables

• Accounts Payable

• Asset Accounting

• Bank Accounting

• Consolidation

(6)