Financial Accountant Training

Contents of Account Training, Book Keeping GST and Advance Excel

 ontents of Bookkeeping  GST and Advance Excel)

·         Treatment of opening balances

·         Choosing the chart of accounts that suits the firm’s needs and its customisation

·         Understanding how double entry is applied in accounting software and how to customise the nominal ledger and nominal codes

·         Maintaining sales and purchase ledgers of organisation

·         Setting up customers’ accounts

·         Process customers invoices and credit notes

·         Setting up suppliers accounts

·         Posting month end adjustments and journals

·         Processing suppliers invoices and credit notes

·         Generating reports customer/supplier invoices, statements and reconciling them

·         Generating aged debtors and aged creditors reports for credit control purposes

·         Understanding CIS deductions and processing invoice containing CIS element

·         Understanding reverse charge and processing invoice containing reverse charge element

·         Identifying errors and performing error corrections

·         Allocating cash payments and receipts

·         Allocating bank payments and receipts

·         Understanding accruals and processing the journal entry

·         Understanding prepayments and processing the journal entry

·         Maintaining fixed asset register of the organisation

·         Writing off fixed assets

·         Calculating depreciation using different methods

·         Understanding gains and losses on disposals of assets

·         Suspense account reconciliation

·         Director’s loan account

·         Loan amortisation account

·         Preparing closing entries

·         Preparing the Final Trial Balance

·         Monthly management accounts

·         Running the year end procedures in  Accounts to close the financial year and start a new financial year

·         Allocating supplier payments and customer receipts against right invoices

·         Performing bank reconciliation / petty cash reconciliation

·         Calculating GST for businesses with mixed zero-rated and standard-rated sales combining Tally and Excel

·         Preparing the GST return

·         Reconciling the GST return

·         Submitting the GST return

·         Dealing with GST queries

·         GST registration and deregistration process

·         Understanding GST period and Tax point

·         Dealing with Imports, Exports and Acquisitions

·         Rules regarding Composition Scheme in GST

·         GST deadlines and penalties

·         E-Way Bill.

·         Entering, Editing & Formatting

·         Working with Basic Excel Formula

·         Modifying Excel Worksheet

·         Working with Shape and Images

·         Creating a chart in Excel

·         Printing Formatting of an Excel Workbook

·         Filter & Sorting

·         Drop Down List in Excel

·         Conditional Statement & Logical operator

·         Count & Sum Function

·         Lookup in excel

·         Text Function

·         Date & Time Function

·         Protecting Excel Worksheet & Workbook

·         What if tools

·         Pivot tables in Excel

Contents of Payroll

·         Program and payroll basics

·         Backing up and restoring data

·         Company settings

·         Understanding Indian legislation relating to Payroll

·         Registering as an employer

·         Understanding Pay as you earn (PAYE) system

·         Adding employees into payroll software

·         Creating pay elements

·         Understanding year to date values

·         Processing payments for employees

·         Generating payslips

·         Generating pre-update reports

·         Departments and employee analysis

·         Calculating and processing statutory payments

·         Calculating and paying statutory sick pay (SSP)

·         Calculating and paying statutory maternity pay (SMP)

·         Calculating and paying statutory paternity pay (SPP)

·         Recording absences

·         Updating the payroll records with leavers and joiners

·         Payment of ESI-EPF

·         Year end procedures

·         Printing and Issuing pay slips to employees

·         Real time information (RTI) reports

·         Full payment submission (FPS)

·         Employer payment summary (EPS)

Contents of Income Tax, Auditing and Export Documentation

·         All Heads of Income – (Salary, House Property, Business and Profession, Capital gain and Other sources.)

• Set off and carry forward of Loss.
• Clubbing of Income
• Rates and Slab of Individual, partnership Firm, Co-operative Society and Company
• Advance Tax calculation and Deposit.
• Deduction and Exemptions
• TDS and TCS Returns
• Depreciation Rates
• Computation of Income
• Income Returns
• Section -44AD & 44ADA Returns
• Statement of AIS and TIS
• Auditing
• Export Documentation

Software Training Covered

·         TALLY ERP.9 Training

·         TALLY PRIME Training

·         BUSY Training

·         ADVANCE EXCEL Training

·         COMPUTAX Training

·         SAP Training ( FICO Optional With Extra Charge)