Quick Books | Peachtree Sage | Tally ERP 9 | Advance Excel

Quick Books

Duration 1- Month:

Course Description

An introductory course of the QuickBooks Pro accounting software, including setting up a new company and chart of accounts; recording transactions with customers, vendors and employees; managing lists; running reports and customizing them; changing forms and generating letters.

Getting Started & Setting up QuickBooks

  • Learning how QuickBooks works and how to get around
  • Discussion of decisions to be made before using QuickBooks
  • Creating a new company file with QuickBooks
  • Customizing QuickBooks with the Easy-Step interview
  • Understanding QuickBooks workflows

Working with Lists, Accounts Payable and Receivables

  • Learn how to set up chart of accounts
  • Setting up and managing customer information in QuickBooks
  • Creating professional looking invoices, printing and emailing invoices
  • Setting up and managing vendor information in QuickBooks
  • Custom fields for customer, vendors, items and list
  • Introduction to other account types of accounts in QuickBooks

Working with Bank Accounts

  • Working with bank account registers
  • Common  features of QuickBooks Bank registers
  • Entering transactions into registers
  • Reconciliation of bank accounts in QuickBooks

Entering Sales Information

  • Learning about the different types of sales forms in QuickBooks
  • Learning about purchase orders and printing forms to PDF
  • Learning how to create invoices in QuickBooks
  • Learn the purpose of and use of the item list
  • Learn how to enter data on a sales form
  • How to memorize invoices
  • How to add new items to the item list
  • How to associate price levels to customer records
  • How to create invoice letters and reminder statements

Receiving and Making Deposits

  • Learning how to record customer payments
  • Learning how to handle customer discounts, partial payments and overpayments
  • Recording payment and generating receipts
  • Learn how to process credit card transaction in QuickBooks

Entering and Paying Bills

  • Discuss the different ways to handle bills in QuickBooks
  • Recording and paying bills, write, print, and mail checks
  • Learn how to enter a discount for a bill from a vendor

Tracking and Paying Sales Taxes

  • Gaining an overview of sales taxes management in QuickBooks
  • How to properly setup sales taxes in QuickBooks
  • How to apply sales taxes to a sale
  • How to determine sales tax liability and pay sales tax liabilities

Doing Payroll in QuickBooks

  • Gaining an overview of managing payroll in QuickBooks
  • Learn how to properly setup payroll in QuickBooks
  • How to set up employees for payroll in QuickBooks
  • How to set up payroll schedules
  • How to pay employees and payroll liabilities.

Estimating and Progress Invoicing

  • Learning how to create job estimates
  • Finding estimates in the company file
  • Learning how to copy estimates
  • How to create invoices from estimates
  • How to display reports on projects
  • How to update a job or project status
  • How to make estimate inactive

Creating Reports and Analyzing Financial Data

  • Discussion of the tools for analyzing data in QuickBooks
  • How to create a Quick Report
  • How to add columns and reposition columns on a report
  • Learn about the different preset reports in QuickBooks
  • Practice creating reports and viewing them on screen
  • Customizing report information and look
  • How to export report to Excel and how filter reports in Excel
  • Learn about the different report graphs in QuickBooks
  • How to create and customize graphs

Tracking Time

  • Learning how to track time spent on a project
  • Learning how to invoice a customer for time worked on a project
  • How to create report for time tracking and learning about other project reports
  • How to pay non-employees for time worked – 1099s

Setting up Inventory

  • Gaining an overview of what inventory will and won’t do in QuickBooks
  • Practice filing out purchase orders for inventory items
  • Tracking the receipt of inventory items in QuickBooks

Learning Tips and Shortcuts to QuickBooks

Question and Answer session


Peachtree Sage

Duration 3- Month:

Course Description

This course introduces the students to the environment of general ledger software using Peachtree accounting for windows. It covers both analysis and record of business transactions in the general and special journals. It also covers subsidiary and general ledger, adjusting entries, depreciation, payroll, petty cash, bank reconciliation and financial statements for service and merchandising enterprise.

 Accounting with Peachtree

Lesson 1: Getting Started
Lesson 2: Setting Up a Company
Lesson 3: Entering Transactions for a Cash Business
Lesson 4: Accounts Receivable and Sales for a Business
Lesson 5: Accounts Payable and Purchases for a Service Business
Lesson 6: Cash Payments and Cash Receipts
Lesson 7: Preparing the Financial Statements
Lesson 8: Purchase of Inventory in a Merchandise Business
Lesson 9: Sales of Inventory in a Merchandise Business
Lesson 10: Payroll
Lesson 11: Job Costing
Lesson 12: Partnerships and Corporations


Tally ERP 9

Duration 1-Months:

Course Description

Tally is a financial accounting software that is currently used in 88 countries beyond its native India, including the United Kingdom, and the Middle East.
Tally’s software is mainly used for vouchers, financial statements, and taxation in many industries, and has specialized packages for retail businesses.

Course Outline:

Level – I 

  •  What is Book Keeping?
  • What is an Account?
  • What is Double –Entry System of Book Keeping?
  • Explain the term transaction
  •  What is journal entry?
  • What is Contra Entry?
  • What is Journal Voucher?
  • Explain the word Liability
  • Explain the word asset s
  • Books of Accounts
  • Definition of Indirect Exp / Indirect Income
  • Definition of Direct Exp / Direct Income
  •  What is debit?
  • What is credit?
  • Difference between Journal voucher / Journal entry

Level – II

  • Golden rules of Accounting

Level – III

  • Accounting Software
  • Why use Tally to maintain Account
  • Advantage over manual Accounting

Level – IV

  • Creation of Company / Accounts only? Accounts with Inventory
  • Alt the company
  • Creation of  password / security
  • Opening the company making it active
  • Creating ledger A/c.
  • Altering individual ledger a/c
  • Viewing / Altering  multiple ledger on screen
  • Inventory creation / Altering stock group /stock items

Level – V

  • Entering Voucher
  • Payment voucher / Receipt Voucher / Contra voucher / Journal voucher
  • Purchase voucher / Sales voucher / Purchase return / Sales Return
  • Purchase Order / Sales order / Stock Journal voucher / physical
  • Stock voucher / Rejection out voucher / Rejection In voucher

Level – VI

  • Easy Access to the various Books of Account
  • Cash Book / Bank Book / Purchase Book / sales Book /
  • Journal voucher book / Debit Note book / Credit Note Book
  • Day Book / Ledger Book

Level – VII

  • Automatic Creation of Financial Accounting Statement
  • Trial  Balance
  • Trading A/c
  • Profit & Loss A/c
  • Balance Sheet
  • Stock  Summary
  • Ratio Analysis

Level – VIII

  • Printing various Book of Account
  • Printing all Financial  Statement


Advance Excel

  Duration 3-Month:

Course Description

The purpose of this course is provide Georgia Tech students the necessary skills to use MS Excel in the workplace as an analysis and presentation tool, above and beyond the average skill level of most users, thus making the student a more attractive candidate in the job market.

  1. Setup and printing issues
  • Worksheet margins
  • Worksheet orientation
  • Worksheet page size
  • Header and footers
  • Header and footers fields
  • Scaling your worksheet to fit a page(s)
  • Visually checking your calculations
  • Displaying gridlines when printing
  • Printing titles on every page when printing
  • Printing the excel row and columns headings
  • Spell checking
  • Previewing a worksheet
  • Viewing workbook side by side
  • Zooming the view
  • Printing options
  • Setting the number of copies to print
  • Selecting a printer
  • Selecting individual worksheet or the entire workbook
  • Selecting which page to print
  • Single or double sided printing
  • Collation options
  • Page orientation
  • Paper size
  • Margins
  • Scaling
  • Printing
  1. Functions and formulas
  • Getting help with functions
  • Nested functions
  • Consolidating data using A 3D reference sum function
  1. Time and date Functions
  • Inserting the current date and time
  • Today
  • Now
  • Day
  • Month
  • Year
  1. Mathematical functions
  • Round
  • Round down
  • Roundup
  1. Logical functions
  • IF
  • AND
  • OR
  1. Mathematical functions
  1. Statistical functions
  • rank
  1. Text functions
  • left
  • Right
  • Mid
  • Trim
  • Concatenate
  1. Financial functions
  • FV
  • PV
  • NPV
  • RATE
  • PMT
  1. Lookup functions
  1. Database Functions
  • DSUM
  • DMIN
  • DMAX
  1. Named ranges
  • Naming cell ranges
  • Removing a named range
  • Named cell ranges and functions
  1. Cell formatting
  • Applying styles to a range
  • Conditional formatting
  • Custom number format
  1. Manipulating worksheets
  •  Copying or moving worksheet between workbooks
  • Splitting a window
  • Hiding rows
  • Hiding columns
  • Hiding worksheets
  • Un-hiding rows
  • Un- hiding columns
  • Un-hiding worksheets


  1. Templates
  • Using templates
  • Creating excel templates
  • Displaying hidden templates folders on a Window 7 computer
  • Editing excel templates in a window 7 computer
  • Displaying hidden templates folders on a window vista computer
  • Displaying hidden templates folders on a window XP computer
  • Editing excel templates on a window XP computer
  1. Paste special options
  • Using paste special to Add, subtract, multiply and divide
  • Using paste special values
  • Using paste special transpose options
  1. Pivot tables
  • Creating and using a pivot table
  • Filtering and sorting data within a pivot table
  • Automatically grouping data in a pivot table and renaming groups
  • Manually grouping data in a pivot table and renaming groups
  1. Input tables
  • One-input data table
  • Two-input data table
  1. Charts
  • Creating a combined line and column chart
  • Adding a secondary axis to chart
  • Changing the chart type for a particular data series
  • Adding a data series to a chart
  • Removing a data series from a chart
  • Repositioning chart title
  • Repositioning the chart legend
  • Moving and formatting chart data labels
  • Modifying chart axis scales
  • Formatting an axis to display using comma
  • Inserting images into chart column
  • Inserting images to chart bars
  • Formatting the chart plot area using a picture
  • Formatting the chart area using a picture


  1. Hyperlinks
  • Inserting a hyperlink
  • Editing a hyperlink
  • Removing a hyperlink
  1. Linking and embedding
  • What is embedding and linking
  • Linking data within a work sheet
  • Linking cells between worksheets within a work book
  • Linking data between workbook
  • Linking data from excel to word document
  • Linking an excel chart to a word document
  • Updating, locking and breaking links
  1. Important text files
  • What is delimited text file
  • Importing a delimited text file
  1. Sorting and filtering data
  • Sorting data by multiple column at the same time
  • Applying a pre-installed custom sort
  • Creating a customized list and performing a custom sort
  • Removing a customized list
  • Using AUTOFILTER to perform multiple queries
  • Removing all AUTOFILTER from a worksheet
  • Advance filter criteria
  • SUB-Totaling
  • Removing sub-totals
  • Expanding and collapsing outline detail levels
  1. Tracking and reviewing changes
  • Enabling or disabling the ‘track changes’ feature
  • Sharing, comparing and merging worksheets
  1. Scenarios
  • Scenario manager
  • Scenarios summary report
  1. Validating
  • Data validation – Whole number
  • Data validation – decimal number
  • Data validation – list
  • Data validation – Date
  • Data validation – time
  • Data validation – text length
  • Customizing a validation input message and error alert
  • Removing data validation
  1. Auditing
  • Tracing precedent cells
  • Tracing dependent cells
  • Identifying cells with missing dependents
  • Showing all formulas in a worksheet, rather than the resulting values
  • Inserting and viewing comments
  • Editing and deleting comments
  • Showing and hiding comments
  1. Macros
  •  Macro to change the page set up
  • Macro to apply a custom number format
  • Macro to format a cell range
  • Macro to insert field into header or footer
  • Assigning a macro to a button on the quick access toolbar
  • Deleting macros
  1. Passwords and security issues
  • Adding ‘open’ password protection to a workbook
  • Adding ‘modify’ password protection to a workbook
  • Removing an ‘Open’ password from a workbook
  • Removing an ‘modify’ password from a workbook
  • Password protecting cells and work sheets
  • Hiding formulas
  • UN-hiding formulas
  1. Final Project



Leave a Reply

Your email address will not be published. Required fields are marked *