No Widget Added

Please add some widget in Offcanvs Sidebar

Shopping cart

7304035211 info@arnicomputerinstitute.com Mon - Sat: 9:00 am - 9:00 pm Sunday - 9:00 am - 4:00 pm
contact us
shape
shape

Accounting

Tally

Professional Course in Accounting

  1. Download Tally Prime Setup File
  2. Tally Prime Installation,
    Company Creation, Alteration, Deletion
  3. Tally Prime Ledgers Creation
  4. Tally Prime Inventory (Creation,
    Stock Items, Groups, Units)
  1. Bill Wise details
  2. Cost Center & Cost Categorise
  3. Voucher Class & Cost Center Class
  4. Multiple Currency
  5. Interest Calculation (a. Simple b. Compound)
  6. Budgets & Controls
  7. Scenario Management
  1. Order Processing Reorder Levels
  2. Traking Number Batch-Wise Details
  3. Rejection in/out
  4. Additional Cost Details Bill Of Materials (BOM)
  5. Stock Journal & Physical Journal
  6. Price Levels and price List Stock Valuation
  7. Different Actual and Billed Quantities
  8. Zero Valued Entries
  9. Stock Valuation
  10. Print Of Sale, Single & Multiple Payment Mode,
    Invoice
  1. Cheque Book Configuration in Tally Prime
  2. Banking Transaction Types
  3.  Post Dated Cheque Management
  4. Post Dated Cheque Note Video
  5. BRS Note
  6. Bank Reconciliation
  1. Introduction
  2. Features of Job Costing
  3. Enabling Job Costing
  4. Creating Required Masters
  5. Creating Ledgers For Job Costing
  6. Recording of Job Costing Related Transactions
  7. Job Costing Reports
  8. Job Work Analysis Report
  9. Materials Consumption Summary Report
  10. Comparative Job Work Analysis Report
  1. Activation Of GST in Tally Prime
  2. Activation Of GST in Transaction
  3. Purchase From URD & Imports
  4. Advance Receipt and Payments
  5. Mixed Supply & Composite Supply Under GST
  6. MRP Transaction
  7. Defining GST Rate-Slab Rate Or Price Range
  8. Accounting Of Supply Of Services
  9. Input Credit & GST Tax Payment
  10. GST Reports & GSTR-1&2
  11. GSTR 3B
  12. Filling Of GSTR-1(Excel Format)
  1.  Payroll Accounting & Compliance
  2.  Configuring Payroll in Tally Prime
  3. Introduction to Payroll
  4.  Payroll in Tally Prime
  5.  Enable Payroll in Tally Prime
  6.  Payroll Transaction
  7. Generate Pay Slips & Pay Sheet
  8. Payroll Statement
  1. TDS Process
  2. Enabling TDS in Tally Prime
  3. Creating TDS Masters
  4. TDS Deduction
  5. Payment of TDS in Tally Prime
  6. Form 26Q
  7. TDS Outstanding & Reports
  1. Basic Concept of TCS
  2. Enabling TCS in Tally Prime
  3. Sales of TCS Goods at Lower Rate & Nil Rated
  4. TCS on Transfer of Right to Use
  5. Payment of TCS
  6. TCS Reports & Form 27EQ
  7. Saving Form 27EQ
  1. Introduction
  2. Features of Job Order Processing in Tally Prime
  3. Configuring Job Order Processing in Tally Prime
  4. Company Setup
  5. Enabling Job Order Processing
  6. Voucher Type Setup
  7. Job Order Processing
  8. Job Work Out Order
  9. Job Work in Order & Job Order Reports
  10. Job Work Out Reports
  1. Introduction
  2. Advantages of Management Information Systems
  3. MIS Reports in Tally Prime
  4. Trial Balance & Balance Sheet
  5. Profit and Loss Account
  6. Cash Flow Statement
  7. Ratio Analysis & Book and Reports
  8. Day Book Receipts and Payments
  9. Purchase Register
  10. Sales Register
  11. Bills Receivable and Bills Payable
  1. Advance Excel
  • Excel Essentials
  • Working with Multiple Worksheet
  • Cell Referencing
  • Conditional Formatting
  • Data Validation
  • What-if Analysis
  • Formula Auditing
  • Protection
  • G Suite-Excel

 2.Formulas & FUNCTIONS

  • Conditional Function
  • Text & Statistical Function
  • Financial function
  • Creating HLOOKUP and VLOOKUP Function
  • Advanced conditional Formatting
  • Advanced Lookup and Reference Functions

  3.Dashboard Designing (MIS)

  • Creating Dshhboard
  • Graphical Representation of Data Using Charts & sparkline’s
  • Use Of Power Pivots For Data Analysis
  • Use Of Power Queries & Power Map
  • Pivote table Dashboard With Slicers

 4.Automation

  • Working With External Data
  • Exporting & Importing Data to Excel, Access, PPT, TXT,CSV
  • Updating Charts, Table in Powerpoint

1.ADVANCED ACCONTING

  • Bill Wise Details & Cost Centre & Cost Catrgories
  • Voucher Class & Cost Centre Class
  • Multiple Currency
  • Interest Calculation & Budgets & Controls

2.ADVANCED INVENTORY

  1. Tracking Number Batch- Wise Details
  2. Additional Cost Details Bill Of Matrrials (BOM)
  3. Price Levels and Price Lists Stock Valuation
  4. Point of Sale

3.TALLY PRIME WITH BANKING

  • Cheque Book Configuration in Tally Prime
  • Banking Transaction Types
  • Post Dated Cheque Management
  • BRS Note & Bnak Reconciliation

4.TALLY PRIME WITH GST

  • Mixed Supply & Composite Supply Under GST
  • GST Reports & GSTR-1 & 2 & GSTR 3B
  • Filling Of GSTR-1 (Excel Format)

5.TALLY DEDUCTED AT SOURCE (TDS)

  • TDS Deduction & Payment Of TDS in Tally Prime
  • Form 26Q & TDS Outstanding & TDS Reports

6.TALLY DEDUCTED AT SOURCE (TCS)

  • Sale OF TCS Goods at Lower Rate & Nil Rated
  • Payment Of TCS & TCS Reports

7.JOB COSTING

  • Creating Required Masters & Ledgers
  • Job Costing Reports & Job Work Analysis Report

8.JOB Working

  • Configuring Job Order Processing in Tally Prime
  • Voucher Type Setup & Job Order Processing
  • Job Work Out Order & Job Work in Order
  • Job Order Reports & Job Work Out Reports

9.MIS REPORTS

  • Advantages Of Managemant Information System
  • MIS Reports in Tally Prime & Trial Balance
  • Balance Sheet & Profit and Loss Account
  • Sales Register & Bills Receivable and Bill Payable

10.Tally Prime with payroll

  • Payroll Accounting & Compliance
  • Configuring payroll in Tally Prime
  • Enable Payroll in Tally Prime
    Payroll
  • Transaction & Generate Pay Slips
  • Pay Sheet & Payroll Statemen
  1. computer competency
  2. system software
  3. windows os
  4. Application software
  1. MS-Word 2019
  2. MS-Excel 2019
  3. MS-Powerpoint
  4. MS-Outlook 2019
  1. Overview working of the internt
  2. World Wide Web
  3. E-Mail