Diploma in Computerized Accounting

Accounting

Introduction: A set of processes, procedures, and controls known as an accounting system is used to gather,…

admin
25
0
(0)

Introduction:

A set of processes, procedures, and controls known as an accounting system is used to gather, record, categorize, and summarize financial data for management decision-making and interpretation.
Using computers and accounting software to capture, store, and analyze financial data is known as computerized accounting. Numerous benefits that an analog accounting system lacks are available with a computerized accounting system.
corporate reports, ads, brochures, and publications.

What You Learn:

· Introduction to Formulas

· Professional charts building

· Advance Functions

· Automated Report building

· Data consolidation and validation

· Pivot Table and pivot charts building

· Data visualisation and Analysation

· Executive Basic Dashboard

· Database Concepts

· short keys

· Advance lookup functions

· Fundamentals of accounting and business concepts

· software introduction

· how to create new company

· maintain inventory, customer, vendors and ledgers

· daily register

· jobs creation

· payroll system

· general journal

· reports handling

· Reconciliation

· payable/receivable Balance handling

· Quickbooks Dashboard analysis

Tools

MS Excel
Peachtree
QuickBooks
Tally

Job Profile:

Accountant
Assistant Accountant
CFO

Course Curriculum

Basic Excel

The Named Range
The Lookup Functions
The H-lookup
The VLOOKUP
More Working with H-lookup
Create Currency
Rate Calculator with VLOOKUP
The Lookup
The If Functions
Financial Functions
Data Base Concepts & Its Functions
Misc. Valuable Functions

Advance Excel

The Sorting
The Filters
The Advance Filters
The Subtotals
The Data Validation
The Form
Charts Concept
Working with Chart
Macro
Running the Macros
Modifying the Macro
Macro or Procedure
Moving and resizing charts
Adding a text box and combination charts
Running macros with keyboard shortcuts
Saving and enabling macros
Conditional formatting (new, clear, manage rules)
Applying grouping and outline features
Using pivot tables for data analysis and creating pivot charts
Using Solver for data analysis
Freezing panes and splitting windows
Text to column and advanced printing techniques

QUICKBOOK

Introduction and scope of QuickBooks
Installation and setup (Create, Back up, Restore a Company)
Import and export data (Quicken, Peachtree, MS Accounting)
Copy, verify, rebuild, and clean up company data
Switch to multi-user mode and stop hosting multi-user mode
Print, save as PDF, printer setup, and send forms
Print, save as PDF, printer setup, and send forms
Search and find transactions, use register, calculator
Add and manage inventory, sales tax, and other items
Make general journal entries and reconcile trial balance
Manage company info, users, and audit trails
Set closing date, planning and budgeting, reminders
Introduction to online banking, payments, and loan manager
Customer management (Create estimates, sales orders, receive payments)
Vendor management (Enter and pay bills, manage inventory)
Employee management (Payroll setup, pay employees, manage payroll taxes)
Banking functions (Write checks, reconcile accounts, transfer funds)
Generate financial reports (Balance Sheet, P&L, Cash Flow)
Manage and process multiple reports
Customize and filter reports (Custom summary, transaction, industry-specific)
Prepare, modify, and audit general journal reports

PEACHTREE

Introduction and scope of Peachtree
Navigation and creating/opening a company
Backup and restore (including online and archive companies)
Data verification and audit trail usage
Create users and assign rights
Import and export data
Create and modify charts of accounts, set beginning balances
Create budgets and memorized transactions (quotes, POs, invoices)
Customize Peachtree (forms, toolbar, options)
General journal entry and account reconciliation
Fund transfers and fiscal year adjustments
Add customers, vendors, and employees with full information
Inventory management (stock, assembly items, adjustments, FIFO/LIFO)
Accounts receivable (quotes, proposals, sales orders, invoices, credit memos)
Accounts payable (purchase orders, invoices, vendor payments)
Bank functions (create account, reconciliation, fund transfers, bounced cheques)
Payroll management and reports
Financial statements and general ledger reports
Internal accounting review and daily register
Custom reports and group reports (Peachtree Crystal Reports)

TALLY 9

Introduction, features, and scope of Tally 9
User interface and installation process
Customization of accounting and inventory features
General, numeric, voucher configurations
Create and customize vouchers and invoices
Open and shut a company, real-time processing
Ratio analysis, budgeting, auditing, and security control
Customer and vendor management
Tally calculator and negative quantity warning
Bill-wise tracking of trading accounts
Simultaneous entry of purchase invoices and purchase orders
Create bank accounts and set beginning balances
Printing cheques and contra entries
Payroll management (adding employees, creating pay heads, attendance)
Inventory management (stock groups, items, unit measurement, discounts)
Various Tally vouchers (payment, receipt, sales, purchase orders)
Journal vouchers (credit/debit notes, stock journal)
Statutory and taxation features (sales tax, service tax)
Tally reports (balance sheet, income/expense reports, stock summary)
Accounts books (cash and bank books, ledgers, registers)
Customize reports and display reconciliation data
Cash flow and fund flow reports
Payroll reports (statement of payroll, attendance sheets)
Inventory analysis (stock transfer, movement analysis, ageing analysis)

School/College students
Employees
Career changers or those entering the workforce.
Individuals looking to upskill in their current role
Recent graduates
Business professionals
Entrepreneurs.
Course Duration : 6 Months
Class Duration : 2 hours
One hour theory class
One hour practical class
Class Days : MWF | TTS