Course Code :


Title :

Computer Based Accounting & Finance

Type/Status :


aaaaaaaaaaaa Aims :
This course module is designed to provide knowledge for handling accounting & finance functions in an computer based business environment.
Learning Outcome : aaaaaaaaaaaaaaaa
By the end of this course unit students should be able to:
  • identify the nature of modern computer based accounting function
  • apply computer technology for accounting functions in an organizations
  • make decisions using electronic accounting information
  • formulate advanced financial management models using Ms Excel

Course Content : Accounting functions using a software; Create a new company in an accounting software; Modify the preset chart of accounts to suit company needs; Add information to company lists, or edit information in company lists; Open and use registers for any balance sheet accounts; Generating other reports; Preparing bank reconciliations, Create sales orders; Estimates, Invoice customers & progress invoicing, Receive payments from customers and make bank deposits, Write cheques and assign amounts to specific expense accounts. Work with asset and liability accounts; Enter bills into accounts payable Pay bills; Create and customize  reports and graphs; Customize sales forms; View MIS Reports Save reports and forms as Portable Document Format (PDF) files; E mail and Export reports to Microsoft Excel or PDF; Set up inventory and build finished goods; Convert units of measure and Multi Location; Track and pay sales tax (VAT & NBT); Write letters in Microsoft Word using accounting software data.
Finance functions using Ms Excel: Time value of money; Valuation; Project appraisal methods

Method of Teaching & Learning:

Lectures, Laboratory works, Tutorials and assignments

Scheme of Evaluation:

End semester examination, assignments and practical test

The weights given to each component of the evaluation method is announced at the commencement of the module.

Recommended Readings:

Benninga, S. (2005). Principles of Finance with Excel (1st ed.). UK: Oxford University Press.

Day, A. (2007). Mastering Financial Modeling in Microsoft Excel: A practitioner's guide to applied corporate finance (3rd ed.). UK: Prentice Hall.

User Manuals for Accounting Software.