Menu

Computerized Accounting

 

About

The purpose of this course is to provide an extensive knowledge and skills of the most popular accounting software packages such as Simply Accounting, QuickBooks, and ACCPAC. This training program aims to transform accounting techniques and concepts into skills and tools needed by accounting staff.


Program participants will be trained to improve effectiveness and efficiencies of organizations, sell new ideas, and implement realistic systems. The program is also useful for those wanting to develop their own financial tool kits to complement their existing accounting skills.
Accounting clerk career is for you if you…

— have an aptitude for numbers
— have excellent work habits
— are punctual in meeting deadlines
— have good oral and written communication skills
— want to work in an excellent working environment
— want a variety of career paths
— want to work in a rapidly changing business environment

Go back to top

Program details

  • Orientation
  • Introduction of the Accounting Function and the Recording Process
  • Adjusting the Accounts and Completion of the Accounting Cycle
  • Accounting for Merchandising operations And pay roll
  • Quick books –Sales and Invoices
  • Quick Books —Bank Accounts and Inventory
  • Quick books other functions
  • Simply Accounting –General Ledger
  • Simply Accounting— Accounts Payable
  • Simply Accounting—Accounts Receivable and Payroll
  • ACCPAC—- General Ledger
  • ACCPAC—-Accounts Payable
  • ACCPAC—-Accounts Receivable
  • Placement

Course Outline:

Module 1 Orientation

Module 2. Introduction of the Accounting Function and the Recording Process

  • Principle of Canadian accounting and bookkeeping system
  • Explain the meaning of GAAP and the Basic Assumptions
  • Distinguishing between bookkeeping and accounting
  • Transaction analysis
  • Define debits and credits and explain how they are used to record business transactions
  • Identify the basic steps in the recording process
  • Record transactions in journal (daily transaction )
  • Post General Journal to General ledger accounts
  • Prepare a trial balance of book and explain its purposes

Module 3. Adjusting the Accounts

  • Explain the time period assumption
  • Distinguish between the Cash Basis accounting and Accrual Basis accounting
  • Explain why adjusting entries are needed
  • Explain the major types of adjusting entries Prepare the adjusting entry and explain the nature and purpose of an adjusted trial balance
  • Prepare closing entries
  • Describe the content and purpose of a post-closing trial balance
  • State the steps in the accounting cycle
  • Prepare a classified financial statement

Module 4. Accounting for Merchandising Operations and Payroll

  • Merchandising operation
  • Recoding purchases of merchandise
  • Purchase returns and allowance
  • Recoding sales of merchandise
  • Sales return and allowances and discount
  • Summary of merchandising entries
  • Internal control over cash receipts
  • Internal control over cash disbursements
  • Making bank deposit
  • Bank statements
  • Reconciling the bank account
  • Explain Canadian payroll system
  • Determining employee gross earnings and employer payroll cost
  • Explain and calculate payroll deductions
  • Prepare payroll journal entry

Module 5 Quick books –Sales and Invoices

  • Introducing QuickBooks
  • Setting up a new company
  • Entering company info
  • Setting up QuickBooks preferences
  • Choosing a start date
  • Creating income and expense accounts
  • Providing details about your income
  • Entering opening balances
  • Getting help while using QuickBooks
  • Using QuickBooks lists
  • Editing the chart of accounts
  • Working with the Customer Job list
  • Working with the Vendor list
  • Working with the Employee list
  • Generating Invoices
  • Editing invoices
  • Printing a batch of invoices
  • Memorizing invoice or other types of transactions
  • Entering a new service item
  • Entering credit memos
  • Issuing refunds
  • Handling bills
  • Managing credit card transactions
  • Editing bills
  • Printing a bill or a batch of bills
  • Paying bills

Module 6. Quick Books —Bank Accounts and Inventory

  • Writing checks
  • Using bank account registers
  • Making deposits
  • Transferring money between accounts
  • Reconciling checking accounts
  • Turning on the inventory feature
  • Entering products into inventory
  • Ordering products
  • Receiving Inventory
  • Entering a bill for inventory
  • Manually adjusting inventory after actual inventory count
  • Determine inventory shrinkage and adjusting entries

Module 7 Quick Books Other Functions

  • Overview of payroll tracking
  • Setting up for payroll
  • Setting up employee payroll information
  • Writing a paycheck
  • Tracking your tax liabilities
  • Paying payroll taxes
  • Tracking and paying sales tax
  • Creating an invoice from an estimate
  • Tracking time
  • Customizing forms
  • Creating and customizing preset reports

Module 8. Simply Accounting –General Ledger

  • Introduction Simply Accounting
  • Setting up a new company
  • Enter company information in system
  • Choose a Typical set of accounts for business
  • Create Chart of accounts
  • Set up bank accounts
  • Set up linked accounts
  • Set up accounts for reconciliation
  • Check chart of accounts
  • Set up sales taxes
  • Set up payroll options
  • Enter payment options for vendors and customers
  • Set display preference
  • Add Credit-card Accounts
  • Select inventory options
  • Add accounts keep track of inventory and service items
  • Make a List of the items and services
  • Create and maintain price lists
  • Assemble items form components

Module 9. Simply Accounting— Accounts Payable

  • Setting Up options for vendors and purchases
  • Adding Vendors
  • Entering a purchases
  • Editing Taxes
  • Ordering Goods and Service
  • Prepaid Orders
  • Paying for goods and service
  • Correcting or canceling purchase invoice
  • Correcting or canceling payments to vendors
  • Correcting or canceling prepayments
  • Paying credit–card bills
  • Paying other bills

Module 10. Simply Accounting—Accounts Receivable and Payroll

  • Setting up options for customers and sales
  • Adding basic customer information
  • Entering a sales
  • Editing taxes
  • Prepaid orders
  • Receiving payment for goods and services
  • Correcting or canceling sales invoice
  • Correcting or canceling payments form customers
  • Accepting a customer return
  • Checking your payroll options
  • Adding employees
  • Paying individual employees
  • Paying a group of employees with a payroll check run
  • Paying out vacation time

Module 11. ACCPAC-General Ledger

  • Setting up the system database
  • Defining the company profile
  • Setting up general ledger options
  • Setting up G/L account structures
  • Adding the general ledger accounts
  • Modifying an charter account
  • Set general ledger to ready
  • Processing a general ledger batch
  • Printing a beginning trial balance

Module 12. Accounts Payable For ACCPAC

  • Adding tax classes
  • Activating the accounts payable ledger
  • Defining the company profile and A/P options
  • A/P background information
  • Creating vendor records
  • Process vendor invoices ,debit notes and credit notes
  • Vendor tax
  • Posting Batch
  • Printing an invoice posting journal
  • Processing adjustments, using the adjustment function
  • Correcting errors in the batch
  • Posting adjustments batch
  • Processing payments
  • Printing analytical reports
  • Payment batch
  • The check run
  • Miscellaneous payments
  • Generate trial balance to general ledger

Module 13. Accounts Receivable For ACCPAC

  • Activating the accounts receivable ledger
  • Modifying A/R options
  • Defining background information
  • Creating customer records
  • Accounts receivable batches
  • Processing customer invoices
  • Processing debit note and credit notes
  • Posting batch
  • Printing an invoice posting journal
  • Processing adjustments
  • Printing the adjustments posting journal
  • Processing customer receipts
  • Printing and posting a receipt batch
  • Generating aging trial balance
  • Processing NSF cheques
  • Processing bad debt
  • Reconcile trial balance to general ledger

Placement

The college will arrange all the students to do their placement in an accounting firm for training after the students have successfully completed the theory study inside the college.

Go back to top

Requirements

  • Grade 12 or equivalent or passing score on the entrance examination
  • Mature student status

Go back to top

Career opportunities

Graduates of this program qualify to work in different types of businesses with the title of Office Administrator, Secretary, Bookkeeper, Account Payable/Receivable Clerk, Payroll Clerk, Data Entry Clerk, Accounting Assistant, Account Manager, Financial Assistant, Marketing Assistant, and Sales Manager.

Go back to top

Save

Save

Save

Save

Save